DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Hot Backup

  1. #1
    Join Date
    Jun 2002


    Thanks for reply but I dont understand that why am i able to take the backup of Tem at my school which has 8i and no t at home which has 9i...

    Alter tablespace temp begin backup;
    ORA-03217: Invalid option for alter temporary tablespace

  2. #2
    Join Date
    Jun 2002
    Probably the tablespace TEMP in your 8i database wasn´t a temporary tablespace, but a normal tablespace.

  3. #3
    Join Date
    Mar 2004
    There is no need to backup the temporary locally manged tablespaces because:

    1. Locally managed tempfiles are always set to NOLOGGING mode. So thus will
    have no undo.
    2. Extents are managed by bitmap in each datafile to keep track of free or
    used status of blocks in that datafile.
    3. The data dictionary does not manage the tablespace.
    4. Rollback information is not generated because there is no update on the
    data dictionary.
    5. Media recovery does not recognize tempfiles.

    And you have to create new temp tables after hot backup by using the script which will come along with the control file.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.