OraFAQ Forum: Backup & Recovery » Database Recovery using Image Copy

Home » RDBMS Server » Backup & Recovery » Database Recovery using Image Copy

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Recovery using Image Copy [message #246516]

Thu, 21 June 2007 03:26

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

In my computer(Solaris 10 and oracle 10.2.0.2.0) I have two databases named 'DB1' and 'DB2'. Now I took an image copy of database 'DB1'. I want to restore this database to 'DB2'. For this reason,

I removed the init.ora file from DB2.
And then I wanted spfile+ control file copied to DB2 . So I invoked the command while being database in nomount state,
----------------

RMAN> restore spfile from '/oradata/backup/cf_D-THERAP_id-2841989990_0bikr2i9';

Starting restore at 21-JUN-07
using channel ORA_DISK_1

channel ORA_DISK_1: autobackup found: /oradata/backup/cf_D-THERAP_id-2841989990_0bikr2i9
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/21/2007 14:03:43
ORA-19870: error reading backup piece /oradata/backup/cf_D-THERAP_id-2841989990_0bikr2i9
ORA-19608: /oradata/backup/cf_D-THERAP_id-2841989990_0bikr2i9 is not a backup piece

------------
As it says I need backup piece.
My question is if I have image copy of a database then cant I restore it to DB2?

[Updated on: Thu, 21 June 2007 04:22]

Report message to a moderator