Home » RDBMS Server » Backup & Recovery » Redo Logs Missing | Datafile Corrupted (Tru64 Unix, Oracle 8.1.7)
icon8.gif  Redo Logs Missing | Datafile Corrupted [message #298674] Thu, 07 February 2008 01:35 Go to next message
ankurjain
Messages: 11
Registered: July 2007
Location: Vadodara, Gujarat, India
Junior Member
Hi All,

I faced the following problem in my database recently.

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 Sad


PS: I am not a DBA but a developer Sad

Ne Hints will be helpful.

Thanks
-AJ
Re: Redo Logs Missing | Datafile Corrupted [message #298676 is a reply to message #298674] Thu, 07 February 2008 01:55 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Are you on Oracle 7/8i?
Quote:
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.



Why did you delete them?

Quote:
3> svrmgrl> recover database until cancel



Did you lose any datafiles?
Tail ALERT LOG.
Re: Redo Logs Missing | Datafile Corrupted [message #298685 is a reply to message #298676] Thu, 07 February 2008 02:52 Go to previous messageGo to next message
ankurjain
Messages: 11
Registered: July 2007
Location: Vadodara, Gujarat, India
Junior Member
I am using oracle 8i v8.1.7. The three redo files were deleted mysteriously .... we only found that the redo files were missing when the error was reported.

Since the files were deleted so i recreated the same files by deleting and then recreating the groups, but in the process deleting the current group gave error.

I got an error for the system_1.dbf file like this :
Quote:

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'


Re: Redo Logs Missing | Datafile Corrupted [message #298697 is a reply to message #298674] Thu, 07 February 2008 03:37 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
You followed the wrong process.
Apply backup and recover the database.
Re: Redo Logs Missing | Datafile Corrupted [message #298704 is a reply to message #298697] Thu, 07 February 2008 04:02 Go to previous messageGo to next message
ankurjain
Messages: 11
Registered: July 2007
Location: Vadodara, Gujarat, India
Junior Member
Can u explain a bit how to do that. what i get from your lines is :

1> Restore backup from old recent tape backup. Backup the .dbf file.

2> For recovery do 'revocer database until cancel'

Am i right ?
Re: Redo Logs Missing | Datafile Corrupted [message #298883 is a reply to message #298704] Fri, 08 February 2008 02:27 Go to previous messageGo to next message
ankurjain
Messages: 11
Registered: July 2007
Location: Vadodara, Gujarat, India
Junior Member
Hi All,

From some search over the net i found that recovery is not possible for my data. Its OK if the data is not recovered as i have another database server which is working and logging all data. Now please instruct me how can i start the database clean, without any errors ?

-Thanks
AJ
Re: Redo Logs Missing | Datafile Corrupted [message #298914 is a reply to message #298704] Fri, 08 February 2008 04:35 Go to previous message
ankurjain
Messages: 11
Registered: July 2007
Location: Vadodara, Gujarat, India
Junior Member
Hi All,

I managed to get the backups of the *.dbf as well as redo logs but they are around 5 months old. Can i place these in the default location and perform recovery steps as described above :

startup nomount;

recover database until cancel;

alter database start resetlogs;

Please reply guys


-AJ
Previous Topic: How to recover from .DAT file
Next Topic: Corrupted File
Goto Forum:
  


Current Time: Fri Dec 09 13:59:10 CST 2016

Total time taken to generate the page: 0.10955 seconds