Category: DataBase

13 Oracle Database Instance This chapter explains the nature of an Oracle database instance, the parameter and diagnostic files associated with an instance, and what occurs during instance creation and the opening and closing of a database. This chapter contains the following sections: Introduction to the Oracle Database Instance Overview of Instance Startup and Shutdown Overview of Checkpoints Overview of Instance Recovery Overview of Parameter Files Overview of Diagnostic Files Introduction to the Oracle Database Instance A database instance is a set of memory structures that manage database files. A database is a set of physical files on disk created […]

Run query: SELECT * FROM V$RECOVER_FILE;    If all files are in proper shape, that is no recovery is needed then it results in below message: SQL> SELECT * FROM V$RECOVER_FILE; no rows selected SQL>   If there are any files that found to be in incorrect status, that is which needs the recovery: SQL> SELECT * FROM V$RECOVER_FILE; FILE# ONLINE ———- ——- ERROR CHANGE# —————————————————————– ———- TIME ——— 1 ONLINE 339928152 20-MAR-14 3 ONLINE 339920405 20-MAR-14 FILE# ONLINE ———- ——- ERROR CHANGE# —————————————————————– ———- TIME ——— 5 ONLINE 339928152 20-MAR-14 3 rows selected. SQL>     To get the […]