1. remove archivelogs from default archivelog location
2. make rman backup files accessible to standby database
3. make rman know backup files
sqlplus> shutdown immediate;
sqlplus> startup mount;
rman target /
rman> catalog start with 'file location directory';
4. restore database
rman > run {
sql 'alter session set optimizer_mode=RULE';
sql 'ALTER SESSION SET NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"';
ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT 'file location directory\DBFULL_%d_%U.bkp';
restore database from TAG "backup tag" ;
RELEASE CHANNEL d1;
}
5. recover database
5.1 use controlfile before open database
rman target /
rman> recover database until sequence ?????;
5.2 use controlfile after open database
rman target /
rman> list incarnation;
rman> reset database to incarnation 1; ( previous number)
rman> recover database unitl seequnece ????;
5.3 test standby database
sqlplus / as sysdba
sqlplus> alter database open;
sqlplus> select name, host_name, open_mode, database_role from v$database, v$instance;
reference:
http://oracledb-admin.blogspot.com/2011/10/ora-19909-datafile-1-belongs-to-orphan.html
http://www.dba-oracle.com/bk_recover_database_until_cancel_tips.htm
No comments:
Post a Comment