cancel
Showing results for 
Search instead for 
Did you mean: 

BRRESTORE does not restore online redo log files

pr_srinivas
Contributor
0 Kudos

on a system crash,

we restored yesterday night online backup , but it does not have online redo log files?

All data files, Control & we have all archive logs.

How to go forwards

Rgds

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Srini...

You will be able to recover data till the last archive log file which was created . The data which was in online redo log file just before the crash either will be recovered automatically on database startup ( The Transaction if incomeplete will be rolled back ) .

Thanks

Aashish

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Srinivas,

The online backup doesn't backs up the online redo logs as Stefan already mentioned. Also, it doesn't backs up the tempfiles.

As you already mentioned, you have the archive logs backed up. So it shouldn't be a problem. You can restore your database, recover it starting from the start time of the backup being used for restoration till the last archive log backed up. Afterwards, perform a ALTER DATABASE OPEN RESETLOGS;

This should help you get back the crashed DB in a consistent state. Also, don't forget to create your tempfiles later.

Regards,

Deoraj Alok.

stefan_koehler
Active Contributor
0 Kudos

Hello,

> we restored yesterday night online backup , but it does not have online redo log files?

That is a normal behaviour.

The online redolog files are never backuped, because they would be inconsistent by an online backup.

The online redolog files are automatically created by an "ALTER DATABASE OPEN RESETLOGS".

If you want to perform a complete recovery you will need the online redolog files from your crashed system.

If the online redolog files are lost, recover your database as far as possible (available archived logs) and perform an open resetlogs.

Regards

Stefan

lbreddemann
Active Contributor
0 Kudos

Hi there,

you may want to use BRRECOVER instead. It will determine which archive logs need to be restored and trigger BRRESTORE appropriately.

regards,

Lars

BTW: there's this funny thing called documentation [http://help.sap.com] ...