Hot Backup

[Fiza15]

Hi
I dont get why this cammand works at my school that has 8i but not at home with 9i...i am new in this field see if u ppl can advice me some....Thanks

Alter tablespace temp begin backup;
ORA-03217: Invalid option for alter temporary tablespace

[marist89]

You can't execute this command on a temporary tablespace.

[Fiza15]

Thanks Jeff but it sounds like Temp is not Temporary tablespace...if so why is this cammand works at my school....what you mean by temporary tablespace...i appreciate ur help

[marist89]

http://otn.oracle.com/docs/products/...space.htm#4682

[sreddy]

Fiza,

Thats a valid command for 8i and it works @ your school as you are using 8i. Its not a valid command in 9i if you are using LMTs for temporary table space. Here you see the restriction in 9i SQL Command reference.


BEGIN BACKUP
Specify BEGIN BACKUP to indicate that an open backup is to be performed on the datafiles that make up this tablespace. This clause does not prevent users from accessing the tablespace. You must use this clause before beginning an open backup.

Restrictions: You cannot specify this clause for a read-only tablespace or for a temporary locally managed tablespace.

http://tahiti.oracle.com/pls/db901/d...?section=79916

[Edited by sreddy on 06-21-2002 at 11:48 AM]

[marist89]

Originally posted by sreddy
Fiza,

Thats a valid command for 8i and it works @ your school as you are using 8i. Its not a valid command in 9i if you are using LMTs for temporary table space. Here you see the restriction in 9i SQL Command reference.

Ah, it's not a valid command in 8i either:

SQL> create temporary tablespace tmp1
  2  tempfile 'e:\oradata\nt817\tmp101.dbf'
  3  size 4M
  4  extent management local uniform size 256K;

Tablespace created.

SQL> alter tablespace tmp1 begin backup;
alter tablespace tmp1 begin backup
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

Without knowing the details, I would guess the tablespace at school is not designated as a temporary tablespace.

[sreddy]

Jeff,

Seems little confusion. I was referring to his school version of the database not what kinda tablespaces they were using. I have assumed that it works means they have dictionary managed tablespaces. Know I had the same problem when I created LMT for TEMP on 8i. Let me go and correct it.

I admit, I have not expalined it right.

[sreddy]

Thats a valid command for DMTs (Dictionary Managed Tablespaces). Its not a valid command if you are using LMTs for temporary table spaces.

[Fiza15]

Thanks Jeff and Sam for helping me here i need to check what we have in school given below is my home TEMP info:

TABLESPACE_NAME CONTENTS STATUS ALLOCATIO LOGGING
TEMP TEMPORARY ONLINE UNIFORM NOLOGGING