DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RMAN

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    TO ALL RMAN GURU,
    Below is rman backup script that was run but backup failed.
    Could some one have a look at the error stack and point me to the right direction as my backup fail with the error

    RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "C:\ORACLE
    \RMAN_BACK\RICK11"
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECRE
    ATE


    below is every thing that you might need.
    Thanks



    C:\>SET ORACLE_SID=RICK

    C:\>RMAN

    Recovery Manager: Release 8.1.7.0.0 - Production

    RMAN> CONNECT TARGET INTERNAL/ORACLE@RICK

    RMAN-06005: connected to target database: RICK (DBID=398027678)

    RMAN> CONNECT CATALOG RMAN_USER/RMAN_USER@RMCAT

    RMAN-06008: connected to recovery catalog database
    RMAN-06428: recovery catalog is not installed

    RMAN> CREATE CATALOG TABLESPACE RMAN_TS;

    RMAN-06431: recovery catalog created

    RMAN> REGISTER DATABASE;

    RMAN-03022: compiling command: register
    RMAN-03023: executing command: register
    RMAN-08006: database registered in recovery catalog
    RMAN-03023: executing command: full resync
    RMAN-08002: starting full resync of recovery catalog
    RMAN-08004: full resync complete

    RMAN> REPORT SCHEMA;

    RMAN-03022: compiling command: report
    Report of database schema
    File K-bytes Tablespace RB segs Name
    ---- ---------- -------------------- ------- -------------------
    1 280576 SYSTEM YES C:\ORACLE\ORADATA\RICK\SYSTEM01.DBF

    2 51200 RBS YES C:\ORACLE\ORADATA\RICK\RBS01.DBF
    3 20480 USERS NO C:\ORACLE\ORADATA\RICK\USERS01.DBF
    4 20480 TEMP NO C:\ORACLE\ORADATA\RICK\TEMP01.DBF
    5 10240 TOOLS NO C:\ORACLE\ORADATA\RICK\TOOLS01.DBF
    6 20480 INDX NO C:\ORACLE\ORADATA\RICK\INDX01.DBF
    7 20480 DRSYS NO C:\ORACLE\ORADATA\RICK\DR01.DBF
    8 204800 USERS NO C:\ORACLE\ORADATA\RICK\USERS02.DBF
    9 204800 DRSYS NO C:\ORACLE\ORADATA\RICK\DRSYS02.DBF
    10 204800 TOOLS NO C:\ORACLE\ORADATA\RICK\TOOLS02.DBF
    11 204800 INDX NO C:\ORACLE\ORADATA\RICK\INDX02.DBF
    12 204800 RBS YES C:\ORACLE\ORADATA\RICK\RBS02.DBF
    13 204800 TEMP NO C:\ORACLE\ORADATA\RICK\TEMP02.DBF
    14 204800 SYSTEM YES C:\ORACLE\ORADATA\RICK\SYSTEM02.DBF

    15 409600 TOOLS NO C:\ORACLE\ORADATA\RICK\TOOLS03.DBF

    RMAN> CREATE SCRIPT DAYFULLBACK{
    2> ALLOCATE CHANNEL DB1 TYPE DISK;
    3> BACKUP
    4> FORMAT'C:\ORACLE\RMAN_BACK\%d%s%p'
    5> (DATABASE);
    6> RELEASE CHANNEL DB1;
    7> }

    RMAN-03022: compiling command: create script
    RMAN-03023: executing command: create script
    RMAN-08085: created script DAYFULLBACK

    RMAN> RUN {EXECUTE SCRIPT DAYFULLBACK;}

    RMAN-03021: executing script: DAYFULLBACK

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: DB1
    RMAN-08500: channel DB1: sid=12 devtype=DISK

    RMAN-03022: compiling command: backup
    RMAN-03023: executing command: backup
    RMAN-08008: channel DB1: starting full datafile backupset
    RMAN-08502: set_count=1 set_stamp=458313079 creation_time=04-APR-02
    RMAN-08010: channel DB1: specifying datafile(s) in backupset
    RMAN-08522: input datafile fno=00015 name=C:\ORACLE\ORADATA\RICK\TOOLS03.DBF
    RMAN-08522: input datafile fno=00001 name=C:\ORACLE\ORADATA\RICK\SYSTEM01.DBF
    RMAN-08011: including current controlfile in backupset
    RMAN-08522: input datafile fno=00008 name=C:\ORACLE\ORADATA\RICK\USERS02.DBF
    RMAN-08522: input datafile fno=00009 name=C:\ORACLE\ORADATA\RICK\DRSYS02.DBF
    RMAN-08522: input datafile fno=00010 name=C:\ORACLE\ORADATA\RICK\TOOLS02.DBF
    RMAN-08522: input datafile fno=00011 name=C:\ORACLE\ORADATA\RICK\INDX02.DBF
    RMAN-08522: input datafile fno=00012 name=C:\ORACLE\ORADATA\RICK\RBS02.DBF
    RMAN-08522: input datafile fno=00013 name=C:\ORACLE\ORADATA\RICK\TEMP02.DBF
    RMAN-08522: input datafile fno=00014 name=C:\ORACLE\ORADATA\RICK\SYSTEM02.DBF
    RMAN-08522: input datafile fno=00002 name=C:\ORACLE\ORADATA\RICK\RBS01.DBF
    RMAN-08522: input datafile fno=00003 name=C:\ORACLE\ORADATA\RICK\USERS01.DBF
    RMAN-08522: input datafile fno=00004 name=C:\ORACLE\ORADATA\RICK\TEMP01.DBF
    RMAN-08522: input datafile fno=00006 name=C:\ORACLE\ORADATA\RICK\INDX01.DBF
    RMAN-08522: input datafile fno=00007 name=C:\ORACLE\ORADATA\RICK\DR01.DBF
    RMAN-08522: input datafile fno=00005 name=C:\ORACLE\ORADATA\RICK\TOOLS01.DBF
    RMAN-03026: error recovery releasing channel resources
    RMAN-08031: released channel: DB1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03015: error occurred in stored script DAYFULLBACK
    RMAN-03007: retryable error occurred during execution of command: backup
    RMAN-07004: unhandled exception during command execution on channel DB1
    RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "C:\ORACLE
    \RMAN_BACK\RICK11"
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECRE
    ATE

    RMAN>
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    As you can see that was an OS error. Check to see whether you have enough space in the disk where you are backing thing

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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