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
