Oracle数据库RMAN备份及恢复.docx

《Oracle数据库RMAN备份及恢复.docx》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、RMAN备份与恢复一、原理和单机使用RMAN备份原理相同，利用其中一个节点做备份（数据都放在ASM共享存储上），恢复也在一个节点上做，恢复到共享存储上，最后2个节点都能正常启动1.1查看归档日志[root@redhat2~]#su-oracleredhat2->sqlplus/assysdba;SQL*Plus:Release11.2.0.1.0ProductiononFriJul2418:31:462015Copyright(c)1982,2009,Oracle.Allrightsreserved.Co

2、nnectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptions//查看归档模式和强制日志是否开启，这里都没有开启SQL>selectname,log_mode,force_loggi

3、ngfromgv$database;NAMELOG_MODEFOR------------------------DEVDBNOARCHIVELOGNODEVDBNOARCHIVELOGNO//开启强制日志模式，在一个节点上执行就可以了SQL>alterdatabaseforcelogging;Databasealtered.//再次查看发现强制日志模式已开启SQL>selectname,log_mode,force_loggingfromgv$database;NAMELOG_MODEFOR------

4、------------------DEVDBNOARCHIVELOGYESDEVDBNOARCHIVELOGYESSQL>1.2开启归档模式//开启归档模式需要关闭数据库，而且需要在mount模式下[root@redhat1~]#su-grid//查看数据库状态redhat1->crs_stat-tNameTypeTargetStateHost------------------------------------------------------------ora.DATA.dgora....up.

5、typeONLINEONLINEredhat1ora.FLASH.dgora....up.typeONLINEONLINEredhat1ora.GRIDDG.dgora....up.typeONLINEONLINEredhat1ora....ER.lsnrora....er.typeONLINEONLINEredhat1ora....N1.lsnrora....er.typeONLINEONLINEredhat2ora.asmora.asm.typeONLINEONLINEredhat1ora.devdb

6、.dbora....se.typeONLINEONLINEredhat1ora.eonsora.eons.typeONLINEONLINEredhat1ora.gsdora.gsd.typeOFFLINEOFFLINEora....networkora....rk.typeONLINEONLINEredhat1ora.oc4jora.oc4j.typeOFFLINEOFFLINEora.onsora.ons.typeONLINEONLINEredhat1ora....SM1.asmapplicationO

7、NLINEONLINEredhat1ora....T1.lsnrapplicationONLINEONLINEredhat1ora....at1.gsdapplicationOFFLINEOFFLINEora....at1.onsapplicationONLINEONLINEredhat1ora....at1.vipora....t1.typeONLINEONLINEredhat1ora....SM2.asmapplicationONLINEONLINEredhat2ora....T2.lsnrappli

8、cationONLINEONLINEredhat2ora....at2.gsdapplicationOFFLINEOFFLINEora....at2.onsapplicationONLINEONLINEredhat2ora....at2.vipora....t1.typeONLINEONLINEredhat2ora.scan1.vipora....ip.typeONLINEONLINEredhat2//查看集群节点运行状态re