shivenracdba

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; ...

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_T...