重建控制文件
1:把控制文件备份到trace
SQL> alter database backup controlfile to trace;
Database altered.
2:trace文件在 user_dump_dest
SQL> show parameter user
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
license_max_users integer 0
parallel_adaptive_multi_user boolean TRUE
redo_transport_user string
user_dump_dest string /u01/app/oracle/diag/rdbms/enm
oedu/ENMOEDU/trace
SQL>
3:打开trace文件
[oracle@imp trace]$ cd /u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU/trace
cle@imp trace]$ ls -lt
找到 ora 第一个
4:复制
oracle@imp trace]$ cat ENMOEDU_ora_4907.trc
CREATE CONTROLFILE REUSE DATABASE "ENMOEDU" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/ENMOEDU/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/ENMOEDU/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/ENMOEDU/redo03.log' SIZE 50M BLOCKSIZE 512,
GROUP 4 (
'/u01/app/oracle/oradata/ENMOEDU/redo04_a.log',
'/u01/app/oracle/oradata/ENMOEDU/redo04_b.log'
) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/ENMOEDU/system01.dbf',
'/u01/app/oracle/oradata/ENMOEDU/sysaux01.dbf',
'/u01/app/oracle/oradata/ENMOEDU/undotbs01.dbf',
'/u01/app/oracle/oradata/ENMOEDU/users01.dbf',
'/u01/app/oracle/oradata/ENMOEDU/example01.dbf'
CHARACTER SET WE8MSWIN1252
;
[oracle@imp zz]$ ls
zz.sql
[oracle@imp zz]$ pwd
/home/oracle/zz
5:nomount状态
SQL> startup nomount
ORACLE instance started.
Total System Global Area 939495424 bytes
Fixed Size 2258840 bytes
Variable Size 612370536 bytes
Database Buffers 318767104 bytes
Redo Buffers 6098944 bytes
SQL>
6:执行脚本
@/home/oracle/zz/zz.sql
SQL> @/home/oracle/zz/zz.sql
Control file created.
SQL>
7:起库
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
--#resetlogs
SQL> alter database open resetlogs;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL>
1:把控制文件备份到trace
SQL> alter database backup controlfile to trace;
Database altered.
2:trace文件在 user_dump_dest
SQL> show parameter user
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
license_max_users integer 0
parallel_adaptive_multi_user boolean TRUE
redo_transport_user string
user_dump_dest string /u01/app/oracle/diag/rdbms/enm
oedu/ENMOEDU/trace
SQL>
3:打开trace文件
[oracle@imp trace]$ cd /u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU/trace
cle@imp trace]$ ls -lt
找到 ora 第一个
4:复制
oracle@imp trace]$ cat ENMOEDU_ora_4907.trc
CREATE CONTROLFILE REUSE DATABASE "ENMOEDU" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/ENMOEDU/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/ENMOEDU/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/ENMOEDU/redo03.log' SIZE 50M BLOCKSIZE 512,
GROUP 4 (
'/u01/app/oracle/oradata/ENMOEDU/redo04_a.log',
'/u01/app/oracle/oradata/ENMOEDU/redo04_b.log'
) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/ENMOEDU/system01.dbf',
'/u01/app/oracle/oradata/ENMOEDU/sysaux01.dbf',
'/u01/app/oracle/oradata/ENMOEDU/undotbs01.dbf',
'/u01/app/oracle/oradata/ENMOEDU/users01.dbf',
'/u01/app/oracle/oradata/ENMOEDU/example01.dbf'
CHARACTER SET WE8MSWIN1252
;
[oracle@imp zz]$ ls
zz.sql
[oracle@imp zz]$ pwd
/home/oracle/zz
5:nomount状态
SQL> startup nomount
ORACLE instance started.
Total System Global Area 939495424 bytes
Fixed Size 2258840 bytes
Variable Size 612370536 bytes
Database Buffers 318767104 bytes
Redo Buffers 6098944 bytes
SQL>
6:执行脚本
@/home/oracle/zz/zz.sql
SQL> @/home/oracle/zz/zz.sql
Control file created.
SQL>
7:起库
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
--#resetlogs
SQL> alter database open resetlogs;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31399171/viewspace-2130008/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31399171/viewspace-2130008/