控制文件重建

重建控制文件
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/