Monday, January 10, 2011

Snapshot standby example in 11gR2 (Part 2)


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 636100608 bytes
Fixed Size 1346048 bytes
Variable Size 406849024 bytes
Database Buffers 222298112 bytes
Redo Buffers 5607424 bytes
Database mounted.
SQL> alter database convert to physical standby;

Database altered.

SQL> recover managed standby database disconnect;
ORA-01507: database not mounted


SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 636100608 bytes
Fixed Size 1346048 bytes
Variable Size 406849024 bytes
Database Buffers 222298112 bytes
Redo Buffers 5607424 bytes
Database mounted.

SQL> recover managed standby database using current logfile disconnect;
Media recovery complete.
SQL>


From alert_drorcl.log:


2011-01-10 11:17:41.693000 +08:00
alter database convert to physical standby
ALTER DATABASE CONVERT TO PHYSICAL STANDBY (drorcl)
krsv_proc_kill: Killing 3 processes (all RFS)
2011-01-10 11:17:43.053000 +08:00
Flashback Restore Start
Flashback Restore Complete
Drop guaranteed restore point
Stopping background process RVWR
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/DRORCL/flashback/o1_mf_6lny14kz_.flb
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/DRORCL/flashback/o1_mf_6lny14yq_.flb
Guaranteed restore point dropped
Clearing standby activation ID 4067086165 (0xf26acf55)
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;
Completed: alter database convert to physical standby
2011-01-10 11:18:38.426000 +08:00
ALTER DATABASE RECOVER managed standby database disconnect
ORA-1507 signalled during: ALTER DATABASE RECOVER managed standby database disconnect ...
2011-01-10 11:18:46.330000 +08:00
Shutting down instance (abort)
License high water mark = 4
USER (ospid: 10661): terminating the instance
2011-01-10 11:18:47.370000 +08:00
Instance terminated by USER, pid = 10661
Instance shutdown complete
2011-01-10 11:18:50.315000 +08:00
Starting ORACLE instance (normal)
2011-01-10 11:18:51.838000 +08:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =84
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfiledrorcl.ora
System parameters with non-default values:
processes = 500
sessions = 772
memory_target = 608M
control_files = "/u01/app/oracle/oradata/drorcl/control01.ctl"
control_files = "/u01/app/oracle/fast_recovery_area/drorcl/control02.ctl"
db_file_name_convert = "prorcl"
db_file_name_convert = "drorcl"
log_file_name_convert = "prorcl"
log_file_name_convert = "drorcl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=drorcl"
log_archive_dest_2 = "SERVICE=prorcl VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prorcl COMPRESSION=enable"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "ENABLE"
fal_server = "prorcl"
log_archive_format = "%t_%s_%r.dbf"
db_recovery_file_dest = "/u01/app/oracle/fast_recovery_area"
db_recovery_file_dest_size= 4977M
standby_file_management = "AUTO"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=drorclXDB)"
audit_file_dest = "/u01/app/oracle/admin/drorcl/adump"
audit_trail = "DB"
db_name = "prorcl"
db_unique_name = "DRORCL"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
PMON started with pid=2, OS id=10756
PSP0 started with pid=3, OS id=10758
VKTM started with pid=4, OS id=10760 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
GEN0 started with pid=5, OS id=10764
DIAG started with pid=6, OS id=10766
2011-01-10 11:18:52.802000 +08:00
DBRM started with pid=7, OS id=10768
DIA0 started with pid=8, OS id=10770
MMAN started with pid=9, OS id=10772
DBW0 started with pid=10, OS id=10774
LGWR started with pid=11, OS id=10776
CKPT started with pid=12, OS id=10778
SMON started with pid=13, OS id=10780
RECO started with pid=14, OS id=10782
MMON started with pid=15, OS id=10784
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=16, OS id=10786
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
2011-01-10 11:18:53.922000 +08:00
ALTER DATABASE MOUNT
2011-01-10 11:18:59.414000 +08:00
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=20, OS id=10848
2011-01-10 11:19:00.736000 +08:00
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Successful mount of redo thread 1, with mount id 4067063582
ARC1 started with pid=21, OS id=10850
Physical Standby Database mounted.
Lost write protection disabled
ARC2 started with pid=22, OS id=10852
Completed: ALTER DATABASE MOUNT
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
ARC3 started with pid=23, OS id=10854
2011-01-10 11:19:02.426000 +08:00
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
2011-01-10 11:19:24.519000 +08:00
ALTER DATABASE RECOVER managed standby database using current logfile disconnect
Attempt to start background Managed Standby Recovery process (drorcl)
MRP0 started with pid=24, OS id=10874
MRP0: Background Managed Standby Recovery process started (drorcl)
2011-01-10 11:19:31.054000 +08:00
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Clearing online redo logfile 1 /u01/app/oracle/oradata/drorcl/redo01.log
Clearing online log 1 of thread 1 sequence number 1
2011-01-10 11:19:32.300000 +08:00
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 /u01/app/oracle/oradata/drorcl/redo02.log
Clearing online log 2 of thread 1 sequence number 2
Completed: ALTER DATABASE RECOVER managed standby database using current logfile disconnect
2011-01-10 11:19:33.993000 +08:00
Clearing online redo logfile 2 complete
Media Recovery Log /u01/app/oracle/fast_recovery_area/DRORCL/archivelog/2011_01_10/o1_mf_1_63_6lny7m56_.arc
Media Recovery Log /u01/app/oracle/fast_recovery_area/DRORCL/archivelog/2011_01_10/o1_mf_1_64_6lny7mdb_.arc
Media Recovery Log /u01/app/oracle/fast_recovery_area/DRORCL/archivelog/2011_01_10/o1_mf_1_65_6lny7m8d_.arc
Media Recovery Log /u01/app/oracle/fast_recovery_area/DRORCL/archivelog/2011_01_10/o1_mf_1_66_6lny7m4h_.arc
Media Recovery Log /u01/app/oracle/fast_recovery_area/DRORCL/archivelog/2011_01_10/o1_mf_1_67_6lny7m6j_.arc
Media Recovery Log /u01/app/oracle/fast_recovery_area/DRORCL/archivelog/2011_01_10/o1_mf_1_68_6lny7pm7_.arc
Media Recovery Log /u01/app/oracle/fast_recovery_area/DRORCL/archivelog/2011_01_10/o1_mf_1_69_6lnyl4ct_.arc
Recovery of Online Redo Log: Thread 1 Group 5 Seq 70 Reading mem 0
Mem# 0: /u01/app/oracle/oradata/drorcl/stdby05.log