Re: share a new 11gR2 feature
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx, chet.justice@xxxxxxxxx, robertgfreeman@xxxxxxxxx
- Date: Fri, 4 Sep 2009 07:42:31 +0000 (GMT)
Hi Niall
I was asked in quite a few interviews if its possible to duplicate a database
to different server when you dont have acesses to target (production) database
pre11gR2 days
My answer was yes
a)you need to restore the backupset to a filesystem say /backup
b)mount the duplicate database using a dummy spfile
c)restore the controlfile from the place where you restored the backup by
keying in restore controlfile from /backupset
d)catalog the backupset by saying catalog backupset like /backupset
e)restore the backupset
f)recover the database and open
With 11gR2 teh syntatic sugar backup location makes the answer to teh interview
question very intersting.
DUPLICATE DATABASE TO dupdb
UNTIL TIME "TO_DATE('11/01/2007 14:00:00', 'MM/DD/YYYY HH24:MI:SS')"
SPFILE
BACKUP LOCATION '/prod_backups'
NOFILENAMECHECK;
regards
Hrishy
--
//www.freelists.org/webpage/oracle-l
Other related posts:
