Here is the scenario

HP UX, 10G R1, DW, noarchivelog, cold backup only

Attempt partial clone to recover data from one tablespace
Tablespace X contains datafiles 1-6

Tablespace X was put in readonly mode on April 2 - files have timestamp
of April 2
Cold backup was taken on April 7 system & sysaux have April 7 as time stamp.

We want to recover from April 2

I request the datafiles from April 7 tape, and attempt the partial clone
by creating a new control file pointing to the restored system, sysaux
and datafiles 1-6

Create the control file, attempt to open with resetlogs, I get the message

"Datafile 1 not restored from a sufficiently old backup"
(FWIW... datafile 1 *is* older the system/sysaux datafiles)

Looking at v$recover_file (as pointed out by Jeremiah Wilton last week)
for discrepancies for the scn, and of course, datafile 1-6 are one scn
-- and system and sysaux are a different scn.

So, can readonly tablespaces be restored via partial clone? Im thinking
the scn (or similar identifier) is kept in the binary control, which
wold "glue" the 2 different groups of datafiles together. Which is
"missing" from the system sysaux datafiles.

??

Openfor suggestions

Thanks !

Bob

--
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."

--
http://www.freelists.org/webpage/oracle-l