Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

RMAN-03002: failure of recover command

Posted on 2010-08-27
7
Medium Priority
?
1,361 Views
Last Modified: 2012-05-10
I am running oracle XE on my production server. The backup is taken through Rman. I have to restore the backup to another server which serves as a standby server.

When restoring the backup when I write recover database at rman I get the following error. After that I write recover database until sequence nnn (nnn means the seq no. Given in the below error) and then it recovers the database. I want to automate this task but this error stops the execution. My question is if there is a way to avoid this error or write a command that automatically recovers till the seq upto where the recovery can be done?

RMAN-03002: failure of recover command at 08/27/2010¿18:10:19¿RMAN-06054: media recovery requesting unknown log: th¿read 1 seq 5491 lowscn 169415048¿
0
Comment
Question by:systemsautomation
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 6

Expert Comment

by:sridharv9
ID: 33547080
I guess you are having problem with using "until time". If yes, are you sure the time falls within the db backup time?  Otherwise you need to copy the archivelog files to your standby server @ archive_destination location.
0
 

Author Comment

by:systemsautomation
ID: 33547204
both servers are in different timezones infact in different cities.
0
 
LVL 6

Expert Comment

by:sridharv9
ID: 33547559
Are you using the backup taken time at primary server(source server) ? Make sure to use the time when the  backup is completed to use in "until time".
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

Author Comment

by:systemsautomation
ID: 33573614
Hi

Sorry for not getting back to you timely.

I am doing following to restore the database (on the standby machine):

1. restore database
2. recover database

At this point I get error something like this:

RMAN-03002: failure of recover command at 08/27/2010¿18:10:19¿RMAN-06054: media recovery requesting unknown log: th¿read 1 seq 5491 lowscn 169415048

I am NOT using 'until time'  anywhere.
0
 
LVL 6

Expert Comment

by:sridharv9
ID: 33601525
Ok, you can recover database with in the time frame of backups you have  i.e.  level 0 + level 1. And one way is to determine backup completion time is by running following query against RMAN catalog:

select max(completion_time) from rc_backup_piece where DB_ID = <YOUR_DB_ID>;

And pass this time to following command:
recover database using backup controlfile until time '<variable value from above command>';

We use this process to automatically refresh our non-prod db's with prod db backup with specific backup pieces.

0
 

Author Comment

by:systemsautomation
ID: 33601746
Thanks.

But as I mentioned in my question that I want to make this task automatic and writing a script for that.

Putting time manually will not let the script work/
0
 
LVL 6

Accepted Solution

by:
sridharv9 earned 2000 total points
ID: 33836379
In that case you can pass on the time as parameter. That is how we do - query the rman catalog and populate the variables in shell script.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question