database recovery

[pao]

Hi,
I facing some problem. Let me describe it:

The version of database is:8.0.6.0.0 . The OS is SunOS 5.5.1.
Some of the files in the filesystem got corrupted.
There was no valid backup at all;

While opening the database, the following error came:

SVRMGR> startup
ORACLE instance started.
Total System Global Area 302836144 bytes
Fixed Size 51632 bytes
Variable Size 40460288 bytes
Database Buffers 262144000 bytes
Redo Buffers 180224 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/data/HST02A/u04/log1HST02A.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Checked in the OS that /data/HST02A/u04/log1HST02A.dbf is missing. In fact all the 3 logfiles got

corrupted. There is no backup of logfiles.
Checked in the database, that none of the logfiles are in STALE state. Checked v$recover_file

that none of the files need recovery.
Added 3 new redo log groups.
Created new control files.
Executed the statement: alter database open RESETLOGS;
The following error came:
alter database open RESETLOGS
*
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/HST02A/u01/SYSTEM.dbf'

Then executed: alter database recover until cancel;
The following error came:
alter database recover until cancel
*
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
Then executed: alter database recover using backup controlfile;
The following error came:
alter database recover using backup controlfile
*
ORA-00279: change 499160782535 generated at 12/08/00 11:18:37 needed for thread 1
ORA-00289: suggestion : /opt/oracle/product/8.0.6/dbs/arch1_391.dbf
ORA-00280: change 499160782535 for thread 1 is in sequence #391

Then shutdown the database.
Added a parameter in pfile _allow_resetlogs_corruption=TRUE
Startup the database. The error came:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

Passed the statement: alter database open resetlogs;
The following erroe came:
alter database open resetlogs
*
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [4000], [3], [], [], [], [], [], []

Then again shutdown the database.
Startup nomount.
The modified control file was created.
the database was opened with resetlogs option. Again same error came.



Is there any way open the database?

[pando]

ops tricky if you dont have any backup and you have performd so many operations without a backup.
Before you did all this did you make a backup if you have I might be able to help you to recover it with a simpler way.
Also state which files were lost, all of lost files.

[pao]

I have taken backup before doing all these operations.
All the on line redo logfiles are missing. the database is running on noarchive log mode.

[pando]

restore backup,
startup mount

ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR LOGFILE GROUP 2;
ALTER DATABASE CLEAR LOGFILE GROUP 3;

alter database open;

[pao]

there is no backup of logfiles.......
i think there is no way......
i have already cloned from another database...

[jgmagnus]

How many Log Members per Log Group?

If you have log members then you can copy the uncorrupted members over your corrupted Log Files. That should work ...

- Magnus

[pao]

only one per group.....
it was a small dev. database.
it is already cloned from production

[pando]

ALTER DATABASE CLEAR LOGFILE GROUP

doesnt need any backups, it will recreate the log groups. and precisely this command is used when you lose all log members

[pao]

Will this command be issued at the mount state?

[pando]

check previous post
startup mount