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: Chuck <skilover_nospam_at_bluebottle.com>
Date: Thu, 19 Jan 2006 17:36:40 GMT
Message-ID: <I6Qzf.8916$Bn4.780@trndny08>


DMina_at_laiki.com wrote:
> Yes i did bring the tablespace online! If i did not then our
> application would not work!
> Maybe i should use the ALTER DATABASE command instead of ALTER
> TABLESPACE?
>

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.

If not, let us know what the problem turned out to be once you figure it out. We're all here to lurn. :-)

-- 
To reply by email remove "_nospam"
Received on Thu Jan 19 2006 - 11:36:40 CST

Original text of this message

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