Interested to Buy Any Domain ? << Click Here >> for more details...
deleted of control file how will u recover control file?
- 4 Answers
- 8686 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / bolla
At o/s level we are restore control.file from cold/hot backup
after
]$sqlplus /'as sysdba'
sys>startup nomount
sys>recover database using backup controlfile until cancel;
sys>alter database mount;
sys>alter database open resetlogs;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is dcl? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is a system database and what is a user database? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is replication? : sql server DBA
what is the use of recording information about current session?
which background process invoke at the time of upgradation tell me???
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What purpose does the model database server? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What happens on checkpoint? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
