Procedure for database backup using db13 Tcode

[Former Member]

Hi

i have a ECC 6.0 R/3 system with oracle as database on Linux.Can any one tell the procedure how to take backup using db13 Tcode.What are the prerequisites i have to follow to have a successful backup?Complete information is appreciated.

Regards

ganesh reddy

[Former Member]

Hi,

I am Sagar Bhattacharya form kolkata, a new user of this community.

I am not finding out the option from where I can post my queries in this forums. Hence I am reply this question.

I am also faceing the backup related problem using CA- BrightStore ArcServe 11.5 . My SAP database is running on windows 2003 R2 64 bit,SAP ECC 6.0 and oracle 10g 64 bit.

please help me how to take backup of SAP database using CA- Brightstore ArcServe R11.5 .

I also dont know RMAN is configured or not.

Thanks

Sagar Bhattacharya

09830570600

[Former Member]

Hi Sridhar,

r u able to connect to ur database thru system user???

Log in as ora<sid> user.

and try conn system/<password>@<SID>

is it successful??

Regds,

Mofizur

[Former Member]

Hi,

Am not very much familar with linux env.

If u want to take bkup in DB13

execute the tcode db13 this takes u to the dba planning calender.

There will be blocks for different dates. Select one line from the the block belonging to the current day.

Double click in one of the rows.

It gives an window "schedule an action "

Select one action ie database bkup or Archive log bkup etc and if u want to start it immediately click the start immediately button otherwise if u want to schedule for a later time, put the time in the "Start Time" box and click enter.

If u want to take backup via brtools then

execute BRTOOLS in cmd prompt.

Select 4 - Backup and database copy

Then in the next menu select

1 = Database backup or

2 - Archivelog backup

Follow the guided instructions.

There are several interfaces through which you can start or schedule a database

backup or an offline redo log backup. But in all cases the BRBACKUP or BRARCHIVE are started

These two tools always log backup actions in database tables SDBAH and SDBAD, as well as in their

own summary log.

For tape administration,BRBACKUP determines the required tapes from tables SDBAH and SDBAD,

while BRARCHIVE does so on the basis of its summary log.

BRBACKUP and BRARCHIVE read values of configuration

parameters from the BR*Tools profile init<DBSID>.sap. Values found there

override default values set in the code. If u specify parameter values at

command line, or in a menu, then they have the highest priority.

A specific choice of parameter value for a BRBACKUP/BRARCHIVE run does

not modify the value in the profile.

To change a parameter value in the profile, you must use an operating system editor.

There is no SAP transaction for the maintenance of this profile.

Customizing SAP Backup and Restore Tools:

The configuration (initialization) profile init<DBSID>.sap contains

parameters that determine how BR*Tools (BRBACKUP, BRARCHIVE,

BRRESTORE, and so on) perform various functions. It is usually stored in

directory $ORACLE_HOME/dbs in UNIX

or

%ORACLE_HOME%\database in case of Windows.

To configure the behavior of the SAP tools, you can edit the profile with a

text editor.

If you then start a tool without command options, the values in the

initialization profile are used.

If a parameter value is not specified in the profile,

the SAP tool uses the default value for the parameter.

If you use BRBACKUP or BRARCHIVE with command options, these override

the corresponding values in the initialization profile.

The following some important parameters for configuring BRBACKUP

and BRARCHIVE:

backup_mode

backup_type

online or offline backup.

backup_dev_type

the backup medium you want to use, such as tape or disk,

tape_copy_cmd

the copy command to be used to copy files from disk to tape like cpio, dd, rman, etc.

expir_period and tape_use_count

Parameters expir_period and tape_use_count are used for tape

management and specify the retention period and the recommended

maximum number of times to which a volume can be written.

volume_backup and volume_archive

Parameter volume_backup provides names of volumes to be used for

backups created with BRBACKUP and volume_archive

provides names of volumes to be used redo log files

tape_address*

Values of tape_address and tape_address_rew identify device

addresses of tape devices

Try this it may help.

All the best

[Former Member]

Hi manas Pattnaik,

This is sridhar, i used the DBA planning calender for backup,

there i used the backup device as disk to store the backup in the

local system D:\BACKUPORA(drive). I changed the init<SID>.sap even though

it giving the following error in JOB log

-> job started

->step 001 started (program RSDBAJOB,variant &0000000000000004,user ID SAP*)

->Execute logical command BRBACKUP on host SAPSER4

->parameter : -u / -jid ALL__20080111112744 -c force -t online -m all -p initNw.sap

-w use_dbv -v D:\BACKUPORA

->SXPG_COMMAND_EXECUTE failed for BACKUP - Reason:X_error

->job cancelled after system exception ERROR_MESSAGE

Instead of DBA planning calender i used the DB13 transaction for backup

using the same disk address as backup media then it giving the following error

C:\usr\sap\NW\DVEBMGS00\exe>brbackup -u -c force -d disk -t online -p initNW.sap

BR0051I BRBACKUP 7.00 (18)

BR0262I Enter database user name[/password]:

SYSTEM

BR0263I Enter password for database user 'SYSTEM' (maximum 30 characters):

BR0055I Start of database backup: bdwzxikt.and 2008-01-10 19.02.15

BR0280I BRBACKUP time stamp: 2008-01-10 19.02.27

BR0301E SQL error -12737 at location BrDbConnect-2, SQL statement:

'CONNECT SYSTEM/*********'

ORA-12737: Instant Client Light: unsupported server character set (null)

BR0310E Connect to database instance NW failed

BR0280I BRBACKUP time stamp: 2008-01-10 19.02.28

BR0301E SQL error -12737 at location BrDbConnect-2, SQL statement:

'CONNECT SYSTEM/*********'

ORA-12737: Instant Client Light: unsupported server character set (null)

BR0310E Connect to database instance NW failed

BR0056I End of database backup: bdwzxikt.and 2008-01-10 19.02.27

BR0280I BRBACKUP time stamp: 2008-01-10 19.02.28

BR0054I BRBACKUP terminated with errors

can you please see and solve this problem. I saw your answer in one thread that is very good answer .

That's why i selected you to send this problem.

Thanks & Regards,

Sridhar M

[fidel_vales]

Lets see

- you are using windows

- You get the error "ORA-12737"

Next step are:

- go to the upper left corner in this forum. There is a box labeled "search"

- Type ORA-12737

- below you select "SAP Support Notes"

- Hit the button "go"

- You find two notes

SAP Note 998399 Changing the Oracle Instance Client from Lite to Full

SAP Note 808505 Secondary connection to Oracle DB w/ different character set

You read them. to save you a little work, the first one is the good one for you

You are welcome

[Former Member]

Hi,

Check this link. It will be useful for your problem.

http://help.sap.com/saphelp_erp2005vp/helpdata/en/df/455e12747111d6b25100508b6b8a93/frameset.htm

Regards

Jaya Ganesh

[Former Member]

Hi,

Can we take backup using third party tool like Openview...if yes? Plz tell me the procedure od any SAP Note to perform this..

regards,

amit

[Former Member]

Hi Ganesh

First thing r u planning to backup u r database using brtools or third party tool

if you give more details then it will good to explain

Cheers

Paresh

[Former Member]

HI

i would like to take backup using brtools.

[Former Member]

Hi Ganesh,

justt update all the details in initSID.sap file and schedule the backup form db13

Cheers

Paresh