Hello,

I'm using Oracle version 8.1.7, and was wondering:

1. If the datafiles for the RBS (rollback segment) tablespace should be backed up as part of the hot backup.

2. Before backing up any of the datafiles, we execute the following commands which have nothing to do with the rollback segment, is it correct:

alter system switch logfile;
alter system archive log all;

3. Is there a way to flush out the RBS (version 8.1.7) or the UNDOTBS (version 9.2) tablespaces?

4. Similarly, in Oracle version 9.2, should the datafiles for the UNDOTBS be backed up as part of the hot backup?

Any information provided will be greatly appreciated.

Many thanks,
NLC