Backup RBS in hot backup - version 8.1.7 Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Backup RBS in hot backup - version 8.1.7

  1. #1
    Join Date
    Mar 2004

    Backup RBS in hot backup - version 8.1.7


    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,

  2. #2
    Join Date
    Nov 2000
    1. yes
    2. yes
    3. what are you talking about?
    4. yes

    Here's a hint: use RMAN.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2002
    Geneva Switzerland
    3. If you don't use RMAN, the physical file is copied, so you can't save any time or space. AFAIK, if you do use RMAN, only blocks that have never been occupied are skipped, with the much same result. I don't think there is any way you can reduce the amount of data to be backed up from the RBS/UNDO.

  4. #4
    Join Date
    Mar 2004
    Thanks to Jeff and DaPi. The information provided is very helpful.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width