system copy with oracle online backup without BR tools

[Former Member]

All,

ECC 6.0 with oracle on suse linux here. I am trying to refresh my QA system with Production database (11g) using backup/restore method. I will be using a online backup of my production database. I have read guides and forum posts about using the backups generated with brtools etc and using control.sql file etc but my scenario is that we do not use brtools for backups. We take oracle backups using commvault and that is managed by a different team.

How should i tell them to restore the Prod database from their backups ?? do they just need to restore the data files and log files to the target system and then I create and modify the control file and use that control file to restore my DB  OR do they also need to restore the DB for me after putting the data files and log files in place ? i am a little confused as I do not use brtools for backup/restore.

Thanks

BV

[Former Member]

Hi,

First check, what are covered in your backup rotation and which files it can restore?

If it restore all sapdata files, then it is same as your brtools restore.

*You need sapdata files in your target file systems to start your post restore steps.

Regards,

Nick Loy

[former_member188883]

Hi,

Can you share which backup tool you have ? Based on the tools suggestions can be made.

Regards,

Deepak Kori

[Reagan]

Hello

BRTools is an SAP provided tool for Oracle database administration for SAP systems running on Oracle database.

To restore the database in the way you want by using tools provided by the backup vendor or in the Oracle specific way.

If you know how to restore a database without using BRTools then you mau use that method.

Once you have restored the database then you will need to recover the database as you are using an online backup.

You can do all these things without using BRTools.

Regards

RB