TDP and SAP for Oracle

[Former Member]

I have installed TDP for SAP Oracle, database files and online redo logs backup fine, the issue is when we get down

to the 'brarchive' process, we get a return code of '1'.

My scenario, we backup our offline redo logs separately, due to size, and how quickly the file system (AIX) fills

up.

So my question, is there a way to disable brbackup from being called by brtools?

[Former Member]

Hi Rajesh,

Thanks for the quick answer... I am trying that now.

Mean while, here is the next question... when I attempt a restore will we be able to tell what redo logs are needed, and will we be able to apply them?

Scenario...

We backup our redo logs (redo1.log, redo2.log, etc) seperately to say another file ssytem and move them out

of their /oraarch/ file system (we are on AIX).

Now we backup our database without the use or brarchive, and the database files and the online redo logs

backup successfully.

Time for restore....

Will we be able to restore the Database, and then apply the offline logs separately that were not backed up

with bracrhive?

Thanks

Edited by: josley on Jan 28, 2010 3:30 PM

[Former Member]

Hi,

You can try using different backup profile for database and archive log backup.

in database backup profile, comment the following parameters..

archive_function = copy_delete_save
archive_copy_dir = /oracle/<SID>/sapbackup
archive_stage_dir = /oracle/<SID>/sapbackup

When you schedule the job, use only "Offilne/Online backup" (without redo logs...)

It should work...

Regards.

Rajesh Narkhede