Oracle用RMAN還原種子資料庫

標籤：oracle   rman   種子資料庫   seed   

起一個新執行個體名newdata

1、準備pfile

cp ...../dbs/init.ora ..../dbs/initnewdata.ora

vim initnewdata.ora

改變controlfile的位置

control_files=‘/u01/app/oracle/oradata/newdata/control.ctl‘

 

2、建立spfile

sqlplus / as sysdba

startup pfile=‘..../dbs/initnewdata.ora‘ nomount;

create spfile from pfile;

shutdown immediate;

startup nomount;

 

3、拷貝種子控制檔案

cp /u01/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/Seed_Database.ctl /u01/app/oracle/oradata/newdata

alter database mount;

 

4、拷貝種子資料檔案備份片

cp /u01/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/Seed_Database.dfb /u01/app/oracle/oradata/newdata

 

5、匯入資料備份片資訊到控制檔案

rman

connect target /

delete noprompt backupset 1;

catalog start with ‘/u01/app/oracle/oradata/newdata/Seed_Database.dfb‘;

 

6、還原並恢複資料庫

run {

set newname for datafile ‘/ade/b/2125410156/oracle/oradata/seeddata/system01.dbf‘ to ‘/u01/app/oracle/oradata/raw/system01.dbf‘;

set newname for datafile ‘/ade/b/2125410156/oracle/oradata/seeddata/sysaux01.dbf‘ to ‘/u01/app/oracle/oradata/raw/sysaux01.dbf‘;

set newname for datafile ‘/ade/b/2125410156/oracle/oradata/seeddata/undotbs01.dbf‘ to ‘/u01/app/oracle/oradata/raw/undotbs01.dbf‘;

set newname for datafile ‘/ade/b/2125410156/oracle/oradata/seeddata/usres01.dbf‘ to ‘/u01/app/oracle/oradata/raw/users01.dbf‘;

restore database;

recover database;

}

7、開啟資料庫

alter database open resetlogs;

Oracle用RMAN還原種子資料庫