The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.
Latest Answer: log switch occurs when current redo logfile gets full and lgwr writes redo to next redo logfile.Even we can perform log switch with the command alsobefore we execute the sql execute following statementSQL> select status from v$log;STATUS----------------UNUSEDUNUSEDCURRENT------>active ...
Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments. Rolling back
Latest Answer: Crash recovery is performed by SMON when database started after an instance crash or after a shutdown abort.
Since during crash current transactions are present in redolog files and not yet been written to corresponding files so the
SCN number of ...
View page << Previous 1 2 3 4 [5]
Go Top
