rman restore procedure

From: Antonio 6sette <bottesini_at_libero.it>
Date: Thu, 15 Dec 2005 09:15:11 +0000 (UTC)
Message-ID: <dnrc6v$s35$2@area.cu.mi.it>

Hi all,

I tried to reproduce a "case study" founded in a rman tutorial. at a certain point, after that command:

alter database mount;
restore database;
recover database noredo;
alter database open resetlogs;

the tutorial say :

"NOTE: Tempfiles are automatically excluded from RMAN backups. This requires them to be re-added at recovery time."

and tell to give the command:

SQL> ALTER TABLESPACE temp add tempfile
2 '/home/oracle/oradata/DIP/temp.dbf' size 25 M AUTOEXTEND on NEXT 10 M;

but I have an error:

  ALTER TABLESPACE temp add tempfile
  *
  ERROR at line 1:
  ORA-01268: invalid TEMPFILE clause for alter of permanent TABLESPACE

from the views I see that the temporary tablespace is ok.

SQL> SELECT * from dba_tablespaces where tablespace_name='TEMP';

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT 
---------------------------
TEMP                                 8192          40960       40960           
1                      50          0 ONLINE    TEMPORARY LOGGING   
NO  DICTIONARYUSER      NO  MANUAL DISABLED

SQL> SELECT * from dba_data_files where tablespace_name='TEMP';

FILE_NAME TABLESPACE_NAME

/home/oracle/oradata/DIP/temp.dbf TEMP

Can anyone explain me this behaviour ??

tanks in advance ...

P.S.
sorry for my english !!

-- 
#include <stdio.h>
int main(void){char c[]={10,65,110,116,111,110,105,111,32,98,97,114,98,111,110,
101,32,60,104,105,110,100,101,109,105,116,64,116,105,115,99,97,108,105,110,101,
116,46,105,116,62,10,10,0};printf("%s",c);return 0;}

Received on Thu Dec 15 2005 - 03:15:11 CST