July 19, 2010 at 2:11 pm
hello everyone,
my question is redo entry inside the logfile
my db has only one log file
i have three log file backupset
can the log file 3 contain log file 2 and 1 backupset redo information or
when i take second log file backupset, is db check first log file backupset last redo entry and then backup those redo entry which are not backup yet quite confuse please help?
July 19, 2010 at 2:33 pm
each log backup will contain discreet transaction information. They are not cumulative like differential backups, they are consecutive,
the first log backup will contain committed transactions up to the point it started backing up the log, finishing at an LSN (Log sequence number). The next log backup will start where the previous one finished up (e.g the next LSN - thats how they are chained together)
see Books On line on this subject.
---------------------------------------------------------------------
July 19, 2010 at 4:03 pm
George is correct in that each log file backup has different information. The log backup takes all active log records that are committed and copies them to thebackup.
There is no redo log. The log backups contain copies of the transactions that occur. Don't use redo terminology as you'll confuse people. Also specify if you are talking about log backups or log files.
July 20, 2010 at 3:57 pm
really sorry to using wrong keyword "redo" here actually i also work both SQL Server and Oracle DB so sometime there little bit mixup
sorry i will keep it mind to posting anything next time
and thanks for your valuable answer
July 20, 2010 at 4:13 pm
It's not a big deal, but if you use the wrong terminology it becomes hard for us to understand each other.
If you have more questions, feel free to ask.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply