missing backups when trying to restore

[Former Member]

Hey everyone,

We are trying to test our backups / restores on a clone backup system.

We took a backup of the original system using brtools/backed up to netbackup, and in we could see the netbackup utility took the backup well, and the backup was listed as successful in db12.

However, when trying to restore this on the clone system, only 2 backups seem to come up when trying to restore the whole database... both these backups are very old (and ones we did to disk before netbackup backup was setup).

Does anyone know what I could look at (I'm out of ideas) in terms of why BRTOOLS cannot see the backup in netbackup?

Any help at this point would be greatly appriciated.

Thanks

Richard

[uwe_theisinger · Accepted solution]

Hi Richard,

you have to sync the following directories from source to target (clone).

/oracle/SID/sapbackup

/oracle/SID/saparch

you need the detail logs and backSID.log

brtools need this information to restore the backups.

regards

Uwe

[Former Member · Accepted solution]

Thank you so much guys.

The issue was with the backSID.log.. For some reason, they ended up restoring an older copy... and of course I could not see my backup.

Thanks for all the help guys.. appriciate it big time.

Richard

[former_member204746]

backSID.log is needed with brtools or brrecover.

if you use brrestore directly, you do not need that file.

[Former Member]

Hi Richard,

Make sure that u have copied the backup logs available in the SAPBACKUP folder to the target system from the source system.

Regards,

Varadharajan M

[volker_borowski2]

Hi,

and you need to configure netbackup to allow client

"clone system" to access backups from client "production system".

On the client you like to restore issue a

echo #NULL | backint -u SID -p /oracle/SID/102_64/dbs/initSID.utl -f inquire

This should list the items the client sees on the netbackup server.

If you do not see anything, your netbackup cxlient configuration is not yet correct.

After the above works, you can either restore backSID.log or copy it

over from source, if that system is still alive. But if you like to have a desaster test,

you should learn how to restore these items, instead of copying them over for ease of process.

Volker