![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions Latest Answer : Redo log buffer is circular buffer,lgwr writes these buffers in cyclic faishon.redo log buffers contains redo entreies which are used to reconstruct or redo chandes. ... Latest Answer : Multiplexing Redo log file called Mirroing. ( Keeping multiple copies in different disks) ... Latest Answer : LGWR process wirtes all change vectors from theredo log buffer to online redo log file sequentially. ... The System Global Area in a Oracle database is the area in memory to facilitates the transfer of information between users. It holds the Changes made to entries are written to the on-line redo log files. So that they can be used in roll forward operations during database recoveries. Before writing them into Process of having a copy of redo log files is called mirroring. This can be achieved by creating group of log files together, so that LGWR will automatically writes them Cold backup is taking backup of all physical files after normal shutdown of database. We need to take. - All Data files. - All Control files. Latest Answer : A backup of one or more database files taken while the database is closed. Typically, closed backups are also whole database backups. If you closed the database cleanly, then all the files in the backup are consistent. SQL>SHUTDOWN IMMEDIATE (or) NORMAL ... Tags : Backup Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data Latest Answer : The database should be in Archive log mode to take hot backups.Step1: Shutdown the database gracefullyStep2: Take full backup of the databaseStep3: Edit the following intialization parameters likelog_archive_destlog_archive_formatlog_archive_startStep4: ... Tags : Backup
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||