Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Duplicate database with READ Only tablespace

user619853Oct 5 2017 — edited Oct 5 2017

LIke to clarify on duplicating database wit hRMAN,

If the RMAN restore command is restore database with check readonly, On duplicate command is there any sort of check readonly?

I'm using the script below

run {

allocate channel ch1 type disk;

allocate auxiliary channel ch2 type disk;

duplicate target database to CHSID UNTIL SCN=2372423856;

}

But I read somewhere :

By default RMAN duplicates current read-only tablespaces.

If a tablespace is currently read/write, but you use untilClause to duplicate the database to an SCN at which the tablespace was read-only, then RMAN does not include the tablespace in the duplicate database. Tablespaces that were read-only in the past are considered offline tablespaces and so are not included in the duplication.

I want to include all READONLY tablespace in the duplication.  I've set many readonly tablespaces but are in the past, will these be skipped in the duplication?

Or Should I avoid using the UNTIL SCN clause?

This post has been answered by Hemant K Chitale on Oct 5 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2017
Added on Oct 5 2017
4 comments
2,192 views