Saturday, November 30, 2013

Oracle - RMAN RESTORE DB


SQL> select dbid from v$database; PRD

      DBID
----------
 250744165
BASE :TESTE_RESTORE

alter system set db_create_file_dest='D:\Oracle\oradata\wms1' scope=spfile;

alter system set db_file_name_convert='E:\ORACLE\ORADATA\WMS','D:\Oracle\oradata\wms1' scope=spfile;

alter system set log_file_name_convert='E:\ORACLE\ORADATA\WMS','D:\Oracle\oradata\wms1' scope=spfile;

alter system set db_create_online_log_dest_1='D:\Oracle\oradata\wms1' scope=spfile;



$ rman target / nocatalog

RMAN> SET DBID=ID_PRD   
RMAN> RMAN RESTORE CONTROLFILE FROM ‘ FILE.BAK’
RMAN> RMAN CATALOG START WITH ‘PATH_BACKUP’;
RMAN> RESTORE DATABASE;



Or Rename datafile destination 

run{
set newname for datafile 1 to ‘d:\oracle\oradata\wms\’;
set newname for datafile 2 to ‘d:\oracle\oradata\wms\’;
set newname for datafile 3 to ‘d:\oracle\oradata\wms\’;
set newname for datafile 4 to ‘d:\oracle\oradata\wms\’;
set newname for datafile 5 to 'd:\oracle\oradata\wms\';
set newname for datafile 6 to 'd:\oracle\oradata\wms\';
set newname for datafile 7 to 'd:\oracle\oradata\wms\';
set newname for datafile 8 to 'd:\oracle\oradata\wms\';
set newname for datafile 9 to 'd:\oracle\oradata\wms\';
set newname for datafile 10 to 'd:\oracle\oradata\wms\';
set newname for datafile 11 to 'd:\oracle\oradata\wms\';
set newname for datafile 12 to 'd:\oracle\oradata\wms\';
set newname for datafile 13 to 'd:\oracle\oradata\wms\';
set newname for datafile 14 to 'd:\oracle\oradata\wms\';
set newname for datafile 15 to 'd:\oracle\oradata\wms\';
set newname for datafile 16 to 'd:\oracle\oradata\wms\';
set newname for datafile 17 to 'd:\oracle\oradata\wms\';
set newname for datafile 18 to 'd:\oracle\oradata\wms\';
set newname for datafile 19 to 'd:\oracle\oradata\wms\';
set newname for datafile 20 to 'd:\oracle\oradata\wms\';
set newname for datafile 21 to 'd:\oracle\oradata\wms\';
set newname for datafile 22 to 'd:\oracle\oradata\wms\';
set newname for datafile 23 to 'd:\oracle\oradata\wms\';
set newname for datafile 24 to 'd:\oracle\oradata\wms\';
set newname for datafile 25 to 'd:\oracle\oradata\wms\';
set newname for datafile 26 to 'd:\oracle\oradata\wms\';
set newname for datafile 27 to 'd:\oracle\oradata\wms\';
restore database;
}

0 comentários:

Post a Comment