DATABASE IS NOT OPENING

[shailendra]

HI

FRIENDS I WANT YOUR HELP VERY URGENTLY

I M GETTING THIS ERROR
ORA-01588: must use RESETLOGS option for database open

I HAVE TRIED TO OPEN DATABASE FROM THIS COMMAND ALSO

ALTER DATABASE OPEN RESETLOGS;

BUT IT IS GIVING AN ERROR
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\HUNGAMA\SYSTEM01.DBF'

WELL I WANTED TO KNOW WHAT HAPPEND IF I WRITE RESERLOG OR NORESETLOG AT THE LAST OF THE ABOVE STATEMENT.

ALSO HOW TO START THE DATABSE?

THANKS

[Edited by shailendra on 07-30-2002 at 05:20 AM]

[soniaarora]

Can u let me know when u r trying to open the database? Was there any problem or any failure that u had to shutdown ur database?
U need a recovery of ur system datafile. Do u have backups and archivelogs of ur database?

[shailendra]

BY MISTAKE I REMOVED THE ARCHIVE FILES

NOW IS THERE ANY WAY TO RECOVER IT BACK?

SHAILENDRA

[SANJAY_G]

Hi Shailendra,

1. RESETLOGS will reset the log sequence and the old Archvied Logs can not be used for recovery. NORESETLOGS will open the database as normal and existing log sequnce will continue.

2. Your system tablespace file is not consistent yet and more logs need to be applied.

HTH
Sanjay

PS: Why all CAPS message?

[SANJAY_G]

Have you tried

RECOVER DATABASE UNTIL CANCEL;

??

Sanjay

[shailendra]

YA SANJAY FIRST OF ALL VERY VERY THANKS
SANJAY I HAVE TRIED THAT ALSO BUT I M GETTING THIS MESSAGE

ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

[moff]

Hi,

Have you recovered your database using a backup taken after the database was not shutdown cleanly

ie Did you take a backup after a system crash or a shutdown abort and are you using this backup to recover the database?

The problem is that the file system01.dbf requires further recovery.

Have you got a clean backup? do you backup your archive logs as well?
I think your best option is to go back to the last clean backup and apply the available archive logs.

If you don't have the Archive logs you can only recover to the last backup....NEVER delete archive logs until you have either backed them up or have just taken a successfull backup (Then only delete those prior to the backup starting)

Regards
Moff.

[SANJAY_G]

What kind of backup you have with you?
What are the operations have you performed after db crash?

Sanjay