If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I have a varchar2 column in a table, which contains binary data. We chose varchar2's columns based on how the RDBMS stores values for varchars as opposed to blobs. At least historically, blobs were stored separately and I was concerned about access times especially in light of the fact that we use select *. In addition, to
change varchar2 to blobs or raws at this point is not worth the development time.

Now we are porting our application to Oracle 10G I want to verify if RMAN can restore a table that has binary data in a varchar2 column without any data translation. So what I tried doing is placing one table that has varchar2 column with binary data into its own tablespace.

I backed up the tablespace using RMAN.

I went into SQLPLUS and dropped the tablespace including contents

I tried restoring the tablespace via RMAN and I was not succesful.

My database is in archive mode but I know I missing some step/(s) on the restoration side. That is where I need a bit of assitance.
Any help and exact syntax would be appreciated.

This message shows that you are connecting RMAN thru target database control file and not thru recovery catalog.
If you use recovery catalog, when you execute your backup,
then use recovery catalog, before executing the restore command.

If you execute your backup command using target database control file, then chances are, those entries have been aged out. And that is why your restore command no longer recognized by RMAN.