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:
- What in my example will be restored in case of
"to end of logs"command - 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