set linesize 430
set pagesize 3200
set feedback on sql_id
create table a0100 as select * from dba_objects;
col PLAN_TABLE_OUTPUT for a150
select /*+ parallel(2) */ count(*) from a0100;
select * from table(dbms_xplan.display_cursor(null,null,'advanced'));
DGMGRL> edit database orcl0dg set STATE ='apply-off';
Succeeded.
DGMGRL>
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 19 16:16:47 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> create restore point beforetest guarantee flashback database;
Restore point created.
SQL> alter database activate standby database;
Database altered.
SQL>
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
2025-09-19T16:16:59.578569+08:00
Starting background process RVWR
2025-09-19T16:16:59.615218+08:00
RVWR started with pid=56, OS id=10266
2025-09-19T16:17:02.672605+08:00
Allocating 3981120 bytes in shared pool for flashback generation buffer.
Allocated 3981120 bytes in shared pool for flashback generation buffer
Created guaranteed restore point BEFORETEST
2025-09-19T16:17:13.006416+08:00
alter database activate standby database
2025-09-19T16:17:13.006985+08:00
ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE [Process Id: 10084] (orcl0dg)
2025-09-19T16:17:14.031362+08:00
Stopping background process MMNL
2025-09-19T16:17:15.031668+08:00
Stopping background process MMON
2025-09-19T16:17:16.030234+08:00
Stopping Emon pool
Dispatchers and shared servers shutdown
CLOSE: killing server sessions.
2025-09-19T16:17:16.128868+08:00
Process termination requested for pid 6634 [source = rdbms], [info = 2] [request issued by pid: 10084, uid: 2100]
2025-09-19T16:17:16.130164+08:00
Process termination requested for pid 6618 [source = rdbms], [info = 2] [request issued by pid: 10084, uid: 2100]
2025-09-19T16:17:16.139254+08:00
Active process 6025 user 'oracle' program 'oracle@prdg19 (SVCB)', waiting for 'wait for unread message on broadcast channel'
Active process 6081 user 'oracle' program 'oracle@prdg19 (W000)', waiting for 'Space Manager: slave idle wait'
Active process 6089 user 'oracle' program 'oracle@prdg19 (W001)', waiting for 'Space Manager: slave idle wait'
Active process 6699 user 'oracle' program 'oracle@prdg19 (W004)', waiting for 'Space Manager: slave idle wait'
Active process 6577 user 'oracle' program 'oracle@prdg19 (W002)', waiting for 'Space Manager: slave idle wait'
Active process 6653 user 'oracle' program 'oracle@prdg19 (W003)', waiting for 'Space Manager: slave idle wait'
Active process 6025 user 'oracle' program 'oracle@prdg19 (SVCB)', waiting for 'wait for unread message on broadcast channel'
Active process 6081 user 'oracle' program 'oracle@prdg19 (W000)', waiting for 'Space Manager: slave idle wait'
Active process 6089 user 'oracle' program 'oracle@prdg19 (W001)', waiting for 'Space Manager: slave idle wait'
Active process 6699 user 'oracle' program 'oracle@prdg19 (W004)', waiting for 'Space Manager: slave idle wait'
Active process 6577 user 'oracle' program 'oracle@prdg19 (W002)', waiting for 'Space Manager: slave idle wait'
Active process 6653 user 'oracle' program 'oracle@prdg19 (W003)', waiting for 'Space Manager: slave idle wait'
2025-09-19T16:17:18.825685+08:00
CLOSE: all sessions shutdown successfully.
2025-09-19T16:17:22.327903+08:00
alter pluggable database all close
Completed: alter pluggable database all close
2025-09-19T16:17:22.397474+08:00
PDB$SEED(2):JIT: pid 10084 requesting stop
PDB$SEED(2):Buffer Cache flush deferred for PDB 2
2025-09-19T16:17:23.527701+08:00
IM on ADG: Start of Empty Journal
IM on ADG: End of Empty Journal
Stopping Emon pool
Buffer Cache invalidation for all PDBs started
Buffer Cache invalidation for all PDBs complete
.... (PID:10084): Killing 3 processes (PIDS:6497,6494,6509) (all RFS) in order to disallow current and future RFS connections. Requested by OS process 10084
2025-09-19T16:17:23.758488+08:00
Process termination requested for pid 6497 [source = rdbms], [info = 2] [request issued by pid: 10084, uid: 2100]
2025-09-19T16:17:23.758826+08:00
Process termination requested for pid 6494 [source = rdbms], [info = 2] [request issued by pid: 10084, uid: 2100]
2025-09-19T16:17:23.759099+08:00
Process termination requested for pid 6509 [source = rdbms], [info = 2] [request issued by pid: 10084, uid: 2100]
2025-09-19T16:17:25.759308+08:00
.... (PID:10084): Begin: SRL archival
.... (PID:10084): End: SRL archival
2025-09-19T16:17:26.826262+08:00
RESETLOGS after complete recovery through change 4713408
2025-09-19T16:17:26.906121+08:00
NET (PID:10084): Archived Log entry 124 added for T-1.S-10 ID 0x65ece59c LAD:1
Resetting resetlogs activation ID 1710024092 (0x65ece59c)
Online log /u01/app/oracle/oradata/ORCL/redo01.log: Thread 1 Group 1 was previously cleared
Online log /u01/app/oracle/oradata/ORCL0DG/onlinelog/o1_mf_6_j8qdfotg_.log: Thread 1 Group 6 was previously cleared
Online log /u01/app/oracle/oradata/ORCL0DG/onlinelog/o1_mf_7_j8qdfpon_.log: Thread 1 Group 7 was previously cleared
Online log /u01/app/oracle/oradata/ORCL0DG/onlinelog/o1_mf_8_j8qdfqh5_.log: Thread 1 Group 8 was previously cleared
Standby became primary SCN: 4713406
2025-09-19T16:17:27.036414+08:00
Setting recovery target incarnation to 5
2025-09-19T16:17:27.146780+08:00
NET (PID:10084): RT: Role transition work is not done
NET (PID:10084): The Time Management Interface (TMI) is being enabled for role transition
NET (PID:10084): information. This will result in messages beingoutput to the alert log
NET (PID:10084): file with the prefix 'TMI: '. This is being enabled to make the timing of
NET (PID:10084): the various stages of the role transition available for diagnostic purposes.
NET (PID:10084): This output will end when the role transition is complete.
NET (PID:10084): Redo network throttle feature is disabled at mount time
AUDIT_TRAIL initialization parameter is changed back to its original value as specified in the parameter file.
2025-09-19T16:17:27.232166+08:00
NET (PID:10084): Database role cleared from PHYSICAL STANDBY [kcvs.c:1030]
ACTIVATE STANDBY: Complete - Database mounted as primary
Completed: alter database activate standby database
2025-09-19T16:17:39.126785+08:00
rfs (PID:10816): Database mount ID mismatch [0x67b71718:0x67b6545c] (1740052248:1740002396)
rfs (PID:10816): Not using real application clusters
[oracle@prdg19 trace]$
set linesize 430
set pagesize 3200
set feedback on sql_id
create table a0100 as select * from dba_objects;
col PLAN_TABLE_OUTPUT for a150
select /*+ parallel(2) */ count(*) from a0100;
select * from table(dbms_xplan.display_cursor(null,null,'advanced'));
set pagesize 3200
set feedback on sql_id
create table a0100 as select * from dba_objects
SQL> col PLAN_TABLE_OUTPUT for a150
SQL> select /*+ parallel(2) */ count(*) from a0100;
select * from table(dbms_xplan.display_cursor(null,null,'advanced'));
COUNT(*)
----------
23144
1 row selected.
SQL_ID: a69cwqwctjts7
SQL>
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID a69cwqwctjts7, child number 0
-------------------------------------
select /*+ parallel(2) */ count(*) from a0100
Plan hash value: 4164602606
--------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib |
--------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | 63 (100)| | | | |
| 1 | SORT AGGREGATE | | 1 | | | | | |
| 2 | PX COORDINATOR | | | | | | | |
| 3 | PX SEND QC (RANDOM) | :TQ10000 | 1 | | | Q1,00 | P->S | QC (RAND) |
| 4 | SORT AGGREGATE | | 1 | | | Q1,00 | PCWP | |
| 5 | PX BLOCK ITERATOR | | 24534 | 63 (0)| 00:00:01 | Q1,00 | PCWC | |
|* 6 | TABLE ACCESS FULL| A0100 | 24534 | 63 (0)| 00:00:01 | Q1,00 | PCWP | |
--------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1
6 - SEL$1 / A0100@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('19.1.0')
DB_VERSION('19.1.0')
ALL_ROWS
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "A0100"@"SEL$1")
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
6 - access(:Z>=:Z AND :Z<=:Z)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - (#keys=0) COUNT()[22]
2 - SYS_OP_MSR()[10]
3 - (#keys=0) SYS_OP_MSR()[10]
4 - (#keys=0) SYS_OP_MSR()[10]
5 - (rowset=1019)
6 - (rowset=1019)
Hint Report (identified by operation id / Query Block Name / Object Alias):
Total hints for statement: 1
---------------------------------------------------------------------------
0 - STATEMENT
- parallel(2)
Note
-----
- dynamic statistics used: dynamic sampling (level=2)
- Degree of Parallelism is 2 because of hint
Query Block Registry:
---------------------
<q o="2" f="y"><n><![CDATA[SEL$1]]></n><f><h><t><![CDATA[A0100]]></t><s><![CDATA[SEL$1]]></s></h
></f></q>
72 rows selected.
SQL_ID: fv0v1agrdrjkv
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PRIMARY
1 row selected.
SQL_ID: 6jaghrm3vy74f
SQL> startup mount force;
ORACLE instance started.
Total System Global Area 335540560 bytes
Fixed Size 9134416 bytes
Variable Size 272629760 bytes
Database Buffers 50331648 bytes
Redo Buffers 3444736 bytes
SQL_ID: 0mtwvr49kxt2m
SQL_ID: 92b382ka0qgdt
Database mounted.
SQL> flashback database to restore point beforetest;
Flashback complete.
SQL_ID: 2sm9qsp6qzx3n
SQL> alter database convert to physical standby;
Database altered.
SQL_ID: g08g8nsnwvcx0
SQL> startup mount force;
ORACLE instance started.
Total System Global Area 335540560 bytes
Fixed Size 9134416 bytes
Variable Size 272629760 bytes
Database Buffers 50331648 bytes
Redo Buffers 3444736 bytes
SQL_ID: 0mtwvr49kxt2m
SQL_ID: 92b382ka0qgdt
Database mounted.
SQL> drop restore point beforetest;
Restore point dropped.
SQL_ID: g6u356k2fgncn
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL_ID: 4qahk46zu0xjt
SQL>
浙公网安备 33010602011771号