what is the difference between catalog & nocatalog?
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
how can you record information about current session?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
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
what is a crs resource?
Explain about your sql server dba experience? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
how can you find out if a table can be redefined?
What the different types of replication and why are they used? : sql server DBA
What happens on checkpoint? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you process messages in order asynchronously?
what is ora 24313?what is the procedure to exclude that error?