| archieve files [message #63377] |
Thu, 30 September 2004 03:19  |
Sanjeev Suri
Messages: 11
Registered: September 2004
|
Junior Member |
|
|
|
can we place back the data which is now in archieve log file back to the database , if not then what is the use of archieve log files.
|
|
|
|
| Re: archieve files [message #63379 is a reply to message #63377] |
Thu, 30 September 2004 04:03  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi
see the archive log files are useful for point in time recovery in event of a failure.
first, it never stores any data which belongs to current transactions it will store redolog history only from the online redolog files,so that when any failure occurs it can get historical changes from this files and applies to datafiles.so that when ur database works after recovery you have all the data till the time of failure.
second,you cannot copy the data of archivelogs to datafiles directly. this process will be done by background process.
Regards
D.Dilip
|
|
|
|
| Re: archieve files [message #63395 is a reply to message #63379] |
Fri, 01 October 2004 05:21 |
BhavinShah
Messages: 105
Registered: February 2004
|
Senior Member |
|
|
Hi,
You can get back-data from the archived file..
mainly it is used for recovery purpose but you can also use that for the flash back.
example : at 10:00 clock you have all copy of your archive file and your database is consistent.
at 10.01 by mistake you have drop a table . which is a very critical to database application.
Now you have a choice to recover database up to 10:00 by imcomplete recovery.
hope this will clear your some of douts
bhavin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
