Answer Detail: RE: Oracle Catalog and Archive Log

GeekInterview.com > Interview Questions > Oracle > Database Administration

Print |

Question: Oracle Catalog and Archive Log

Answer: Explain what are Oracle Catalog and Oracle Archive log?

April 04, 2009 13:04:13	#3
sivaraju.sateesh	Member Since: January 2009 Total Comments: 9
RE: Oracle Catalog and Archive Log
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.