Database Backup and Recovery (MOSC)

MOSC Banner

Datafiles not showing after database recovery

edited Sep 10, 2019 12:58AM in Database Backup and Recovery (MOSC) 9 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center