| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: Oracle Catalog and Archive Log
Answer: Explain what are Oracle Catalog and Oracle Archive log? |
| July 07, 2009 05:59:35 |
#5 |
| m4k4v3l1 |
Member Since: July 2009 Total Comments: 3 |
RE: Oracle Catalog and Archive Log
|
Oracle System Catalog :
System Created Tables Which Contain Statistics and Useful Data Collected Automatically by the Database Engine to Help the Administrator or the regular users.
There Are Several Kinds Of Catalogs :
V$_Catalog
dba_Catalog
User_Catalog
RMAN Catalog:
Catalog Created By Rman manually After Enabling Archive Log , Which Contain Data Regarding The BackUp/Recovery Process.
-----------------------------------
Archive Log: Member Of The Archive Group Contain all committed data , is very essential in recovering database to the last minute before disaster.
DataBase Archiver: Responsible For Creating Archive Log Files .
|
| |
Back To Question | |
