Oracle catlog is the catlog database in RMAN in which we can register the target databases of which the backup should be taken.
Archive log files are the offline copies of the redolog files which are used for the recovery purpose.
1 User has rated as useful.
Login to rate this answer.
The Oracle system catalog is comprised of tables and views which allow the user to obtain information about the database, such as what other tables and views are available, their attributes, constraints, etc. Oracle has hundreds of available system catalog relations, only some of which are available to the average user (as many are intended for use only by qualified database administrators). .
2 Users have rated as useful.
Login to rate this answer.
Oracle catalog consists of the metadata about objects like tables, synonyms, views etc.
Oracle catalog is read by oracle when the database is getting up. Archive log as the backup or a copy of the redolog files.
Archive logs are used to recover the database or whenever the log mining is required to perform.
Login to rate this answer.
Oracle System Catalog is comprised of tables,views that provide user to obtain information about the database for eg : user_catalog, user_views, user_tables.
Where as Archive Log Files are offline copies of Online Redo Log Files meaning :
Once the Online Redo Log files are filled if database is running in archive log mode archiver saves these files to the archive destination.
1 User has rated as useful.
Login to rate this answer.
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 .
Login to rate this answer.
Oracle catalog are like views which provide information about the database, such as what other tables and views are available, their attributes, constraints, etc. Oracle has hundreds of available system catalog relations.
Archive log are the copies of redo log files. If system is running in archive mode then redo logs are being copies in the form of archive logs.
Login to rate this answer.
Catalog term is used in 2 ways.
Catalog - All tables/views stores information about database and all objects in it.
RMAN Catalog - Schema where RMAN executable stores/reads/writes the information about backup/recovery process.
Archive Log
This is also know as off-line log or off-line redo logs. When the ARC process copies/archives the redo log to another location it is called archive log.
This log is used in recovery process of database(primary and/or stand by).
Login to rate this answer.
Sriniv@s..
Answered On : May 23rd, 2012
Oracle catalog contain the metadata of objects.
RMAN catalog maintain the backup information.
Redo data persistently stored in archive logs,for recovery..
Login to rate this answer.
