Home » RDBMS Server » Backup & Recovery » Need a procedure to restore ASM RAC instance on to FileSystem. (Oracle 10.2.0.3, Linux)
Need a procedure to restore ASM RAC instance on to FileSystem. [message #409376] Mon, 22 June 2009 06:16 Go to next message
sballipati
Messages: 4
Registered: June 2009
Junior Member
Hello All

We have a two node RAC Database in production which is using ASM. This needs to be restored to a test
server on a different network using a filesystem for datafiles.
There is no common netwotk for establishing any SQL/RMAN sessions (to duplicate) between production and
test server but RMAN backups can be transferred to test server by using a kind
of USB device.

Could anyone share a detailed procedure to achieve this please.

Thanks

[Updated on: Mon, 22 June 2009 06:32]

Report message to a moderator

Re: Need a procedure to restore ASM RAC instance on to FileSystem. [message #409380 is a reply to message #409376] Mon, 22 June 2009 06:52 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
A simple search on this forum would have revealed this which is literally several posts down from your post.
Re: Need a procedure to restore ASM RAC instance on to FileSystem. [message #409405 is a reply to message #409376] Mon, 22 June 2009 08:05 Go to previous messageGo to next message
sballipati
Messages: 4
Registered: June 2009
Junior Member
Please note that as there is no common netwotk for establishing any SQL/RMAN sessions (to duplicate) between production and
test server, I cannot use RMAN commands such as
rman target <USER>/<PASS>@<TARGET> AUXILIARY <USER>/<PASS>
DUPLICATE TARGET DATABASE TO .

Thanks
Suresh
Re: Need a procedure to restore ASM RAC instance on to FileSystem. [message #409467 is a reply to message #409405] Mon, 22 June 2009 16:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Copy the files to a local filesytem in the other network
and restore using RMAN (instead of duplicate).
Check docs for restoring to a new host.
Apply the same principles using "set new".
There are many examples in this forum and web.
Re: Need a procedure to restore ASM RAC instance on to FileSystem. [message #409623 is a reply to message #409467] Tue, 23 June 2009 06:15 Go to previous message
sballipati
Messages: 4
Registered: June 2009
Junior Member
Mahesh
I have done this successfully.

Many Thanks
Suresh.
Previous Topic: recovery in stndby
Next Topic: RMAN Backup for two identically named databases
Goto Forum:
  


Current Time: Fri Dec 02 14:02:53 CST 2016

Total time taken to generate the page: 0.25976 seconds