Re: RMAN duplicate and read-only tablespaces

Actually the datafile was backed up through rman. In the duplicate, I'm using "set until scn" to specify the scn of my last cold backup. I can see the datafile restored to the new server. However, during the "alter database open resetlogs," I receive the ORA-01152 error.

All the datafiles have the same scn (that I specified in "set until") -- except the datafiles belonging to the read-only tablespaces (obvious, right?). The Oracle support engineer explained the scn's of all datafiles have to be the same for the database to open. Sounds great, but the point of "duplicate" is to handle such caveats (like changing dbid, recreating control files, etc).

If you read the 8.0, 8i, or even 9i documentation it leads you to believe this is possible (otw, what's the point of 'skip readonly' -- should be default behavoir because it would fail otherwise). The engineer referred me to bug #1040149 which explains my situation exactly. The problem is the report says it's fixed in 8.1.7 -- I'm using 8.1.7.4.

He closed the tar and said if I wanted to get a bug# or corrected documentation I had to open another tar. The burden of documenting bugs is placed on the customer? I can't believe it.

"Quinn Am" <quinn_zou_at_hotmail.com> wrote in message news:<41JVa.8236$9f7.956975_at_news02.tsnz.net>...
> Using rman to backup the datafile
> '/opt/oradata03/psqa/data/ps_hr_hist_table01.dbf' first before you start the
> rman duplicate.
> This will resolve the problem.
>
> "Keith" <kknauss_at_yahoo.com>
> ??????:4ddf7db5.0307290951.5295eddc_at_posting.google.com...
> > Hello Gurus,
> >
> > I am curious if anyone has used "rman duplicate" to duplicate a
> > database with read-only tablespaces?
> >
> > I recently tried this and I received:
> > ORA-01152: file 30 was not restored from a sufficiently old backup
> > ORA-01110: data file 30:
> > '/opt/oradata03/psqa/data/ps_hr_hist_table01.dbf
> >
> > Oracle support has stated this is not supported. But nowhere in the
> > Oracle RMAN Users Guide, nor the RMAN reference guide have I seen
> > this. In fact, the docs state to use the "skip readonly" clause to
> > omit these tablespaces from the duplication because they are included
> > by default.
> >
> > The support engineer was unable to provide any documentation saying it
> > was unsupported. He sent me a few bug reports that describe what I
> > was seeing, but the reports said it was fixed in 817. My target db,
> > aux db, and rman binary are 8174.
> >
> > Any help is much appreciated.
> >
> > Thanks,
> >
> > Keith
Received on Wed Jul 30 2003 - 08:38:17 CDT