Topic: Backup & Recovery >> ABOUT REDO 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: ABOUT REDO LOG FILE |
| indra |
Posted: Oct 09, 2007 11:53:43 AM |
Total Post: 20
Joined: Jan, 2007
|
HI,
I WANT TO KNOW WHAT TYPE OF CHANGES DOES AN ONLINE REDO LOG FILE RECORD?
ARE CHANGES DUE TO INSERTION OF NEW DATA,UPDATION OF EXISTING DATA ARE RECORDED IN THE REDO LOG FILES? |
|
|
 Mohammed Taj |
| Posted: Oct 09, 2007 12:53:13 PM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Any changes made in the database goes to redo log files.
|
|
|
|
|
| nick |
| Posted: Oct 19, 2007 04:07:42 PM | |
|
Total Post: 30
Joined: Sep, 2007
|
Redo logs stores the changes made to existing data, file sizes, addition of new files etc... any change made to DB is recorded.
|
|
|
|
|
| Vinod |
| Posted: Dec 11, 2007 09:30:16 AM | |
|
Total Post: 54
Joined: Oct, 2007
|
Hi,
Redo logs contain a record of changes that have been made to datafiles. In a single-instance Oracle database, redo logs are stored in two or more redo log file groups. Each of these groups contains a redo log file and possibly one or more mirrored copies of that file .
Oracle RAC database with two instances, instance A and instance B. If instance A is down, then instance B can read the redo log files for both instance A and B to ensure a successful recovery. In an Oracle RAC database, all the redo log files reside on shared storage.
In addition,each instance must have access to the redo log files of all the other instances in the cluster. If Oracle RAC database uses ASM, then ASM manages the shared storage for the redo log files and the access to those files.
In Oracle instances with standby databases for providing level of protection, the redo data needed to recover each transaction must be written to standby redolog files as well .
Thanks & Regards,
Vinod
|
|
|
|
|
| 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 | 843 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 272 |
| neeraj sharma | 252 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
