what is the difference between catalog & nocatalog?

Question Posted / kittu_chintu2005

3 Answers
21441 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

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

what is the differnce between process and thread ?

1 Answers IBM,

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers

Name two files used for network connection to a database.

5 Answers

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

How to determine the service pack currently installed on SQL Server?

1 Answers

what are the differences of where and if in SAS?

0 Answers

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers Patni,

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?