db backup failure with DB13 for whole database offline backup

[Former Member]

Dear experts,

I found a problem after using DB13 for whole database offline backup,it prompt the following error information :

BR0143I Backup type: offline_force

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

BR0289I BRARCHIVE will be started at the end of processing

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRBACKUP time stamp: 2008-09-06 22.03.32

BR0307I Shutting down database instance DEV ...

BR0278E Command output of '/sapdev/oracle/DEV/102_64/bin/sqlplus':

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 6 22:03:33 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> Connected.

SQL> csh: The file access permissions do not allow the specified action.

SQL> ORA-01013: user requested cancel of current operation

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

BR0280I BRBACKUP time stamp: 2008-09-06 23.03.40

BR0279E Return code from '/sapdev/oracle/DEV/102_64/bin/sqlplus': 0

BR0302E SQLPLUS call for database instance DEV failed

BR0309E Shutdown of database instance DEV failed

BR0056I End of database backup: bdythfth.aff 2008-09-06 23.03.40

BR0280I BRBACKUP time stamp: 2008-09-06 23.03.40

BR0054I BRBACKUP terminated with errors

i have checked the file mode in the directory of sapbackup and it seem no problem.please help me to analyze it,thanks.

[Former Member]

Dear fans,

thanks for your help,I find a way to resolve this problem by sap message,it refer to the following notes:

113747 Permissions for DBA tools BR*Tools and SAPDBA

651351 BR tools on UNIX: Error due to executable permissions

[Former Member]

Hi Radhakrishna D S,

Thanks for your reply.I think the emphasis about this problem is "csh: The file access permissions do not allow the specified action".Because of no access permissions,so the following steps can't continue do it.i direct use BRBACKUP in the BRTOOLS to backup database and it is successful.

[former_member182034]

Hi Zhiyong,

if you don't mind .... could you tell me the procedure of taking backup with BRBACKUP in BRTOOLS...

regards,

majamil

[former_member227600]

Hi,

If you are using oracle database than you can take backup using brtools(online or offline). login as user <sid>adm & run brtools command at command prompt.Than you will get a menu driven screen .

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

select option 4(Backup & database copy)

than you get the following screen

Backup and database copy

1 = Database backup

2 - Archivelog backup

3 - Database copy

4 - Non-database backup

5 - Backup of database disk backup

6 - Verification of database backup

7 - Verification of archivelog backup

8 - Additional functions

9 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

select 8(Additional functions)

you get the following screen

Additional functions for backup and copy

1 = Update of compression rates

2 - Preparation of RMAN backups

3 - Deletion of database disk backups

4 - Deletion of archivelog disk backups

5 - Controlling of BRARCHIVE run

6 - Initialization of BRBACKUP tape volumes

7 - Initialization of BRARCHIVE tape volumes

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

select option 6(Initialization of BRBACKUP tape volumes)

than u get the following screen

Options for initialization of BRBACKUP tape volumes

1 - BRBACKUP profile (profile) ....... http://initPRD.sap

2 - Initialization type (initialize) . rename

3 ~ Number of volumes (number) ....... []

4 - Confirmation mode (confirm) ...... yes

5 - Message language (language) ...... [E]

6 ~ Tape volume names (volume) ....... PRDB01

7 - BRBACKUP command line (command) .. http://-p initPRD.sap -i -l E -v PRDB01

choose option 2 & put force & enter

than choose 6 give tape name which one you define in init<sid>.sap file

than press "c"

press "c" to initialize the tape

After that go back to main menu

Backup and database copy

1 = Database backup

2 - Archivelog backup

3 - Database copy

4 - Non-database backup

5 - Backup of database disk backup

6 - Verification of database backup

7 - Verification of archivelog backup

8 - Additional functions

9 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

chose option 1

BRBACKUP main options for backup and database copy

1 - BRBACKUP profile (profile) ....... http://initPRD.sap

2 - Backup device type (device) ...... tape

3 ~ Tape volumes for backup (volume) . []

4 # BACKINT/Mount profile (parfile) .. []

5 - Database user/password (user) .... [/]

6 - Backup type (type) ............... offline_force

7 - Disk backup for backup (backup) .. no

8 # Delete disk backup (delete) ...... no

9 ~ Files for backup (mode) .......... all

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

chose option 3

give the tape volume name (Ex -PRDB01)

tahn c & c&c &c backup will start

Let me know If you have any query related to backup.

Karan

[Former Member]

Hi,

just check out the SNote 618861. It says

" 1. If you terminate the explicit or implicit execution of an SQL statement in tools such as SVRMGRL, SQLPLUS, SAPDBA, BRBACKUP, BRARCHIVE, BRCONNECT, BRRESTORE or BRRECOVER with CTRL+C, the system logs an ORA-01013 error. This behavior is normal and not an error."

I hope this will help you to drill your ptoblem.

Even instance DEV is not shutting properly.

-

---

BR0280I BRBACKUP time stamp: 2008-09-06 23.03.40

BR0279E Return code from '/sapdev/oracle/DEV/102_64/bin/sqlplus': 0

BR0302E SQLPLUS call for database instance DEV failed

BR0309E Shutdown of database instance DEV failed

Hence need to shut the dev instance and take a backup.

Rgds

Radhakrishna D S

Edited by: Radhakrishna D S on Sep 8, 2008 7:06 AM