on 03-17-2009 2:04 PM
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.