ITPub博客

首页 > 数据库 > Oracle > RMAN备份异机恢复

RMAN备份异机恢复

原创 Oracle 作者:fengsongtao123 时间:2016-03-15 19:53:24 0 删除 编辑
一、生产库中使用RMAN备份数据库
1、RMAN备份脚本


configure retention policy to redundancy 30; 
configure maxsetsize to 10g; 
configure controlfile autobackup on; 
configure controlfile autobackup format for device type disk to '/ora_backup/controlfile/%F'; 
crosscheck backup of database; 
crosscheck archivelog all; 
delete noprompt obsolete ; 
delete noprompt expired backup; 
delete noprompt backup completed before 'sysdate-30'; 
delete noprompt archivelog until time 'sysdate-5'; 
run { 
allocate channel c0 type disk; 
backup incremental level 0 database format '/ora_backup/full_db_%d_%s_%t_%p' tag="full_db_`date +'%y%m%d%H%M'`"; 
release channel c0 ; 

configure controlfile autobackup off; 


2、查看备份
[oracle@localhost nba]$ tree /ora_backup/
/ora_backup/
|-- controlfile
|   |-- c-829384100-20160103-07
|-- full_db_NBA_26_900192470_1


3、将备份文件拷贝到目标库的相同路径下




二、在目标库上恢复


1、使用RMAN启动DUMMY实例到nomount状态
[oracle@rhel5u8 ~]$ rman target /


RMAN> startup nomount;


RMAN> restore spfile to '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilenba.ora' from '/ora_backup/controlfile/c-829384100-20160103-07';


RMAN> restore controlfile to '/u01/app/oracle/oradata/nba/control01.ctl' from '/ora_backup/controlfile/c-829384100-20160103-07';


2、根据参数文件中指定的文件,创建相应目录
[oracle@rhel5u8 dbs]$ mkdir -p /u01/app/oracle/admin/nba/adump


[oracle@rhel5u8 dbs]$ mkdir -p u01/app/oracle/fast_recovery_area/nba


[oracle@rhel5u8 dbs]$ mkdir -p /u01/app/oracle/oradata/nba


[oracle@rhel5u8 dbs]$ cp /u01/app/oracle/oradata/nba/control01.ctl /u01/app/oracle/fast_recovery_area/nba/control02.ctl




3、重新启动数据库到mount状态
SQL> shut immediate
ORA-01507: database not mounted




ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.


Total System Global Area  622149632 bytes
Fixed Size    2255792 bytes
Variable Size  398459984 bytes
Database Buffers  218103808 bytes
Redo Buffers    3330048 bytes
Database mounted.




4、还原数据库(备份数据存放路径和生产库中RMAN备份路径相同)
RMAN> restore database ;




5、恢复数据库(根据提示,将生产库中的36号归档文件拷贝到指定目录)
SQL> recover database using backup controlfile;
ORA-00279: change 1362106 generated at 01/03/2016 21:27:51 needed for thread 1
ORA-00289: suggestion :/u01/app/oracle/fast_recovery_area/NBA/archivelog/2016_01_03/o1_mf_1_36_c8l95rbl_.arc
ORA-00280: change 1362106 for thread 1 is in sequence #36


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 1362467 generated at 01/03/2016 21:40:08 needed for thread 1
ORA-00289: suggestion :/u01/app/oracle/fast_recovery_area/NBA/archivelog/2016_01_03/o1_mf_1_37_%u_.arc
ORA-00280: change 1362467 for thread 1 is in sequence #37
ORA-00278: log file'/u01/app/oracle/fast_recovery_area/NBA/archivelog/2016_01_03/o1_mf_1_36_c8l95rbl_.arc' no longer needed for this recovery


ORA-00308: cannot open archived log'/u01/app/oracle/fast_recovery_area/NBA/archivelog/2016_01_03/o1_mf_1_37_%u_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3




6、根据提示还需要37号归档,但生产库中并没有37号归档,则实例恢复所需日志在生产库的联机日志中,将生产库当前日志拷贝到目标库的/home/oracle/redo01.log
SQL> recover database using backup controlfile;
ORA-00279: change 1362467 generated at 01/03/2016 21:40:08 needed for thread 1
ORA-00289: suggestion :/u01/app/oracle/fast_recovery_area/NBA/archivelog/2016_01_03/o1_mf_1_37_%u_.arc
ORA-00280: change 1362467 for thread 1 is in sequence #37


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/home/oracle/redo01.log
Log applied.
Media recovery complete.


7、使用resetlogs打开数据库。
SQL> alter database open resetlogs;


Database altered.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30373263/viewspace-2057834/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-07-25

  • 博文量
    96
  • 访问量
    209282