Re: share a new 11gR2 feature

From: hrishy <>
Date: Fri, 4 Sep 2009 07:42:31 +0000 (GMT)
Message-ID: <>

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.

  UNTIL TIME "TO_DATE('11/01/2007 14:00:00', 'MM/DD/YYYY HH24:MI:SS')"   SPFILE
  BACKUP LOCATION '/prod_backups'


Received on Fri Sep 04 2009 - 02:42:31 CDT

Original text of this message