Database Backup and Recovery (MOSC)

MOSC Banner

Duplicate database from tape backup

edited Mar 15, 2012 12:05AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
Hi,
I have 2 physical hosts, sourceHOST and targetHOST. Both have access to the same media library but both servers are on different network segments, hence they are inaccessible to the other. I have a database (SID=sourceDB) on sourceHOST running in ARCHIVELOG mode where it is backed up to tape.  No recovery catalog exists for sourceDB.

Question 1: Is it possible to duplicate database sourceDB to new database (SID=targetDB) to host targetHOST using just the backup of sourceDB available on tape? If yes, how would I specify the value for "backup location" in the duplicate database command?

Question 2: Is it possible to restore a copy of the backup files for sourceDB from tape onto a disk location without performing any recovery? For example, I want to just restore all files in the backupset to a particular folder in targetHOST. How would I go about doing that?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center