 Related Questions A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter. Latest Answer : When using logical backup if we give full=y - that is a full backup.When using RMAN by default it takes full backup and image copy is also full backup since it contains all blocks used and not used ones. But in RMAN terms full backup is part of incremental ... Tags : Backup The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the Latest Answer : Online redologs name is used since archivelogs are called offline redologs. Online redologs can be in three states current to which lWr is currently writing transaction changes then this current becomes active after it gets filled and logswitch/ckpt ... A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members. Latest Answer : mirrored redologfile is the same copy of redologfile,when lgwr writes in the redologfile the same will be in the mirrored redofile.it is useful when original redo is corrupt database can recover from mirrored redologfile. ... Archived Redo Log consists of Redo Log files that have archived before being reused. Latest Answer : Answer: The archived redo log consists of archived redo logfile copies that have archived before being reused. ... 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 ... Why more redos are generated when the database is in begin backup mode? Latest Answer : As soon as you issue SQL> Alter database begin backup;This command freezes the datafile headers as well as controlfile headers, but the headers of redolog files are free. Hence if any of the transaction is performed after the online backup command. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
