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

Thread: alter tbs begin bkup

  1. 08-07-2004, 02:36 AM #1
    svijay21
    svijay21 is offline Junior Member
    Join Date
    Apr 2004
    Location
    chennai
    Posts
    9

    alter tbs begin bkup

    when this command is executed
    Code:
       alter tablespace users begin backup
    In which location is the datafile corresponding to users tablespace backeup to
    Last edited by svijay21; 08-07-2004 at 02:39 AM.
    Thanks
    Vijay
    Reply With Quote Reply With Quote
  2. 08-07-2004, 05:30 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    go read the backup and recovery guide, the file is copied anywhere, the header of the datafile is frozen so you are able to take a backup of the file yourself
    Reply With Quote Reply With Quote
  3. 08-09-2004, 05:12 AM #3
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Vijay,
    as Davey says, read the concepts as you are misunderstanding what 'Begin backup' does. It is not backing up the TBS, just putting in a state that will enable you to back it up in a consistent state.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width