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

Thread: RMAN recovery test question

  1. #1
    Join Date
    Jan 2005
    Posts
    221

    RMAN recovery test question

    Hi all,

    I am in the process of testing RMAN recovery and have question.

    if the controlfiles and online redo log are still present a whole databse recovery can be achieved by running the following:

    run {
    shutdown immediate; # use abort if this fails
    startup mount;
    restore database;
    recover database;
    alter database open;
    }


    QUESTION: on this senarios, if we lost everything , however can we startup this base s b/c from RMAN catalog (repository). As you see below, you can't even connect to the database so how can you do the recovery????



    H:\>rman catalog rman/rman target sysman/manager@rmantest

    Recovery Manager: Release 9.2.0.6.0 - Production

    Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-04005: error from target database:
    ORA-12505: TNS:listener could not resolve SID given in connect descriptor

    H:\> to connect to the target database (the database that need to recover) like:

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The database has to be started in at least nomount mode before you can recover. Then you recover your control files, and THEN your database.
    Jeff Hunter

  3. #3
    Join Date
    Jan 2005
    Posts
    221
    Jeff,

    thanks for the info, I still have the problem:

    H:\>rman catalog rman/rman target test/test@rmantest

    Recovery Manager: Release 9.2.0.6.0 - Production

    Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-04005: error from target database:
    ORA-12519: TNS:no appropriate service handler found

    H:\>



    ONETHING ABOUT MY SETUP AND I AM NOT SURE IF APPROPRIATE:

    I HAVE THE CATALOG DATABASE RUNNING ON MY DESKTOP AND THE DATABASE IS ON DIFFERENT SERVER AND THE RMAN BACKUP FILE IS ON THE SAME SERVER WITH DATA TARGET DATABASE.
    Last edited by hannah00; 08-23-2005 at 12:16 PM.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    is the service started (rmantest)

  5. #5
    Join Date
    Jan 2005
    Posts
    221
    yes, I think I am missing something out

  6. #6
    Join Date
    Jan 2005
    Posts
    221
    I am reading the RMAN backup & recovery book and I really confused, here what it said in the book . (BTW, this is the case where you lost spfile)

    1. set your ORACLE_SID and then log into RMAN (I assumed Oracle means ORACLE_SID refer to the target database that you want to recover the spfile
    2. set DBID so that RMAN know which database spfile looking for.

    what I don't understand was: the TARGET database is on differnet server with the one I am on since I am running RMAN on my desktop to backup the target database, so set Oracle env doesn't do any good and I think this is where I got choked.

    Please advises.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I run rman from the server I am trying to restore, not the recovery catalog.
    Jeff Hunter

  8. #8
    Join Date
    Jan 2005
    Posts
    221
    Jeff,

    Please explain a little more, so is it true to say "you don't need recovery catalog when you try to resotre the database ??? Is it true for all case???? I think that's what I am missing.

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    this is like talko to /dev/null

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