what is the difference between catalog & nocatalog?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
You have just compiled a PL/SQL package but got errors, how would you view the errors?
What is the difference between online backup & offline backup?
What is RAID and what are different types of RAID configurations?
Which autogrowth database setting is good? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Give the stages of instance startup to a usable state where normal users may access it.
How can you control the amount of free space in your index pages? : sql server DBA
How would you determine who has added a row to a table?
what are the benefits of flashback feature?
What command would you use to encrypt a PL/SQL application?
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?????
how can you schedule a job in database?