• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 692
  • Last Modified:

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
0
k khnn
Asked:
k khnn
  • 2
  • 2
1 Solution
 
k khnnAuthor Commented:
sorry my steps are

1. startup nomount
2. restore standby controlfile
3. alter standby database mount
4. restore
5. recover
0
 
MikeOM_DBACommented:
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

:p
0
 
k khnnAuthor Commented:
How do i find sequence number in backup set?
0
 
MikeOM_DBACommented:
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

:p
0
 
Geert GruwezOracle dbaCommented:
it looks like the restore worked ok, but it fails at recovery
for that i use sqlplus ... it gives way more info

set oracle_sid=sid
sqlplus "/ as sysdba"
recover standby database;

it will show you exactly what file it wants to apply next
> the file will not be in that folder
copy the file from the production database archive location and then hit enter
> then sqlplus will ask for the next file

copy the rest to the archive location, type auto and hit enter to apply the rest

check the FAL_SERVER and FAL_CLIENT in your init for automated rollforward
http://docs.oracle.com/cd/B28359_01/server.111/b28294/create_ps.htm#i70559
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now