Oracle Database Discussions

Hi All,

I faced the following problem in my database recently.

EDIT : Oracle 8i (version 8.1.7)

The online redo files redo_1.log(group 1 ), redo_2.log (group 2),redo_3.log (group 3) are all missing from the database. The Current log files was redo_1.log. I Deleted the two unused groups and created newer ones. But am not able to delete the redo_1.log(group 1). The error states that its an online log file. thats fine.

Now i searched on net and found some same problems so i followed one and did the following :

1> svrmgrl> connect internal
2> svrmgrl> shutdown immediate
3> svrmgrl> recover database until cancel


Now this last line gives error as :

SVRMGR> recover database until cancel;
ORA-00279: change 166306965 generated at 01/31/2008 04:47:49 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/admin/master2/arch/arch.logLOG0000007588
.ARC
ORA-00280: change 166306965 for thread 1 is in sequence #7588
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '/u01/app/oracle/admin/master2/arch/arch.log
LOG0000007588.ARC'
ORA-27037: unable to obtain file status
Compaq Tru64 UNIX Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/oradata/master2/system_1.dbf'

SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/oradata/master2/system_1.dbf'

SVRMGR> exit
Server Manager complete.

4> svrmgrl> alter database open resetlogs

This gave error as mentioned above regarding system_1.dbf.

Now i am having one more oracle running on some other server of the same configuration. Though its not the backup, but has the same config. Can i copy the system_1.dbf from that and put it here.

We also have replication setup between the servers.

I guess from looking at init.ora file that server is running in archive mode . The following lines mean so i guess :

log_archive_start = true
log_archive_format = "LOG%S.ARC"
log_archive_dest = /u01/app/oracle/admin/hyundai/arch/arch.log

The file in log_archive_dest is also not there :(


PS: I am not a DBA but a developer :(

Ne Hints will be helpful.

Thanks
-AJ

Message was edited by:
oracle10g