-
sequence number for clone db
I would like to take a clone of a database and have all the necessary steps. However
one crucial step is not entirely clear to me and that is the part when I am on the target
server and issue a 'recover database until sequence = xxx';
My question is where do I obtain this sequence number from?
is it from the source database, prior to the backup?
Can I obtain the sequence number on the target database after I have performed 'restore database'
I am not using Dataguard but simply a restore, recover and open resetlogs
Can anyone help provide me the SQL and explain how I obtain the necessary sequence number
Many thanks in advance
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|