Oracle用老的控制文件备份恢复新建的数据文件

最后，如果是system表空间损坏，又无备份，那么是无法打开数据库的，如果是sysaux，无备份，数据库还是可以open，当然要在重建控制文件的时候去掉损坏的数据文件，否则是无法创建成功的，如下实例：SQL> CREATE CONTROLFILE REUSE DATABASE "SKYREAD" NORESETLOGS FORCE LOGGING ARCHIVELOG2 MAXLOGFILES 203 MAXLOGMEMBERS 54 MAXDATAFILES 10005 MAXINSTANCES 86 MAXLOGHISTORY 23377 LOGFILE8 GROUP 1 "/database/oradata/skyread/redo01.log" SIZE 512M,9 GROUP 2 "/database/oradata/skyread/redo02.log" SIZE 512M,10 GROUP 3 "/database/oradata/skyread/redo03.log" SIZE 512M,11 GROUP 4 "/database/oradata/skyread/redo04.log" SIZE 512M,12 GROUP 5 "/database/oradata/skyread/redo05.log" SIZE 512M13 DATAFILE14 "/database/oradata/skyread/system01.dbf",15 "/database/oradata/skyread/tbs_test.dbf",16"/database/oradata/skyread/sysaux01.dbf",17 "/database/oradata/skyread/users01.dbf",18 "/database/oradata/skyread/tbs_tbs.dbf",19 "/database2/oradata/skyread/TBS_MRPMUSIC01.dbf",20 "/database/oradata/skyread/sf01.dbf",21 "/database2/oradata/skyread/undotbs02"22 CHARACTER SET UTF8;CREATE CONTROLFILE REUSE DATABASE "SKYREAD" NORESETLOGS FORCE LOGGING ARCHIVELOG*ERROR at line 1:ORA-01503: CREATE CONTROLFILE failedORA-01565: error in identifying file "/database/oradata/skyread/sysaux01.dbf"ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3 SQL> CREATE CONTROLFILE REUSE DATABASE "SKYREAD" NORESETLOGS FORCE LOGGING ARCHIVELOG2 MAXLOGFILES 203 MAXLOGMEMBERS 54 MAXDATAFILES 10005 MAXINSTANCES 86 MAXLOGHISTORY 23377 LOGFILE8 GROUP 1 "/database/oradata/skyread/redo01.log" SIZE 512M,9 GROUP 2 "/database/oradata/skyread/redo02.log" SIZE 512M,10 GROUP 3 "/database/oradata/skyread/redo03.log" SIZE 512M,11 GROUP 4 "/database/oradata/skyread/redo04.log" SIZE 512M,12 GROUP 5 "/database/oradata/skyread/redo05.log" SIZE 512M13 DATAFILE14 "/database/oradata/skyread/system01.dbf",15 "/database/oradata/skyread/tbs_test.dbf",16 "/database/oradata/skyread/users01.dbf",17 "/database/oradata/skyread/tbs_tbs.dbf",18 "/database2/oradata/skyread/TBS_MRPMUSIC01.dbf",19 "/database/oradata/skyread/sf01.dbf",20 "/database2/oradata/skyread/undotbs02"21 CHARACTER SET UTF8;Control file created.SQL> alter database open;Database altered.更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12

Oracle 日志文件和控制文件损坏的恢复Oracle中将表设置为read only的问题相关资讯 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）