Home » RDBMS Server » Server Administration » RMAN Recovery (oracle 10gR2 on Unix)
RMAN Recovery [message #389797] Tue, 03 March 2009 10:52 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have a production database(10g R2) running on unix and have stagging database which is also in the same version running on a different server. Production is ASM but stagging is on file system. Can I user RMAN to restore and recover from Production to Stagging database eventhough one is ASM and the other database is on file system?
Thanks
Re: RMAN Recovery [message #389799 is a reply to message #389797] Tue, 03 March 2009 11:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yes.
Re: RMAN Recovery [message #389847 is a reply to message #389799] Tue, 03 March 2009 15:11 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Actually I copied the backup taken in the production server locally on the Staging database server. How do i tell RMAN to pickup the backup from this new location and do the restore? what command i should use?
Thanks
Re: RMAN Recovery [message #389849 is a reply to message #389847] Tue, 03 March 2009 15:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
nothing.
Keep it in the same path.
RMAN should recognize it.
Hope you have copied all the files required in the right manner.
I prefer to nfs mount the backup drive if possible.
Re: RMAN Recovery [message #389852 is a reply to message #389849] Tue, 03 March 2009 15:35 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Can you tell me what do you mean by copy the file in right manner? Normal cp command wont work?
Also, the backup on the production server is in /u01/orabackup and I copied the files in stagging database in /u30/orabackup. When I start the RMAN backup, how do i tell RMAN to look at /u30/orabackup for the backup files?
Re: RMAN Recovery [message #389864 is a reply to message #389852] Tue, 03 March 2009 17:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
copy it in /u01/orabackup.
Else, you have to go through a lot of pain.
Check the docs. It is all written there.

>>Normal cp command wont work?
Should work.
Had you done it properly, without corrupting the files.
If you are using some utility like SCP, just make sure you are using bin options.
Re: RMAN Recovery [message #391359 is a reply to message #389797] Wed, 11 March 2009 22:44 Go to previous message
microsoft_fly
Messages: 5
Registered: March 2009
Location: hz.zj.china
Junior Member

run
{
set newname for datafile 1 to " ";
set newname for datafile 2 to " ";
...

duplicate target database to ;
}
Previous Topic: How to start/access additional database created from command line
Next Topic: Convert Manual Segment Space Management to Auto.
Goto Forum:
  


Current Time: Mon Dec 05 09:08:36 CST 2016

Total time taken to generate the page: 0.22039 seconds