What command would you use to create a backup control file?
- 2 Answers
- 4690 Views
- I also Faced
- E-Mail Answers
Answer Posted / simhadri naidu
At offline backup copy the CTL file to back up location.
At online backup
Alter database backup controlfile to trace as '/path';
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you schedule a job in database?
What are the recovery models for a database? : sql server DBA
what are the performance views in an oracle rac environment?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What the different components in replication and what is their use? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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
Where would you look for errors from the database engine?
What would you do with an "in-doubt" distributed transaction?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What are the different types of indexes available in sql server? : sql server DBA
What is dcl? : sql server DBA
what are the types of connection load-balancing?
