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 |
What is transparent data encryption? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
which background process will run @ the time of creation of catalog database
what are the types of connection load-balancing?
how to restore files with rman?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
what are the performance views in an oracle rac environment?
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?
Give the reasoning behind using an index.
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???
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
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.