what is the difference between catalog & nocatalog?

Question Posted / kittu_chintu2005

3 Answers
21621 Views
CSC, I also Faced
E-Mail Answers

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

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

What are the ways tablespaces can be managed and how do they differ?

2 Answers IBM,

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers

what is rebuild index??

2 Answers IBM, Sapient,

What is the dataguard background process??

1 Answers iGate,

what is the use of home directory???

1 Answers HP,

How would you go about verifying the network name that the local_listener is currently using?

0 Answers

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

What are the steps you will take to improve performance of a poor performing query?

0 Answers

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here