Home » RDBMS Server » Backup & Recovery » RMAN - recover database fails...
RMAN - recover database fails... [message #162290] Thu, 09 March 2006 10:11 Go to next message
cloudina99
Messages: 3
Registered: December 2005
Junior Member
Hello,

I am trying to restore a database to a new host. I have full backup with nocatalog from a customer. Here is what I have done:

Installed oracle after created same directory structure and started rman. Set dbid to customer's dbid. After then,
1. Restored spfile
2. Created a pfile using that spfile
3. Restored control files
4. Restored datafiles from the full backup using 'restore database' command.

Now, when I try to recover, I am getting an error

RMAN> recover database;

Starting recover at 09-MAR-06
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/09/2006 07:17:26
ORA-19698: /ora02/oradata/test/redo01.log is from different database: id=3378408
07, db_name=TEST

Am I missing something here? I had set the dbid to customer's dbid before starting the database.

Please help!

Thanks,

Cloudina
Re: RMAN - recover database fails... [message #162402 is a reply to message #162290] Fri, 10 March 2006 01:27 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
Try this
RMAN> recover database using backup controlfile until cancel;

Alex zeng | Skype Me: hans9zeng
Previous Topic: time-based recovery
Next Topic: problem in opening the database
Goto Forum:
  


Current Time: Mon Nov 25 00:04:28 CST 2024