Skip to Main Content
Forums

Database Software

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!

Switch datafile <datafilespec> to copy ; what this does ?

701636May 18 2009 — edited Aug 26 2011
1) SWITCH DATAFILE datafileSpec;
2) SWITCH DATAFILE datafileSpec TO COPY;

^^
I cant understand the difference in the above 2 commands teIs there a difference in the above 2 commands.

The description in DOC is :

DATAFILE datafileSpec TO COPY : Specifies the datafile that you wish to rename. As with DATABASE TO COPY, specifies to switch this datafile to the latest image copy.


When would the 2nd option be preferred over the 1st ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2011
Added on May 18 2009
#performance-availability, #recovery-manager-rman
2 comments
8,054 views