OraFAQ Forum: Backup & Recovery » Error Restore Control File

Home » RDBMS Server » Backup & Recovery » Error Restore Control File

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

Error Restore Control File [message #246547]

Thu, 21 June 2007 05:06

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

Senior Member

I have two database running in my machine. I want to copy full backup from one database to another database. Now I took backupset and then wanted to perform backup.

For this , I did ,(in 2nd database),

-bash-3.00$ rman target /

Recovery Manager: Release 10.2.0.2.0 - Production on Thu Jun 21 15:34:14 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DUMMY (not mounted)

RMAN> restore spfile from '/oracle/app/oracle/product/10.2.0/db_2/flash_recovery_area/THERAP/autobackup/2007_06_21/o1_mf_s_625850993_37nk8l77_.bkp';

Starting restore at 21-JUN-07
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=39 devtype=DISK

channel ORA_DISK_1: autobackup found: /oracle/app/oracle/product/10.2.0/db_2/flash_recovery_area/THERAP/autobackup/2007_06_21/o1_mf_s_625850993_37nk8l77_.bkp
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 21-JUN-07

RMAN> shutdown immediate;

Oracle instance shut down

RMAN> startup nomount;

connected to target database (not started)
Oracle instance started

Total System Global Area     612368384 bytes

Fixed Size                     1281648 bytes
Variable Size                167772560 bytes
Database Buffers             436207616 bytes
Redo Buffers                   7106560 bytes

RMAN> restore controlfile from '/oracle/app/oracle/product/10.2.0/db_2/flash_recovery_area/THERAP/autobackup/2007_06_21/o1_mf_s_625850993_37nk8l77_.bkp';

Starting restore at 21-JUN-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/21/2007 15:35:53
ORA-19870: error reading backup piece /oracle/app/oracle/product/10.2.0/db_2/flash_recovery_area/THERAP/autobackup/2007_06_21/o1_mf_s_625850993_37nk8l77_.bkp
ORA-19504: failed to create file "/oracle/app/oracle/product/10.2.0/db_2/THERAP/control01.ctl"
ORA-27086: unable to lock file - already in use
Intel SVR4 UNIX Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 886

I dont want to down my first database. But I want to import data into 2nd database. How I can do it?

Report message to a moderator

Re: Error Restore Control File [message #246555 is a reply to message #246547]

Thu, 21 June 2007 05:26

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I want to import data into 2nd database.

RMAN and import data are exclusive.
You can transport tablespace with RMAN but you can't export/import data.

Regards
Michel

Report message to a moderator

Re: Error Restore Control File [message #246558 is a reply to message #246547]

Thu, 21 June 2007 05:30

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

Senior Member

Sorry I used the wrong term. I want to restore full database backup into 2nd database using RMAN. But it says to me "cant not lock control file" as it is used by first database.

Report message to a moderator

Re: Error Restore Control File [message #246562 is a reply to message #246558]

Thu, 21 June 2007 05:41

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You don't restore into a database, you restore a database that is it is a new not existant database.

Set ORACLE_SID to new one.
Start RMAN, then the new database in nomount state, then you can try your restore but you have to change directory of all files, switch...
Was not this the purpose of another thread?
I think you have to wait that DreamzZ awakes to get a full answer. Wink

Regards
Michel

Report message to a moderator

Re: Error Restore Control File [message #246564 is a reply to message #246547]

Thu, 21 June 2007 05:44

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

Senior Member

Dream is in asleep now. When he used to get up from bed? Razz

Report message to a moderator

Re: Error Restore Control File [message #246572 is a reply to message #246564]

Thu, 21 June 2007 06:13

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I think he is from Virginia that is UTC -5 or -4.

Regards
Michel

Report message to a moderator

Re: Error Restore Control File [message #246719 is a reply to message #246572]

Thu, 21 June 2007 12:11

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

I told you in another thread also you cant restore backup of database MY_DB to database MY_DB2,
but there is an other option restore the backup to MY_DB and then use NID utility to change your DB name to MY_DB2.

Report message to a moderator

Previous Topic:	Database Recovery using Image Copy
Next Topic:	ORA-19602 during backup on closed DB (10g)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 15:55:37 CDT 2024