Home » RDBMS Server » Backup & Recovery » Database Recovery using Image Copy
Database Recovery using Image Copy [message #246516] Thu, 21 June 2007 03:26 Go to next message
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

Re: Database Recovery using Image Copy [message #246717 is a reply to message #246516] Thu, 21 June 2007 12:08 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
My question is if I have image copy of a database then cant I restore it to DB2?

NO

Previous Topic: I cant open my Database
Next Topic: Error Restore Control File
Goto Forum:
  


Current Time: Tue Dec 06 08:26:28 CST 2016

Total time taken to generate the page: 0.15658 seconds