Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ALTER TABLESPACE xxxxx END BACKUP

ALTER TABLESPACE xxxxx END BACKUP

From: Zachary Agatstein <Zachary.Agatstein_at_atsc.allied.com>
Date: Tue, 27 Oct 1998 08:04:26 -0500
Message-ID: <714gg1$111a1@tmpsp002.tmpprv.allied.com>


As I was testing my database backup procedure, for each tablespace I was doing the following:
alter tablespace tablespacename begin backup; copy the file to the backup folder
alter tablespace tablespacename end backup;

It went fine for all of them but one: TEMPORARY_DATA. The "alter tablespace TEMPORARY_DATA end backup" command produces a "Query is executing" message, and is stuck forever.

Why is this happening, and what should I do?

Prior to performing the backup, I enabled the ARCHIVELOG mode by performing: shutdown immediate
startup mount pfile=<location of initinstancename.ora> alter database archivelog
alter database open

Thanks
Zach Agatstein Received on Tue Oct 27 1998 - 07:04:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US