Backup restore on DR

[Former Member]

Hello,

While restoring tape backup on DR we did following procedure:

1> copied latest files .aft and backSID.log to DR in sapbackup dir.

2> brrestore -m full -b latest filename.aft

Can somebody help me identifying the significance of .aft and .log files.

Thanks .

Regards,

Tushar

[Former Member · Accepted solution]

Hello Eric,

Thanks a lot for your help.

But is there a way to restore in multiple drives due space constraint.

Regards,

Tushar

[former_member204746 · Accepted solution]

you can restore individual datafiles one by one and then place them where you want.

if you can handle downtime, you can also copy files over the network to your new machine and place them where you want, then manipulate the controlfile to use the new paths.

[Former Member]

Hi Eric,

Thanks a lot for your help.

Regards,

Tushar

[Former Member]

we are trying to do the same however we cannot apply the archive logs.

we have copied over the following directories to the dr site.

/oracle/EP1/sapcheck/

/oracle/EP1/sapreorg/

/oracle/EP1/saparch/

/oracle/EP1/sapbackup/

we are encountering an error that says:

BR0439E No offline redo log files found in /oracle/EP1/saparch/archEP1.log for processing for device type TAPE/BACKINT/RMAN

we are using netbackup 6.0

[Former Member]

Hello Eric,

Backup has been taken by brbackup.( no third party tool )

Source:

E: origlogA, OriglogB

F: mirrorlogA,MirrorlogB, SAPDATA1..

Target :

E: SAPDATA1...

F : OriglogA,OriglogB,MirrorlogA,MirrorlogB

command used :

brrestore -m full -b bdvwowyd.afd -d disk -c

Thanks

Regards,

Tushar

[former_member204746]

Ok, I would temporarily change drive letters E and F so taht E is F... and F is E:.

then create mirrorlogA,MirrorlogB on E:

restore

then move back mirrorlogA,MirrorlogB

then rename E and F.

good luck!

[Former Member]

Hello Eric and All,

We have taken offline database backup and now we want to restore it on another

database ( Homogeneous system copy )

I have copied filename.afd and backSID.log to target system's sapbackup dir.

Now my query is which parameters I have to change in filename.afd file to meet target system's file structure.

Thanks in advance.

Regards,

Tushar

[former_member204746]

change this file contents is not a good idea and may not work.

Have you used a third party program such as netbackup or TSM to backup? If so, they have interfaces to restore files individually and you can use an alternate path to restore without using BRRESTORE.

what are your sources path and destination paths? if only the SID changed in the paths, then you do not need to play around with your backups files, but simply temporarily rename /oracle/SID to the source SID.

[former_member204746]

AFT file contains the log for your offline backup. brrestore uses that file to start the restore.

backSID.log contains thje list of all backups made. it is only used by SAPDBA BRRECOVER and BRTOOLS. if you use BRRESTORE, you do not need it.

[Former Member]

hi

while backup take place the entire thing i stored in .aft file so while restoring we are using this file .The detail log displayed in DB13 for backup is from this .aft file

So this file is required for restoration