What command would you use to create a backup control file?
Alter database backup control file to trace.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What are disadvantages of having raw devices? 24.05.08
We should depend on export/import utility for backup/recovery (fully reliable) The tar command cannot be used for physical file backup, instead we can use dd c...How to implement the multiple control files for an existing database? 23.05.08
Shutdown the database Copy one of the existing control file to new location' Edit config.ora file by adding new control file name Restart the database...What is a control file? 23.05.08
Database's overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operat...How will you swap objects into a different table space for an existing database? 08.05.08
- Export the user - Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sq...How do you backup SAP Script layout sets? Can you download and upload? How? 13.04.07
SAP script backup :- In transaction SE71 goto Utilities -> Copy from client -> Give source form name, source client (000 default), Target form name. Download...What is cold backup, hot backup, warm backup recovery? 22.10.06
Cold backup (All these files must be backed up at the same time, before the databaseis restarted). Hot backup (official name is ‘online backup’) is a backup...Explain the difference between a hot backup and a cold backup and the benefits associated with each. 06.08.06
A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup...What is cold backup and hot backup (in case of Oracle)? 30.06.06
Cold Backup: It is copying the three sets of files (database files, redo logs, and control file) when the instance is shut down. This is a straight file copy,...What command is used to create a table by copying the structure of another table? 09.03.06
CREATE TABLE .. AS SELECT command Explanation : To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the f...What is cold backup and hot backup (in case of Oracle)? 08.03.06
Cold Backup: It is copying the three sets of files (database files, redo logs, and control file) when the instance is shut down. This is a straight file copy, u...