Create Standby database using Rman Duplicate Database from active database
1. Configure or install oracle binary oracle_home in target system
2. Configure tns entries in both node(target and source). TNS entry should be pin-gable from source and target system
3. Create password file in target system using orapw utility. password should be same in source and target database
4. Start the target database in nomont point using temporary pfile
$sqlplus / as sysdba
sqlplus>startup nomount pfile=temppfile.ora
-bash-4.4$ cat temppfile.ora
db_name = ERPSBY
compatible = 12.1.0
control_files = '/erpsby_data1/oradata/control01.ctl','/erpsby_data1/oradata/control02.ctl'
*.db_create_file_dest='/erpsby_data1/oradata'
*.DB_CREATE_ONLINE_LOG_DEST_1='/erpsby_data1/oradata'
*.DB_CREATE_ONLINE_LOG_DEST_2='/erpsby_data1/oradata'
*.memory_target=10G
*.remote_login_passwordfile='exclusive'
DB_FILES=2000
5. Connect to auxilary database
rman target sys/manager@source-tns AUXILIARY sys/manager@target-tns
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'erpprod','erpsby'
set db_unique_name='erpsby'
set diagnostic_dest='/erpsby_base/app/oracle'
set db_recovery_file_dest='/erpsby_flash'
set db_file_name_convert='/erpprod','/erpsby'
set log_file_name_convert='/erpprod','/erpsby'
set control_files='/erpsby_data1/oradata/control01.ctl','/erpsby_data1/oradata/control02.ctl'
set log_archive_max_processes='5'
set fal_client='ERPSBY'
set fal_server='ERPPROD'
set LOCAL_LISTENER='erpsby'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(ERPPROD,ERPSBY)'
set log_archive_dest_3='SERVICE=ERPPROD LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ERPPROD'
}
1. Configure or install oracle binary oracle_home in target system
2. Configure tns entries in both node(target and source). TNS entry should be pin-gable from source and target system
3. Create password file in target system using orapw utility. password should be same in source and target database
4. Start the target database in nomont point using temporary pfile
$sqlplus / as sysdba
sqlplus>startup nomount pfile=temppfile.ora
-bash-4.4$ cat temppfile.ora
db_name = ERPSBY
compatible = 12.1.0
control_files = '/erpsby_data1/oradata/control01.ctl','/erpsby_data1/oradata/control02.ctl'
*.db_create_file_dest='/erpsby_data1/oradata'
*.DB_CREATE_ONLINE_LOG_DEST_1='/erpsby_data1/oradata'
*.DB_CREATE_ONLINE_LOG_DEST_2='/erpsby_data1/oradata'
*.memory_target=10G
*.remote_login_passwordfile='exclusive'
DB_FILES=2000
5. Connect to auxilary database
rman target sys/manager@source-tns AUXILIARY sys/manager@target-tns
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'erpprod','erpsby'
set db_unique_name='erpsby'
set diagnostic_dest='/erpsby_base/app/oracle'
set db_recovery_file_dest='/erpsby_flash'
set db_file_name_convert='/erpprod','/erpsby'
set log_file_name_convert='/erpprod','/erpsby'
set control_files='/erpsby_data1/oradata/control01.ctl','/erpsby_data1/oradata/control02.ctl'
set log_archive_max_processes='5'
set fal_client='ERPSBY'
set fal_server='ERPPROD'
set LOCAL_LISTENER='erpsby'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(ERPPROD,ERPSBY)'
set log_archive_dest_3='SERVICE=ERPPROD LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ERPPROD'
}