Interested to Buy Any Domain ? << Click Here >> for more details...
deleted of control file how will u recover control file?
- 4 Answers
- 9111 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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How do you open a cluster administrator? : 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?
What are the different ways you can create databases in sql server? : sql server DBA
What is transparent data encryption? : sql server DBA
what functionality does oracle provide to secure sensitive information?
what is logical system in sap basis
What the different components in replication and what is their use? : sql server DBA
what do you understand by fine-grained auditing?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Explain materialized views and how they are used.
What the different types of replication and why are they used? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
