Cache Database backup and restore

Question

Question

Manish Valecha · May 17, 2018

Hi,

Please let me know best way to restore single cache database of 300 GB from one server to another with minimum downtime.

Cold backup will take lot of time for 300 GB database size and snapshot backup not possible.

Not sure about cache online backup which take all databases backup.

Discussion (5)1

Log in or sign up to continue

Robert Cemper · May 17, 2018

Online backup can run for exactly selected DBs.
It gives an exact image taking also care for all changes during the backup process.
requirement:
-Journal for the DB must be active at least during the backup process.
- enough disk space to hold the backup

1 0

score 1 · Answer 1 · 2018-05-17T12:38:31-04:00

Hint:
backup of %SYS is good for recovery but not recommended for a copy
there a lot of instance related settings (e.g. config) included that may cause serious problems in the copy.

score 0 · Answer 2 · 2018-05-17T12:36:14-04:00

You can edit which databases you want to backup in the management portal under Backup Database List and you can run a online backup from Run Backup. Hope this helps.

score 0 · Answer 3 · 2018-05-18T11:38:45-04:00

Hi,

Please confirm if I follow below steps for refresh.

1. Export user permission on destination database.

2. Dismount source database and destination database.

3. copy cache.dat file from source server and replace on destination server.

4. Mount database on both source and destination server.

5. Import user permission.

score 0 · Answer 4 · 2018-05-17T12:55:39-04:00

John Murray · May 17, 2018

What Cache version are you using?

0 0