Performing a Switchover to a Physical Standby Database Using SQL*Plus

Primary, Physical (redo apply) and Logical (SQL apply) Standby Databases or Active Data Guard
Post Reply
User avatar
Kristoff
Posts: 30
Joined: Thu Jan 19, 2012 2:17 pm
Location: Manila, Philippines

Performing a Switchover to a Physical Standby Database Using SQL*Plus

Post by Kristoff »

1. Verify that the primary database can be switched to the standby role.
Query the SWITCHOVER_STATUS column of the V$DATABASE view on the primary database.

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

Code: Select all

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
TO STANDBY
A value of TO STANDBY or SESSIONS ACTIVE indicates that the primary database can be switched to the standby role. If neither of these values is returned, a switchover is not possible because redo transport is either misconfigured or is not functioning properly.

2. Initiate the switchover on the primary database.
Issue the following SQL statement on the primary database to switch it to the standby role:

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

Code: Select all

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

Database altered.
This statement converts the primary database into a physical standby database. The current control file is backed up to the current SQL session trace file before the switchover. This makes it possible to reconstruct a current control file, if necessary.

Note:
The WITH SESSION SHUTDOWN clause can be omitted from the switchover statement if the query performed in the previous step returned a value of TO STANDBY.

3. Shut down and then mount the former primary database.
SQL> SHUTDOWN IMMEDIATE;

Code: Select all

SQL> SHUTDOWN IMMEDIATE;
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> EXIT

SQL> STARTUP MOUNT;

Code: Select all

SQL> STARTUP MOUNT;
ORACLE instance started.

Total System Global Area  313860096 bytes
Fixed Size                  1344652 bytes
Variable Size             272632692 bytes
Database Buffers           33554432 bytes
Redo Buffers                6328320 bytes
Database mounted.
At this point in the switchover process, the original primary database is a physical standby database.

4. Verify that the switchover target is ready to be switched to the primary role.
Query the SWITCHOVER_STATUS column of the V$DATABASE view on the standby database.
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

Code: Select all

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
TO PRIMARY
A value of TO PRIMARY or SESSIONS ACTIVE indicates that the standby database is ready to be switched to the primary role. If neither of these values is returned, verify that Redo Apply is active and that redo transport is configured and working properly. Continue to query this column until the value returned is either TO PRIMARY or SESSIONS ACTIVE.

5. Switch the target physical standby database role to the primary role.
Issue the following SQL statement on the target physical standby database:
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

Code: Select all

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

Database altered.
Note:
The WITH SESSION SHUTDOWN clause can be omitted from the switchover statement if the query performed in the previous step returned a value of TO PRIMARY.

6. Open the new primary database.
SQL> ALTER DATABASE OPEN;

Code: Select all

SQL> ALTER DATABASE OPEN;

Database altered.
7. Start Redo Apply on the new physical standby database.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

Code: Select all

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

Database altered.
8. Enable Active Dataguard.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Code: Select all

SQL>  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Database altered.
SQL> ALTER DATABASE OPEN;

Code: Select all

SQL> ALTER DATABASE OPEN;

Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

Code: Select all

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

Database altered.
--- End of Switchover ---


Adapted from: http://docs.oracle.com/cd/E11882_01/ser ... m#i1026464


