Oracle控制文件备份恢复 noresetlogs 恢复

控制文件的备份有两种格式的备份，一种是文本格式的备份另一种是二进制格式的备份备份文本格式SQL> alterdatabase backup controlfile to trace as "/bk/con.sql"; Databasealtered.备份二进制格式SQL> alterdatabase backup controlfile to trace as "/bk/con.ctl"; Databasealtered.----加上as字句是为了自定义存储的位置noresetlog重建控制文件SQL>！cp /etc/passwd /u01/tiger/oradata/orcl2/control01.ctl SQL> altersystem swirch logfile;alter systemswirch logfile *ERROR at line 1:ORA-02065:illegal option for ALTER SYSTEM SQL> altersystem switch logfile;alter systemswitch logfile *ERROR at line 1:ORA-03113:end-of-file on communication channelSQL> conn /assysdbaConnected to anidle instance.SQL> startupOracle instancestarted. Total SystemGlobal Area 314572800 bytesFixed Size 1219136 bytesVariableSize 109053376 bytesDatabaseBuffers 197132288 bytesRedoBuffers 7168000 bytesORA-00205: errorin identifying control file, check alert log for more info这里发现当mount的时候发现控制文件有问题，这样我们可以根据之前备份的控制文件的文本文件来恢复控制文件CREATECONTROLFILE REUSE DATABASE "ORCL2" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1"/u01/tiger/oradata/orcl2/redo01.log" SIZE 50M, GROUP 2"/u01/tiger/oradata/orcl2/redo02.log" SIZE 50M, GROUP 3"/u01/tiger/oradata/orcl2/redo03.log" SIZE50MDATAFILE "/u01/tiger/oradata/orcl2/system01.dbf", "/u01/tiger/oradata/orcl2/tiger.dbf", "/u01/tiger/oradata/orcl2/sysaux01.dbf", "/u01/tiger/oradata/orcl2/users01.dbf", "/u01/tiger/oradata/orcl2/undotbs02.dbf", "/u01/tiger/oradata/orcl2/undotbs01", "/u01/tiger/oradata/orcl2/tiger01.dbf"CHARACTER SETZHS16GBKSQL> alterdatabase open;alter databaseopen*ERROR at line 1:ORA-01113: file1 needs media recoveryORA-01110: datafile 1: "/u01/tiger/oradata/orcl2/system01.dbf"SQL> recoverdatabase;Media recoverycomplete.SQL> alterdatabase open;Databasealtered.UNDO表空间备份恢复ASM磁盘组一点管理相关资讯 Oracle备份恢复

Oracle数据库物理文件备份/恢复（07/20/2015 20:53:07）
Oracle 数据备份与恢复（04/26/2014 09:35:49）
Oracle 10g控制文件备份到文件与手（02/23/2014 09:03:34）

Oracle使用句柄实现特定场景的无备（11/24/2014 14:07:02）
Oracle控制文件的备份、恢复以及多（04/10/2014 15:15:06）
Oracle用控制文件旧备份恢复后数据（08/19/2013 09:38:27）

本文评论查看全部评论（0）