生产库备份恢复到测试库步骤

《生产库备份恢复到测试库步骤》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、生产库备份恢复到测试库步骤rh于生产库使用的是RMAN的增量备份，所以必须保证冇原先的0级完整备份以及所冇的增量备份，否则不能恢复成功。1.切换到oracle户，杳看SHDB数据库是否在运行。如果运行则关闭数据库。#su-oracle$ps-ef

2、grepSHDBoracle2305709:31:460:00ora_lgwr_SHDBoracle2305309:31:460:00ora^mman_SHDBoracle2308109:31:550:00ora_j000_SHDBoracle2305909:31:460:00orackptSHDBoracl

3、e2314409:32:020:00ora一qOOOSIIDBoracle2307509:31:510:00oraarclSHDBoracle2306309:31:460:00ora_reco_SHDBoracle2305509:31:460:00ora_dbw0_SHDBoracle2307309:31:510:00oraarcOSHDBoracle2305109:31:450:00ora_pspO_SHDBoracle2306909:31:460:00orammnlSHDBoracle2307909:31:520:00ora_qmnc_SHDBor

4、acle2306709:31:460:01orammonSHDBoracle230651009:31:46?0:00ora_cjqO_SIIDBoracle230611009:31:46?0:00ora_smon_SHDBoracle230491009:31:45?0:00ora_pmon_SHDBoracle2315823130009:32:20pts/00:00grepSHDB$exportORACLE_SID=SHDB$$sqlplus/nologSQL*Plus:Release10.2.0.3.0-ProductiononWedJun309:3

5、3:392009Copyright(c)1982,2006,Oracle.AllRightsReserved.SQL>conn/assysdbaConnected・SQL>SQL>selectopen_mode,namefromv$database;OPEN.MODENAMEREADWRITESHDBSQL>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>SQL>exitDisconnectedfromOracleDatabaselOgEnter

6、priseEditionRelease10.2.0.3.0-64bitProductionWiththePartitioning,OLAPandDataMiningoptions2•删除数据库文件3.把数据库打开到nomount状态$exportORACLE_SID二SHDB$$sqlplus/nologSQL*Plus:Release10.2.0.3.0-ProductiononWedJun309:39:042009Copyright(c)1982,2006,Oracle.AllRightsReserved.SQL>conn/assysdbaConn

7、ectedtoanidleinstance.SQL>SQL>startupnomountORACLEinstancestarted.TotalSystemGlobalArea2147483648bytesFixedSize2046816bytesVariableSize486540448bytesDatabaseBuffers1644167168bytesRedoBuffers14729216bytesSQL>SQL>exit64bitDisconnectedfromOracleDatabaselOgEnterpriseEditionRelease10

8、.2.0.3.0ProductionWiththePartitioning,OLAPandDataMiningoptions4.进入37或38的RMAN,查看控制文件的备份集以及要恢复到哪天的SCN号对应的序列号以及线程号。1).查看控制文件备份集#su-oracle$$rmantarget/RecoveryManager:Release10.2.0.3.0-ProductiononWedJun309:43:192009Copyright(c)1982,2005,Oracle.Allrightsreserved.connectedtotargetdat

9、abase:SHDB(DBID二1463542324)RMAN>RMAN>listbackup