How to end Backup mode files
venkatFeb 27 2012 — edited Feb 27 2012Hi,
I want backup mode files.
I have seen 2 queries to end hotbackup mode files.
ALTER database datafile ' ||name|| ' end backup;' from v$datafile where file# in (select file# from v$backup where status='ACTIVE');
and
Alter tablesapce Tablespace_name end backup;
pls suggest that what is the right queryto end hot backup mode files.
Regards,
Venkat.