Skip to Main Content
Forums

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!

Difference between switch logfile and archive log current

683230Feb 21 2009 — edited Feb 24 2009
Hi,

Can anyone tell me the differences of;

1. ALTER SYSTEM SWITCH LOGFILE;
2. ALTER SYSTEM ARCHIVE LOG ALL;
3. ALTER SYSTEM ARCHIVE LOG CURRENT;

I read Oracle's document but still didn't understand the difference in real life-use.

If you were writing a hotbackup script, which would you use at the end of datafile copy?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2009
Added on Feb 21 2009
#general-database-discussions
5 comments
11,680 views