cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to backup database using RMAN to disk.

Former Member
0 Kudos

Hello there,

We are trying to setup database backup using RMAN to local disk. Unfortunately, backup doesn't work as expected. Moreover, despit the setting of all RMAN parameters, BRBACKUP doesn't use RMAN.

Any help?

Regards.

PS: We use Oracle 10gR2 (10.2.0.4)

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Mourad,

in order to get some help, you should first provide a bit more of information. Nobody here can know what you mean by backup doesn't work as expected.

Please help us to help you!

For example.

Are there any error messages?

What exactly does happen when you start brbackup?

Posting a relevant part of brbackup log file may be helpful.

Your operating system?

How to you start brbackup? DB13 or command line?

regards

Former Member
0 Kudos

Hi Joe,

"Backup doesn't work as expected" means that RMAN isn't used. There are no error messages. The server is a Linux box Rehat 5.

How to you start brbackup? DB13 or command line? Both.

Thanks for your help.

Former Member
0 Kudos

Then let me repeat:

Posting a relevant part of brbackup log file may be helpful.

There is a log file, isn't it?

Look in /oracle/<SID>/sapbackup.

stefan_koehler
Active Contributor
0 Kudos

Hello Mourad,

did you perform the steps that are mentioned in the documentation (RMAN Backups Without Backup Library)?

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/3f/9d800e1aec11d2b42c00609419997a/content.htm

Regards

Stefan

Former Member
0 Kudos

Hello Stephan,

Yes. Below parameters we set in init<SID>.sap :

backup_dev_type = disk

disk_copy_cmd = rman

Regards.

stefan_koehler
Active Contributor
0 Kudos

Hello Mourad,

and how do you call brbackup? Which options do you use?

The easiest way is to post what you have done .. so we can see it.

Regards

Stefan

Former Member
0 Kudos

Hi,

I admit, I'm not a SAP Specialist. We've retried this morning, and analyzed logs, I confirm that backup using RMAN utility works fine. I was misleaded by the fact that brbackup makes backup datafile file by data file. However, starting backup through scheduler doesn't work.

BR0280I BRBACKUP time stamp: 2009-03-18 10.38.37

BR0057I Backup of database: CQA

BR0058I BRBACKUP action ID: beadtbru

BR0059I BRBACKUP function ID: fnd

BR0110I Backup mode: FULL

BR0077I Database file for backup: /oracle/CQA/sapbackup/cntrlCQA.dbf

BR0061I 28 files found for backup, total size 84462.477 MB

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: /backup/beadtbru

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

BR0370I Directory /backup/beadtbru created

BR0278E Command output of 'SHELL=/bin/sh /oracle/CQA/102_64/bin/rman nocatalog':

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Mar 18 10:38:37 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>

RMAN> connect target *

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-01031: insufficient privileges

RMAN> *end-of-file*

RMAN>

host command complete

RMAN>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of configure command at 03/18/2009 10:38:37

RMAN-06171: not connected to target database

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2009-03-18 10.38.37

BR0279E Return code from 'SHELL=/bin/sh /oracle/CQA/102_64/bin/rman nocatalog': 1

BR0536E RMAN call for database instance CQA failed

BR0280I BRBACKUP time stamp: 2009-03-18 10.38.37

BR0056I End of database backup: beadtbru.fnd 2009-03-18 10.38.37

BR0280I BRBACKUP time stamp: 2009-03-18 10.38.37

BR0054I BRBACKUP terminated with errors

This means that OS user launching rman is not a privileged (not a sysdba) user.

Any idea?

Thanks for your help.

Regards.

stefan_koehler
Active Contributor
0 Kudos

Hello Mourad,

have you already checked sapnote #148535?

Regards

Stefan

Former Member
0 Kudos

Hi Stephan,

Yes, already checked :

Below groups command output for user cqaadm :

sapsys sapinst dba oper

Regards.

stefan_koehler
Active Contributor
0 Kudos

Hello Mourad,

sorry i missed the information that you are using a linux server (Redhat). So i think you hit the problem that is described in sapnote #776505.

Please let me know, if i am correct.

Regards

Stefan

former_member220071
Active Participant
0 Kudos

Hi ,

>ORA-01031: insufficient privileges

Your issue is look like the user from which you taking having no sufficient access.

1 You can create a password file using the password file creation utility, ORAPWD.

2 Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to

EXCLUSIVE

Abhijeet

Former Member
0 Kudos

Hi,

We added ora<sid> as dba group member which fixed our issue. Every things wok fine.

Thanks

Answers (0)