OraFAQ Forum: Backup & Recovery » Redo Logs Missing

Home » RDBMS Server » Backup & Recovery » Redo Logs Missing | Datafile Corrupted (Tru64 Unix, Oracle 8.1.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Redo Logs Missing | Datafile Corrupted [message #298674]

Thu, 07 February 2008 01:35

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

Report message to a moderator

Re: Redo Logs Missing | Datafile Corrupted [message #298676 is a reply to message #298674]

Thu, 07 February 2008 01:55

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.

Report message to a moderator

Re: Redo Logs Missing | Datafile Corrupted [message #298685 is a reply to message #298676]

Thu, 07 February 2008 02:52

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'

Report message to a moderator

Re: Redo Logs Missing | Datafile Corrupted [message #298697 is a reply to message #298674]

Thu, 07 February 2008 03:37

varu123
Messages: 754
Registered: October 2007

Senior Member

You followed the wrong process.
Apply backup and recover the database.

Report message to a moderator

Re: Redo Logs Missing | Datafile Corrupted [message #298704 is a reply to message #298697]

Thu, 07 February 2008 04:02

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 ?

Report message to a moderator

Re: Redo Logs Missing | Datafile Corrupted [message #298883 is a reply to message #298704]

Fri, 08 February 2008 02:27

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

Report message to a moderator

Re: Redo Logs Missing | Datafile Corrupted [message #298914 is a reply to message #298704]

Fri, 08 February 2008 04:35

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

Report message to a moderator

Previous Topic:	How to recover from .DAT file
Next Topic:	Corrupted File

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 01:46:18 CST 2024