Using Oracle Database Standard Edition 11r2 .
I'm looking a way to backup the database with zero downtime , using a snapshot of datafiles (LVM snapshots) and without need backup de archive logs.
All options found so far , we will need save fews archives logs.
My reason for this requirement is today our databases are put offline to copy our datafiles. There are procedures and documentation about backup and the restore . I want to minimize any change here at backup and restore process , all looking for minimize point of failures , human error which could be invalidate all backup. So , I need to exclude the archive logs from the equation , do not want they involved.
I think something like :
- flush all data from database to disk (checkpoint)
- lock any write at the database datafiles (how?)
- create the snapshot
- release the database
- mount the snapshot
- copy all data of the snapshot
- destroy the snapshot.
And if need to restore , just restore de data files and open the database.
ALTER DATABASE BEGIN BACKUP
, snapshot,ALTER DATABASE END BACKUP
.