Oracle BACKUP failed.
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Oracle BACKUP failed.

  1. #1
    Join Date
    Apr 2008
    Posts
    6

    Oracle BACKUP failed.

    Hello.
    I have Oracle DB 10.0.2 on OS Sles 10
    I make every day backup on type drive. But from yestarday the archive is failed. I was only restart the DB. I not change the permissions, not install new software,patches, updates and etc.. I read many manuals for this error but cant find the reason.
    Here I paste the error.


    Thanks for all!!!
    -------------------------------------------------------------------

    24.04.2008 10:10:49 BR0317I 'Alter tablespace SYSTEM end backup'
    successful
    24.04.2008 10:10:49
    24.04.2008 10:10:49 BR0280I BRBACKUP time stamp: 2008-04-24 10.10.36
    24.04.2008 10:10:49 BR0530I Cataloging backups of all database
    files...
    24.04.2008 10:10:49 BR0278E Command output of 'SHELL=/bin/sh
    /oracle/BLP/102_32/bin/rman nocatalog':
    24.04.2008 10:10:49 Copyright (c) 1982, 2005, Oracle. All rights
    reserved.
    24.04.2008 10:10:49 RMAN>
    24.04.2008 10:10:49 RMAN> connect target *
    24.04.2008 10:10:49 connected to target database: BLP (DBID=73553200)
    24.04.2008 10:10:49 using target database control file instead of
    recovery catalog
    24.04.2008 10:10:49 RMAN> **end-of-file**
    24.04.2008 10:10:49 RMAN>
    24.04.2008 10:10:49 host command complete
    24.04.2008 10:10:49
    24.04.2008 10:10:49 RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
    14>15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31>
    32> 33> 34
    24.04.2008 10:10:49 RMAN-00571:
    ===========================================================
    24.04.2008 10:10:49 RMAN-00569: =============== ERROR MESSAGE
    STACK FOLLOWS ===============
    24.04.2008 10:10:49 RMAN-00571:
    ===========================================================
    24.04.2008 10:10:49 RMAN-03009: failure of catalog command on
    defaultchannel at 04/24/2008 10:10:39
    24.04.2008 10:10:49 ORA-19564: error occurred writing 8192 bytes
    at block number 1
    24.04.2008 10:10:49 ORA-27091: unable to queue I/O
    24.04.2008 10:10:49 ORA-27041: unable to open file
    24.04.2008 10:10:49 Linux Error: 13: Permission denied
    24.04.2008 10:10:49 Additional information: 3
    24.04.2008 10:10:49
    24.04.2008 10:10:49 RMAN>
    24.04.2008 10:10:49
    24.04.2008 10:10:49 Recovery Manager complete.
    24.04.2008 10:10:49 BR0280I BRBACKUP time stamp: 2008-04-24 10.10.39
    24.04.2008 10:10:49 BR0279E Return code from 'SHELL=/bin/sh
    /oracle/BLP/102_32/bin/rman nocatalog': 1
    24.04.2008 10:10:49 BR0536E RMAN call for database instance BLP failed
    24.04.2008 10:10:49
    24.04.2008 10:10:49 BR0280I BRBACKUP time stamp: 2008-04-24 10.10.39
    24.04.2008 10:10:49 BR0532E Cataloging backups of all database
    files failed
    24.04.2008 10:10:49
    24.04.2008 10:10:49 BR0056I End of database backup: bdxtrtem.fnt
    2008-04-24 10.10.39
    24.04.2008 10:10:49 BR0280I BRBACKUP time stamp: 2008-04-24 10.10.49
    24.04.2008 10:10:49 BR0054I BRBACKUP terminated with errors
    24.04.2008 10:10:49 External program terminated with exit code 5
    24.04.2008 10:10:49 BRBACKUP returned error status E

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480

    Talking

    Check permissions on directories your channels are formatted to:


    Linux Error: 13: Permission denied
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Apr 2008
    Posts
    6
    Where are this channels ?
    Thanks a lot :-)
    "I make every day backup on type drive. But from yestarday the archive is failed. I was only restart the DB. I not change the permissions, not install new software,patches, updates and etc.."

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480

    Cool

    Normally they reside in the rman catalog -- but you are not using catalog.

    Apparently you are using the SAP BR utility, therefore you may need to find out where is the rman script that is being executed and/or look at the configuration files under $OH/dbs/init{sid}.sap
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Apr 2008
    Posts
    6

    re

    Hello.
    I find many files to *.sap , and I don't know who is the file with wrong permissions.
    Here attach screenshot.
    Thanks for all.
    The group is "sapsys" , and fileowner is "blpadm - sap system administrator" - 777.
    Thats true?
    Attached Images Attached Images

  6. #6
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480

    Wink

    ... I was only restart the DB. ...
    Make sure you are executing the script as 'Oracle' account.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  7. #7
    Join Date
    Apr 2008
    Posts
    6

    re

    I have 2 scripts - start and stop.

    stopscript is:
    su blspadm -c "/sapmnt/BLP/exe/stopsap"

    ----
    startscript is:
    su orablp -c "lsnrctl start"
    su blpadm -c "startdb"
    su blpadm -c "/sapmnt/BLP/exe/startsap"

    ----
    Before I run stopscript, after startscript and try to make backup , but the error is this.
    So , however.
    On who user or file the permissions you tell me to see and change it?

    Thanks a lot for everything!

  8. #8
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480

    Talking

    Looks like you need this user:

    Code:
    su orablp -c "startdb"
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  9. #9
    Join Date
    Apr 2008
    Posts
    6
    Quote Originally Posted by LKBrwn_DBA
    Looks like you need this user:

    Code:
    su orablp -c "startdb"
    Ok. I now try it.
    Change the user who run the DB , RUN the SAP and run the Backup ot type drive.
    The make archive is long proccess and I write tomorrow whats are the results.
    Thanks a lot!
    Have a nice day (or night :-P )

    P.S. The question is - how is work before???
    But now is not?! I`m not change anything!!!

  10. #10
    Join Date
    Apr 2008
    Posts
    6

    re:

    The error is same :-(
    Do you have other ideas?


    30.04.2008 18:13:46 #FILE..... /oracle/BLP/sapdata1/system_1/system.data1
    30.04.2008 18:13:46
    30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.33
    30.04.2008 18:13:46 BR0063I 33 of 33 files processed - 92090.258 MB of 92090.258 MB done
    30.04.2008 18:13:46 BR0204I Percentage done: 100.00%, estimated end time: 18:13
    30.04.2008 18:13:46
    30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.33
    30.04.2008 18:13:46 BR0317I 'Alter tablespace SYSTEM end backup' successful
    30.04.2008 18:13:46
    30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.35
    30.04.2008 18:13:46 BR0530I Cataloging backups of all database files...
    30.04.2008 18:13:46 BR0278E Command output of 'SHELL=/bin/sh /oracle/BLP/102_32/bin/rman nocatalog':
    30.04.2008 18:13:46
    30.04.2008 18:13:46 Recovery Manager: Release 10.2.0.2.0 - Productionon Wed Apr 30 18:13:36 2008
    30.04.2008 18:13:46
    30.04.2008 18:13:46 Copyright (c) 1982, 2005, Oracle. All rights reserved.
    30.04.2008 18:13:46
    30.04.2008 18:13:46 RMAN>
    30.04.2008 18:13:46 RMAN> connect target *
    30.04.2008 18:13:46 connected to target database: BLP (DBID=73553200)
    30.04.2008 18:13:46 using target database control file instead of recovery catalog
    30.04.2008 18:13:46
    30.04.2008 18:13:46 RMAN> **end-of-file**
    30.04.2008 18:13:46
    30.04.2008 18:13:46 RMAN>
    30.04.2008 18:13:46 host command complete
    30.04.2008 18:13:46
    30.04.2008 18:13:46 RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14>15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34
    30.04.2008 18:13:46 RMAN-00571: ===========================================================
    30.04.2008 18:13:46 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    30.04.2008 18:13:46 RMAN-00571: ===========================================================
    30.04.2008 18:13:46 RMAN-03009: failure of catalog command on defaultchannel at 04/30/2008 18:13:39
    30.04.2008 18:13:46 ORA-19564: error occurred writing 8192 bytes at block number 1
    30.04.2008 18:13:46 ORA-27091: unable to queue I/O
    30.04.2008 18:13:46 ORA-27041: unable to open file
    30.04.2008 18:13:46 Linux Error: 13: Permission denied
    30.04.2008 18:13:46 Additional information: 3
    30.04.2008 18:13:46
    30.04.2008 18:13:46 RMAN>
    30.04.2008 18:13:46
    30.04.2008 18:13:46 Recovery Manager complete.
    30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.39
    30.04.2008 18:13:46 BR0279E Return code from 'SHELL=/bin/sh /oracle/BLP/102_32/bin/rman nocatalog': 1
    30.04.2008 18:13:46 BR0536E RMAN call for database instance BLP failed
    30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.39
    30.04.2008 18:13:46 BR0532E Cataloging backups of all database files failed
    30.04.2008 18:13:46 BR0056I End of database backup: bdxuwwyg.fnt 2008-04-30 18.13.39
    30.04.2008 18:13:46 BR0280I BRBACKUP time stamp: 2008-04-30 18.13.46
    30.04.2008 18:13:46 BR0054I BRBACKUP terminated with errors
    30.04.2008 18:13:46 External program terminated with exit code 5
    30.04.2008 18:13:46 BRBACKUP returned error status E

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width