首页 » ORACLE 9i-23c » Any loss of controlfile effects of database and recovery the controlfile

Any loss of controlfile effects of database and recovery the controlfile

Your database is having two control files, three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down?
A) any control file
B) any archive log file
C) one of the redo log members
D) loss of the initialization parameter file
E) any data file belonging to the default permanent tablespace

SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              83888372 bytes
Database Buffers           79691776 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.


SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/oracle/oradata/anbob/control01.ctl
/oracle/oradata/anbob/control02.ctl
/oracle/oradata/anbob/control03.ctl

SQL> ! rm /oracle/oradata/anbob/control01.ctl

SQL> ! ls /oracle/oradata/anbob/
control02.ctl  control03.ctl  redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  undotbs2.dbf  users01.dbf

SQL> alter system checkpoint;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@aix anbob]$ ls
control02.ctl  control03.ctl  redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  undotbs2.dbf  users01.dbf
[oracle@aix anbob]$ cp control02.ctl control01.ctl
[oracle@aix anbob]$ ora

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 14 23:13:44 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              83888372 bytes
Database Buffers           79691776 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
打赏

对不起,这篇文章暂时关闭评论。