A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
Latest Answer: A partial backup is an operating system backup of part of a database. The backup of an individual tablespace's datafiles or the backup of a control file are examples of partial backups. Partial backups are useful only when the database is in ARCHIVELOG ...
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: Redo logs records all the changes to the database whether commited or uncommited. How does it know whether you are committing or rolling back till you commit it. Oracle always thinks positively that everything is going to be commited and writes to the ...
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. ...
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
Complete database recovery from disk failure is possible only in ARCHIVELOG mode.Online database backup is possible only in ARCHIVELOG mode.
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: Steps involve in recovery1.Restore backup datafiles2.Recover using Archive log files 3.apply partial backup 4.recover using redo log files ...
View page << Previous 1 2 3 [4]
Go Top
