Backup-based Duplication without a target and a recovery catalog connection
Hi,
we need to restore a database - it's now my idea to use backup-based duplication without a target and a recovery catalog connection (I don't want to bother the source database and we don't use a recovery catalog).
The backups are stored on tapes (by HP's Omniback).
The syntax should be like this:
duplicate database to dup_db
until time "to_date('05/02/2012 02:00:00, 'MM/DD/YYYY HH24:MI:SS')
spfile
backup location '???'
nofilenamecheck;
We need to use the backup from the 2nd May 2012 - therefore it's my understading that we need to use the clause "until time "to_date('05/02/2012 02:00:00, 'MM/DD/YYYY HH24:MI:SS')".
But since the backup is on tape I don't know the value for "backup location". I thought the name of the backup in Omniback could be used but that didn't work.
Now my questions are:
- is it possible to restore a database as mentioned with the duplicate-option?
- and does the "until time" work in that case?
Any help will be appriciated.
Rgds
JH