I have questions regarding the RMAN duplicate 10g command. I'm running Oracle Database 10.2.0.4 on Red Hat Enterprise Linux.

1) I am going to use RMAN to duplicate (remote host) a database. Does the RMAN duplicate 10g command restore the datafile size exactly the same (i.e., datafile size is 500MB but using only 200MB) or restore the datafile that is actually being used (i.e., 200MB)?

    Requires Free Membership to View

More on Oracle database expert answers

Check out more of Brian Peasland's expert answers

Ask your own Oracle question

2) My database is single-instance database. How do I know what SEQUENCE to put into the RMAN duplicate 10g command?

Example:

RMAN>run

{

set until sequence <sequence##>

duplicate target database to dupg nofilenamecheck;

}

On the first question, Oracle just does a datafile copy when you use RMAN to duplicate the database. So your 500MB file in the source database will be a 500MB file in the auxiliary database even though you may only be using 200MB of that.

For the second question, the SET UNTIL SEQUENCE command defines a log sequence number for the point-in-time of the duplication. Each archived redo log gets a new sequence number. If you find that log sequence number 1234 was created today at noon, then if you use SET UNTIL SEQUENCE 1234, your duplicate database will be current as of noon today. You can query V$ARCHIVE_LOG to see when the sequence numbers were generated. But I typically do not use this. I skip the SET UNTIL command and let RMAN duplicate my database to be current as of the time I am performing the DUPLICATE operation.

This was first published in February 2013

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: