LOST IF ONE CONTROLFILE


SQL> show parameter control_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /export/d3120/oradata/AZKKDB/c
 ontrol01.ctl, /export/d3120/or
 adata/AZKKDB/control02.ctl, /e
 xport/d3120/oradata/AZKKDB/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 backup
bash-3.00$ rm control01.ctl 
bash-3.00$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 28 09:09:08 2013
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 Nov 28 09:09:56 2013
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: