Restore archive logs

[Former Member]

Hi

I restored datafiles with restore commnad but how can I restore archive logs which are in .dbf.z files.

Can you please let me know how could I restore archive files so that I could recover database?

Thanks

[Former Member]

Hello Kasinath,

Please tell me how did u un compress the archive files? Even i want to un compress 5 files having .dbf.z extension.

Regards,

MT

[yrk_tkm]

uncompress *.dbf.z

that's it.

[Former Member]

Gerard Christopher's last steps worked

[stefan_koehler]

Hello Kasinath,

> Can you please let me know how could I restore archive files so that I could recover database?

How did you backup the archive log files (BR*Tools?)?

Regards

Stefan

[Former Member]

Yes....

Through DB13 in SAP. SAP uses BRARCHIVE tool to backup

Thanks

[stefan_koehler]

Hello Kasinath,

check this (Point Process Flow): http://help.sap.com/saphelp_nw70/helpdata/en/8c/09503e30a9d549e10000000a114084/content.htm

Regards

Stefan

[Former Member]

Hi Stefan

This link is showing different options than our BRTOOLS.

Do you sql command to restore and apply these archives?

I tell you the process I am doing

1) I restored the database from our back up file system.

when tried to start up databse it was saying to reset/no reset logs as below

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

2) I did reset the logs ( alter database open reset logs)

3) and Trying to recover database using backup control file until canncel. It came up below message

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/EPR/sapdata1/system_1/system.data1'

SQL> recover database using backup controlfile;

ORA-03113: end-of-file on communication channel

I tried to shut down abort but it is giving error as

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

Can you please let me know what went wrong and how can we startup database?

Thanks in advance

[Former Member]

Kasi,

Before your recover database using backup control file .

Did you edit the trace file you created from the source , did you change the SID's in the filesystem to the target .

Incase your target SID is different.

and did u remove all the unnecessary entries in there.

You have to create the control file creation sql file first

You need to execute the control.sql script that you created from the source.

sqlplus "/as sysdba",

startup nomount

SQL>@control.sql

you should get a message saying the controlfile is created.

after which you need to

SQL> recover database using backup controlfile until cancel;

SQL> alter database open resetlogs;

Gerard

[Former Member]

Hi Gerard

I am not doing system refresh. We have set up all the same as source system like file systems, SID, profiles, host name.......

So, In this case I think we wont need to generate controlfiles.

The error I had as said in previous message that is "ORA-01041: internal error. hostdef extension doesn't exist" is no more now.

I exited from SQL prompt and login again to SQL prompt then this error is not coming.

Now when I say recover database using backup control file until cancel, it is giving error as below

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 7516255258615 generated at 12/30/2009 16:49:55 needed for

thread 1

ORA-00289: suggestion : /oracle/EPR/saparch/EPRarch1_4573.dbf

ORA-00280: change 7516255258615 for thread 1 is in sequence #4573

Please let me know further.

Thanks in advance

[stefan_koehler]

Hello Kasinath,

i highly recommend - use the BR*Tools only.

If you do a manual restore and recovery you really need to know what you do.

>1) I restored the database from our back up file system.

>when tried to start up databse it was saying to reset/no reset logs as below

>ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

Works as designed. I assume that your backup was an online backup.

> 2) I did reset the logs ( alter database open reset logs)

Totally wrong .. you can't do an open resetlogs without recovery of an online backup.

> 3) and Trying to recover database using backup control file until canncel. It came up below message

You didn't recover enough .. you need all archive logs between the "ALTER DATABASE BEGIN BACKUP" and the "ALTER DATABASE END BACKUP" command or between the RMAN start and end.

>Now when I say recover database using backup control file until cancel, it is giving error as below

>ORA-00279: change 7516255258615 generated at 12/30/2009 16:49:55 needed for thread 1

>ORA-00289: suggestion : /oracle/EPR/saparch/EPRarch1_4573.dbf

>ORA-00280: change 7516255258615 for thread 1 is in sequence #4573

That is not an error, this is the information that you should provide the archive log with the sequence number 4573 to perform / continue the recovery. If you don't want to recover so far you have to cancel your recovery and open the database with "RESETLOGS".

Again - use the BR*Tools like it is described in the process flow from above and you will be fine.

Regards

Stefan

[Former Member]

Hi Stefan

Last time when you gave me the options for BRTOOLS they are not suitable to our vesion......our version is 640 (51).

Can you Please let me know step by step BRTOOLS options so I will try with that?

Thank-you

[stefan_koehler]

Hello Kasinath,

> Can you Please let me know step by step BRTOOLS options so I will try with that?

I am not pretty sure if your BR*Tools version looks like this .. but give it a try:

http://help.sap.com/saphelp_erp2004/helpdata/en/bc/07503e30a9d549e10000000a114084/content.htm

http://help.sap.com/saphelp_erp2004/helpdata/en/6e/4c37b85dc7f24d88f177396dc45645/content.htm

Regards

Stefan

[Former Member]

Hi Stefan

I just used couple commands and resolved the issue.

I used until cancel command and applied all the archives it was asking and next open reset logs.

Basically, before this message also I did this until cancel command but since files were in compressed status system did not take into.

I uncompressed and applied all the archives and it worked.

Thanks for your response.

[Former Member]

Hi,

Please let me know how will you uncompress .dbf.Z and recovered. I am facing same problem.

OR it will automaticcaly decompress and recover after runing controlfile.

Regards

DK