数据库备份恢复测试

《数据库备份恢复测试》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、1追加归档形式恢复数据库1.1一RMAN配置信息：RMAN>showall;正在使用目标数据库控制文件替代恢复目录RMAN配置参数为:CONFIGURERETENTIONPOLICYTOREDUNDANCY1;#defaultCONFIGUREBACKUPOPTIMIZATIONOFF;#defaultCONFIGUREDEFAULTDEVICETYPETODISK;#defaultCONFIGURECONTROLFILEAUTOBACKUPON;CONFIGURECONTROLFILEAUTOBACKUPFO

2、RMATFORDEVICETYPEDISKTO'd:arch%F';CONFIGUREDEVICETYPEDISKPARALLELISM1BACKUPTYPETOBACKUPSET;#defaultCONFIGUREDATAFILEBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGUREARCHIVELOGBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGUREMAXSETSIZETOUNLIMITED;#default

3、CONFIGUREARCHIVELOGDELETIONPOLICYTONONE;#defaultCONFIGURESNAPSHOTCONTROLFILENAMETO'C:ORACLEPRODUCT10.1.0DB_1DATABASESNCFORCL.ORA';#default1.2二删除归档空间现有全部归档日志D:CdarchlogDelete*三数据库进行全备份：Backupfulldatabaseformat‘d:arch%t_%s’;三系统切换日志Altersystemarchivelog

4、current;Altersystemarchivelogcurrent;Altersystemarchivelogcurrent;Altersystemarchivelogcurrent;Altersystemarchivelogcurrent;Altersystemarchivelogcurrent;备份文件和归档日志如下：1.1将归档日志剪切到arctest目录：现况如下：1.2分批次恢复1.3恢复控制文件：MicrosoftWindowsXP[版本5.1.2600](C)版权所有1985-2001Mic

5、rosoftCorp.C:DocumentsandSettingsliruilong>sqlplus"/assysdba"SQL*Plus:Release10.1.0.2.0-Productionon星期五3月2519:26:182011Copyright(c)1982,2004,Oracle.Allrightsreserved.连接到:OracleDatabase10gEnterpriseEditionRelease10.1.0.2.0-ProductionWiththePartitioning,OLAP

6、andDataMiningoptionsSQL>shutdownimmediate;ORA-01109:数据库未打开已经卸载数据库。ORACLE例程已经关闭。SQL>startupnomount;ORACLE例程已经启动。TotalSystemGlobalArea171966464bytesFixedSize787988bytesVariableSize145488364bytesDatabaseBuffers25165824bytesRedoBuffers524288bytesSQL>exit从OracleD

7、atabase10gEnterpriseEditionRelease10.1.0.2.0-ProductionWiththePartitioning,OLAPandDataMiningoptions断开C:DocumentsandSettingsliruilong>rmantarget/恢复管理器:版本10.1.0.2.0-ProductionCopyright(c)1995,2004,Oracle.Allrightsreserved.连接到目标数据库:orcl(未装载)RMAN>restorecontro

8、lfileto'C:oracleproduct10.1.0oradataorclCONTROL01.CTL'form'D:archC-1254907373-20110325-00';RMAN-00571:===========================================================RMAN-00569:==============