| recovery when redo is lost [message #160843] |
Tue, 28 February 2006 11:51  |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
|
I have my database on Oracle 9i release 2, on Windows 2000, I had two redo groups and have lost both my redo log groups, I have no backup as well, how do I start the database.
|
|
|
|
|
|
| Re: recovery when redo is lost [message #160873 is a reply to message #160843] |
Tue, 28 February 2006 20:13  |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
There are three steps to deal with this situation.
Step 1: try to clear the logfiles. It will work if the logfiles don't contain any active transaction.
SQL> startup mount
SQL> alter database clear logfile group 1;
or SQL> alter database clear UNARCHIVED logfile group 1;
SQL> alter database open;
Step2. try to recreate the crontrol files. This will work if the datafiles is in a consistent staus. expample:
SQL> startup nomount
SQL> CREATE CONTROLFILE REUSE DATABASE "T920" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'D:\ORACLE\ORA920DATA\T920\REDO01.LOG' SIZE 100M,
GROUP 2 'D:\ORACLE\ORA920DATA\T920\REDO02.LOG' SIZE 100M,
GROUP 3 'D:\ORACLE\ORA920DATA\T920\REDO03.LOG' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'D:\ORACLE\ORA920DATA\T920\SYSTEM01.DBF',
'D:\ORACLE\ORA920DATA\T920\UNDOTBS01.DBF',
'D:\ORACLE\ORA920DATA\T920\CWMLITE01.DBF',
'D:\ORACLE\ORA920DATA\T920\DRSYS01.DBF',
'D:\ORACLE\ORA920DATA\T920\EXAMPLE01.DBF',
'D:\ORACLE\ORA920DATA\T920\INDX01.DBF',
'D:\ORACLE\ORA920DATA\T920\ODM01.DBF',
'D:\ORACLE\ORA920DATA\T920\TOOLS01.DBF',
'D:\ORACLE\ORA920DATA\T920\USERS01.DBF',
'D:\ORACLE\ORA920DATA\T920\XDB01.DBF'
CHARACTER SET UTF8;
SQL> alter database open resetlogs；
Step3. Using undocumented parameter.
set parameter in pfile
_allow_resetlogs_corruption=true
NOTE: YOU DATABASE WILL NOT SUPORTED BY ORACLE IF YOU SET USE THE PARAMETER TO OPEN THE DB.
SQL> startup pfile='f:\pfile.ora'
SQL> alter database open resetlogs;
After that exp full database and then import to a new db.
Hope this helpful!
Alex zeng
|
|
|
|
| Re: recovery when redo is lost [message #161151 is a reply to message #160873] |
Thu, 02 March 2006 04:56 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
I think the folowing steps should suffice for you.
1. Start the database in mount stage.
2. Drop the existing redo log members, that you have lost.
3. Add new redo log files.
4. Open database.
--Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
