This content has been marked as final. Show 8 replies
Sorry but I don't understand the question, you must specific what datafile you want to recover, not rman, i.e.:
RMAN> RECOVER DATAFILE N;<-- where N is the number of datafile
RMAN> RECOVER DATAFILE '/DATAFILE_NAME';
920273 wrote:RMAN does not decides that a file needs recovery as its a recovery tool which means it can do recovery for you but can't detect the same. From 11g onwards, Oracle has introduced data recovery advisor tool which can be used to find the media recovery to be done. As for your 2nd question, the basis is one , to keep your job alive :) .
how rman decides that a datafile requires media recovery....i.e on what basis the media recovery requirements are decided...??
PS: Always mention your 4 digit db version along with the o/s.
Use V$RECOVER_FILE To identify which files needs media recovery.
When the SCN of the datafile (in the datafile header) doesn't match the SCN for that datafile in the controlfile.
Senior Oracle DBA
thanks for reply....
do control file contain scn's value for each datafile....???
if yes...can you please tell me the query to get those scn values...
V$DATAFILE is a view on this information in the controlfile.
V$DATAFILE_HEADER is a view on the actual headers in the datafiles.
Hemant K Chitale
but i have checked the value is always same.....so when we need to perform media recovery...??
All the datafiles and the controlfile must be at the same SCN. If the controlfile is at a higher SCN, Oracle will keep attempting recovery to the SCN unless you specify an Incomplete Recovery (e.g. with a SET UNTIL clause)
Hemant K Chitale