> The backup is a hot backup. I take tablespaces offline, copy them and
> put them back online. I keep copies of all the archive logs from
> start of backup up until current.
If you literally mean "ALTER TABLESPACE ...OFFLINE" before copying the files
that is **NOT** a hot backup -- to do a hot backup you must issue an "ALTER
TABLESPACE...BEGIN BACKUP", copy all the files in the TS & then issue "ALTER
TABLESPACE...END BACKUP." Anything else will NOT work. Also make sure you
do ALL tablespaces (except TEMPORARY tablespaces) & backup the control file
as well using "ALTER DATABASE BACKUP CONTROLFILE TO '<path/filename>'".
Received on Tue Dec 04 2001 - 09:20:35 CST
