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

Thread: Hot BackUp

Hybrid View

  1. #1
    Join Date
    Jun 2002
    Posts
    65
    Hi
    I am trying to take hot backup for all the table spaces to have a full backup of database with 9i...I took backup of all table spaces went ok....but for the temp it doesnt work and i dont think theres any diffrent cammand for that i used the following command and getting the ERROR massage:

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

  2. #2
    Join Date
    Feb 2000
    Location
    austin, tx
    Posts
    2
    Don't back up TEMP, it cannot be recovered anyway. If you have to do a restore, just recreate the TEMP tablespace as part of the restore process.

  3. #3
    Join Date
    Jun 2002
    Posts
    5

    Thumbs up

    Hi Fiza,

    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.


  4. #4
    Join Date
    Feb 2003
    Posts
    17
    hi

    fiza is right and DBA's agree to that. thank you fiza.

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