当前位置:Gxlcms > mysql > Oracle用老的控制文件备份恢复新建的数据文件

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

时间:2021-07-01 10:21:17 帮助过:29人阅读

最后,如果是system表空间损坏,又无备份,那么是无法打开数据库的,如果是sysaux,无备份,数据库还是可以open,当然要在重建控

最后,如果是system表空间损坏,,又无备份,那么是无法打开数据库的,如果是sysaux,无备份,数据库还是可以open,当然要在重建控制文件的时候去掉损坏的数据文件,否则是无法创建成功的,如下实例:

SQL> CREATE CONTROLFILE REUSE DATABASE "SKYREAD" NORESETLOGS FORCE LOGGING ARCHIVELOG

2 MAXLOGFILES 20

3 MAXLOGMEMBERS 5

4 MAXDATAFILES 1000

5 MAXINSTANCES 8

6 MAXLOGHISTORY 2337

7 LOGFILE

8 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 512M

13 DATAFILE

14 '/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 failed

ORA-01565: error in identifying file '/database/oradata/skyread/sysaux01.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

SQL> CREATE CONTROLFILE REUSE DATABASE "SKYREAD" NORESETLOGS FORCE LOGGING ARCHIVELOG

2 MAXLOGFILES 20

3 MAXLOGMEMBERS 5

4 MAXDATAFILES 1000

5 MAXINSTANCES 8

6 MAXLOGHISTORY 2337

7 LOGFILE

8 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 512M

13 DATAFILE

14 '/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.

linux

人气教程排行