jeudi 5 mars 2015

DB2 ROLLFORWARD option "TO END OF LOGS" - does it read archive logs?


I read about ROLLFORWARD option on link http://ift.tt/1zNd22n but I could not find answer to my issue.


I have database in Archive mode.


I made full ONLINE backup at Monday at 23:59


I have archive logs for Tuesday, Wednesday and Thursday. Let's say just for example one for each day: S0000001.LOG and S0000002.LOG and S0000003.LOG.


In Friday I have active log S0000004.LOG.


Let's say just for testing purpose I want to do the restore of Online backup made at Monday and all transactions committed during Tuesday, Wednesday,Thursday and Friday. So I want to restore everything from Monday to Friday


I thought by reading all manuals that I just need to perform after restore ROLLFORWARD TO END OF LOGS



db2 rollforward db maxdb75 to end of logs and complete;


I thought that this command to end of logs it will include Backup+Archive Logs(S0000001.LOG + S0000002.LOG + S0000003.LOG.)+Active Logs(S0000004.LOG)


But one good database expert told me that: "When rolling forward to end of logs without specifying overflow log path only active logs will be read"


So I have 2 questions:



  1. What in my example will be restored in case of "to end of logs" command

  2. Is this the command if I want to rollforward everything from Monday To Friday in my exampe: db2 rollforward db maxdb75 to end of logs and complete overflow log path "(/data/archiveLogsPath)";


Thank you in advance!!!!





Aucun commentaire:

Enregistrer un commentaire