what is the difference between catalog & nocatalog?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you initialize log miner?

688


What is the default fill factor value? : sql server DBA

671


What happens on checkpoint? : sql server DBA

654


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2166


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

2014






what is the last version,the release date of that version and fix pack of ibm db2 udb?

1599


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2096


What are the different types of indexes available in sql server? : sql server DBA

666


what are the performance views in an oracle rac environment?

666


What is the default port no on which sql server listens? : sql server DBA

670


what is ora 24313?what is the procedure to exclude that error?

2197


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

2840


What authentication modes does sql server support? : sql server DBA

792


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.

1602


What is the difference between clustered and non-clustered index? : sql server DBA

636