Re: Missing all redo log files

Hi,

Have you done any recovery (in your case incomplete recovery) prior to RESETLOGS? As OPEN RESETLOGS is used for after incomplete recovery to synchronize all the data files. If you have a most recent backup, restore them (all data files, archived logs, and probably your backup controlfile as you have set all SCN to 0 as a result of RESETLOGS) and do a RECOVER DATABASE UNTIL ... USING BACKUP CONTROLFILE, then OPEN RESETLOGS. Before doing an actual restore you may like to look at the V$LOG, V$LOG_HISTORY view to obtain some information, not sure whether it's meaningful if you've done a RESETLOGS.

I'm not sure it is the best procedure for you but by at looking your case it should work, provided that you have your full backup.

cheers,
geoffrey

Alianto wrote:
>
> Our clients use HP Oracle database, when database is running, one without
> accident delete all redo log files and oracle's system shutdown
> automatically without any messages. When One try to startup the instance, it
> show a message :
>
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 34165080 bytes
> Fixed Size 47936 bytes
> Variable Size 13080088 bytes
> Database Buffers 20971520 bytes
> Redo Buffers 65536 bytes
> Database mounted.
> ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
> SVRMGR>
> SVRMGR> alter database open resetlogs;
> alter database open resetlogs
> *
> ORA-01194: file 1 needs more recovery to be consistent
> ORA-01110: data file 1: '/data2/mims13s/dbs/system.dbf'
> SVRMGR>
>
> Regards,
>
> Alianto
Received on Mon Jan 18 1999 - 02:34:44 CST