This discussion is archived
2 Replies Latest reply: Jan 13, 2013 6:57 PM by Hemant K Chitale RSS

RMAN recover

902332 Newbie
Currently Being Moderated
Hi all,

I have cluster database with 2 instnaces oracle 10g version.

I restored database and then trying to recover it now. But it is saying

released channel: T1
released channel: T2
released channel: T3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/13/2013 06:25:09
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 2 seq 112561 lowscn 27183166476 found to restore
RMAN-06025: no backup of log thread 2 seq 112560 lowscn 27183156285 found to restore
RMAN-06025: no backup of log thread 2 seq 112559 lowscn 27183144555 found to restore
RMAN-06025: no backup of log thread 2 seq 112558 lowscn 27183129592 found to restore
RMAN-06025: no backup of log thread 2 seq 112557 lowscn 27183110956 found to restore
RMAN-06025: no backup of log thread 1 seq 38877 lowscn 27183144574 found to restore
RMAN-06025: no backup of log thread 1 seq 38876 lowscn 27183093707 found to restore

RMAN> exit


on both the nodes i have archives redos are available.

I want to open db with noresetlogs option.

could you please suggest for this..

thanks
  • 1. Re: RMAN recover
    damorgan Oracle ACE Director
    Currently Being Moderated
    A couple of thoughts in no particular order.

    1. What is your version number ... 10g is a marketing label not a version number.

    2. Have you verified the files are where Oracle is looking? The files may be on a drive where you can see them but is that where Oracle is looking?

    3. Have you opened an SR with Oracle and if not why not?

    4. What went wrong that is causing you to want to restore the system and perform a reset. Please provide full details and exceptions.
  • 2. Re: RMAN recover
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Are you restoring back to the same cluster ? Did you restore the controlfile from the backup or only restore the database ?




    Hemant K Chitale

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points