what is the difference between catalog & nocatalog?

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

What is transparent data encryption? : sql server DBA

0 Answers  


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  


which background process will run @ the time of creation of catalog database

1 Answers   CSC,


what are the types of connection load-balancing?

0 Answers   Oracle,


how to restore files with rman?

0 Answers  






What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  


what are the performance views in an oracle rac environment?

0 Answers   Oracle,


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?

1 Answers  


Give the reasoning behind using an index.

2 Answers  


Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  


Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,


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  


Categories