移動控制文件
[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.ctlSQL>?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.ctlSQL>?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/king/wallet/traceSQL>?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.trcSQL>?shutdown?immediate
Database?closed.
Database?dismounted.
ORACLE?instance?shut?down.SQL>?host?rm?-rf?/u01/app/oracle/oradata/wallet/control01.ctlSQL>?host?rm?-rf?/u02/app/oracle/oradata/wallet/control02.ctlSQL>?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?bytesSQL>?CREATE?CONTROLFILE?REUSE?DATABASE?"WALLET"?NORESETLOGS??ARCHIVELOGMAXLOGFILES?16MAXLOGMEMBERS?3MAXDATAFILES?100MAXINSTANCES?8MAXLOGHISTORY?292
LOGFILEGROUP?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.