Re: share a new 11gR2 feature
From: hrishy <hrishys_at_yahoo.co.uk>
Date: Fri, 4 Sep 2009 07:42:31 +0000 (GMT)
Message-ID: <275546.2924.qm_at_web23706.mail.ird.yahoo.com>
Hi Niall
Date: Fri, 4 Sep 2009 07:42:31 +0000 (GMT)
Message-ID: <275546.2924.qm_at_web23706.mail.ird.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 04 2009 - 02:42:31 CDT