msvkrishna

 Profile Answers by msvkrishna Questions by msvkrishna

• Feb 23rd, 2009

 

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.

chandubtech

 Profile Answers by chandubtech Questions by chandubtech

• Mar 22nd, 2009

 

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). .

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh 

• Apr 5th, 2009

 

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.

mmaz2002

 Profile Answers by mmaz2002 

• Jun 18th, 2009

 

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.

m4k4v3l1

 Profile Answers by m4k4v3l1 

• Jul 1st, 2009

 

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 .

vivekverma

 Profile Answers by vivekverma 

• Feb 11th, 2010

 

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.

pandish

 Profile Answers by pandish Questions by pandish

• Dec 31st, 2010

 

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).

 

Sriniv@s..

• 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..