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!

while upgrading, v$recover_file is having entries

user12052260May 10 2010 — edited May 10 2010

Hi All,

Oracle version 9.2.0.4
upgrading to 10.2.0.4
Os : HP-UX 11.11

Am trying to upgrade from 9i to 10g, and gone through Complete checklist...there i have seen
"v$recover_file should return no rows"
But in my database v$recover_file is having some datafiles like
>
14:13:00 SQL> select * from v$recover_file;

FILE#ONLINE ONLINE_ERROR CHANGE#TIME
------------------------------------------------------------------------------------------------------------
6OFFLINEOFFLINEFILE MISSING 0
7OFFLINEOFFLINEFILE MISSING 0
8OFFLINEOFFLINEFILE MISSING 0
10OFFLINEOFFLINEFILE MISSING 0
11OFFLINEOFFLINEFILE MISSING 0
>

these are old datafiles ...
for the same tablespaces ...now we are having another datafiles which are active.

So please suggest me will this impact the upgrade process in any manner ..?
and advice me better way to overcome this...

Thanks in Adavance
Vamshi

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2010

Added on May 10 2010

#general-database-discussions

17 comments

2,444 views