deleted of control file how will u recover control file?
- 4 Answers
- 7634 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
Why does Oracle not permit the use of PCTUSED with indexes?
what are the benefits of flashback feature?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Can you redefine a table online?
What the different types of replication and why are they used? : sql server DBA
How to start SQL Server in minimal configuration mode?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are statistics, under what circumstances they go out of date, how do you update them?
Where do you find the default index fill factor and how to change it? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
what is logical system in sap basis
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Query processing is slow(eg select query)how will u solve that
what functionality does oracle provide to secure sensitive information?
