deleted of control file how will u recover control file?
- 4 Answers
- 7313 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
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
how can you initialize log miner?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
what is a user-defined lock?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you enable flashback feature?
how to restore files with rman?
what are the performance views in an oracle rac environment?
Where would you look for errors from the database engine?
What is the default port no on which sql server listens? : sql server DBA
