- Damage a control file
SQL> Shutdown Immediate database has been turned off. The database has been uninstalled. Oracle routines have been closed. SQL> HostMicrosoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp.
C: /> DEL D: /ORACLE9/ORADATA/nbxtdb/control01.ctl
C: /> EXIT
SQL> StartUporacle routines have been started.
Total System Global Area 378608760 Bytesfixed Size 453752 bytesvariable size 167772160 bytesdatabase buffers 209715200 BYTESREDO BUFFERS 667648 BYTESORA-00205: ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
SQL> shutdown immediateora-01507: ??????
Oracle routines have been closed. SQL> HostMicrosoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp.
C: /> Copy D: /oracle9/oradata/nbxtdb/control02.cttl d: /oracle9/oradata/nbxtdb/control01.ctl has copied 1 file.
C: /> Startup'Startup 'is not internal or external commands, nor is also a running program or batch file.
C: /> EXIT
SQL> StartUporacle routines have been started.
Total System Global Area 378608760 Bytesfixed Size 453752 bytesvariable size 167772160 bytesdatabase buffers 209715200 BYTESREDO BUFFERS 667648 BYTES Database Loading. The database has been opened. SQL>
--1, because all control files in the database are the same, only simple copy is available - 2, suggest that the mirror control file is on different disks - 3, it is recommended to do more control file backup, long-term Keep a text backup of a control file generated by the ALTER DATABASE Backup Control File to TRACE.
