Topic: SQL*Plus and PL/SQL >> how to restore and recover control file , redo log file and archive log file
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: how to restore and recover control file , redo log file and archive log file |
| jeeva |
Posted: Jan 12, 2008 09:16:49 AM |
Total Post: 11
Joined: Oct, 2007
|
how to restore and recover control file , redo log file and archive log file in user managed recovery and rman recovery?
thank u |
|
|
 Mohammed Taj |
| Posted: Jan 12, 2008 09:23:39 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
So many question you include in one question.
1. how to restore and recover controlfile ?
Answer: Depends on Controlfile Lost, Depands on Controlfile Backup.
2. how to restore and recover redolog file ?
Answer: depands on redolog file lost, depand on redolog file group/member configuration,depands on redolog file backup.
3. how to restore archivelog file ?
Answer: First archivelog file will not recover becuase archive log file itself use for recovery purpose.
and for restore answer depands on how to store archivelog files, depands on database log mode , depands on archivelog destination/multiplexing.
Hope this helps
Regards
Taj
PS: hope you understand what i want to say i want you need to read oracle backup and recovery concept guide.
|
|
|
|
|
| Babu |
| Posted: Jan 12, 2008 12:22:22 PM | |
|
Total Post: 94
Joined: Oct, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 327 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
