Search This Blog

Tuesday, April 3, 2007

All Control File LOST Without Backup

Database : 10gr1
OS : Windows
Archivelog : ENABLE

Note : All control files LOST due to system crash and without backup !!!
Database Initially Closed when Lost all control files.





SQL>conn "/ as sysdba"
connected.
SQL> startup nomount;


SQL> select status from v$instance;

STATUS
------------
STARTED

SQL> ED
Wrote file afiedt.buf

1 CREATE CONTROLFILE REUSE DATABASE "ORA101" NORESETLOGS ARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 271
7 LOGFILE
8 GROUP 1 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\REDO01.LOG' SIZE 10M,
9 GROUP 2 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\REDO02.LOG' SIZE 10M,
10 GROUP 3 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\REDO03.LOG' SIZE 10M
11 -- STANDBY LOGFILE
12 DATAFILE
13 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\SYSTEM01.DBF' size 440m,
14 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\UNDOTBS01.DBF' size 25m,
15 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\SYSAUX01.DBF' size 220m,
16 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\USERS01.DBF' size 5m,
17 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\EXAMPLE01.DBF' size 150m
18* CHARACTER SET WE8MSWIN1252
SQL> /

Control file created.

Note: Create new crontrol file with SIZE clause.
SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 15
Next log sequence to archive 17
Current log sequence 17
SQL>



Take database consistent backup.

1 comment:

Babu said...

Thanks Taj...