【Oracle Database】数据库控制文件管理

移动控制文件
[oracle@wallet01 ~]$ sqlplus / as sysdba
SQL> set line 200
SQL> col name for a60
SQL> select status,name from v$controlfile;

STATUS  NAME
------- ------------------------------------------------------------
        /u01/app/oracle/oradata/wallet/control01.ctl
        /u01/app/oracle/fast_recovery_area/wallet/control02.ctl
                      
SQL> alter system set control_files=
'/u01/app/oracle/oradata/wallet/control01.ctl',
'/u02/app/oracle/oradata/wallet/control02.ctl' scope=spfile;
System altered.

SQL> shutdown immediate   
Database closed.
Database dismounted.
ORACLE instance shut down.

[oracle@wallet01 ~]$ cp /u01/app/oracle/oradata/wallet/control01.ctl /u02/app/oracle/oradata/wallet/control02.ctl

[oracle@wallet01 ~]$ sqlplus / as sysdba
SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             335545224 bytes
Database Buffers          725614592 bytes
Redo Buffers                5517312 bytes
Database mounted.
Database opened.

SQL> set line 200
SQL> col name for a60
SQL> select status,name from v$controlfile;

STATUS  NAME
------- ------------------------------------------------------------
        /u01/app/oracle/oradata/wallet/control01.ctl
        /u02/app/oracle/oradata/wallet/control02.ctl
                      
SQL> host rm -rf /u01/app/oracle/flash_recovery_area/wallet/control02.ctl

重建控制文件
SQL> show parameter user_dump_dest
NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
user_dump_dest                       string                            /u01/app/oracle/diag/rdbms/kin
                                                                       g/wallet/trace
                                                                       
SQL> alter session set tracefile_identifier='trace_control';
Session altered.

SQL> alter database backup controlfile to trace;
Database altered.

[oracle@wallet01 ~]$ cd /u01/app/oracle/diag/rdbms/wallet/wallet/trace

[oracle@wallet01 trace]$ more wallet_ora_28356_trace_control.trc

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> host rm -rf /u01/app/oracle/oradata/wallet/control01.ctl

SQL> host rm -rf /u02/app/oracle/oradata/wallet/control02.ctl

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             335545224 bytes
Database Buffers          725614592 bytes
Redo Buffers                5517312 bytes

SQL> CREATE CONTROLFILE REUSE DATABASE "WALLET" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
    '/u01/app/oracle/oradata/wallet/redo01a.log',
    '/u02/app/oracle/oradata/wallet/redo01b.log'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 2 (
    '/u01/app/oracle/oradata/wallet/redo02a.log',
    '/u02/app/oracle/oradata/wallet/redo02b.log'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 3 (
    '/u01/app/oracle/oradata/wallet/redo03a.log',
    '/u02/app/oracle/oradata/wallet/redo03b.log'
  ) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/wallet/system01.dbf',
  '/u01/app/oracle/oradata/wallet/sysaux01.dbf',
  '/u01/app/oracle/oradata/wallet/undotbs01.dbf',
  '/u01/app/oracle/oradata/wallet/users01.dbf',
  '/u01/app/oracle/oradata/wallet/soe01.dbf',
  '/u01/app/oracle/oradata/wallet/soe02.dbf',
CHARACTER SET AL32UTF8;
Control file created.

SQL> shutdown abort    
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             335545224 bytes
Database Buffers          725614592 bytes
Redo Buffers                5517312 bytes
Database mounted.
Database opened.