Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN problem
On Thu, 19 Jan 2006 17:36:40 GMT, Chuck
<skilover_nospam_at_bluebottle.com> wrote:
>If RMAN can't find the datafile, it probably didn't get changed in the
>database, or got changed to something else (a type-o). See if you can
>find it with this...
>
>select file_name from dba_data_files where tablespace_name = 'YOUR_TS_NAME';
>
>My money says it comes up with something other than the current name of
>the file.
likely the file_name will be MISSING<0-padded number>
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Jan 19 2006 - 14:52:06 CST
![]() |
![]() |