In some scenarios, if a user accidentally deleted rows of a table and as a DBA you have to recover the table to point in time . How you can recover the rows without using more time -consuming tablespace point-in-time recovery operation? Flashback Table allows us to recover one or more tables to specific point [...]
Published by Paresh Sarma //
Instance failure prevents the synchronization of the database’s datafiles and control file before the instance is shutdown. Oracle automatically recovers the instance failure when starting up the database with the STARTUP command. The main purpose of the instance failure is to bring the control file and database file to the same SCN. Instance recover occurs [...]
Published by Paresh Sarma //
Flashback Drop is an new features of Oracle 10g features. With Flashback Drop we can restore a dropped table easily without using tablespace point-in-time recovery. Tablespace point-in-time recovery is an time consuming process and had the side effect of losing work from other transactions that occurred within the same tablespace after the table was dropped. [...]
Published by Paresh Sarma //
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 //
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 //
