This content has been marked as final. Show 5 replies
at mount stage..issue the following query..
select name,checkpoint_change#,last_change# from v$datafile;
if last_change# column is null..you need instance recovery(Automatically done by oracle before opening the database).
select * from v$recover_file;
if any file are present,you need media recovery(which you need to do).by querying the following you might find which logs are needed
for ur media recovery.
select * from v$recovery_log;