Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ALTER TABLESPACE xxxxx END BACKUP
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