INTERVIEW QUESTIONS ORACLE BACKUP AND RECOVERY DETAILS

Question: What is Log Switch ?

Answer: The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.

The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch. Source: CoolInterview.com

A log switch occurs when one online redo log has been filled and the next online redo log is going to be filled. A log switch always triggers a checkpoint.
We can switch the log file using:
SQL>ALTER SYSTEM SWITCH logfile;
Source: CoolInterview.com

Log switch is information about the backup and restored database
Source: CoolInterview.com

After the current online redo log file group is filled, LGWR begins writing to the next group. This is called log switch. Source: CoolInterview.com

Log switch means if one redo is filled up with present transactions then log writer comes into picture and does switch occurs and the new transactions will saved in the other redo Source: CoolInterview.com

if one redolog group has filled, LGWr switch to next redolog group for write the redo entries. that is called log switch Source: CoolInterview.com

logswitch means as a when need to prevent deadlock or overflow in same redolog file tats y v need to logswitch to take d next redolog file Source: CoolInterview.com

there are minimum 2 online redo log file necessary for a database when one redolog group is filled it is switch to next redogroup .we do switching forcely by ALTER system switch log file..if database in noarchive mode then the information in redolog group is overwritten... Source: CoolInterview.com

when one redo log full dn
the lgwr writes to log file.
dn i will switch for new transcation... Source: CoolInterview.com

When one redolog is full then logwrite will automatically goes to the second the redolog .or otherwise we can manually apply the logswitch ie. alter system switch logfile.

ADvantage:
It is used for backup recovery purpose. Source: CoolInterview.com

when redo log buffer is 1/3 is filled lgwr will writes to redo log files (this consits of memebers data is written into members when members are filled logswitch writes to another member Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question