What command would you use to create a backup control file?
Answer Posted / ram
alter database backup controlfile '\path';
alter database backup controlfile to trace;
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the different sql server versions you have worked on? : sql server DBA
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?
What would you do with an "in-doubt" distributed transaction?
What are the different types of indexes available in sql server? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
Why would you call update statistics? : sql server DBA
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?
How can you control the amount of free space in your index pages? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the recovery models for a database? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Query processing is slow(eg select query)how will u solve that
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?
What is fill factor? : sql server DBA