Unable to verify Oracle temporary tablespace which is restored by FS plugin. (80254)

Date - 01/2008
Affected Product & Version - NetVault: Backup 7.4.5 and later
Affected Module & Version - n/a
OS Version - All supported Unix/Linux
Application Information - All supported Oracle


Description:
Unable to verify Oracle temporary tablespace which is restored by FS plugin.


Symptoms:
Unable to access to temporary tablespace with error similar to following in Oracle alert log.


ORA-01186: file 201 failed verification tests
ORA-01122: database file 201 failed verification check
ORA-01110: data file 201: '/u01/app/oracle/oradata/ORCL/temp01.dbf'
ORA-01200: actual file size of 1928 is smaller than correct size of 2560 blocks
:
:
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/u01/app/oracle/oradata/ORCL/temp01.dbf'

This situation can happen when the online temporary tablespace dbf file is backed up/restored via FS plugin.

Recreate the temporary tablespace manually from SQL by the "create temporary tablespace" command. For example,

1. Drop the existing tablespace and then delete the data file created for the temporary tablespace.

SQL>DROP TABLESPACE TEMP INCLUDING CONTENTS;

$ ls /oracle/oradata/xxx/
$ rm -f /oracle/oradata/xxx/

2. Create temporary tablespace again.

SQL> CREATE TEMPORARY TABLESPACE temp
?TEMPFILE '/oracle/oradata/xxx/ '
?SIZE 256M AUTOEXTEND on NEXT 1024K MAXSIZE 2048M
?EXTENT MANAGEMENT LOCAL;