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 |
internal architecture
who owns the operating system files created by the utl_file package?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is the difference between the SQL Loader and IMPORT utilities?
how can you get actual data change values from previous transactions in oracle?
What is the default port no on which sql server listens? : sql server DBA
How can we see the database version in os level
WHEN DOWN TIME WHAT CAN U DO?
the process of adding a cpu in sql server is called..?
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.