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 |
how can a session indicate its interest in receiving alerts?
Explain about your sql server dba experience? : sql server DBA
how can you create a user-defined lock?
What happens on checkpoint? : sql server DBA
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
Where would you look for errors from the database engine?
what is logical system in sap basis
What are the commands used in dcl? : sql server DBA
How do you add a data file to a tablespace?
What does coalescing a tablespace do?
what is a crs resource?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)