Recovery Using RMAN Giving errors
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Recovery Using RMAN Giving errors

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,
    I am trying to recover a lost datafile using rman and get errors.

    Here is the script I am running and below that are errors.



    RMAN> run {
    2> allocate channel c2 type disk;
    3> restore database;
    4> recover database;
    5> release channel c2;
    6> }

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

    RMAN-03022: compiling command: restore

    RMAN-03022: compiling command: IRESTORE
    RMAN-03023: executing command: IRESTORE
    RMAN-08016: channel c2: starting datafile backupset restore
    RMAN-08502: set_count=3 set_stamp=428428372
    RMAN-08019: channel c2: restoring datafile 1
    RMAN-08509: destination for restore of datafile 1: C:\ORA805\DATABASE\SYS1ORCL.O
    RA
    RMAN-08019: channel c2: restoring datafile 2
    RMAN-08509: destination for restore of datafile 2: C:\ORA805\DATABASE\USR1ORCL.O
    RA
    RMAN-08019: channel c2: restoring datafile 3
    RMAN-08509: destination for restore of datafile 3: C:\ORA805\DATABASE\RBS1ORCL.O
    RA
    RMAN-08019: channel c2: restoring datafile 4
    RMAN-08509: destination for restore of datafile 4: C:\ORA805\DATABASE\TMP1ORCL.O
    RA
    RMAN-08019: channel c2: restoring datafile 5
    RMAN-08509: destination for restore of datafile 5: C:\ORA805\DATABASE\USR2ORCL.O
    RA
    RMAN-08019: channel c2: restoring datafile 6
    RMAN-08509: destination for restore of datafile 6: C:\ORA805\DATABASE\TEMPORCL.O
    RA
    RMAN-08019: channel c2: restoring datafile 7
    RMAN-08509: destination for restore of datafile 7: C:\ORA805\DATABASE\REC_DATAOR
    CL.ORA
    RMAN-03026: error recovery releasing channel resources
    RMAN-08031: released channel: c2
    RMAN-00569: ================error message stack follows================
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: restore
    RMAN-03007: retryable error occurred during execution of command: IRESTORE
    RMAN-07004: unhandled exception during command execution on channel c2
    RMAN-10032: unhandled exception during execution of job step 1: ORA-06512: at li
    ne 148
    RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry possible

    ORA-19504: failed to create file "C:\ORA805\DATABASE\REC_DATAORCL.ORA"
    ORA-27038: skgfrcre: file exists
    OSD-04010: option specified, file already exists
    ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 925
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
    IECE

    Thanks
    Anurag

  2. #2
    Join Date
    Aug 2000
    Posts
    194
    I am not much familiar with Oracle on Windows platform.

    This could be due to Oracle not having permission to remove the existing file and restore the backup copy to the destination.

    1, verify C:\ORA805\DATABASE\REC_DATAORCL.ORA exists

    2, try removing the file urself (only if you are ging to restore) and restore the file from backup

    3, recover the DB

  3. #3
    Join Date
    Sep 2000
    Posts
    362
    Yes, The file exists and i tried to restore it after removing it but it still does not work.

    Please Suggest.

    Thanks
    Anurag

  4. #4
    Join Date
    Aug 2000
    Posts
    194
    Did you check whether there is enough space?

    Also, try adding a file thru sql*plus and see what error it is giving (if another test DB on the machine is available)

    (ex. Alter tablespace ts1 add datafile C:\ORA805\DATABASE\REC_DATAORCLn.ORA size size1 ;

  5. #5
    Join Date
    Sep 2000
    Posts
    362
    It gives me the following error when I try to create the file through sql plus


    Alter tablespace usr add datafile 'C:\ORA805DATABASE\REC_DATAORCL100.ORA'
    *
    ERROR at line 1:
    ORA-01119: error in creating database file 'C:\ORA805\DATABASE\REC_DATAORCL100.ORA'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.

    But I am able to create the datafiles using server manager and enterprise manager.

    Please suggest how do i fix this.

    Thanks
    Anurag

  6. #6
    Join Date
    Aug 2000
    Posts
    194
    check the path,

    I guess 'C:\ORA805DATABASE' has to be
    'C:\ORA805\DATABASE'

    Note the "SLASH" betwn ORA805 and DATABASE

    BTW, is it a parallel DB?

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    That would be correct, but how are you connecting to the target database as SYS/SYSTEM/SOME_USER. If you are a sys/system, then make sure of the file permissions like. As prince suggested it has to do some thing with your file permissions I beleive, if you were able to restore the other file except this one.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Sep 2000
    Posts
    362
    The path is correct. It has a / in it.
    It is 'C:\ORA805\DATABASE'

    Alter tablespace usr
    add datafile
    'C:\ORA805\DATABASE\REC_DATAORCL100.ORA';

    I connect to the target database using internal.

    It is not a Parallel Database.

    Thanks
    Anurag


  9. #9
    Join Date
    Sep 2000
    Posts
    362
    How do i view/manage file permissions for the user internal and assign it the required permissions to perform the recovery on a windows 2000 machine.

    I have a Oracle 8.0.5 database installed.


    And why is that I am able to create a datafile using server manager and enterprise manager using the same user and not sql plus?????


    Thanks
    Anurag

  10. #10
    Join Date
    Aug 2000
    Posts
    194
    I am not sure, whether this is of any help. Anyway try this.

    Righ click the mouse on another file which got restored and compare its properties, securities with the one which is giving the problem. May be you will find some information.

    Also make sure ur path, SID all set properly to avoid mess-ups

    Prince..


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