LOST if one or more CONTROLFILE


SQL> show parameter control_file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      /export/d3120/oradata/JUNKDB/c
                                                 ontrol01.ctl, /export/d3120/or
                                                 adata/JUNKDB/control02.ctl, /e
                                                 xport/d3120/oradata/JUNKDB/con
                                                 trol03.ctl
SQL> shu abort
ORACLE instance shut down.
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

bash-3.00$ ls
arch            control02.ctl   cooldata01.dbf  redo01.log      redo03.log      system01.dbf    ttstest.dbf     users01.dbf
control01.ctl   control03.ctl   cooldata02.dbf  redo02.log      sysaux01.dbf    temp02.dbf      undotbs01.dbf   yedek

bash-3.00$ rm control01.ctl
bash-3.00$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Apr 28 09:09:08 2011

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size                  2126904 bytes
Variable Size             513641416 bytes
Database Buffers          738197504 bytes
Redo Buffers                4325376 bytes
ORA-00205: error in identifying control file, check alert log for more info

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

bash-3.00$ cp control02.ctl control01.ctl
bash-3.00$
bash-3.00$
bash-3.00$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Apr 28 09:09:56 2011

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> startup     
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> startup force
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size                  2126904 bytes
Variable Size             513641416 bytes
Database Buffers          738197504 bytes
Redo Buffers                4325376 bytes
Database mounted.
Database opened.
SQL>
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: