Restore Readonly Tablespace Via Partial Clone
- From: Bob <orcl@xxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 02 May 2006 19:46:23 -0400
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."
--
//www.freelists.org/webpage/oracle-l
Other related posts: