cancel
Showing results for 
Search instead for 
Did you mean: 

Redo log backup

Former Member
0 Kudos

Hi,

I´ve the next doubt about the archive logs of oracle.

The task of db13 redo log backup makes the backup of the archive logs and after the backup erase the archive logs of the directory?

More thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

that depend upon the option you selected in initSID.sap file which is available in \oracle\SID\102\database folder. if your database is oracle 10g.

if you select archive_function = save_delete it takes backup and delete the file.

if you select archive_function = save only it takes backup and it don't delete the file.

Former Member
0 Kudos

Thanks,

If I edit the initsid.sap, i´ve to restart the oracle database to take effect?

Former Member
0 Kudos

yes

Former Member
0 Kudos

I´ve modify the parameters:

backup_dev_type = disk

and archive... = save_delete

I´ve restarted the service OracleServiceR3D and I can´t see the change, in the DB13 indicates the tape name on every task to schedule not disk.

Former Member
0 Kudos

you have to restart database not service. follow the below steps.

1. login with sidadm in to OS level

1. go to command prompt:

2. execute below command.

sqlplus "/as sysdba"

3. execute below command

shutdown immediate;

after this command

4. execute below command

startup;

before you do above changes you need to stop the SAP application.

volker_borowski2
Active Contributor
0 Kudos

> Thanks,

>

> If I edit the initsid.sap, i´ve to restart the oracle database to take effect?

Surely NOT !

initSID.sap is a SAP configuration file, which gets no inspection from Oracle at all.

As far as DB13 is concerned, leave the tape volume field empty, that's it.

Volker

former_member204746
Active Contributor
0 Kudos

you DO NOT need to restart Oracle after modifying init[SID].sap

Former Member
0 Kudos

Sorry, it will be backup_root_dir = E:\oracle\SID\sapbackup ,no?

How can to define the path for to do the backup? Which is the parameter?

More thanks

Edited by: Ruben Torres on Jan 27, 2011 12:57 PM

former_member204746
Active Contributor
0 Kudos

you are changing the wrong parameter.

you need to adapt init[SID].sap file. it located in the same place as init[SID].ora

but, as a default behaviour, SAP will backup redologs, then on the next run, it will delete them. .. especially if you go through DB13...

Answers (0)