backing up database

[Former Member]

hai experts,

any boby tell me the command to take the back up in oracle database.plzhelp me.

[Former Member · Accepted solution]

Hello Raj,

1. You can use brtools to take the oracle db backup.

2. You can schedule the oracle backup from db13 (if getway has been install in your SAP system).

3. The command that you may use to take online backup is

brbackup -u / -c force -t online -m all -p initSID.sap -a -c force -p initSID.sap -cds

(This command will ask userid & password where you have to give system as user id and it's password.)

Best wishes...

Sovon Sengupta

[Former Member · Accepted solution]

hi sovon,

i want the commands for back up.plz help me.

[former_member204746 · Accepted solution]

he gave you the command:

brbackup -u / -c force -t online -m all -p initSID.sap -a -c force -p initSID.sap -cds

personally, I would use:

brbackup -u / -c force -t online_cons -m all -p initSID.sap

[Former Member · Accepted solution]

all command you can find here:

http://help.sap.com/saphelp_nw70/helpdata/EN/c7/c90e6b7cfd44309bd90b2b7a8a89fd/content.htm

[sebastian_sebaraj]

You can use Newly released BR*Tools Studio also

[former_member204746]

BR*Tools studio is pretty buggy right now, I would wait a bit before implementing this on a prod system.

[sebastian_sebaraj]

pugazh

It is all depend upon what type of Backup you want to take.

I could help you if you could answer the following questions.

1. Do you want to take backup of Oracle DB directly to Tape or to Disk first and then to Tape.

2. What Software is used to manage backups in the Tape?

3. You can use SAP Backup Tools or Oracle Bcakup Tools like RMAN, What do you want to use?

I will answer more specific as soon as you answer the above

[Former Member]

Hi,

This could help you,

conn /as sysdba

alter database backup control to trace;

copy the control file, datfile and redolog file from o/s level to safe destination.

and the trace will be generated in udump. Check the parameter for the destination of udump.

user_dump_destination='/disk1/oradata/mega/udump'

Regards

Iliyas