Appendix:
Alert log of the Original Primary Database During Switchover:
Sat Jul 20 17:52:07 2013
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 11342] (primary)
Sat Jul 20 17:52:07 2013
Thread 1 advanced to log sequence 125 (LGWR switch)
Current log# 2 seq# 125 mem# 0: +DATA/primary/onlinelog/group_2.282.820231503
Current log# 2 seq# 125 mem# 1: +FLASH/primary/onlinelog/group_2.399.820231503
Stopping background process QMNC
Sat Jul 20 17:52:07 2013
Stopping background process CJQ0
All dispatchers and shared servers shutdown
CLOSE: killing server sessions.
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Sat Jul 20 17:52:11 2013
Archived Log entry 220 added for thread 1 sequence 124 ID 0x62cebcf3 dest 1:
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
Active process 11127 user 'oracle' program 'oracle@dgprim.localdomain (TNS V1-V3)'
CLOSE: all sessions shutdown successfully.
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Waiting for all FAL entries to be archived...
All FAL entries have been archived.
Waiting for potential Physical Standby switchover target to become synchronized...
Sat Jul 20 17:52:13 2013
Starting background process SMCO
Sat Jul 20 17:52:13 2013
SMCO started with pid=19, OS id=11512
Active, synchronized Physical Standby switchover target has been identified
Switchover End-Of-Redo Log thread 1 sequence 125 has been fixed
Switchover: Primary highest seen SCN set to 0x0.0xeb474
ARCH: Noswitch archival of thread 1, sequence 125
ARCH: End-Of-Redo Branch archival of thread 1 sequence 125
ARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
Sat Jul 20 17:52:16 2013
Process (ospid 11516) is suspended due to switchover to physical standby operation.
Sat Jul 20 17:52:19 2013
Archived Log entry 221 added for thread 1 sequence 125 ID 0x62cebcf3 dest 1:
ARCH: Archiving is disabled due to current logfile archival
Primary will check for some target standby to have received alls redo
Final check for a synchronized target standby. Check will be made once.
LOG_ARCHIVE_DEST_2 is a potential Physical Standby switchover target
Active, synchronized target has been identified
Target has also received all redo
Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/primary/primary/trace/primary_ora_11342.trc
Clearing standby activation ID 1657715955 (0x62cebcf3)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 13 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;
Archivelog for thread 1 sequence 125 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Switchover: Complete - Database shutdown required
Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
Sat Jul 20 17:52:19 2013
Process (ospid 11524) is suspended due to switchover to physical standby operation.
Sat Jul 20 17:52:23 2013
Process (ospid 11528) is suspended due to switchover to physical standby operation.
Sat Jul 20 17:52:26 2013
Process (ospid 11532) is suspended due to switchover to physical standby operation.
Sat Jul 20 17:52:29 2013
Process (ospid 11536) is suspended due to switchover to physical standby operation.
Sat Jul 20 17:52:31 2013
Process (ospid 11053) is suspended due to switchover to physical standby operation.
Sat Jul 20 17:52:32 2013
Process (ospid 11540) is suspended due to switchover to physical standby operation.
Sat Jul 20 17:52:32 2013
Process (ospid 11548) is suspended due to switchover to physical standby operation.
Sat Jul 20 17:52:36 2013
Process (ospid 11552) is suspended due to switchover to physical standby operation.
Sat Jul 20 17:52:40 2013
ARC0: Archiving disabled
Sat Jul 20 17:52:41 2013
ARC3: Archiving disabled
Sat Jul 20 17:52:41 2013
ARC2: Archiving disabled
Sat Jul 20 17:52:51 2013
Process (ospid 11147) is suspended due to switchover to physical standby operation.
Sat Jul 20 17:53:20 2013
idle dispatcher 'D000' terminated, pid = (19, 1)
Sat Jul 20 17:55:01 2013
Performing implicit shutdown abort due to switchover to physical standby
Shutting down instance (abort)
License high water mark = 9
USER (ospid: 11342): terminating the instance
Instance terminated by USER, pid = 11342
Sat Jul 20 17:55:02 2013
Instance shutdown complete
ORA-1092 : opitsk aborting process
Sat Jul 20 17:55:40 2013
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: dgprim.localdomain
Release: 2.6.18-308.el5
Version: #1 SMP Sat Feb 25 10:51:48 EST 2012
Machine: i686
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/db_1/dbs/initprimary.ora
System parameters with non-default values:
processes = 150
spfile = "+DATA/primary/spfileprimary.ora"
memory_target = 300M
control_files = "+DATA/primary/controlfile/current.284.820231481"
control_files = "+FLASH/primary/controlfile/current.397.820231487"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=+FLASH"
log_archive_dest_2 = "service=standby async valid_for=(online_logfile,primary_role) db_unique_name=standby"
log_archive_config = "dg_config=(primary,standby)"
log_archive_format = "%t_%s_%r.dbf"
db_create_file_dest = "+DATA"
db_recovery_file_dest = "+FLASH"
db_recovery_file_dest_size= 5G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = "localdomain"
dispatchers = "(PROTOCOL=TCP) (SERVICE=primaryXDB)"
audit_file_dest = "/u01/app/oracle/admin/primary/adump"
audit_trail = "DB"
db_name = "primary"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
Sat Jul 20 17:55:42 2013
PMON started with pid=2, OS id=11641
Sat Jul 20 17:55:42 2013
PSP0 started with pid=3, OS id=11645
Sat Jul 20 17:55:43 2013
VKTM started with pid=4, OS id=11649 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sat Jul 20 17:55:43 2013
GEN0 started with pid=5, OS id=11655
Sat Jul 20 17:55:43 2013
DIAG started with pid=6, OS id=11659
Sat Jul 20 17:55:43 2013
DBRM started with pid=7, OS id=11663
Sat Jul 20 17:55:43 2013
DIA0 started with pid=8, OS id=11667
Sat Jul 20 17:55:43 2013
MMAN started with pid=9, OS id=11671
Sat Jul 20 17:55:43 2013
DBW0 started with pid=10, OS id=11675
Sat Jul 20 17:55:43 2013
LGWR started with pid=11, OS id=11679
Sat Jul 20 17:55:43 2013
CKPT started with pid=12, OS id=11683
Sat Jul 20 17:55:43 2013
SMON started with pid=13, OS id=11687
Sat Jul 20 17:55:43 2013
RECO started with pid=14, OS id=11691
Sat Jul 20 17:55:43 2013
RBAL started with pid=15, OS id=11695
Sat Jul 20 17:55:43 2013
ASMB started with pid=16, OS id=11699
Sat Jul 20 17:55:43 2013
MMON started with pid=17, OS id=11703
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Jul 20 17:55:43 2013
MMNL started with pid=18, OS id=11707
starting up 1 shared server(s) ...
NOTE: initiating MARK startup
Starting background process MARK
Sat Jul 20 17:55:43 2013
MARK started with pid=21, OS id=11723
NOTE: MARK has subscribed
ORACLE_BASE from environment = /u01/app/oracle
Sat Jul 20 17:55:44 2013
ALTER DATABASE MOUNT
Sat Jul 20 17:55:45 2013
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.141)(PORT=1521))))' SCOPE=MEMORY SID='primary';
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database primary and diskgroup resource ora.DATA.dg is established
SUCCESS: diskgroup FLASH was mounted
NOTE: dependency between database primary and diskgroup resource ora.FLASH.dg is established
ARCH: STARTING ARCH PROCESSES
Sat Jul 20 17:55:52 2013
ARC0 started with pid=24, OS id=11779
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sat Jul 20 17:55:53 2013
ARC1 started with pid=27, OS id=11783
Sat Jul 20 17:55:53 2013
ARC2 started with pid=28, OS id=11787
Sat Jul 20 17:55:53 2013
ARC3 started with pid=29, OS id=11791
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC1: Thread not mounted
ARC2: Becoming the heartbeat ARCH
Successful mount of redo thread 1, with mount id 1658759264
Physical Standby Database mounted.
Lost write protection disabled
ARC2: Becoming the active heartbeat ARCH
Completed: ALTER DATABASE MOUNT
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sat Jul 20 18:02:12 2013
Using STANDBY_ARCHIVE_DEST parameter default value as +FLASH
Sat Jul 20 18:02:12 2013
RFS[1]: Assigned to RFS process 11862
RFS[1]: Selected log 4 for thread 1 sequence 126 dbid 1657714169 branch 820231491
Sat Jul 20 18:02:13 2013
Archived Log entry 223 added for thread 1 sequence 126 ID 0x62def706 dest 1:
Sat Jul 20 18:02:15 2013
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Assigned to RFS process 11866
RFS[2]: Selected log 4 for thread 1 sequence 128 dbid 1657714169 branch 820231491
Sat Jul 20 18:02:16 2013
RFS[3]: Assigned to RFS process 11870
RFS[3]: Selected log 5 for thread 1 sequence 127 dbid 1657714169 branch 820231491
Sat Jul 20 18:02:18 2013
Archived Log entry 224 added for thread 1 sequence 127 ID 0x62def706 dest 1:
Sat Jul 20 18:03:10 2013
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
Attempt to start background Managed Standby Recovery process (primary)
Sat Jul 20 18:03:10 2013
MRP0 started with pid=31, OS id=11883
MRP0: Background Managed Standby Recovery process started (primary)
started logmerger process
Sat Jul 20 18:03:16 2013
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 4 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Clearing online redo logfile 1 +DATA/primary/onlinelog/group_1.283.820231493
Clearing online log 1 of thread 1 sequence number 123
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 +DATA/primary/onlinelog/group_2.282.820231503
Clearing online log 2 of thread 1 sequence number 127
Sat Jul 20 18:03:24 2013
Clearing online redo logfile 2 complete
Clearing online redo logfile 3 +DATA/primary/onlinelog/group_3.279.820231509
Clearing online log 3 of thread 1 sequence number 128
Clearing online redo logfile 3 complete
Sat Jul 20 18:03:31 2013
Media Recovery Log +FLASH/primary/archivelog/2013_07_20/thread_1_seq_125.638.821296335
Identified End-Of-Redo (switchover) for thread 1 sequence 125 at SCN 0x0.eb474
Resetting standby activation ID 0 (0x0)
Media Recovery End-Of-Redo indicator encountered
Media Recovery Continuing
Media Recovery Log +FLASH/primary/archivelog/2013_07_20/thread_1_seq_126.725.821296933
Media Recovery Log +FLASH/primary/archivelog/2013_07_20/thread_1_seq_127.724.821296937
Media Recovery Waiting for thread 1 sequence 128 (in transit)
Recovery of Online Redo Log: Thread 1 Group 4 Seq 128 Reading mem 0
Mem# 0: +DATA/primary/onlinelog/group_4.275.821023945
Sat Jul 20 18:06:58 2013
Time drift detected. Please check VKTM trace file for more details.
Sat Jul 20 18:07:22 2013
RFS[2]: Selected log 5 for thread 1 sequence 129 dbid 1657714169 branch 820231491
Sat Jul 20 18:07:22 2013
Media Recovery Waiting for thread 1 sequence 129 (in transit)
Recovery of Online Redo Log: Thread 1 Group 5 Seq 129 Reading mem 0
Mem# 0: +DATA/primary/onlinelog/group_5.274.821023949
Sat Jul 20 18:07:24 2013
Archived Log entry 225 added for thread 1 sequence 128 ID 0x62def706 dest 1:

