Bismillah

Asalaam Alaikum Shahid !

It is normal for writes to occur to the database file while the tablespace
is
in hot backup mode. A hot backup allows the database files to be backed up

while the database is up and running. It still allows the database file to
be
updated.

When an 'alter tablespce begin backup' command is issued the datafiles that

belong to the tablespace are marked as hot-backup-in-progress. The dirty
databuffers in the database buffer cache that belong to the database files
are
written out to the files and the datafiles are checkpointed. The datafile
headers are updated to the SCN captured when the begin backup is issued.
The
datafile headers are not updated until the 'alter tablespace end backup'
command is issued; however, the datablock within the database files can
continue to be read and updated. When the datafile is restored from a hot
backup, the recovery will begin from the SCN captured during the begin
backup
is issued. All changes applied during the hot backup time period will be
rolled forward from the redo logs.

Best Regards

Your DBA

Salman Faheem


Oracle LazyDBA home page