Lost control files of Target Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Lost control files of Target Database

  1. #1
    Join Date
    Aug 2007
    Posts
    54

    Lost control files of Target Database


    Hi, I lost my control files of target database. How to recover the database from RMAN backup. I take full database backup using RMAN weekly.

    thanks,

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    using the restore command, which part of the docs did you get stuck on

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    I hope you do backup the controlfiles right ?

    regards
    Hrishy

  4. #4
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339

    Smile

    Hi
    use the command

    RMAN>restore controlfile;

    The rman backup keep the snapshot of the spfile.
    gopu

  5. #5
    Join Date
    Aug 2007
    Posts
    54

    Lost control files of Target Database

    Hi, I cannot mount the database. Both the target database and catalog database are on same machine. The Restore database command does'nt work, RMAN displays error: Database not mounted.

    Iam logging to RMAN by giving

    $ rman target system/devrman;

  6. #6
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339

    Smile

    Hi
    First u want to restore the spile.

    RMAN>restore spfile;

    then u restore the controlfie.
    RMAN>restore controlfile;

    then mount the database;
    RMAN>startup mount;
    then the database will be in the mount stage,then you can restore the database using the command restore dataabase;
    gopu

  7. #7
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    $ rman target system/devrman;
    You should connect as sys with sysdba
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

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