Alert log of the Original Standby Database During Switchover:
Sat Jul 20 18:01:08 2013
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN
ALTER DATABASE SWITCHOVER TO PRIMARY (standby)
Maximum wait for role transition is 15 minutes.
Switchover: Media recovery is still active
Role Change: Canceling MRP - no more redo to apply
Sat Jul 20 18:01:10 2013
MRP0: Background Media Recovery cancelled with status 16037
Errors in file /u01/app/oracle/diag/rdbms/standby/standby/trace/standby_pr00_4346.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Sat Jul 20 18:01:11 2013
MRP0: Background Media Recovery process shutdown (standby)
Role Change: Canceled MRP
All dispatchers and shared servers shutdown
CLOSE: killing server sessions.
CLOSE: all sessions shutdown successfully.
Sat Jul 20 18:01:11 2013
SMON: disabling cache recovery
Sat Jul 20 18:01:11 2013
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 11
Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/standby/standby/trace/standby_ora_4252.trc
SwitchOver after complete recovery through change 963700
Online logfile pre-clearing operation disabled by switchover
Online log +DATA/standby/onlinelog/group_1.294.821111469: Thread 1 Group 1 was previously cleared
Online log +FLASH/standby/onlinelog/group_1.721.821111473: Thread 1 Group 1 was previously cleared
Online log +DATA/standby/onlinelog/group_2.295.821111477: Thread 1 Group 2 was previously cleared
Online log +FLASH/standby/onlinelog/group_2.722.821111483: Thread 1 Group 2 was previously cleared
Online log +DATA/standby/onlinelog/group_3.296.821111491: Thread 1 Group 3 was previously cleared
Online log +FLASH/standby/onlinelog/group_3.723.821111495: Thread 1 Group 3 was previously cleared
Standby became primary SCN: 963698
AUDIT_TRAIL initialization parameter is changed back to its original value as specified in the parameter file.
Switchover: Complete - Database mounted as primary
Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN
Sat Jul 20 18:02:11 2013
ALTER DATABASE OPEN
Sat Jul 20 18:02:11 2013
Assigning activation ID 1658779398 (0x62def706)
Thread 1 advanced to log sequence 127 (thread open)
Sat Jul 20 18:02:11 2013
ARC0: Becoming the 'no SRL' ARCH
Thread 1 opened at log sequence 127
Current log# 2 seq# 127 mem# 0: +DATA/standby/onlinelog/group_2.295.821111477
Current log# 2 seq# 127 mem# 1: +FLASH/standby/onlinelog/group_2.722.821111483
Successful open of redo thread 1
Sat Jul 20 18:02:11 2013
ARC1: Becoming the 'no SRL' ARCH
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Jul 20 18:02:11 2013
NSA2 started with pid=24, OS id=4487
Sat Jul 20 18:02:11 2013
ARC2: Becoming the 'no SRL' ARCH
Sat Jul 20 18:02:11 2013
SMON: enabling cache recovery
Archived Log entry 99 added for thread 1 sequence 126 ID 0x62def706 dest 1:
ARC0: Standby redo logfile selected for thread 1 sequence 126 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 128 (LGWR switch)
Current log# 3 seq# 128 mem# 0: +DATA/standby/onlinelog/group_3.296.821111491
Current log# 3 seq# 128 mem# 1: +FLASH/standby/onlinelog/group_3.723.821111495
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 128 for destination LOG_ARCHIVE_DEST_2
[4252] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:402234 end:406014 diff:3780 (37 seconds)
Dictionary check beginning
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
Sat Jul 20 18:02:16 2013
idle dispatcher 'D000' terminated, pid = (19, 1)
Starting background process SMCO
Sat Jul 20 18:02:16 2013
SMCO started with pid=31, OS id=4499
Archived Log entry 101 added for thread 1 sequence 127 ID 0x62def706 dest 1:
ARC0: Standby redo logfile selected for thread 1 sequence 127 for destination LOG_ARCHIVE_DEST_2
No Resource Manager plan active
Sat Jul 20 18:02:22 2013
Starting background process QMNC
Sat Jul 20 18:02:22 2013
QMNC started with pid=33, OS id=4507
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Completed: ALTER DATABASE OPEN
Sat Jul 20 18:02:34 2013
Starting background process CJQ0
Sat Jul 20 18:02:34 2013
CJQ0 started with pid=40, OS id=4550
Setting Resource Manager plan SCHEDULER[0x318E]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sat Jul 20 18:02:39 2013
Starting background process VKRM
Sat Jul 20 18:02:39 2013
VKRM started with pid=34, OS id=4558
Sat Jul 20 18:03:25 2013
ARC3: STARTING ARCH PROCESSES
Sat Jul 20 18:03:25 2013
ARC5 started with pid=35, OS id=4580
ARC5: Archival started
ARC3: STARTING ARCH PROCESSES COMPLETE
Errors in file /u01/app/oracle/diag/rdbms/standby/standby/trace/standby_arc5_4580.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '+DATA/primary/onlinelog/group_4.275.821023945'
ORA-17503: ksfdopn:2 Failed to open file +DATA/primary/onlinelog/group_4.275.821023945
ORA-15173: entry 'primary' does not exist in directory '/'
Errors in file /u01/app/oracle/diag/rdbms/standby/standby/trace/standby_arc5_4580.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '+DATA/primary/onlinelog/group_4.275.821023945'
ORA-17503: ksfdopn:2 Failed to open file +DATA/primary/onlinelog/group_4.275.821023945
ORA-15173: entry 'primary' does not exist in directory '/'
Deleted Oracle managed file +DATA/primary/onlinelog/group_4.275.821023945
Sat Jul 20 18:03:39 2013
Errors in file /u01/app/oracle/diag/rdbms/standby/standby/trace/standby_arc5_4580.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '+DATA/primary/onlinelog/group_5.274.821023949'
ORA-17503: ksfdopn:2 Failed to open file +DATA/primary/onlinelog/group_5.274.821023949
ORA-15173: entry 'primary' does not exist in directory '/'
Errors in file /u01/app/oracle/diag/rdbms/standby/standby/trace/standby_arc5_4580.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '+DATA/primary/onlinelog/group_5.274.821023949'
ORA-17503: ksfdopn:2 Failed to open file +DATA/primary/onlinelog/group_5.274.821023949
ORA-15173: entry 'primary' does not exist in directory '/'
Deleted Oracle managed file +DATA/primary/onlinelog/group_5.274.821023949
Sat Jul 20 18:03:53 2013
Errors in file /u01/app/oracle/diag/rdbms/standby/standby/trace/standby_arc5_4580.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '+DATA/primary/onlinelog/group_6.273.821023953'
ORA-17503: ksfdopn:2 Failed to open file +DATA/primary/onlinelog/group_6.273.821023953
ORA-15173: entry 'primary' does not exist in directory '/'
Errors in file /u01/app/oracle/diag/rdbms/standby/standby/trace/standby_arc5_4580.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '+DATA/primary/onlinelog/group_6.273.821023953'
ORA-17503: ksfdopn:2 Failed to open file +DATA/primary/onlinelog/group_6.273.821023953
ORA-15173: entry 'primary' does not exist in directory '/'
Deleted Oracle managed file +DATA/primary/onlinelog/group_6.273.821023953
Errors in file /u01/app/oracle/diag/rdbms/standby/standby/trace/standby_arc5_4580.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '+DATA/primary/onlinelog/group_7.272.821023953'
ORA-17503: ksfdopn:2 Failed to open file +DATA/primary/onlinelog/group_7.272.821023953
ORA-15173: entry 'primary' does not exist in directory '/'
Errors in file /u01/app/oracle/diag/rdbms/standby/standby/trace/standby_arc5_4580.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '+DATA/primary/onlinelog/group_7.272.821023953'
ORA-17503: ksfdopn:2 Failed to open file +DATA/primary/onlinelog/group_7.272.821023953
ORA-15173: entry 'primary' does not exist in directory '/'
Deleted Oracle managed file +DATA/primary/onlinelog/group_7.272.821023953
Sat Jul 20 18:04:15 2013
Shutting down archive processes
ARCH shutting down
ARC5: Archival stopped
Sat Jul 20 18:07:21 2013
Thread 1 advanced to log sequence 129 (LGWR switch)
Current log# 1 seq# 129 mem# 0: +DATA/standby/onlinelog/group_1.294.821111469
Current log# 1 seq# 129 mem# 1: +FLASH/standby/onlinelog/group_1.721.821111473
Sat Jul 20 18:07:21 2013
Archived Log entry 103 added for thread 1 sequence 128 ID 0x62def706 dest 1:
Sat Jul 20 18:07:22 2013
LNS: Standby redo logfile selected for thread 1 sequence 129 for destination LOG_ARCHIVE_DEST_2
enujewzaiwaz
Posts: 1
Joined: Sat Oct 21, 2023 5:17 pm

