What is a log switch?
A log switch is occurring means oracle stops writing the transactions information in to current redo log file and will be continuing writing into another redo log file.
The old redo log file information will be written into archived log by using Arcn process.
we can take log switch forcibly by issuing a command like
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
A log switch is occurring means oracle stops writing the transactions information in to current redo log file and will be continuing writing into another redo log file.
The old redo log file information will be written into archived log by using Arcn process.
we can take log switch forcibly by issuing a command like
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
No comments:
Post a Comment