on 02-22-2023 6:57 PM
Dear experts,
Looking for the feasibility wherein HANA database does not turn online upon the completion of database recovery, enabling to apply subsequent logs later.
Problem Statement:
Performing a system copy i.e. across data centers for a very large database, along with target HANA DB upgrade with backup-restore method.
Due to some limitations at source data-center for HSR , I am considering for the backup-restore approach, in which the full backup is restored much ahead the cut-over date with option -Recover the database to specific data backup. Until the time of cut-over, we wish to apply the subsequent logs,without having to restore with any data backup.
We can do such log recovery in databases such as MS SQL and Oracle as long as the database is not open (for connections), but HANA DB automatically comes online for usage after recovery.
Thanks all,
I explored the possibilities. Since the HANA DB does always come online (and is open for establishing connections) after recovery, we cannot apply further logs on it.
To apply further logs for roll forwarding, we must need a Full backup as base snapshot of the persistence.However, the subsequent recovery goes relatively faster as the recovery process just walks through the last save-points and roll forwards with the additional logs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.