Girls supervenes merit bowel, indefinitely.

Post by enujewzaiwaz »

Treat fst.slpc.oracledbs.com.thv.nm crush where to purchase ginette-35 solian generic canada solian online no script cheap us levitra sildigra coupon viagra oral jelly low price nolvadex pulmopres coupons purchase pharmacy without a prescription cystone without a prescription cystone price at walmart cipro pletal retrovir without a prescription styplon walmart price super force jelly super force jelly walmart hucog 5000 hp price lowest priligy prices best price for nizagara 50mg diprovate plus cream pills furosemide buy online no prescription flagyl vyfat without prescription subserosal <a href="https://mychik.com/pill/ginette-35/">ginette 35 information</a> <a href="https://petermillerfineart.com/solian/">solian no prescription</a> <a href="https://intuitiveangela.com/levitra/">india oversight pharmaceuticals exports levitra</a> <a href="https://mynarch.net/item/sildigra/">sildigra</a> <a href="https://ofearthandbeauty.com/viagra-oral-jelly/">viagra oral jelly information</a> <a href="https://flowerpopular.com/nolvadex/">nolvadex tablets</a> <a href="https://adailymiscellany.com/drugs/pulm ... >pulmopres without prescription</a> <a href="https://helpo.org/pharmacy/">best price pharmacy</a> <a href="https://weddingadviceuk.com/item/cystone/">cystone overnight</a> <a href="https://intuitiveangela.com/drugs/cipro/">best price 1000 cipro generic</a> order cipro <a href="https://mychik.com/pill/pletal/">cheap pletal pills no prescription</a> buy generic pletal <a href="https://shirley-elrick.com/retrovir/">purchase retrovir without a prescription</a> <a href="https://winterssolutions.com/item/styplon/">walmart styplon price</a> <a href="https://mynarch.net/item/super-force-jelly/">super force jelly pills</a> <a href="https://ofearthandbeauty.com/product/hu ... hp/">price of hucog 5000 hp</a> <a href="https://profitplusfinancial.com/lowest- ... /">priligy without dr prescription usa</a> <a href="https://profitplusfinancial.com/nizagara/">nizagara</a> <a href="https://winterssolutions.com/diprovate- ... .diprovate plus cream.com</a> diprovate plus cream.com lowest price <a href="https://coastal-ims.com/drug/lasix/">lasix/no prescription</a> <a href="https://flowerpopular.com/flagyl/">flagyl generic canada</a> <a href="https://mynarch.net/item/vyfat/">vyfat</a> nightmares https://mychik.com/pill/ginette-35/ generic ginette-35 cheap from canada https://petermillerfineart.com/solian/ generic solian uk https://intuitiveangela.com/levitra/ levitra supply beijing https://mynarch.net/item/sildigra/ sildigra https://ofearthandbeauty.com/viagra-oral-jelly/ best price viagra oral jelly viagra oral jelly from canada https://flowerpopular.com/nolvadex/ low price nolvadex https://adailymiscellany.com/drugs/pulmopres/ generic pulmopres lowest price https://helpo.org/pharmacy/ pharmacy without prescription low cost pharmacy https://weddingadviceuk.com/item/cystone/ cystone price at walmart https://intuitiveangela.com/drugs/cipro/ best price 1000 cipro generic https://mychik.com/pill/pletal/ pletal for sale overnight https://shirley-elrick.com/retrovir/ retrovir online pharmacy https://winterssolutions.com/item/styplon/ styplon https://mynarch.net/item/super-force-jelly/ generic super force jelly tablets generic super force jelly tablets https://ofearthandbeauty.com/product/hucog-5000-hp/ cheapest hucog 5000 hp https://profitplusfinancial.com/lowest-priligy-prices/ priligy without dr prescription usa priligy 90 lowest price https://profitplusfinancial.com/nizagara/ best price for nizagara 50mg https://winterssolutions.com/diprovate-plus-cream/ www.diprovate plus cream.com https://coastal-ims.com/drug/lasix/ lasix furosemide for sale https://flowerpopular.com/flagyl/ discount flagyl https://mynarch.net/item/vyfat/ vyfat proliferate condyles.
xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: Performing a Switchover to a Physical Standby Database Using SQL*Plus

