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

Thread: Rman Restore Failed To Create Controlfile

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374

    Rman Restore Failed To Create Controlfile

    Hi Gurus,

    I am trying to restore with rman but create controlfile failed. This is a high priority so any help will be highly appriciated.

    Thanks

    Ablakios

    Below is the script I run.


    run{

    allocate auxiliary channel dev_0 type sbt;

    set until time = "to_date('23-OCT-2006:00:00:00','DD-MON-YYYY:HH24:MI:SS')";

    duplicate target database to prodqp

    nofilenamecheck

    logfile

    group 1 ('/vault/redo1/redo1a.log',

    '/vault/redo1/redo2b.log') size 10M reuse,

    group 2 ('/vault/redo2/redo1b.log',

    '/vault/redo2/redo2a.log') size 5M reuse,

    group 3 ('/vault/redo1/redo3b.log',

    '/vault/redo2/redo3a.log') size 5M reuse,

    group 4 (‘/vault/redo1/redo4a.log’,

    ‘/vault/redo2/redo4b.log’) size 5M reuse,

    group 5 (‘/vault/redo1/redo5a.log’,

    ‘/vault/redo2/redo5b.log’) size 5M reuse,

    group 6 (‘/vault/redo1/redo6a.log’,

    ‘/vault/redo2/redo6b.log’) size 5M reuse;

    }


    ======================

    Below is the error received

    ======================


    RMAN-00571: ===================================================

    RMAN-00569: =====ERROR MESSAGE STACK FOLLOWS ========
    RMAN-00571: ===================================================

    RMAN-03002: failure of Duplicate Db command at 10/25/2006 05:49:28

    RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed

    ORA-01158: database already mounted

    MAXLOGFILES 40

    MAXLOGMEMBERS 5

    MAXDATAFILES 1022

    MAXINSTANCES 8

    MAXLOGHISTORY 453

    LOGFILE

    GROUP 1 ( '/vault/redo1/redo1a.log', '/vault/redo1/redo2b.log' ) SIZE 10485760 REUSE,

    GROUP 2 ( '/vault/redo2/redo1b.log', '/vault/redo2/redo2a.log' ) SIZE 10485760 REUSE

    DATAFILE

    '/vault/data1/system01.dbf'

    CHARACTER SET WE8ISO8859P1
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    the database is already mounted , unmount it

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Davey
    I used startup force nomount first and received that error.
    Now I simply used "startup nomount". no error so far. will keep you posted.
    Thanks for your prompt response.always
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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