> -----Original Message-----
> From: Deepak Kulkarni
> Sent: Sunday, September 29, 2002 10:14 PM
> To: 'Ganesh Raja'
> Subject: RE: tablespace offline & backup mode difference
>
> Hi Ganesh,
>
> Thanks for your reply.
>
> Actually i know this that offline can't be accessed while Backup can be.
>
> Also to put Tablespace in backup mode , DB should be in archivelog mode.
>
> But the Question is what oracle does internally to make it happen so ?
>
> I remember somewhere that it Freezes the header of datafile or something
> like that..
>
> Can you take me further?
>
> Thanks again.
>
> -----Original Message-----
> From: Ganesh Raja [SMTP:[Email Address Removed] Sent: Monday, September 30, 2002 10:02 AM
> To: LazyDBA.com Discussion
> Subject: RE: tablespace offline & backup mode difference
>
> Offline Tablespaces cannot be accessed.
>
> Backup Mode Tablespaces can be Accessed.
>
> The concepts manual - Is Very Good ... ;)
>
> HTH
>
> Best Regards,
> Ganesh R
> Tel : +971 (4) 397 3337 Ext 420
> Fax : +971 (4) 397 6262
> HP : +971 (50) 745 6019
> ============================================
> Live to learn... forget... and learn again.
> ============================================
>
>
>
> -----Original Message-----
> From: Deepak Kulkarni [mailto:deepak.[Email Address Removed]
> Sent: Monday, September 30, 2002 8:23 AM
> To: LazyDBA.com Discussion
> Subject: tablespace offline & backup mode difference
>
>
> Hi,
>
> What's the exact difference between as far as ORACLE's INTENAL OPERATION
> IS
> CONCERNED BETWEEN.
>
> A.'ALTER TABLESPACE <TABLESPACE_NAME> OFFLINE &
>
> B.'ALTER TABLESPACE BEGIN BACKUP'.
>
> Regards
> Deepak Kulkarni
> Sr. Software Engineer
> > CyberTech Systems and Software Ltd.
> > B-65, CyberTech House, J B Sawant Marg,
> > Rd. No. 21, Wagle Estate, Thane 400 604.
> > Call: 583 46 43/44/45 Extn 2241
> > ===============================================
> > "No major application will run in Third Normal Form"
> > George Koch --- ORACLE8 : The complete
> > Reference ===============================================
> >
> >
> >
> >
> >
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------------------------------------------------------------------------
> --
> -------------------
> Any opinions, expressed or implied,presented are solely those of the
> author
> and do not necessarily represent those of GTFS.
> --------------------------------------------------------------------------
> --
> -------------------
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002

Oracle LazyDBA home page