Standby database using RMAN duplicate

articles: 

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]$