Home » RDBMS Server » Backup & Recovery » restore issue about asm to no-asm (11.2.0.1 windows xp)
restore issue about asm to no-asm [message #538681] Sun, 08 January 2012 23:25 Go to next message
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?
Re: restore issue about asm to no-asm [message #538691 is a reply to message #538681] Mon, 09 January 2012 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
I will try it!
Re: restore issue about asm to no-asm [message #538992 is a reply to message #538691] Tue, 10 January 2012 12:50 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: why should i offline the tablespace?
Next Topic: error in Making Permanent Backup
Goto Forum:
  


Current Time: Sun Oct 21 03:04:47 CDT 2018