Data Backup and Recovery

Oracle - Quiesce on Snap

PDDICKERSON
2,813 Views

I have configured the following parameters:

ORACLE_DATABASES=DEV3:dev3

SQLPLUS_CMD=/f01/dev3/db/tech_st/11.2.0.2/bin/sqlplus

CNTL_FILE_BACKUP_DIR=/f01/dev3/ControlFileBackup

ORA_TEMP=/tmp

ARCHIVE_LOG_ONLY=Y

ORACLE_HOME=/f01/dev3/db/tech_st/11.2.0.2

ORACLE_EXPORT_PARAMETERS=Y

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?

2 REPLIES 2

clilescapario
2,813 Views

I don't see some parameters in your snipit, see if you also have:

APP_NAME=oracle

ORACLE_BACKUPMODE=online

After that is set consult the debug log and you should see SC trying to call sqlplus to put the db in hotbackup mode.

Thanks

--

Chris

it_operations
2,813 Views

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.

Thank

Public