Standby Database creation with RMAN Duplicate

Posted By Pankaj Yadav

Setup: Physical Standby Data Guard Creation with RMAN, step by step 

	Primary Site	Standby Site
Hostname	pk.prod.com	pk.standby.com
Database Name	prod	prod
Database Unique Name	prod	standby
Net Service Name	prod	standby

In this article, I explained the step by step process to create a physical standby database using RMAN duplicate command without shutting down the primary Database.

1.      Enable Database Force Logging

2.      Create SRL (Standby Redo Logs)

3.      Modify Init.ora parameters

4.      Enable Archiving

5.      Create a init.ora file for Standby Database ( Optional )

6.      Configure listener.ora and tnsnames.ora

7.      Copy init.ora and password  files to Standby Server

Standby Site Preparation :

1.      Create a remote login password file ( if it is not copied from primary site )

2.      Create a directory structure

3.      Modify the init.ora parameter file (Optional) [oracle@pk ~]$ sqlplus / as sysdba

[oracle@pk ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 28 08:21:24 2013

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> select name from v$database;

NAME

---------

PROD

SQL>  select name,db_unique_name,database_role,switchover_status from v$database

;

NAME      DB_UNIQUE_NAME                 DATABASE_ROLE    SWITCHOVER_STATUS

--------- ------------------------------ ---------------- --------------------

PROD      prod                           PRIMARY          SESSIONS ACTIVE

 SQL> select FORCE_LOGGING from v$database;

FOR

---

NO

SQL>  ALTER DATABASE FORCE LOGGING;

Database altered.

SQL> select name,user from v$database;

NAME      USER

--------- ------------------------------

PROD      SYS

SQL> col group# for 9999

SQL> col member for a50

SQL> set linesize 120

SQL> select name,user from v$database;

NAME      USER

--------- ------------------------------

PROD      SYS

SQL> select GROUP#,THREAD#,MEMBERS,BYTES FROM V$LOG;

GROUP#    THREAD#    MEMBERS      BYTES

------ ---------- ---------- ----------

     1          1          1   52428800

     2          1          1   52428800

     3          1          1   52428800

SQL> select group#,member from v$logfile;

GROUP# MEMBER

------ --------------------------------------------------

     3 /home/oracle/oracle/product/10.2.0/oradata/prod/redo03.log

     2 /home/oracle/oracle/product/10.2.0/oradata/prod/redo02.log

     1 /home/oracle/oracle/product/10.2.0/oradata/prod/redo01.log

SQL> ALTER DATABASE ADD STANDBY LOGFILE ('/home/oracle/oracle/product/10.2.0/oradata/prod/s_redo1.log') size 52428800;

Database altered.

SQL>  ALTER DATABASE ADD STANDBY LOGFILE ('/home/oracle/oracle/product/10.2.0/oradata/prod/s_redo2.log')  size 52428800;                                               

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE ('/home/oracle/oracle/product/10.2.0/oradata/prod/s_redo3.log') size 52428800;

Database altered.

SQL>  ALTER DATABASE ADD STANDBY LOGFILE ('/home/oracle/oracle/product/10.2.0/oradata/prod/s_redo4.log')  size 52428800;                                                

Database altered.

SQL> select GROUP#,THREAD#,MEMBERS,BYTES FROM V$LOG;

    GROUP#    THREAD#    MEMBERS      BYTES

---------- ---------- ---------- ----------

         1          1          1   52428800

         2          1          1   52428800

         3          1          1   52428800

SQL> SELECT GROUP#, BYTES FROM V$STANDBY_LOG;

    GROUP#      BYTES

---------- ----------

         4   52428800

         5   52428800

         6   52428800

         7   52428800

************ Modify the init.ora parameters: *******************

Modify the initprod.ora parameters on the primary database side to reflect the following values. If you are using spfile, you can add these parameter online without

down the primary database.

alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(prod,standby)';

alter system set LOG_ARCHIVE_DEST_1='LOCATION=/home/oracle/archive/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prod';

alter system set LOG_ARCHIVE_DEST_2=’SERVICE=standby ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby’;

alter system set LOG_ARCHIVE_DEST_STATE_1=ENABLE;

alter system set LOG_ARCHIVE_DEST_STATE_2=ENABLE;

alter system set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE SCOPE=spfile;

ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;

alter system set LOG_ARCHIVE_MAX_PROCESSES=30;

alter system set FAL_SERVER=standby;

alter system set DB_FILE_NAME_CONVERT='standby','prod' SCOPE=spfile;

alter system set LOG_FILE_NAME_CONVERT=

'/home/oracle/oracle/product/10.2.0/oradata/prod/','/home/oracle/oracle/product/10.2.0/oradata/standby/'SCOPE=spfile;    

alter system set STANDBY_FILE_MANAGEMENT=AUTO;

                                  

SQL> alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(prod,standby)';

`System altered.

  

SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=/home/oracle/archive/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prod';

System altered.

  

SQL> alter system set LOG_ARCHIVE_DEST_2='SERVICE=standby ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby' SCOPE=spfile;

System altered.

SQL> alter system set LOG_ARCHIVE_DEST_STATE_1=ENABLE;

System altered.

 SQL> alter system set LOG_ARCHIVE_DEST_STATE_2=ENABLE;

 System altered.

 SQL>  alter system set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE SCOPE=spfile;

System altered.

SQL> ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;

 System altered.

 SQL> alter system set LOG_ARCHIVE_MAX_PROCESSES=30;

 System altered.

 SQL> alter system set FAL_SERVER=standby;

 System altered.

 SQL> alter system set DB_FILE_NAME_CONVERT='standby','prod' SCOPE=spfile;

 System altered.

SQL> alter system set STANDBY_FILE_MANAGEMENT=AUTO;

 System altered.

SQL> alter system set LOG_FILE_NAME_CONVERT='/home/oracle/oracle/product/10.2.0/oradata/standby/','/home/oracle/oracle/product/10.2.0/oradata/prod/'SCOPE=spfile;

 System altered.

*****CHECK & UPDATE initprod.ora( PFILE ) PRIMARY DB SIDE *************

 vi initprod.ora 

prod.__db_cache_size=197132288

prod.__java_pool_size=4194304

prod.__large_pool_size=4194304

prod.__large_pool_size=4194304

prod.__shared_pool_size=75497472

prod.__db_cache_size=197132288

prod.__java_pool_size=4194304

prod.__large_pool_size=4194304

prod.__shared_pool_size=75497472

prod.__streams_pool_size=0

*.audit_file_dest='/home/oracle/oracle/product/10.2.0/db_1/admin/prod/adump'

*.background_dump_dest='/home/oracle/oracle/product/10.2.0/db_1/admin/prod/bdump'

*.compatible='10.2.0.1.0'

*.control_files='/home/oracle/oracle/product/10.2.0/oradata/prod/control01.ctl',

                        '/home/oracle/oracle/product/10.2.0/oradata/prod/control02.ctl',  

                        '/home/oracle/oracle/product/10.2.0/oradata/prod/control03.ctl'

*.core_dump_dest='/home/oracle/oracle/product/10.2.0/db_1/admin/prod/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_file_name_convert='standby','prod'

*.db_name='prod'

*.db_recovery_file_dest='/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP) (SERVICE=prodXDB)'

*.fal_server='STANDBY'

*.job_queue_processes=10

*.local_listener='LISTENER_PROD'

*.log_archive_config='DG_CONFIG=(prod,standby)'

*.log_archive_dest_1='LOCATION=/home/oracle/archive/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prod'

*.log_archive_dest_2='SERVICE=standby ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'

*.log_archive_dest_state_1='ENABLE'

*.log_archive_dest_state_2='ENABLE'

*.log_archive_format='arch_%t_%s_%r.arc'

*.log_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/standby/','/home/oracle/oracle/product/10.2.0/oradata/prod/'

*.db_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/standby/','/home/oracle/oracle/product/10.2.0/oradata/prod/'

*.open_cursors=300

*.pga_aggregate_target=94371840

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=285212672

*.standby_file_management='AUTO'

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/home/oracle/oracle/product/10.2.0/db_1/admin/prod/udump'

sql> create spfile from pfile;

sql> shutdown immediate;

sql> startup;

Create pfile for standby database:

 SQL> create pfile='/home/oracle/oracle/product/10.2.0/db_1/dbs/initstandby.ora' from spfile;

 File created.

Configure listener.ora and tnsnames.ora:

 # tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools. 

PROD =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = pk.prod.com)(PORT = 1522))

# tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

PROD =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.226.129)(PORT = 1522))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = prod)

    )

  )

STANDBY =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.226.131)(PORT = 1522))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = standby)

    )

  )

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

LISTENER_PROD =

  (ADDRESS = (PROTOCOL = TCP)(HOST = pk.prod.com)(PORT = 1522))

[oracle@pk dbs]$ orapwd file=$ORACLE_SID  password=sys force=y;

 [oracle@pk dbs]$ ls

hc_prod.dat  initdw.ora  init.ora  initprod.ora  initstandby.ora  lkPROD  orapwprod  prod  spfileprod.ora

Transfer init.ora and password files to Standby Server:

Create Password file  and copy initstandby.ora and password file from primary server to standby server.

[oracle@pk dbs]$ ls

hc_prod.dat  initdw.ora  init.ora  initprod.ora  initstandby.ora  lkPROD  orapwprod  prod  spfileprod.ora

[oracle@pk dbs]$ scp initstandby.ora orapwprod oracle@192.168.226.131:/home/oracle/oracle/product/10.2.0/db_1/dbs/

oracle@192.168.226.131's password:

initstandby.ora                                                                          100% 1806     1.8KB/s   00:00

orapwprod                                                                                100% 1536     1.5KB/s   00:00

*****************************************************************************            Standby Database Site Preparation :

*****************************************************************************

* Create a remote login password file ( if it is not copied from primary site )

* Create a directory structure

If you are using a different directory structure on the standby server, then you need to create all the directories on the standby site.

Copy initstandby.ora to $ORACLE_HOME/dbs location.

SQL>  conn sys/sys@prod as sysdba

SQL> select name from v$database;

NAME

---------

PROD

Configure listener.ora and tnsnames.ora:

# tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

PROD =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = pk.prod.com)(PORT = 1522))

# tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

PROD =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.226.129)(PORT = 1522))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = prod)

    )

  )

STANDBY =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.226.131)(PORT = 1522))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = standby)

    )

  )

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

LISTENER_PROD =

  (ADDRESS = (PROTOCOL = TCP)(HOST = pk.prod.com)(PORT = 1522))

*****************************************************************************

            Standby Database Site Preparation :

*****************************************************************************

* Create a remote login password file ( if it is not copied from primary site )

* Create a directory structure

If you are using a different directory structure on the standby server, then you need to create all the directories on the standby site.

Copy initstandby.ora to $ORACLE_HOME/dbs location.

**************** Edit pfile and update parameter for Standby *******************

 DB_NAME=prod

DB_UNIQUE_NAME=standby

LOG_ARCHIVE_CONFIG=’DG_CONFIG=(prod,standby)’

CONTROL_FILES=’/home/oracle/app/oracle/oradata/sbyorcl/s_control01.ctl’, ‘/home/oracle/app/oracle/flash_recovery_area/sbyorcl/s_control02.ctl’

DB_FILE_NAME_CONVERT=’prod’,'standby’

LOG_FILE_NAME_CONVERT=’/home/oracle/app/oracle/flash_recovery_area/prod/’,'/home/oracle/app/oracle/flash_recovery_area/standby/’

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

LOG_ARCHIVE_DEST_1=’LOCATION=/home/oracle/app/oracle/flash_recovery_area/standby/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby’

LOG_ARCHIVE_DEST_2=’SERVICE=prod ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prod’

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

STANDBY_FILE_MANAGEMENT=AUTO

FAL_SERVER=prod

Edit parameter file and update parameteres required for standby

 vi initstandby.ora

*.audit_file_dest='/home/oracle/oracle/product/10.2.0/db_1/admin/standby/adump'

*.background_dump_dest='/home/oracle/oracle/product/10.2.0/db_1/admin/standby/bdump'

*.compatible='10.2.0.1.0'

*.control_files='/home/oracle/oracle/product/10.2.0/oradata/standby/control01.ctl','/home/oracle/oracle/product/10.2.0/oradata/standby/control02.ctl','/home/oracle/ora

cle/product/10.2.0/oradata/standby/control03.ctl'

*.core_dump_dest='/home/oracle/oracle/product/10.2.0/db_1/admin/standby/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_file_name_convert='prod','standby'

*.db_name='prod'

*.db_unique_name=standby

*.db_recovery_file_dest='/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area'

#*.db_recovery_file_dest='/home/oracle/backup'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP) (SERVICE=prodXDB)'

*.fal_server='PROD'

*.job_queue_processes=10

*.local_listener='LISTENER_STANDBY'

*.log_archive_config='DG_CONFIG=(prod,standby)'

*.log_archive_dest_1='LOCATION=/home/oracle/archive/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby'

*.log_archive_dest_2='SERVICE=prod ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prod'

*.log_archive_dest_state_1='ENABLE'

*.log_archive_dest_state_2='ENABLE'

*.log_archive_format='arch_%t_%s_%r.arc'

*.log_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/prod/','/home/oracle/oracle/product/10.2.0/oradata/standby/'

*.db_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/prod/','/home/oracle/oracle/product/10.2.0/oradata/standby/'

*.open_cursors=300

*.pga_aggregate_target=94371840

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=285212672

*.standby_file_management='AUTO'

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/home/oracle/oracle/product/10.2.0/db_1/admin/standby/udump'

~

SYS@STANDBY > startup nomount pfile='/home/oracle/oracle/product/10.2.0/db_1/dbs/initstandby.ora';

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1218992 bytes

Variable Size              83887696 bytes

Database Buffers          197132288 bytes

Redo Buffers                2973696 bytes

SYS@STANDBY > create spfile from pfile='/home/oracle/oracle/product/10.2.0/db_1/dbs/initstandby.ora';

 File created.

 SYS@STANDBY > shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SYS@STANDBY > startup nomount

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  1218992 bytes

Variable Size              83887696 bytes

Database Buffers          197132288 bytes

Redo Buffers                2973696 bytes

_________________________________________________

*********** Take the backup of Primary Database in Primary DB side ***********

_________________________________________________

Create one backup directory for the backup of database on both side ( primary database & Standby database)

same path and same directory name like here i create with the name of backup on '/home/oracle/' path

 RMAN> backup full database format'/home/oracle/backup/%d_%U.bckp' plus archivelog format '/home/oracle/backup/5D_%U.bkp';

RMAN> configure channel device type disk format '/home/oracle/backup/%U';

RMAN> BACKUP CURRENT CONTROLFILE FOR STANDBY;

RMAN> BACKUP ARCHIVELOG ALL;

****** Transfer ALL Backup to standby Database *********************

____________________________________________________

********** ON STANDBY DATABASE SIDE *****************************

Create the standby database using rman: 

_______________________________________________________________

[oracle@rac1 ~]$ . oraenv

ORACLE_SID = [standby] ? standby

STARTUP DATABASE IN MOUNT MODE

SYS@STANDBY > startup nomount

ORACLE instance started. 

Total System Global Area  285212672 bytes

Fixed Size                  1218992 bytes

Variable Size              83887696 bytes

Database Buffers          197132288 bytes

Redo Buffers                2973696 bytes

_________________________________________

  *******CONNECT RMAN**********

_________________________________________

 [oracle@pk ~]$ rman target=sys/sys@prod auxiliary=/

 Recovery Manager: Release 10.2.0.1.0 - Production on Fri Aug 30 08:29:55 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: PROD (DBID=236467520)

connected to auxiliary database: PROD (DBID=236467520, not open)

RMAN> DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK; 

Starting Duplicate Db at 30-AUG-13

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:

{

   restore clone standby controlfile;

   sql clone 'alter database mount standby database';

}

executing Memory Script

Starting restore at 30-AUG-13

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 /home/oracle/backup/0toig3u6_1_1

channel ORA_AUX_DISK_1: restored backup piece 1

piece handle=/home/oracle/backup/0toig3u6_1_1 tag=TAG20130829T055102

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

output filename=/home/oracle/oracle/product/10.2.0/oradata/standby/control01.ctl

output filename=/home/oracle/oracle/product/10.2.0/oradata/standby/control02.ctl

output filename=/home/oracle/oracle/product/10.2.0/oradata/standby/control03.ctl

Finished restore at 30-AUG-13

sql statement: alter database mount standby database

released channel: ORA_AUX_DISK_1

contents of Memory Script:

{

   set newname for tempfile  1 to

 "/home/oracle/oracle/product/10.2.0/oradata/standby/temp01.dbf";

   switch clone tempfile all;

   set newname for datafile  1 to

 "/home/oracle/oracle/product/10.2.0/oradata/standby/system01.dbf";

   set newname for datafile  2 to

 "/home/oracle/oracle/product/10.2.0/oradata/standby/undotbs01.dbf";

   set newname for datafile  3 to

 "/home/oracle/oracle/product/10.2.0/oradata/standby/sysaux01.dbf";

   set newname for datafile  4 to

 "/home/oracle/oracle/product/10.2.0/oradata/standby/users01.dbf";

   set newname for datafile  5 to

 "/home/oracle/oracle/product/10.2.0/oradata/standby/example01.dbf";

   restore

   check readonly

   clone database

   ;

}

executing Memory Script

executing command: SET NEWNAME

renamed temporary file 1 to /home/oracle/oracle/product/10.2.0/oradata/standby/temp01.dbf 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 30-AUG-13

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 /home/oracle/oracle/product/10.2.0/oradata/standby/system01.dbf

restoring datafile 00002 to /home/oracle/oracle/product/10.2.0/oradata/standby/undotbs01.dbf

restoring datafile 00003 to /home/oracle/oracle/product/10.2.0/oradata/standby/sysaux01.dbf

restoring datafile 00004 to /home/oracle/oracle/product/10.2.0/oradata/standby/users01.dbf

restoring datafile 00005 to /home/oracle/oracle/product/10.2.0/oradata/standby/example01.dbf

channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/backup/PROD_0qoig3k8_1_1.bckp

channel ORA_AUX_DISK_1: restored backup piece 1

piece handle=/home/oracle/backup/PROD_0qoig3k8_1_1.bckp tag=TAG20130829T054544

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:11

Finished restore at 30-AUG-13

contents of Memory Script:

{

   switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy recid=7 stamp=824821751 filename=/home/oracle/oracle/product/10.2.0/oradata/standby/system01.dbf

datafile 2 switched to datafile copy

input datafile copy recid=8 stamp=824821751 filename=/home/oracle/oracle/product/10.2.0/oradata/standby/undotbs01.dbf

datafile 3 switched to datafile copy

input datafile copy recid=9 stamp=824821751 filename=/home/oracle/oracle/product/10.2.0/oradata/standby/sysaux01.dbf

datafile 4 switched to datafile copy

input datafile copy recid=10 stamp=824821751 filename=/home/oracle/oracle/product/10.2.0/oradata/standby/users01.dbf

datafile 5 switched to datafile copy

input datafile copy recid=11 stamp=824821751 filename=/home/oracle/oracle/product/10.2.0/oradata/standby/example01.dbf

Finished Duplicate Db at 30-AUG-13

RMAN> exit

Recovery Manager complete.

[oracle@pk dbs]$ sqlplus / as sysdba

 SYS@STANDBY > alter database recover managed standby database disconnect from session;

 Database altered.

 _________________________________________

      On the Primary:

_________________________________________

 SYS@PROD > alter system switch logfile;

 System altered.

SYS@PROD > alter system archive log current;

 System altered.

  

SYS@PROD > archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /home/oracle/archive/

Oldest online log sequence     16

Next log sequence to archive   18

Current log sequence           18

_______________________________________________

            ON STAND BY DATABASE

_______________________________________________

SYS@STANDBY > archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /home/oracle/archive/

Oldest online log sequence     16

Next log sequence to archive   0

Current log sequence           18

 SYS@STANDBY > SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

  SEQUENCE# APP

---------- ---

         8 NO

         9 NO

        10 NO

        11 NO

        12 NO

        13 YES

        14 YES

        15 YES

        16 YES

        17 YES

10 rows selected.

SYS@STANDBY > select recovery_mode  from v$archive_dest_status;

 RECOVERY_MODE

-----------------------

MANAGED

MANAGED

MANAGED

MANAGED

MANAGED

MANAGED

MANAGED

MANAGED

MANAGED

MANAGED

MANAGED

11 rows selected.

SYS@STANDBY > select max(sequence#) from v$log_history;

 MAX(SEQUENCE#)

--------------

            17

SYS@STANDBY > archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /home/oracle/archive/

Oldest online log sequence     18

Next log sequence to archive   0

Current log sequence           20

  

***********CHECK ON BOTH PRIMARY AND STAND BY SIDE*************

SYS@STANDBY >  select max(sequence#) from v$archived_log; 

MAX(SEQUENCE#)

--------------

            19