what is the difference between catalog & nocatalog?

Answers were Sorted based on User's Feedback



what is the difference between catalog & nocatalog?..

Answer / kittu_chintu2005

CATALOG is used when you use a repository database as catalog.
NOCATALOG is used when you used the controlfile to register your backup information.
Default in NOCATALOG.

Is This Answer Correct ?    44 Yes 3 No

what is the difference between catalog & nocatalog?..

Answer / manish

catalog means backup information store in control file as well as catalog database.

nocatalog means backup information store in only control file no other external repository

Is This Answer Correct ?    6 Yes 0 No

what is the difference between catalog & nocatalog?..

Answer / mohammed rafi uddin

Catalogue means backup contains the information of control file, backup information and tendency of time period and requires no network connectivity.whereas no catalogue having separate database backup information, no limit of time period & It should be network wise connection.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB Administration Interview Questions

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  


What is the difference between online backup & offline backup?

3 Answers   CSC,


What is RAID and what are different types of RAID configurations?

1 Answers  


Which autogrowth database setting is good? : sql server DBA

0 Answers  


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  






Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  


How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  


How would you determine who has added a row to a table?

4 Answers  


what are the benefits of flashback feature?

0 Answers   Oracle,


What command would you use to encrypt a PL/SQL application?

1 Answers  


1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,


how can you schedule a job in database?

0 Answers   Oracle,


Categories