I've started with my next challenge: snapcenter based snapshot backup and try to understand it's restore options.
In a test-environment (snapcenter 4.1.1 server, Oracle12 dbhost based on sles12) I've done some snapshot backups (including logs and controllfiles, no log bruning after backup)
Now, I've moved away all archivelogs from the archivelog location. (/oracle/PKW/oraarch/)
I expected to have them restored during the snap-restore task.
- I chose the snapshot timestamp I'd like to restore and click on restore,
- chose "All Datafiles"
- chose "change database state if needed for restore and recovery"
- chose "Force in place restore"
- select "Date and Time" and give a timestamp
- no pre ops, no post ops, no notification mail
The result: Post restore error:
PL-SCO-25000: SCO_POSTRESTORE of database files failed with error: ORACLE-30036: Recovery of PKW failed due to the following error(s): [ORA-00308: cannot open archived log '/oracle/PKW/oraarch/PKWarch1_117_998124950.dbf', ORA-27037: unable to obtain file status, ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below, ORA-01195: online backup of file 1 needs more recovery to be consistent]
I suggested to have the archvelogs restord from snapshot, if logs are needed.
in both cases archivelogs got expected at the original oraarch location.
Do I misunderstand the way to restore an oracle database from within SnapCenter?
I had the opinion that in a situation where datafiles have been corrupted AND archivelogs got manually deleted, a snapcenter based full restore should restore the required logs as well.