2013-05-15 10:39 AM - edited 2015-12-18 12:32 AM
I have configured the following parameters:
When I start the snap using snapcreator using:
|./snapcreator --profile Databases --action snaplist --policy daily --config DEV3_Refresh --verbose|
I can see the backup controlfile created, but I am not seeing in the Oracle Alert log oracle executing the command alter database begin backup:
This command must be executed properly use snaprestore and recover the database.
Must I use the pre/post application quiesce command section to put the alter database begin backup and alter database end backup commands?
2013-05-21 07:16 AM
I don't see some parameters in your snipit, see if you also have:
After that is set consult the debug log and you should see SC trying to call sqlplus to put the db in hotbackup mode.
2013-05-24 07:07 AM
Yes, I have APP_NAME=oracle
I have found that Oracle must check the volume actually contains data files, before it will perform the begin and end backup. In my testing I was using a volume that contained the oracle home and did not contain datafiles, just to see if the commands would work. Not until I used a volume with the datafiles did I see the begin and end backup in the log.