欢迎来到天天文库
浏览记录
ID:38699685
大小:416.50 KB
页数:22页
时间:2019-06-17
《数据库备份恢复测试》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
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:==============
此文档下载收益归作者所有