OraFAQ Forum: Backup & Recovery » rman backup cannot restore

Home » RDBMS Server » Backup & Recovery » rman backup cannot restore (10.2.0.3.1)

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

rman backup cannot restore [message #287474]

Wed, 12 December 2007 05:54

mwansalovewell
Messages: 71
Registered: October 2007
Location: uk

Member

I have done an rman backup of the database but did not include the controlfile.
the backup was a cold back in database mount stage.

I do not have the database ID. The database was using ASM.

Is there a way to restore this backup??

I only have the backup of the datafiles. AUTO CONTROLFILE BACKUP WAS NOT CONFIGURED.

Report message to a moderator

Re: rman backup cannot restore [message #287477 is a reply to message #287474]

Wed, 12 December 2007 06:04

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do you really have this problem or is this a theorical question?

Regards
Michel

Report message to a moderator

Re: rman backup cannot restore [message #287479 is a reply to message #287477]

Wed, 12 December 2007 06:16

mwansalovewell
Messages: 71
Registered: October 2007
Location: uk

Member

how production database server was rebuilt
os
oracle

now we cannot restore the backup. urgent help will be appreciated. It is a real situation. We do not have any other backups. we are afraid how all database is gone.

Report message to a moderator

Re: rman backup cannot restore [message #287480 is a reply to message #287474]

Wed, 12 December 2007 06:22

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

No, you can't restore your backup without controlfile.

Report message to a moderator

Re: rman backup cannot restore [message #287482 is a reply to message #287479]

Wed, 12 December 2007 06:24

mwansalovewell
Messages: 71
Registered: October 2007
Location: uk

Member

oracle say there is a PL/SQL script that you can use to extract the files from the backup set if you have lost your controlfile backup in RMAN. I'm checking on it.

you can extrant the files.

Report message to a moderator

Re: rman backup cannot restore [message #287487 is a reply to message #287482]

Wed, 12 December 2007 06:31

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

I don't know about such a pl/sql script. but when you find please let me know.

Report message to a moderator

Re: rman backup cannot restore [message #287490 is a reply to message #287480]

Wed, 12 December 2007 06:33

mwansalovewell
Messages: 71
Registered: October 2007
Location: uk

Member

check metalink note 60545.1

Report message to a moderator

Re: rman backup cannot restore [message #287568 is a reply to message #287474]

Wed, 12 December 2007 12:54

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Even with AUTOBACKUP OFF, RMAN will include a backup of the controlfile and spfile in the backupset of the datafile as long as your backup includes datafile 1.

Report message to a moderator

Re: rman backup cannot restore [message #287698 is a reply to message #287568]

Thu, 13 December 2007 03:38

mwansalovewell
Messages: 71
Registered: October 2007
Location: uk

Member

Yes you are right.

backup database; command only

includes the controlfile and spfile in the backup set even if the AUTO CONTROLFILE BACKUP is off. if AUTO is on then the controlfile backupiece will be created separate out of the backup set.

The control file was restored with

RMAN> restore controlfile from '<path of backupset>

and this worked.

Thankyou

Report message to a moderator

Re: rman backup cannot restore [message #287702 is a reply to message #287474]

Thu, 13 December 2007 03:48

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

Senior Member

Quote:

if AUTO is on then the controlfile backupiece will be created separate out of the backup set.

Even if it is not (autobackup is not on)then there may create separate backup set when block size of datafile 1 is not same as block size of controlfile.

Report message to a moderator

Previous Topic:	Oracle data Replication
Next Topic:	RMAN Parallel Recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 11:24:11 CST 2024