What command would you use to create a backup control file?
Answers were Sorted based on User's Feedback
Answer / ram
alter database backup controlfile '\path';
alter database backup controlfile to trace;
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Explain CREATE DATABASE syntax?
what is the differnce between process and thread ?
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
What view would you use to look at the size of a data file?
What is the recommended interval at which to run statspack snapshots, and why?
mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?
What is the difference between online backup & offline backup?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is the default fill factor value? : sql server DBA
From the database level, how can you tell under which time zone a database is operating?
How would you go about verifying the network name that the local_listener is currently using?