RMAN Machine Recovery data (Oracle 11g)

1  Backup parameter file $oracle_home$/dbs2  copy files and backup requirements according to the path of Ramn backup 3  delete the old library exactly as the original server path [email protected]> shutdown immediate; [email protected]>startup mount restrict; [email protected]>drop database;4  Restore parameter file cp /backup/other/* /app/oracle/product/ 11.2.0/dbhome_1/dbs/5  Restore Control Files rman target /rman> startup nomount; rman> restore controlfile from  '/backup/other/c-1325328971-20150701-01 ';6  mount the control file. rman> alter database mount;7  view the path of each data/Temp file,rman> report schema;8  Check the recovery database to a specified point in time, the required backup set, including the database backup set, and the log file backup set is complete rman> crosscheck backup; rman> restore database until time  ' 2015-07-01 14:00:00 '  preview  summary;9  generates a recovery script based on the 7-step file path of the data (note to ensure that the following path does exist if it does not exist) run{allocate channel d1 type disk;  allocate channel d2 type disk; set archivelog destination to  '/backup/tmplog '; set newname for datafile 1   to  '/ app/oracle/oradata/orcl/datafile/system.260.797548131 ';  set newname for datafile 2    to  '/app/oracle/oradata/orcl/datafile/sysaux.267.797548131 ';  set newname  for datafile 3   to  '/app/oracle/oradata/orcl/datafile/ undotbs1.263.797548131 '; set newname for datafile 4   to  '/app/ oracle/oradata/orcl/datafile/users.266.797548131 '; set newname for datafile 5    to  '/app/oracle/oradata/orcl/datafile/undotbs2.259.797548341 ';  set newname for  datafile 6   to  '/app/oracle/oradata/orcl/datafile/eas_d_hleas_ standard.268.797536759 '; set newname for datafile 7   to  '/app/ oracle/oradata/orcl/datafile/eas_d_hleas_temp2.269.797536799'; set newname for datafile 8   to  '/app/oracle/oradata/orcl/ datafile/eas_d_hlwl_standard.271.800633637 '; set newname for datafile 9    to  '/app/oracle/oradata/orcl/datafile/eas_d_hlwl_temp2.272.800633731 '; set newname  for datafile 10  to  '/app/oracle/oradata/orcl/datafile/eas_d_hlwl_index.273.800633759 '; set newname for datafile 11  to  '/app/oracle/oradata/orcl/datafile/ hlwl_data_ts.292.829046739 '; set newname for datafile 12  to  '/app/ oracle/oradata/orcl/datafile/hlwl_index_ts.296.862571959 '; set newname for datafile  13  to  '/app/oracle/oradata/orcl/datafile/hlwl_index_ts.293.829046757 ';  set newname  for datafile 14  to  '/app/oracle/oradata/orcl/datafile/sysaux.294.829149347 ';  set newname for datafile 15  to  '/app/oracle/oradata/orcl/datafile/movets.281.835217279 ';  set newname for datafile 16  to  '/app/oracle/oradata/orcl/datafile/ movets_idx.280.835217465 '; set newname for datafile 17  to  '/app/ Oracle/oradata/orcl/datafile/hlwl_data_ts02 '; set newname for datafile 18   to  '/app/oracle/oradata/orcl/datafile/eas_d_hlwl_standard02.dbf '; set newname for  datafile 19  to  '/app/oracle/oradata/orcl/datafile/eas_d_hlwl_standard03.dbf ';  set  newname for datafile 20  to  '/app/oracle/oradata/orcl/datafile/hlwl_data_ ts.289.862572033 '; set newname for datafile 21  to  '/app/oracle/ oradata/orcl/datafile/hlwl_index_ts.284.879677831 '; set newname for datafile 25   to  '/app/oracle/oradata/orcl/datafile/hlwl_data_ts.275.868207823 ';  set newname for datafile 27  to   '/app/oracle/oradata/orcl/datafile/hlwl_lob_ts06 ';  set newname for tempfile 1    to  '/app/oracle/oradata/orcl/tempfile/temp.264.797548243 '; set newname  for tempfile 2   to  '/app/oracle/oradata/orcl/tempfile/temp.261.853322227 ';  restore database; switch datafile all; switch tempfile all;   RELEASE CHANNEL D1; RELEASE CHANNEL D2;} 10  Append log file (if a new control file is loaded, the database needs to be restarted for the loaded file to take effect) rman> catalog start with  '/backup/logbackup ';11  reverts to the specified time rman> run{allocate channel d1 type disk;  set  until time  ' 2015-07-01 16:00:00 '; set archivelog destination to  '/ Backup2/tmplog ';  recover database delete archiveloG; RELEASE CHANNEL D1;} 12   prohibit block  change tracking sql> alter database disable block change  tracking;13  Change log file location Sql> select * from v$logfile;alter database rename  file  ' +dbdata/orcl/onlinelog/inst2_redo0201.log '  to  '/app/oracle/oradata/orcl/onlinelog/ Inst2_redo0201.log ';alter database rename file  ' +flashdata/orcl/onlinelog/inst2_ Redo0202.log '  to  '/app/oracle/oradata/orcl/onlinelog/inst2_redo0202.log ';alter database  rename file  ' +dbdata/orcl/onlinelog/inst1_redo0101.log '  to  '/app/oracle/oradata/orcl/ Onlinelog/inst1_redo0101.log ';alter database rename file  ' +FLASHDATA/orcl/onlinelog/inst1_ Redo0102.log '  to  '/app/oracle/oradata/orcl/onlinelog/inst1_redo0102.log ';alter database  rename file  ' +dbdata/orcl/onlinelog/inst1_redo0301.log '  to  '/app/oracle/oradata/orcl/onliNelog/inst1_redo0301.log ';alter database rename file  ' +flashdata/orcl/onlinelog/inst1_ Redo0302.log '  to  '/app/oracle/oradata/orcl/onlinelog/inst1_redo0302.log ';alter database  rename file  ' +dbdata/orcl/onlinelog/inst2_redo0401.log '  to  '/app/oracle/oradata/orcl/ Onlinelog/inst2_redo0401.log ';alter database rename file  ' +FLASHDATA/orcl/onlinelog/inst2_ Redo0402.log '  to  '/app/oracle/oradata/orcl/onlinelog/inst2_redo0402.log ';alter database  rename file  ' +dbdata/orcl/onlinelog/inst1_redo0501.log '  to  '/app/oracle/oradata/orcl/ Onlinelog/inst1_redo0501.log ';alter database rename file  ' +FLASHDATA/orcl/onlinelog/inst1_ Redo0502.log '  to  '/app/oracle/oradata/orcl/onlinelog/inst1_redo0502.log ';alter database  rename file  ' +dbdata/orcl/onlinelog/inst2_redo0601.log '  to  '/app/oracle/oradata/orcl/ Onlinelog/inst2_redo0601.log '; alter database rename file  ' +flashdata/orcl/onlinelog/inst2_redo0602.log '  to  '/app/ Oracle/oradata/orcl/onlinelog/inst2_redo0602.log ';alter database rename file  ' +DBDATA/ORCL /onlinelog/inst1_redo0701.log '  to  '/app/oracle/oradata/orcl/onlinelog/inst1_redo0701.log '; alter  database rename file  ' +flashdata/orcl/onlinelog/inst1_redo0702.log '  to  '/app/ Oracle/oradata/orcl/onlinelog/inst1_redo0702.log ';alter database rename file  ' +DBDATA/ORCL /onlinelog/inst2_redo0801.log '  to  '/app/oracle/oradata/orcl/onlinelog/inst2_redo0801.log '; alter  database rename file  ' +flashdata/orcl/onlinelog/inst2_redo0802.log '  to  '/app/ Oracle/oradata/orcl/onlinelog/inst2_redo0802.log ';14   prohibits archiving and opens the database. sql> alter database noarchivelog; sql> alter database open resetlogs;15   suppresses node 2 instances. (Because a dual RAC is restored on a non-cluster, you want to delete other instances) Sql> select * from v$thread; --Viewing instance information Sql> alter database disable thread  2; sql> select group#,thread#,members,archived,status from v$log;--Viewing log Group SQL > alter database drop logfile group 2; --Disabling online logging sql> alter  database drop logfile group 4; sql> alter database drop logfile group 6; sql> alter database drop logfile group 8; sql> drop tablespace undotbs2 including contents and datafiles; -- Delete the rollback table space used by the node 2 instance sql> alter user hlwl identified by  "1";   --Modify the master user  hlwl  password sql> exec dbms_scheduler.disable ();  --Forbidden  hlwl  User's timed job

RMAN Machine Recovery data (Oracle 11g)