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)