1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

what is the difference between catalog & nocatalog?

Question Posted / kittu_chintu2005

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1322

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

1931

What are the different ways you can create databases in sql server? : sql server DBA

687

What are the recovery models for a database? : sql server DBA

683

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

1797




Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2275

What is transparent data encryption? : sql server DBA

648

what are the differences of where and if in SAS?

1753

. 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?

2068

how can you generate profile of pl/sql applications to identify performance bottlenecks?

691

What are the different types of database compression introduced in sql server 2008? : sql server DBA

649

what are the types of connection load-balancing?

642

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

691

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

2089

what is the use of ocr?

683