Posts

oracle physical standby db creation with broker config

SOURCE SERVER

Create the new directories:
mkdir /oraflashback/PRODDG1
mkdir /oraarc1/PRODDG1
mkdir /oralog1/PRODDG1
mkdir /oralog2/PRODDG1

create a backup of pfile . then move ahead .
Using SQL*Plus:
show parameter recovery;
alter system set db_recovery_file_dest='/oraflashback/PRODDG1' scope=spfile;
alter system set db_recovery_file_dest_size=10G scope=spfile;
alter system set db_flashback_retention_target=2880;
Modify the parameters in the pfile:
*.instance_name=PRODDG1
*.service_names=PROD.com
*.db_file_name_convert=PRODDG2,PRODDG1
*.log_file_name_convert=PRODDG2,PRODDG1

SQL> alter system set instance_name=PRODDG1 scope=spfile;

System altered.


SQL>  alter system set service_names='PROD.com'  scope=spfile;

System altered.

SQL> alter system set db_file_name_convert=PRODDG2,PRODDG1 scope=spfile;

System altered.

SQL> alter system set log_file_name_convert=PRODDG2,PRODDG1 scope=spfile;

System altered.


shutdown immediate;
startup mount;
alter database archive…

recover oracle database exclude tablespace

db_file_name_convert=('/oradata3/PRODPV/','/oradata3/PRODQA/','/oratemp1/PRODPV/','/oratemp1/PRODQA/') log_file_name_convert=('/oralog1/PRODPV/','/oralog1/PRODQA/','/oralog2/PRODPV/','/oralog2/PRODQA/')

[oracle@usnode dbs]$ cat CRQ000000123456.cmd run { set until time "to_date('mar 03 2016 11:59:00','Mon DD YYYY HH24:MI:SS')"; allocate channel t1 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-FULL)'; allocate channel t3 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-INCR)'; allocate channel t5 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-ARCH)'; allocate auxiliary channel a1 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-INCR)'; allocate auxiliary channel a3 type 'SBT_TAPE' PARMS='ENV=…