重建控制文件 - 墨天轮文档

重建控制文件

张帅

1016

6页

26次

2020-07-14

免费下载

重建控制文件

单实例：

先生成控制文件重建脚步后重建控制文件

(

要做

mount

状态下才能生成）

SQL> shut

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 263090176 bytes

Fixed Size 2252256 bytes

Variable Size 167772704 bytes

Database Buffers 88080384 bytes

Redo Buffers 4984832 bytes

Database mounted.

SQL> alter database backup controlfile to trace as'/home/oracle/controlfile.trc'

Database altered.

找到控制文件把它删了

SQL> show parameter control;

NAME TYPE VALUE

------------------------------------ -----------

------------------------------

control_file_record_keep_time integer 7

control_files string /oracle/app/oracle/oradata/sb1

23456/control01.ctl, /oracle/a

pp/oracle/fast_recovery_area/s

b123456/control02.ctl

control_management_pack_access string DIAGNOSTIC+TUNING

进入对应位置：

rm -f control01.ctl

rm -f control02.ctl

关库以后已经无法再正常启动

SQL> shut

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 263090176 bytes

Fixed Size 2252256 bytes

Variable Size 167772704 bytes

Database Buffers 88080384 bytes

Redo Buffers 4984832 bytes

ORA-00205: error in identifying control file, check alert log for more info

重建控制文件：

[oracle@localhost ~]$ cat controlfile.trc

-- The following are current System-scope REDO Log Archival related

-- parameters and can be included in the database initialization file.

-- LOG_ARCHIVE_DEST=''

-- LOG_ARCHIVE_DUPLEX_DEST=''

-- LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf

-- DB_UNIQUE_NAME="sb123456"

-- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG'

-- LOG_ARCHIVE_MAX_PROCESSES=3

-- STANDBY_FILE_MANAGEMENT=MANUAL

-- STANDBY_ARCHIVE_DEST=?/dbs/arch

-- FAL_CLIENT=''

-- FAL_SERVER=''

-- LOG_ARCHIVE_DEST_1='LOCATION=/oracle/app/oracle/fast_recovery_area/'

-- LOG_ARCHIVE_DEST_1='OPTIONAL REOPEN=300 NODELAY'

-- LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM NOEXPEDITE NOVERIFY SYNC'

-- LOG_ARCHIVE_DEST_1='REGISTER NOALTERNATE NODEPENDENCY'

-- LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED

NODB_UNIQUE_NAME'

-- LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'

-- LOG_ARCHIVE_DEST_STATE_1=ENABLE

of 6

免费下载

oracle

关注

评论