on 08-10-2013 4:14 AM
Hi
I was trying to take online backup of production server and face below problem. Please help
BR0051I BRBACKUP 7.00 (20)
BR0055I Start of database backup: belvilvc.ant 2013-08-10 08.25.28
BR0484I BRBACKUP log file: /oracle/JMP/sapbackup/belvilvc.ant
BR0477I Oracle pfile /oracle/JMP/102_64/dbs/initJMP.ora created from spfile /oracle/JMP/102_64/dbs/spfileJMP.ora
BR0280I BRBACKUP time stamp: 2013-08-10 08.25.30
BR0301E SQL error -1587 at location BrCtlCopy-1, SQL statement:
'/* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/JMP/sapbackup/cntrlJMP.dbf''
ORA-01587: error during control file backup file copy
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
HPUX-ia64 Error: 2: No such file or directory
Additional information: 4
Additional information: 3
Additional information: 112640
BR0320E Copying of control file to /oracle/JMP/sapbackup/cntrlJMP.dbf failed
BR0314E Collection of information on database files failed
BR0056I End of database backup: belvilvc.ant 2013-08-10 08.25.30
BR0280I BRBACKUP time stamp: 2013-08-10 08.25.30
BR0054I BRBACKUP terminated with errors
Hello Chandan,
The command used there from BRBACKUP could be tested from sqlplus as well :
sqlplus "/ as sysoper"
alter database backup controlfile to '<path>/<filename>';
exit;
You can try to use different filesystems to create the copy of controlfile. It really looks lik the current file system path "/oracle/JMP/sapbackup" is having the problem. Please try a different location and check.
I guess, it's either a filesystem privilegies issue or the owner of Oracle or BR* executables is not correctly set Please check SAP notes #113747 and #583861.
Regards,
Arun.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chandan Singh,
for async I/O, set the parameter to FILESYSTEMIO_OPTIONS = ASYNCH in initSID.ora file.
Take oracle restart and check the results.
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chandan,
Please check
http://scn.sap.com/thread/706669
http://scn.sap.com/thread/1930579
https://forums.oracle.com/thread/2231104
And please provide more information about this.
BR
Atul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chandan,
May i know what type of backup that you are using??
if you are using Tivoli Storage Manager backup
thoroughly check the parameter backup_root_dir in file init<sid>.sap file.
and if you are using the RMAN backup
kindly go through the last 2 pages of the following link
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmvalid.htm
Regards,
Sandeep.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.