Database crashes. Corruption is found scattered among the
file system neither of your doing nor of Oracle's. What
database recovery options are available? Database is in
archive log mode.
- 1 Answers
- 2407 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / Deepak Tiwari
When the database crashes due to media corruption, you can recover it using Recovery Manager (RMAN). Here's how:n
1. Start RMAN as a client:n```bashnrman target /n```
2. Connect to the control file:n```sqlnconnect rman/password@controls_file=/path/to/control_file;n``` Replace '/path/to/control_file' with the actual path to your control file.
3. Create a recovery catalog (if you don't have one):n```sqlncreat catalog rman_cat@db;``` Replace 'rman_cat' and 'db' with your desired catalog name and database service name, respectively.
4. Recover the database:n```sqlnrun{n recover database;n}n```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what is the last version,the release date of that version and fix pack of ibm db2 udb?
