【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.