Actions to be performed after a online backup restore

[former_member463397]

Hello Guru's,

I have an online backup of a system.

(AIX - ORACLE)

If I restore the backup using Tivoli Storage Manager I still have to perform some actions to recover the database.

I have read through the SAP documentation and it seems I can restore the logs using brtools (brrecover).

My questions actually is, which option do I have to take if I want to apply the offline archive logs as far as possible ?

"Complete database recovery" of "database point in time recovery" ?

I want to make sure that only the archivelogs are being applied and that the database restore is not peformed again.

Thank you all !

bye

BUD

[Former Member]

Hi,

Please let me know how to configure TSM,TDP in sap landscape.

Any docs, or link would be helpful.

Thanks in adavance

[fidel_vales]

Hi Hans,

I'd recommend you to take a look at the SAP documentation about it: [Restore and Recovery|http://help.sap.com/saphelp_nw70/helpdata/en/65/cade3bd0c8545ee10000000a114084/content.htm]

If you performed the backup with BR* tools (BRBACKUP) I'd recommend you to use the menu driven BRTOOLS to perform the restore and recovery as it will "find out" the details for wat you want.

[stefan_koehler]

Hello Hans,

> and it seems I can restore the logs using brtools (brrecover).

If you only want to restore your archivelogs, then use brrestore.

brrecover is for recovering the database, not for restoring.

Take a look at here:

http://help.sap.com/saphelp_nw04/helpdata/en/88/cadaca94734ae5b8ea3491f615741b/content.htm

and here:

http://help.sap.com/saphelp_nw04/helpdata/en/0d/d3077b4a0c11d182b80000e829fbfe/content.htm

> My questions actually is, which option do I have to take if I want to apply the offline archive logs as far as possible ?

> "Complete database recovery" of "database point in time recovery" ?

In this case you have to do an incomplete database recovery or in other words called "point in time recovery". For the difference between these two restore types take a look at the oracle documentation:

http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14192/intro004.htm#i1016863

After you have restored your archive logs you can perform the recovery manually:

> SQL> recover database using backup controlfile until cancel;

> SQL> cancel;

> SQL> alter database open resetlogs;

Btw.as you are using TDP for SAP you can use backfm to restore only some several files.

Regards

Stefan