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 is a system database and what is a user database? : sql server DBA
how can you create a user-defined lock?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
How would you extract DDL of a table without using a GUI tool?
What is the default port no on which sql server listens? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is fill factor? : sql server DBA
how can you initialize log miner?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
internal architecture
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?