Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-19634 during recovery

435383Jun 12 2006 — edited Jun 12 2006
Hi All,

On my database the datafile belonging to UNDO tablespace is corrupted, and that cause the database to be down automatically. For the recovery using RMAN I started the DB in mount and try to restore the UNDO tbs.
The restore process was successfull but I got ORA-19634 while recovering the tablespace.

The log is :

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /opt/oracle/oradata7/undotbs01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/opt/oracle/orabackup/XXXXX_XXXX_1.rmn tag=TAG20060612T130252 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 12-JUN-06

Starting recover at 12-JUN-06
using channel ORA_DISK_1

starting media recovery

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/12/2006 13:52:30
ORA-19634: filename required for this function

Please suggest.. I am using ORACLE 9.2.0.6.0

Thanks in advanced
Bhupinder
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2006
Added on Jun 12 2006
7 comments
1,355 views