重新建控制文件 ORA-00205

最新推荐文章于 2025-09-25 12:02:27 发布

原创

最新推荐文章于 2025-09-25 12:02:27 发布 · 1.1w 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#database #thread #file #system #sql #archive

本文详细介绍了在Oracle数据库中遇到控制文件问题时如何进行重建，并在归档模式下进行数据库恢复，包括备份控制文件、启动实例、使用备份控制文件恢复数据库、处理ORA-01589和ORA-01152错误等步骤。

1、在非归档中，联机重做日志文件没丢失，

SQL> startup;

ORACLE instance started.

Total System Global Area 243269632 bytes
Fixed Size 1218748 bytes
Variable Size 79693636 bytes
Database Buffers 159383552 bytes
Redo Buffers 2973696 bytes
ORA-00205: error in identifying control file, check alert log for more info

SQL> archive log list
ORA-01507: database not mounted
SQL> select * from v$database;
select * from v$database
*
ERROR at line 1:
ORA-01507: database not mounted

-- noresetlogs一定要带这个参数

SQL> create controlfile reuse database orcl noarchivelog noresetlogs
2 maxlogfiles 16
3 maxlogmembers 3
4 maxdatafiles 100
5 maxinstances 8
6 maxloghistory 292
7 datafile
8 '/u1/oracle/oradata/orcl/system01.dbf',
9 '/u1/oracle/oradata/orcl/undotbs01.dbf',
10 '/u1/oracle/oradata/orcl/sysaux01.dbf',
11 '/u1/oracle/oradata/orcl/users01.dbf',
12 '/u1/oracle/oradata/orcl/example01.dbf'
13 logfile
14 GROUP 1 '/u1/oracle/oradata/orcl/redo01.log' SIZE 50M,
15 GROUP 2 '/u1/oracle/oradata/orcl/redo02.log' SIZE 50M,
16 GROUP 3 '/u1/oracle/oradata/orcl/redo03.log' SIZE 50M
17 character set AL32UTF8;

Control file created.

SQL> alter database open;

Database altered.

SQL>

2、在归档模式下

1）首先备份控制文件

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 8
Next log sequence to archive 10
Current log sequence 10
SQL> show parameter control_f

NAME

最低0.47元/天解锁文章