Re: Tablespace Backup question

On Fri, 2 Jun 2000, Mayan Cheriya wrote:

> I have a small basic question. If I say
> Alter Tablespace 't.s name' Begin Backup, where is
> this
> backup getting stored. Is there any init.ora
> parameter which controls this one. couldn't
> find anything in the manual.

Mayan:

You need to do some reading in the Backup and Recovery manual, and concepts manual. This command does not back anything up. It places the underlying datafiles of the tablespace in a frozen state, that is Oracle will not write to these files while in hotbackup mode. You have to do the work of backing up the file while it's in this mode. You can use an OS command like cp (or dd if you're using raw I/O). Copy the datafiles to another disk, or to tape, then take the tablespace out of backup mode. Received on Mon Jun 05 2000 - 14:35:57 CDT