[Oracle Database] Database control file management

Mobile control file [oracle@wallet01 ~] $sqlplus / as sysdbaSQL > set line 200SQL > col name for a60SQL > 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' '/ u02App scope=spfile to oracle, oradata, Wallet, control, control02.ctl' 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 sysdbaSQL > startupORACLE instance started.Total System Global Area 1068937216 bytesFixed Size 2260088 bytesVariable Size 335545224 bytesDatabase Buffers 725614592 bytesRedo Buffers 5517312 bytesDatabase mounted.Database opened.SQL > set line 200SQL > col name for a60SQL > 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

Rebuild control file SQL > show parameter user_dump_destNAME 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.trcSQL > shutdown immediateDatabase 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 nomountORACLE instance started.Total System Global Area 1068937216 bytesFixed Size 2260088 bytesVariable Size 335545224 bytesDatabase Buffers 725614592 bytesRedo Buffers 5517312 bytesSQL > CREATE CONTROLFILE REUSE DATABASE "WALLET" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 ('/ u01Accorde Greater oradata Greater Wallet Greater redo01a.log' SIZE 50m BLOCKSIZE 512, GROUP 2 ('/ u01LexaporadataRedo02a.log','/ u02LexoradataUniverse redo02b.log') SIZE 50m BLOCKSIZE 512, GROUP 3 ('/ u01Lexoradata GROUP') SIZE 50M BLOCKSIZE 512-STANDBY LOGFILEDATAFILE'/ u01 apprenticeships Walllet system 01.dbfills,'/ u01LameApplicationoradataWallletSystemsysaux01.dbfills,'/ u01apprenticesoradatawalletbacks,'/ u01andappsLeLeoradatawallets01.dbfills,'/ u01andappThree oradatawallets01.dbfills,'/ u01ApplicaloradataWallletusers01.dbftogether,'/ u01apps01.dbf` '/ u01appranumoracle.oradataAccording to Wallet SET AL32UTF8 soe02.dbfencing Control file created.SQL > shutdown abort ORACLE instance shut down.SQL > startupORACLE instance started.Total System Global Area 1068937216 bytesFixed Size 2260088 bytesVariable Size 335545224 bytesDatabase Buffers 725614592 bytesRedo Buffers 5517312 bytesDatabase mounted.Database opened.