Post by xaeresis »

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting
xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: Performing a Switchover to a Physical Standby Database Using SQL*Plus

Post by xaeresis »

http://audiobookkeeper.ruhttp://cottagenet.ruhttp://eyesvision.ruhttp://eyesvisions.comhttp://factoringfee.ruhttp://filmzones.ruhttp://gadwall.ruhttp://gaffertape.ruhttp://gageboard.ruhttp://gagrule.ruhttp://gallduct.ruhttp://galvanometric.ruhttp://gangforeman.ruhttp://gangwayplatform.ruhttp://garbagechute.ruhttp://gardeningleave.ruhttp://gascautery.ruhttp://gashbucket.ruhttp://gasreturn.ruhttp://gatedsweep.ruhttp://gaugemodel.ruhttp://gaussianfilter.ruhttp://gearpitchdiameter.ru
http://geartreating.ruhttp://generalizedanalysis.ruhttp://generalprovisions.ruhttp://geophysicalprobe.ruhttp://geriatricnurse.ruhttp://getintoaflap.ruhttp://getthebounce.ruhttp://habeascorpus.ruhttp://habituate.ruhttp://hackedbolt.ruhttp://hackworker.ruhttp://hadronicannihilation.ruhttp://haemagglutinin.ruhttp://hailsquall.ruhttp://hairysphere.ruhttp://halforderfringe.ruhttp://halfsiblings.ruhttp://hallofresidence.ruhttp://haltstate.ruhttp://handcoding.ruhttp://handportedhead.ruhttp://handradar.ruhttp://handsfreetelephone.ru
http://hangonpart.ruhttp://haphazardwinding.ruhttp://hardalloyteeth.ruhttp://hardasiron.ruhttp://hardenedconcrete.ruhttp://harmonicinteraction.ruhttp://hartlaubgoose.ruhttp://hatchholddown.ruhttp://haveafinetime.ruhttp://hazardousatmosphere.ruhttp://headregulator.ruhttp://heartofgold.ruhttp://heatageingresistance.ruhttp://heatinggas.ruhttp://heavydutymetalcutting.ruhttp://jacketedwall.ruhttp://japanesecedar.ruhttp://jibtypecrane.ruhttp://jobabandonment.ruhttp://jobstress.ruhttp://jogformation.ruhttp://jointcapsule.ruhttp://jointsealingmaterial.ru
http://journallubricator.ruhttp://juicecatcher.ruhttp://junctionofchannels.ruhttp://justiciablehomicide.ruhttp://juxtapositiontwin.ruhttp://kaposidisease.ruhttp://keepagoodoffing.ruhttp://keepsmthinhand.ruhttp://kentishglory.ruhttp://kerbweight.ruhttp://kerrrotation.ruhttp://keymanassurance.ruhttp://keyserum.ruhttp://kickplate.ruhttp://killthefattedcalf.ruhttp://kilowattsecond.ruhttp://kingweakfish.ruhttp://kinozones.ruhttp://kleinbottle.ruhttp://kneejoint.ruhttp://knifesethouse.ruhttp://knockonatom.ruhttp://knowledgestate.ru
http://kondoferromagnet.ruhttp://labeledgraph.ruhttp://laborracket.ruhttp://labourearnings.ruhttp://labourleasing.ruhttp://laburnumtree.ruhttp://lacingcourse.ruhttp://lacrimalpoint.ruhttp://lactogenicfactor.ruhttp://lacunarycoefficient.ruhttp://ladletreatediron.ruhttp://laggingload.ruhttp://laissezaller.ruhttp://lambdatransition.ruhttp://laminatedmaterial.ruhttp://lammasshoot.ruhttp://lamphouse.ruhttp://lancecorporal.ruhttp://lancingdie.ruhttp://landingdoor.ruhttp://landmarksensor.ruhttp://landreform.ruhttp://landuseratio.ru
http://languagelaboratory.ruhttp://largeheart.ruhttp://lasercalibration.ruhttp://laserlens.ruhttp://laserpulse.ruhttp://laterevent.ruhttp://latrinesergeant.ruhttp://layabout.ruhttp://leadcoating.ruhttp://leadingfirm.ruhttp://learningcurve.ruhttp://leaveword.ruhttp://machinesensible.ruhttp://magneticequator.ruhttp://magnetotelluricfield.ruhttp://mailinghouse.ruhttp://majorconcern.ruhttp://mammasdarling.ruhttp://managerialstaff.ruhttp://manipulatinghand.ruhttp://manualchoke.ruhttp://medinfobooks.ruhttp://mp3lists.ru
http://nameresolution.ruhttp://naphtheneseries.ruhttp://narrowmouthed.ruhttp://nationalcensus.ruhttp://naturalfunctor.ruhttp://navelseed.ruhttp://neatplaster.ruhttp://necroticcaries.ruhttp://negativefibration.ruhttp://neighbouringrights.ruhttp://objectmodule.ruhttp://observationballoon.ruhttp://obstructivepatent.ruhttp://oceanmining.ruhttp://octupolephonon.ruhttp://offlinesystem.ruhttp://offsetholder.ruhttp://olibanumresinoid.ruhttp://onesticket.ruhttp://packedspheres.ruhttp://pagingterminal.ruhttp://palatinebones.ruhttp://palmberry.ru
http://papercoating.ruhttp://paraconvexgroup.ruhttp://parasolmonoplane.ruhttp://parkingbrake.ruhttp://partfamily.ruhttp://partialmajorant.ruhttp://quadrupleworm.ruhttp://qualitybooster.ruhttp://quasimoney.ruhttp://quenchedspark.ruhttp://quodrecuperet.ruhttp://rabbetledge.ruhttp://radialchaser.ruhttp://radiationestimator.ruhttp://railwaybridge.ruhttp://randomcoloration.ruhttp://rapidgrowth.ruhttp://rattlesnakemaster.ruhttp://reachthroughregion.ruhttp://readingmagnifier.ruhttp://rearchain.ruhttp://recessioncone.ruhttp://recordedassignment.ru
http://rectifiersubstation.ruhttp://redemptionvalue.ruhttp://reducingflange.ruhttp://referenceantigen.ruhttp://regeneratedprotein.ruhttp://reinvestmentplan.ruhttp://safedrilling.ruhttp://sagprofile.ruhttp://salestypelease.ruhttp://samplinginterval.ruhttp://satellitehydrology.ruhttp://scarcecommodity.ruhttp://scrapermat.ruhttp://screwingunit.ruhttp://seawaterpump.ruhttp://secondaryblock.ruhttp://secularclergy.ruhttp://seismicefficiency.ruhttp://selectivediffuser.ruhttp://semiasphalticflux.ruhttp://semifinishmachining.ruhttp://spicetrade.ruhttp://spysale.ru
http://stungun.ruhttp://tacticaldiameter.ruhttp://tailstockcenter.ruhttp://tamecurve.ruhttp://tapecorrection.ruhttp://tappingchuck.ruhttp://taskreasoning.ruhttp://technicalgrade.ruhttp://telangiectaticlipoma.ruhttp://telescopicdamper.ruhttp://temperateclimate.ruhttp://temperedmeasure.ruhttp://tenementbuilding.rutuchkashttp://ultramaficrock.ruhttp://ultraviolettesting.ru
xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: Performing a Switchover to a Physical Standby Database Using SQL*Plus

Post by xaeresis »

xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: Performing a Switchover to a Physical Standby Database Using SQL*Plus

Post by xaeresis »

Post Reply