asked on

Rman standby Restore and recovery

Hi,
i am trying to create standby database using rman full , i did the following steps.

I am getting following error.

RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/08/2014 11:43:53
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 1562116 and starting SCN of 13424006030831 found to

restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1562115 and starting SCN of 13424006026981 found to

restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1562114 and starting SCN of 13424006019657 found to

restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1562113 and starting SCN of 13424006019582 found to

restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1562112 and starting SCN of 13424006019489 found to

restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1562111 and starting SCN of 13424006019093 found to

restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1562110 and starting SCN of 13424005846842 found to

restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1562109 and starting SCN of 13424005845114 found to

restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1562108 and starting SCN of 13424005843497 found to

restore
RMAN-06025: no backup of archived log for thread 1 with sequence 1562107 and starting SCN of 13424005843049 found to

restore

RMAN> EXIT

k khnn

ASKER

sorry my steps are

1. startup nomount
2. restore standby controlfile
3. alter standby database mount
4. restore
5. recover

MikeOM_DBA

No physical backup is necessary if you try the DUPLICATE command:

connect target sys/syspwd@SRCDB
connect auxiliary sys/syspwd@STBYDB
RUN {
  DUPLICATE TARGET DATABASE FOR STANDBY
       FROM ACTIVE DATABASE
  ;
}

Open in new window

k khnn

ASKER

How do i find sequence number in backup set?

MikeOM_DBA

If you use DUPLICATE you do not need backup files or archive logs.

Q: "How do i find sequence number in backup set? "

A: - -
1) If you are using catalog, query the RC_* Views.
2) Issue rman command with "PREVIEW" option like:

SET ECHO ON
SPOOL LOG TO MyRestore.log
RUN
{
  RESTORE DATABASE PREVIEW;
}

Open in new window

ASKER CERTIFIED SOLUTION

Geert G

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial