Physical Standby

Steps to create physical standby database which has similar file system structure.

1) Put the primary database in force logging mode

ALTER DATABASE FORCE LOGGING;

2) On primary database enable the below intialization parameter and ensure that database archivelog mode.


log_archive_dest_1='LOCATION=/oracle/ORCLDB_P/arch’
log_archive_dest_2='SERVICE=ORCLDB_S reopen=60'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
log_archive_format=ARCH_%t_%r_%s.dbf

Shutdown immediate
Startup mount
alter database archivelog;
alter database open;
archive log list;


3) On Standby Database enable the below intialization parameter

fal_server=ORCLDB_P
fal_client=ORCLDB_S
log_archive_dest_1='LOCATION=/oracle/ORCLDB_P/arch'
log_archive_dest_state_1=enable
log_archive_format=ARCH_%t_%r_%s.dbf

4) Startup nomount database

startup nomount;

5) On standby use RMAN Duplicate to restore standby database from primary

rman target sys/manager@ORCLDB_P auxiliary sys/manager nocatalog

run
{
allocate auxiliary channel c1 type disk;
DUPLICATE TARGET DATABASE FOR STANDBY DORECOVER;
}

6) Put standby database in recover managed mode

alter database recover managed standby database disconnect from session;