Restore full backup only

[Former Member]

Hi,

We need to restore a full backup a week ago as audit needs to check access logs that have been deleted.

Just need clarification from all as we aim to do a point in time recovery(PIT) and restore in another server.

First step is that we have run the restore command brrestore -m full -b bekmsq.fnf -u system/******* -c

After restore was completed, we ran the command recover database.

And it has been asking for archivelogs which timestamp were hours after the time that we have identified as PIT.

Can anyone advise us if what we are doing is correct?

Definitely need help.

BRTOOLS version 7.20

Thanks.

Saiful

[Reagan · Accepted solution]

Hello

If you want to recover the database to a point in time the restore all the archived logs until that time.

sqlplus "/as sysdba"

startup mount

recover database until time ‘YYYY-MM-DD:HH:MM:SS’ using backup controlfile;

Regards

RB

[Former Member]

Hi,

You can also check the below note.

602497 - BRRECOVER - New tool for Oracle Restore and Recovery

And the below doc.

This doc will tell you all about it.

BRRECOVER call in the target system:

brrecover -u / -t reset -b last -f NEW -SFR -SRR [-c force]

The special options "-SFR" (skip file restore) and "-SRR" (skip redofile restore) suppress the database data file and archive log file restore that is no longer required.

Comment: Here, you can also use "dbpit" (database point-in-time recovery) instead of the recovery type "reset" (database reset). A consistent online backup (online_cons|oncons_split) is not required in this case. However, the archive log files required for the recovery must be made available on the target system instead (as in the standard procedure).

Important: The BR*Tool special options used here must only be used in the context of the database copies described here.

What you need to be aware of.

434645 - Point-in-time recovery: What must I be aware of?

Thanks

Rishi Abrol