restore offline redolog

[Former Member]

Dear Team,

I have full restore my offline backup .via command sql> nohup brrestore -c force -b bebxjokq.aft -m full &

After restoration my SAP Server is working perfectelly.

But now I want to restore offline redo log in my server that was generate after full offline backup.

How I restore offline redo log backup in this server .

kavi

[Former Member · Accepted solution]

Hi,

In case you have taken the backup of archive log and restored the log files from that tape, use the following command to extract the archive files.

Brrestore u2013a <log_seq_no_A>-<Log_seq_no_B>

NOTE : <log_seq_no_A> stands as u201CCurrent Log Sequenceu201D in the header of the detail BRBACKUP log (<filename>.svd> recovered from brarchive TAPE.

<log_seq_no_B> stands as u201CTarget Log Sequence nou201D from archPRO.log

*i assume that you are restoring offline redologs seperately, means you haven't taken offline+redologs.

If you have taken offline+redologs, then you can restore both with one go

brrestore -b filename(offline backup log file) -m full

Regards

Nick Loy

[lbreddemann]

> I have full restore my offline backup .via command sql> nohup brrestore -c force -b bebxjokq.aft -m full &

> After restoration my SAP Server is working perfectelly.

Why is does nobody seem to understand that it's not necessary to manually trigger the restore of data files and the restore of archive log backups to finally use sqlplus to recover the database?

Instead you should just use BRRECOVER.

BRRECOVER will automatically figure out:

- what data files need recovery

- what data files need to be restored from what backup

- what archive log files are required

It will also:

- call BRRESTORE to perform the restore actions

- recover and open the database right away.

- choose the optimal strategy for the whole recovery

Using BRRECOVER will also prevent a premature opening of the database.

just my 2 cent.

Lars

[former_member204746]

use the same strategy and use nohup with brrestore... but with option -a

nohup brrestore -c force -a axxxxxxx.cds &

file axxxxxxx.cds should be found in /oracle/SID/saparch

[Former Member]

my offline redo log backup in my tape.

I have checked in other server archive log via db13

Redo log start from PRDarch1_28090_637623713.dbf to PRDarch1_28150_637623713.dbf

How I restore these archive log from tape to new server.

and How I can see the redo log in tape . I am using HP Unix.

What command to see the content in tape

Kavi

[Former Member]

Hello,

After the restore of your off line backup did you open your database in resetlogs mode ?

I suppose so because otherwise you were not able to start SAP.

If this is the case I'm afraid you can no longer apply your off line redologs, because you can not recover a database that was opened with resetlogs (because new redologs are already created and your database has evolved).

Wim Van den Wyngaert