 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 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 ... Latest Answer : Creating a physical standby using RMAN ... If an oracle database has crashed. How would you recover the transactions that are not in the backups? Read Answers (3) | Asked by : Ed My database is in archive mode. when log switch occur that log file is archiving . what happens when log switch occurs Latest Answer : After logswitch checkpoint accour.It update the hedder of datafile and controlfile with new SCN no. and checkpoint position.it also give the signal to dbwr to writ dirty buffer to datafile. ... Read Answers (2) | Asked by : NAVIN KUMAR Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial? Latest Answer : It lets you to view and repair historical data.They query the database by TIME or user specified SCN. It do not UNDO anything .It is only a query mechanism.You can take o/p from flashback query and perform an undo yourself. It ... What are different types of backup? (Hot, Cold, logical, Physical) Explain in detail. Latest Answer : 1. Hot, inconsistance and online backup are same2. Cold, close consistance and offline backup are sameFor 1. db must be archive mode, inconsistance mean the SCN are not sameFor 2. db may be archive mode, consistance mean SCN are same (controlfile, datafile)Logical ... Tags : Backup
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
