on 2017 Apr 20 12:22 PM
Running DBREMOTE with v17.0.7.3382, I notice warnings in the DBREMOTE log like the following:
W. The timeline 'fb466259-a824-4931-88c3-f2941bcb662e' was found but will not be used in the output.
The remote has been run with several v17 versions for a while (before 17.0.7 with 17.0.4.2053). - I've never noticed such a warning before. The previous run before that warning appeared for the first time, the TL had been renamed. Every following SQL Remote run contains that warning.
Do I need to take care of something - if so, what?
FWIW, here's a complete log (nothing has been modified within the remote after the previous run, and no new message has been sent by the cons, so scanning start with the current TL offset):
I. Scanning logs starting at offset 0132219796 I. Transaction log "C:/....17.log" starts at offset 0132219796 I. Processing transaction logs from directory "C:\\..." W. The timeline 'fb466259-a824-4931-88c3-f2941bcb662e' was found but will not be used in the output. I. Processing transactions from active transaction log I. Execution completed
Request clarification before answering.
One thought: timelines are feature of point in time recovery {new version 17 feature}.
If you have restored from backups and recovered up to a point in time, you would have created multiple timelines in the offline log files left on your system. I expect this message will go away once DELETE_OLD_LOGS clear out the extra log sections that reference the older timeline (pre-recovery).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The timeline belongs to an older log, and apparently that one should have been deleted by the DELETE_OLD_LOGS option today, because a newer "old log" (created yesterday) for the same remote was deleted today.
After checking the DBLOG output for all offline logs and the DB, I noticed the older log ended before the current SQL Remote truncation offset, so I deleted the orphaned log, and now the warning does not appear anymore.
That being said, I have never explicitly used the "point in time recovery" facility for that remote - but such timeline is "mentioned" within the other offline and online logs, too.
Volker, I don't suppose you still have the dblog output from all the transaction logs in the old logs directory that includes the orphaned log that wasn't being deleted do you? I'd be interested in seeing that.
Reg
Aside : I just made a fix in 17.0.7 build 3399 (available now in SAP Marketplace) that was related to point in time recovery and the ability for the log scanning tools to scan logs in the offline logs directory. If your environment will have multiple pre-v17 transaction logs in the offline directory, you should really upgrade right now.
Customer Description : If the log scanning code shared by dbremote, dbmlsync and dbtran was scanning an offline directory that contained multiple pre-v17 transaction logs AND at least one v17 transaction log, then all but the earliest pre-v17 transaction log would be flagged as not needed. This would result in dbremote, dbmlsync or dbtran complaining that a range of log offsets were missing between the end of earliest pre-v17 transaction log and the start of the first v17 transaction log in the offline directory. This has been fixed.
Volker, I don't suppose you still have the dblog output from all the transaction logs in the old logs directory that includes the orphaned log that wasn't being deleted do you?
Unfortunately, I deleted that some minutes ago...:( - Note, there were only v17 logs in that dir, no ones from older versions. The particular log was renamed with 17.0.4.2053, the newer ones with 17.0.7.3382.
(So I'll gladly assume the mentioned bug won't apply to my situation...)
FWIW, I have the DBREMOTE output of all runs, if that would be of help to you...
Reg, the readme.html for 17.0.7.3399 provieded in the SAP Support Portal (https://launchpad.support.sap.com/#/notes/0002460695) does not contain such a description...
User | Count |
---|---|
50 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.