| redo log file [message #15863] |
Thu, 28 October 2004 18:36  |
Sumit
Messages: 21
Registered: December 2000
|
Junior Member |
|
|
Any one tell me the purpose of redolog file in oracle
and what is inbound and outbound in oracle
thaks in advance,
Sumit
|
|
|
|
| Re: redo log file [message #15892 is a reply to message #15863] |
Fri, 29 October 2004 12:42  |
Edward Stoever
Messages: 58
Registered: August 2002
|
Member |
|
|
"Redo" is somewhat self-explanatory... the purpose of the redo logs is to redo all transactions that have taken place on the database, just in case there is a failure, and the database must be recovered up to the point of failure. Suppose you backup your database on Saturday, then on the following Monday the disk that the database is on fails. If you have the redo log on a different disk as the database files, you can use your backup copy of the database and the redo logs to apply all of the transactions that took place between the time of the backup and the moment the disk failed. Archiving the redo logs is almost always done on production databases. This allows an "unlimited" number of transactions to be saved into many, many archived redo log files. I hope this helps!
Edward -- www.database-expert.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
