Datafiles not showing after database recovery
Hi,
We have recovered our Test database from Prod Database Rman Backup.
Database recovery is showing successfull and the Test DB is open with resetlogs as shown below,
archive log filename=/oradata6/AFISDB/redolog/redo010201.log thread=1 sequence=269
archive log filename=/oradata7/AFISDB/redo010301.log thread=1 sequence=270
archive log filename=/oradata7/AFISDB/redo010101.log thread=1 sequence=271
media recovery complete, elapsed time: 00:03:06
Finished recover at 19/09/09 05:34:54
RMAN> exit;
Recovery Manager complete.
Database altered.
STATUS
------------
OPEN
OPEN
==============================================================
==============================================================
DATABASE RECOVER SUCCESSFULL
==============================================================
But when we check the number of datafiles in PROD and TEST DB, there is a mismatch.
2 datafiles are missing, file #761 and file#762.