![]() |
| 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 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 : Full backup means it having datafiles, controlfile and parameter file. ... 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 (2) | 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 : Log switch event will take place. But the status of the log file which is archiving will be ACTIVE till it finish archiving. ... Read Answers (1) | 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 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||