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


Please Help Members By Posting Answers For Below Questions

What are the different sql server versions you have worked on? : sql server DBA

765


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?

2414


What would you do with an "in-doubt" distributed transaction?

1654


What are the different types of indexes available in sql server? : sql server DBA

816


What is the difference between clustered and non-clustered index? : sql server DBA

766


Why would you call update statistics? : sql server DBA

766


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?

2262


How can you control the amount of free space in your index pages? : sql server DBA

995


What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

759


What are the recovery models for a database? : sql server DBA

820


What the different topologies in which replication can be configured? : sql server DBA

917


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2176


Query processing is slow(eg select query)how will u solve that

7181


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?

1750


What is fill factor? : sql server DBA

891