What command would you use to create a backup control file?
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
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is a correlated sub-query? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How do you trace the traffic hitting a sql server? : sql server DBA
what are the types of connection load-balancing?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is the use of ocr?
What authentication modes does sql server support? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what is a crs resource?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What happens on checkpoint? : sql server DBA
What is the importance of a recovery model? : sql server DBA