What command would you use to create a backup control file?
Answer Posted / 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 |
Post New Answer View All Answers
Which autogrowth database setting is good? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
How do you trace the traffic hitting a sql server? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What would you do with an "in-doubt" distributed transaction?
how can you initialize log miner?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
what do you understand by flashback feature of oracle?
what is asm?
What are statistics, under what circumstances they go out of date, how do you update them?
What the different types of replication and why are they used? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA