Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN problem

Re: RMAN problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 19 Jan 2006 21:52:06 +0100
Message-ID: <tuuvs11g7ath0sai5b2j92oc9j94nk9j1n@4ax.com>


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 DBA
Received on Thu Jan 19 2006 - 14:52:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US