Re: Backup & Restore

See uday's answer for the how to.

It is easy to avoid data loss, all you have to do is keep all the archive log files from the moment of the begin backup command until the point of failure of the database. Of course this might mean that your disk fills up.

Problems I can envisage with your scenario.

1. The system tablespace falls over and you don't have a backup. I don't see how you would get your data back. I rather suspect it is possible with some esoteric tricks but i wouldn't bet on it.
2. some of your objects that you believe to be in the tablespace you are backing up in fact are not.
3. loss of control files meaning database does not restart.

In short i'd recommend at least a full export of your database (or user account) every week. This will give you data loss but does ensure you can recover. You could also do a full hot backup.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Legal disclaimer required by my employer
****************************************************************************
**
This email contains information intended for the addressee only.
 It may be confidential and may be the subject of legal and/or professional
privilege.
Any dissemination, distribution, copyright or use of this communication
without prior permission of the addressee is strictly prohibited.
****************************************************************************
**
"Ganesh Kamath" <ganesh.kamath_at_in.bosch.com> wrote in message
news:9km0t7$1sb$1_at_proxy.fe.internet.bosch.com...


> I want to backup/restore the tablespace.

>

> Data loss acceptable at the moment...but how difficult is it to avoid it.

 I


> don't want to go ahead with very difficult backup/recovery procedure.

>

> Thanks again.

>

> - Ganesh

>

> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message

> news:3b6e7f29$0$8505$ed9e5944_at_reading.news.pipex.net...

> > What is it you actually want to achieve? A tablespace backup or a

 database


> > backup? Is data loss acceptable or not?

 


> > Niall Litchfield

> > Oracle DBA

> > Audit Commission UK

> >

> > Legal disclaimer required by my employer

> >

>

 ****************************************************************************


> > **

> > This email contains information intended for the addressee only.

> >  It may be confidential and may be the subject of legal and/or

 professional


> > privilege.

> > Any dissemination, distribution, copyright or use of this communication

> > without prior permission of the addressee is strictly prohibited.

> >

>

>

>