OraFAQ Forum: Backup & Recovery » restore issue about asm to no-asm

Home » RDBMS Server » Backup & Recovery » restore issue about asm to no-asm (11.2.0.1 windows xp)

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

restore issue about asm to no-asm [message #538681]

Sun, 08 January 2012 23:25

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
My product db is a RAC entironment with ASM,Now i backup my db using Rman,and want to restore to a test db with just as a node with no-asm,how can i do?

Report message to a moderator

Re: restore issue about asm to no-asm [message #538691 is a reply to message #538681]

Mon, 09 January 2012 01:25

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

Senior Member
Account Moderator

Use SET NEWNAME for all datafiles and ALTER DATABASE RENAME FILE for all logfiles, and SWITCH command after restoring the control file and before restoring the datafiles.

Regards
Michel

[Updated on: Mon, 09 January 2012 01:33]

Report message to a moderator

Re: restore issue about asm to no-asm [message #538705 is a reply to message #538691]

Mon, 09 January 2012 02:08

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
I will try it!

Report message to a moderator

Re: restore issue about asm to no-asm [message #538992 is a reply to message #538691]

Tue, 10 January 2012 12:50

himabija
Messages: 33
Registered: December 2011
Location: San Francisco

Member

Quote:

and SWITCH command after restoring the control file and before restoring the datafiles.

@MICHEL : I just tried your suggestion and found that SWITCH command should be used after restoration of datafiles are done .Below document also suggest the same(although the document belongs to 10g)

http://docs.oracle.com/cd/B14117_01/server.101/b10735/recov.htm

Did you want to mean something else?

[Updated on: Tue, 10 January 2012 13:04]

Report message to a moderator

Re: restore issue about asm to no-asm [message #539000 is a reply to message #538992]

Tue, 10 January 2012 13:45

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

Senior Member
Account Moderator

You are right, SET NEWNAME must be done before RESTORE and SWITCH after RESTORE and before RECOVER. I added SWITCH afterwards and a little bit too fast. Thanks for the correction.

Regards
Michel

Report message to a moderator

Previous Topic:	why should i offline the tablespace?
Next Topic:	error in Making Permanent Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 02:34:20 CST 2025