Standby database using RMAN duplicate
Steps to create standby database using RMAN:
primary database name:taurus
host name:sony
db_unique_name=production
standby database name:taurus
hostname:sonydr
db_unique_name=standby
Oracle 10.2.0.1.0
RHEL 4
-force logging is enabled on the primary database.
-password file is created for primary database
-primary database is in archivelog mode
SQL> select name,open_mode,log_mode 2 from v$database; NAME OPEN_MODE LOG_MODE --------- ---------- ------------ TAURUS READ WRITE ARCHIVELOG SQL> SQL> select instance_name,host_name 2 from v$instance; INSTANCE_NAME HOST_NAME ---------------- ---------------------------------------------------------------- taurus sony SQL>
create the pfile to add dataguard related parameters:
SQL> create pfile='/u01/backup/pfile.ora' from spfile; File created. SQL> SQL> ! [oracle@sony ~]$ vi /u01/backup/pfile.ora taurus.__db_cache_size=243269632 taurus.__java_pool_size=4194304 taurus.__large_pool_size=4194304 taurus.__shared_pool_size=92274688 taurus.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/taurus/adump' *.background_dump_dest='/u01/app/oracle/admin/taurus/bdump' *.compatible='10.2.0.1.0' *.control_files='/u01/app/oracle/TAURUS/controlfile/o1_mf_6r25p3f5_.ctl','/u01/app/oracle/flash_recovery_area/TAURUS/controlfile/o1_mf_6r25p3j0_.ctl' *.core_dump_dest='/u01/app/oracle/admin/taurus/cdump' *.db_block_size=8192 *.db_create_file_dest='/u01/app/oracle' *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='taurus' *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=taurusXDB)' *.job_queue_processes=10 *.log_archive_format='%t_%s_%r.dbf' *.open_cursors=300 *.pga_aggregate_target=115343360 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=347078656 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/oracle/admin/taurus/udump' ####dataguard#### service_names=taurus FAL_SERVER='TAURUSSTDBY' FAL_CLIENT='TAURUS' log_archive_dest_1='service=taurusstdby valid_for=(online_logfiles,primary_role) db_unique_name=standby' db_unique_name=production log_archive_dest_state_1=enable log_archive_config='dg_config=(production,standby)' standby_file_management=auto db_file_name_convert='/u01/taurusstandby/','/u01/app/oracle/TAURUS/datafile/' log_file_name_convert='/u01/taurusstandby/','/u01/app/oracle/TAURUS/onlinelog/'
modify the tnsnames.ora file to add entry for primary and standby database:
[oracle@sony ~]$ cd /u01/app/oracle/product/10.2.0/db_1/network/admin/ [oracle@sony admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. UNICORN = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sony)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = unicorn) ) ) TAURUS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sony)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = taurus) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) TAURUSSTDBY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sonydr)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = taurusstdby) ) )
copy the pfile and password file to standby server.
modify the parameter file for standby database
[oracle@sony admin]$ scp /u01/backup/pfile.ora oracle@sonydr:/u01/backup/pfile.ora The authenticity of host 'sonydr (192.168.2.21)' can't be established. RSA key fingerprint is 14:07:8b:fb:c3:ef:65:20:e3:bf:62:ce:d3:08:29:77. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'sonydr,192.168.2.21' (RSA) to the list of known hosts. oracle@sonydr's password: pfile.ora 100% 1576 1.5KB/s 00:00 [oracle@sony admin]$ [oracle@sony dbs]$ scp /u01/app/oracle/product/10.2.0/db_1/dbs/orapwtaurus oracle@sonydr:/u01/app/oracle/product/10.2.0/db_1/dbs/orapwtaurusstdby oracle@sonydr's password: orapwtaurus 100% 1536 1.5KB/s 00:00 [oracle@sony dbs]$
modified parameter file for standby:
db_cache_size=243269632 java_pool_size=4194304 large_pool_size=4194304 shared_pool_size=92274688 streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/taurusstdby/adump' *.background_dump_dest='/u01/app/oracle/admin/taurusstdby/bdump' *.compatible='10.2.0.1.0' #*.control_files='/u01/app/oracle/TAURUS/controlfile/o1_mf_6r25p3f5_.ctl','/u01/app/oracle/flash_recovery_area/TAURUS/controlfile/o1_mf_6r25p3j0_.ctl' *.core_dump_dest='/u01/app/oracle/admin/taurusstdby/cdump' *.db_block_size=8192 *.db_create_file_dest='/u01/taurusstandby/' *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='taurus' *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=taurusstdbyXDB)' *.job_queue_processes=10 *.log_archive_format='%t_%s_%r.dbf' *.open_cursors=300 *.pga_aggregate_target=115343360 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=347078656 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/oracle/admin/taurusstdby/udump' ####dataguard#### service_names=taurusstdby FAL_SERVER='TAURUS' FAL_CLIENT='TAURUSSTDBY' log_archive_dest_1='service=taurus valid_for=(online_logfiles,primary_role) db_unique_name=production' db_unique_name=standby log_archive_dest_state_1=enable log_archive_config='dg_config=(production,standby)' standby_file_management=auto db_file_name_convert='/u01/app/oracle/TAURUS/datafile/','/u01/taurusstandby/' log_file_name_convert='/u01/app/oracle/TAURUS/onlinelog/','/u01/taurusstandby/'
check for connectivity between the two databases:
[oracle@sonydr admin]$ tnsping taurus TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 18-MAR-2011 01:54:47 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sony)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = taurus))) OK (0 msec) [oracle@sonydr admin]$ [oracle@sony admin]$ tnsping taurusstdby TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 18-MAR-2011 01:55:06 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sonydr)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = taurusstdby))) OK (0 msec) [oracle@sony admin]$
backup the controlfile for standby
[oracle@sony dbs]$ echo $ORACLE_SID taurus [oracle@sony dbs]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Fri Mar 18 02:02:03 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: TAURUS (DBID=1293056731) RMAN> backup current controlfile for standby format '/u01/backup/standbycontrol.ctl'; Starting backup at 18-MAR-11 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=158 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including standby control file in backupset channel ORA_DISK_1: starting piece 1 at 18-MAR-11 channel ORA_DISK_1: finished piece 1 at 18-MAR-11 piece handle=/u01/backup/standbycontrol.ctl tag=TAG20110318T020241 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 18-MAR-11 RMAN>
backup the primary database and copy the standby controlfile and backup pieces to standby host
[oracle@sony backup]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Fri Mar 18 02:24:13 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: TAURUS (DBID=1293056731) RMAN> run 2> { 3> allocate channel c2 device type disk format '/u01/backup/%u'; 4> backup database plus archivelog; 5> } using target database control file instead of recovery catalog allocated channel: c2 channel c2: sid=143 devtype=DISK Starting backup at 18-MAR-11 current log archived channel c2: starting archive log backupset channel c2: specifying archive log(s) in backup set input archive log thread=1 sequence=1 recid=1 stamp=745983457 input archive log thread=1 sequence=2 recid=2 stamp=745983516 input archive log thread=1 sequence=3 recid=3 stamp=746017820 input archive log thread=1 sequence=4 recid=4 stamp=746018243 input archive log thread=1 sequence=5 recid=5 stamp=746018295 input archive log thread=1 sequence=6 recid=6 stamp=746065687 input archive log thread=1 sequence=7 recid=8 stamp=746071594 input archive log thread=1 sequence=8 recid=7 stamp=746071593 input archive log thread=1 sequence=9 recid=9 stamp=746071597 input archive log thread=1 sequence=10 recid=10 stamp=746071597 input archive log thread=1 sequence=11 recid=11 stamp=746071660 input archive log thread=1 sequence=12 recid=12 stamp=746072191 input archive log thread=1 sequence=13 recid=13 stamp=746072191 input archive log thread=1 sequence=14 recid=14 stamp=746072196 input archive log thread=1 sequence=15 recid=29 stamp=746072508 input archive log thread=1 sequence=16 recid=31 stamp=746072561 input archive log thread=1 sequence=17 recid=33 stamp=746072701 channel c2: starting piece 1 at 18-MAR-11 channel c2: finished piece 1 at 18-MAR-11 piece handle=/u01/backup/0bm7gaju tag=TAG20110318T022501 comment=NONE channel c2: backup set complete, elapsed time: 00:00:04 Finished backup at 18-MAR-11 Starting backup at 18-MAR-11 channel c2: starting full datafile backupset channel c2: specifying datafile(s) in backupset input datafile fno=00001 name=/u01/app/oracle/TAURUS/datafile/o1_mf_system_6r25o651_.dbf input datafile fno=00003 name=/u01/app/oracle/TAURUS/datafile/o1_mf_sysaux_6r25o65c_.dbf input datafile fno=00002 name=/u01/app/oracle/TAURUS/datafile/o1_mf_undotbs1_6r25o674_.dbf input datafile fno=00005 name=/u01/app/oracle/TAURUS/datafile/o1_mf_mandar_6r37s0yl_.dbf input datafile fno=00004 name=/u01/app/oracle/TAURUS/datafile/o1_mf_users_6r25o67k_.dbf channel c2: starting piece 1 at 18-MAR-11 channel c2: finished piece 1 at 18-MAR-11 piece handle=/u01/backup/0cm7gak2 tag=TAG20110318T022506 comment=NONE channel c2: backup set complete, elapsed time: 00:00:45 channel c2: starting full datafile backupset channel c2: specifying datafile(s) in backupset including current control file in backupset including current SPFILE in backupset channel c2: starting piece 1 at 18-MAR-11 channel c2: finished piece 1 at 18-MAR-11 piece handle=/u01/backup/0dm7galf tag=TAG20110318T022506 comment=NONE channel c2: backup set complete, elapsed time: 00:00:02 Finished backup at 18-MAR-11 Starting backup at 18-MAR-11 current log archived channel c2: starting archive log backupset channel c2: specifying archive log(s) in backup set input archive log thread=1 sequence=18 recid=35 stamp=746072754 channel c2: starting piece 1 at 18-MAR-11 channel c2: finished piece 1 at 18-MAR-11 piece handle=/u01/backup/0em7gali tag=TAG20110318T022554 comment=NONE channel c2: backup set complete, elapsed time: 00:00:02 Finished backup at 18-MAR-11 released channel: c2 RMAN> [oracle@sony backup]$ scp standbycontrol.ctl oracle@sonydr:/u01/backup/ oracle@sonydr's password: standbycontrol.ctl 100% 6944KB 6.8MB/s 00:01 [oracle@sony backup]$ pwd /u01/backup [oracle@sony backup]$ ls -lrth total 577M -rw-r--r-- 1 oracle oinstall 1.6K Mar 18 01:37 pfile.ora -rw-r----- 1 oracle oinstall 6.8M Mar 18 02:02 standbycontrol.ctl -rw-r----- 1 oracle oinstall 56M Mar 18 02:25 0bm7gaju -rw-r----- 1 oracle oinstall 507M Mar 18 02:25 0cm7gak2 -rw-r----- 1 oracle oinstall 7.0M Mar 18 02:25 0dm7galf -rw-r----- 1 oracle oinstall 3.0K Mar 18 02:25 0em7gali [oracle@sony backup]$ [oracle@sony backup]$ scp 0* oracle@sonydr:/u01/backup/ oracle@sonydr's password: 0bm7gaju 100% 55MB 13.8MB/s 00:04 0cm7gak2 100% 507MB 12.7MB/s 00:40 0dm7galf 100% 7168KB 7.0MB/s 00:01 0em7gali 100% 3072 3.0KB/s 00:00 [oracle@sony backup]$
restart both instances with new parameter file:
[oracle@sony backup]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 18 02:10:44 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> SQL> SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> SQL> SQL> SQL> startup pfile='/u01/backup/pfile.ora'; ORACLE instance started. Total System Global Area 348127232 bytes Fixed Size 1219352 bytes Variable Size 100664552 bytes Database Buffers 243269632 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SQL> SQL> create spfile from pfile='/u01/backup/pfile.ora'; File created. SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> SQL> startup ORACLE instance started. Total System Global Area 348127232 bytes Fixed Size 1219352 bytes Variable Size 100664552 bytes Database Buffers 243269632 bytes Redo Buffers 2973696 bytes show parameter log_arDatabase mounted. chive_dDatabase opened. SQL> est_1 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_1 string service=taurusstdby valid_for= (online_logfiles,primary_role) db_unique_name=standby log_archive_dest_10 string SQL> standby: [oracle@sonydr ~]$ echo $ORACLE_SID taurusstdby [oracle@sonydr ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 18 02:11:39 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount pfile='/u01/backup/pfile.ora'; ORACLE instance started. Total System Global Area 348127232 bytes Fixed Size 1219352 bytes Variable Size 100664552 bytes Database Buffers 243269632 bytes Redo Buffers 2973696 bytes SQL> create spfile from pfile='/u01/backup/pfile.ora'; File created. SQL> show parameter log_archive_dest_1 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_1 string service=taurus valid_for=(onli ne_logfiles,primary_role) db_u nique_name=production log_archive_dest_10 string SQL> shut immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL> SQL> startup nomount; ORACLE instance started. Total System Global Area 348127232 bytes Fixed Size 1219352 bytes Variable Size 100664552 bytes Database Buffers 243269632 bytes Redo Buffers 2973696 bytes SQL>
RMAN duplicate for standby:
[oracle@sony backup]$ rman target / auxiliary sys@taurusstdby Recovery Manager: Release 10.2.0.1.0 - Production on Fri Mar 18 02:30:20 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: TAURUS (DBID=1293056731) auxiliary database Password: connected to auxiliary database: TAURUS (not mounted) RMAN> duplicate target database for standby dorecover; Starting Duplicate Db at 18-MAR-11 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid=155 devtype=DISK contents of Memory Script: { set until scn 500967; restore clone standby controlfile; sql clone 'alter database mount standby database'; } executing Memory Script executing command: SET until clause Starting restore at 18-MAR-11 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/standbycontrol.ctl channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/u01/backup/standbycontrol.ctl tag=TAG20110318T020241 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 output filename=/u01/taurusstandby/STANDBY/controlfile/o1_mf_6r4wvkxo_.ctl output filename=/u01/app/oracle/flash_recovery_area/STANDBY/controlfile/o1_mf_6r4wvl4g_.ctl Finished restore at 18-MAR-11 sql statement: alter database mount standby database released channel: ORA_AUX_DISK_1 contents of Memory Script: { set until scn 500967; set newname for tempfile 1 to "/u01/taurusstandby/o1_mf_temp_6r25pjy7_.tmp"; switch clone tempfile all; set newname for datafile 1 to "/u01/taurusstandby/o1_mf_system_6r25o651_.dbf"; set newname for datafile 2 to "/u01/taurusstandby/o1_mf_undotbs1_6r25o674_.dbf"; set newname for datafile 3 to "/u01/taurusstandby/o1_mf_sysaux_6r25o65c_.dbf"; set newname for datafile 4 to "/u01/taurusstandby/o1_mf_users_6r25o67k_.dbf"; set newname for datafile 5 to "/u01/taurusstandby/o1_mf_mandar_6r37s0yl_.dbf"; restore check readonly clone database ; } executing Memory Script executing command: SET until clause executing command: SET NEWNAME renamed temporary file 1 to /u01/taurusstandby/o1_mf_temp_6r25pjy7_.tmp in control file executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 18-MAR-11 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid=155 devtype=DISK channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u01/taurusstandby/o1_mf_system_6r25o651_.dbf restoring datafile 00002 to /u01/taurusstandby/o1_mf_undotbs1_6r25o674_.dbf restoring datafile 00003 to /u01/taurusstandby/o1_mf_sysaux_6r25o65c_.dbf restoring datafile 00004 to /u01/taurusstandby/o1_mf_users_6r25o67k_.dbf restoring datafile 00005 to /u01/taurusstandby/o1_mf_mandar_6r37s0yl_.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/0cm7gak2 channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/u01/backup/0cm7gak2 tag=TAG20110318T022506 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:30 Finished restore at 18-MAR-11 contents of Memory Script: { switch clone datafile all; } executing Memory Script datafile 1 switched to datafile copy input datafile copy recid=6 stamp=746073056 filename=/u01/taurusstandby/STANDBY/datafile/o1_mf_system_6r4xmbqp_.dbf datafile 2 switched to datafile copy input datafile copy recid=7 stamp=746073056 filename=/u01/taurusstandby/STANDBY/datafile/o1_mf_undotbs1_6r4xmbrl_.dbf datafile 3 switched to datafile copy input datafile copy recid=8 stamp=746073056 filename=/u01/taurusstandby/STANDBY/datafile/o1_mf_sysaux_6r4xmbrc_.dbf datafile 4 switched to datafile copy input datafile copy recid=9 stamp=746073056 filename=/u01/taurusstandby/STANDBY/datafile/o1_mf_users_6r4xmbt6_.dbf datafile 5 switched to datafile copy input datafile copy recid=10 stamp=746073056 filename=/u01/taurusstandby/STANDBY/datafile/o1_mf_mandar_6r4xmbrw_.dbf contents of Memory Script: { set until scn 500967; recover standby clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 18-MAR-11 using channel ORA_AUX_DISK_1 starting media recovery channel ORA_AUX_DISK_1: starting archive log restore to default destination channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=7 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=8 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=9 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=10 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=11 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=12 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=13 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=14 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=15 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=16 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=17 channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/0bm7gaju channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/u01/backup/0bm7gaju tag=TAG20110318T022501 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_7_6r4xncko_.arc thread=1 sequence=7 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_7_6r4xncko_.arc recid=11 stamp=746073061 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_8_6r4xnd2f_.arc thread=1 sequence=8 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_8_6r4xnd2f_.arc recid=7 stamp=746073060 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_9_6r4xncoy_.arc thread=1 sequence=9 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_9_6r4xncoy_.arc recid=4 stamp=746073059 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_10_6r4xnd3o_.arc thread=1 sequence=10 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_10_6r4xnd3o_.arc recid=8 stamp=746073060 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_11_6r4xnd4r_.arc thread=1 sequence=11 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_11_6r4xnd4r_.arc recid=9 stamp=746073060 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_12_6r4xnclr_.arc thread=1 sequence=12 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_12_6r4xnclr_.arc recid=3 stamp=746073059 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_13_6r4xnd5v_.arc thread=1 sequence=13 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_13_6r4xnd5v_.arc recid=10 stamp=746073060 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_14_6r4xncs6_.arc thread=1 sequence=14 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_14_6r4xncs6_.arc recid=5 stamp=746073060 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_15_6r4xncny_.arc thread=1 sequence=15 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_15_6r4xncny_.arc recid=2 stamp=746073059 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_16_6r4xnct8_.arc thread=1 sequence=16 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_16_6r4xnct8_.arc recid=6 stamp=746073060 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_17_6r4xncn4_.arc thread=1 sequence=17 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_17_6r4xncn4_.arc recid=1 stamp=746073059 channel ORA_AUX_DISK_1: starting archive log restore to default destination channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=18 channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/0em7gali channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/u01/backup/0em7gali tag=TAG20110318T022554 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02 archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_18_6r4xnml3_.arc thread=1 sequence=18 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18/o1_mf_1_18_6r4xnml3_.arc recid=12 stamp=746073067 media recovery complete, elapsed time: 00:00:03 Finished recover at 18-MAR-11 Finished Duplicate Db at 18-MAR-11 RMAN>
switch logfiles on the primary database,put the standby database in managed recovery mode and check for sync
the logs from primary are shipped over to standby at fra destination:
primary:
SQL> select max(sequence#) from v$archived_log; MAX(SEQUENCE#) -------------- 18 SQL> alter system switch logfile; System altered. SQL> / System altered. SQL> SQL> SQL> SQL> SQL> / System altered. SQL> SQL> SQL> SQL> select max(sequence#) from v$archived_log; MAX(SEQUENCE#) -------------- 21 SQL>
standby:
SQL> select name,open_mode,log_mode 2 from v$database; NAME OPEN_MODE LOG_MODE --------- ---------- ------------ TAURUS MOUNTED ARCHIVELOG SQL> select recovery_mode 2 from v$archive_dest_status; RECOVERY_MODE ----------------------- IDLE IDLE IDLE IDLE IDLE IDLE IDLE IDLE IDLE IDLE IDLE 11 rows selected. SQL> SQL> select max(sequence#) from v$log_history; MAX(SEQUENCE#) -------------- 18 SQL> alter database recover managed standby database disconnect from session; Database altered. SQL> select recovery_mode 2 from v$archive_dest_status; RECOVERY_MODE ----------------------- MANAGED MANAGED MANAGED MANAGED MANAGED MANAGED MANAGED MANAGED MANAGED MANAGED MANAGED 11 rows selected. SQL> select max(sequence#) from v$log_history; MAX(SEQUENCE#) -------------- 21 SQL> /u01/app/oracle/flash_recovery_area/STANDBY/archivelog/2011_03_18 [oracle@sonydr 2011_03_18]$ ls -lrth total 57M -rw-r----- 1 oracle oinstall 32M Mar 18 02:19 o1_mf_1_1_6r4wyr5h_.arc -rw-r----- 1 oracle oinstall 213K Mar 18 02:19 o1_mf_1_3_6r4wyvtf_.arc -rw-r----- 1 oracle oinstall 1.0K Mar 18 02:19 o1_mf_1_2_6r4wyvqc_.arc -rw-r----- 1 oracle oinstall 2.0M Mar 18 02:19 o1_mf_1_6_6r4wyw5c_.arc -rw-r----- 1 oracle oinstall 2.0K Mar 18 02:19 o1_mf_1_5_6r4wyw2q_.arc -rw-r----- 1 oracle oinstall 120K Mar 18 02:19 o1_mf_1_4_6r4wyw0h_.arc -rw-r----- 1 oracle oinstall 2.0K Mar 18 02:19 o1_mf_1_9_6r4wyxoc_.arc -rw-r----- 1 oracle oinstall 1.0K Mar 18 02:19 o1_mf_1_8_6r4wyxm8_.arc -rw-r----- 1 oracle oinstall 21M Mar 18 02:19 o1_mf_1_7_6r4wywky_.arc -rw-r----- 1 oracle oinstall 1.0K Mar 18 02:19 o1_mf_1_11_6r4wyxsw_.arc -rw-r----- 1 oracle oinstall 1.0K Mar 18 02:19 o1_mf_1_10_6r4wyxqf_.arc -rw-r----- 1 oracle oinstall 2.0K Mar 18 02:19 o1_mf_1_14_6r4wyy47_.arc -rw-r----- 1 oracle oinstall 1.0K Mar 18 02:19 o1_mf_1_13_6r4wyy3g_.arc -rw-r----- 1 oracle oinstall 557K Mar 18 02:19 o1_mf_1_12_6r4wyxtz_.arc -rw-r----- 1 oracle oinstall 3.5K Mar 18 02:22 o1_mf_1_15_6r4x4f7b_.arc -rw-r----- 1 oracle oinstall 1.5K Mar 18 02:23 o1_mf_1_16_6r4x5zrs_.arc -rw-r----- 1 oracle oinstall 13K Mar 18 02:25 o1_mf_1_17_6r4x9xhz_.arc -rw-r----- 1 oracle oinstall 1.5K Mar 18 02:25 o1_mf_1_18_6r4xbjrm_.arc -rw-r----- 1 oracle oinstall 1.1M Mar 18 02:35 o1_mf_1_19_6r4xwxc6_.arc -rw-r----- 1 oracle oinstall 1.0K Mar 18 02:35 o1_mf_1_20_6r4xwxgk_.arc -rw-r----- 1 oracle oinstall 8.5K Mar 18 02:35 o1_mf_1_21_6r4xwxhp_.arc [oracle@sonydr 2011_03_18]$
- knight's blog
- Log in to post comments