Flashback Query features introduces in Oracle 9i. This features allows us to view the contents of a table as it existed at some point in the recent past. Flashback Query uses the “AS OF TIMESTAMP” clause in the standard SELECT statement.We can specify the timestamp as any valid expression that evaluates to a date or [...]
Published by Paresh Sarma //
Database restore is just opposite of our backup process.The backup file from disk or other media is copied back to their original location. when we need to do database restore After a media failure occurs When database point in time recovery to be done Database Recovery There is a change of data in the backup [...]
Published by Paresh Sarma //
Question : Which dynamic view stores the information about the files to be recover Ans : v$RECOVER_FILE Question : IF a datafile is offline or corrupt , the database instance will start or not ? Ans : Instance will start , if the file is not belongs to SYSTEM or UNDO tablespace. Question : All [...]
Published by Paresh Sarma //
As an Oracle DBA , Recover database and maintain high availability is your prime job. Some day you my faced a scenario where all your control files and online redo log files are lost and you have to recover your database as early as possible. In this section we will learn how to overcome such [...]
Published by Paresh Sarma //
When a user session changes data in the database ,Oracle saves the original data in a tablespace,called is undo data and the tablespace where the undo data is stored is called Undo tablespace. Undo tablespaces are same as the other tablespace and we can monitor that have enough undo space in the tablespace to satisfy [...]
Published by Paresh Sarma //
