RMAN and tempfiles

From: <dbaplusplus_at_hotmail.com>
Date: 31 Jul 2005 14:54:02 -0700
Message-ID: <1122846842.271645.122980@g47g2000cwa.googlegroups.com>

Oracle database 9.2.0.5 or 10.1.0.3
Platforms - Windows 2000 or HP UNIX 11i

When I do a RMAN database backup, I do not see tempfiles backed up. Only database files are backed up and shown in RMAN backup log.

When I do a full restore of database, I do not see tempfile restored (not shown in log), yet I know sometimes tempfile gets created (looking at v$tempfile). However, some of my older backups, I have seen tempfile does not get recreated and I have to create it myself after restore.

Is creation of tempfile version dependent (10g vs 9i)? Will appreciate clarfification on it.

Yes, I have read RMAN manuals.

Thanks. Received on Sun Jul 31 2005 - 16:54:02 CDT