移动控制文件
[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.