Re: Table recovery using Standby Database and RMAN

Kaptain524 wrote:
> Okay, I tried making the LMT in the standby database, but it didn't
> work. Here is the error I got:
>
> SQL> create temporary tablespace xtemp tempfile 'd:\xtemp.dbf'
> 2 size 20M reuse extent management local uniform size 16M;
> create temporary tablespace xtemp tempfile 'd:\xtemp.dbf'
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-16000: database open for read-only access
>
> I basically used the example right out of the documentation.

Come on. Think about it. Your database is open read-only, and what does a 'create anything' DDL get converted into? Correct: DML on the data dictionary. (In this specific case, it will be inserts into TS$, amongst others) Reckon you are going to be allowed to do DML on SYSTEM tables when the thing is in a read-only state?

> According to the documentation, the "size" and "extend management
> local" and "uniform size" parts are totally optional. It claims that
> because it is a temporary tablespace, it is automatically local and
> uniform. Anyway, it didn't include any considerations for a read-only
> database. All it said was that it can be done.
> Has anyone successfully created the temp tablespace for a read-only
> database? What do I need to do to make it work?
>

Make it read-write. You can't expect DDL commands to work when the database is read-only. Any of them.

It's the subsequent USE of the temporary tablespace that is permitted in read-only databases, precisely because the extent allocations that happen within them are handled by the tablespace's bitmap, not data dictionary tables UET$ and FET$.

You're supposed to be using this sort of temporary tablespace anyway in 8i and 9i, because they perform a bit more efficiently, and multiple simultaneous sorts won't swamp the one set of data dictionary tables as they start. So when you set up your standby database, the tempfile temporary tablespace is assumed to be already part of that which you need to clone.

Regards
HJR
> It would be nice if I could just use a regular duplicate instance.
> But it appears that I have to use a standby database to make RMAN
> happy. I cannot recover a duplicate to a point in time, not even when
> I create it. RMAN will only perform recovery on a standby database.
> So I have to use a standby. And currently the only way that I can
> successfully recover it to a specific point in time is to fully
> rebuild it every time. I really don't think this is the only way.
> There must be something that I am missing to get the recovery to work
> on the standby database without using the DUPLICATE command. Even so,
> it will suffice to accomplish the required task. At this point, I
> mainly want to be able to export from the standby database.
>
> Thanks,
> Kaptain524
Received on Fri Jan 24 2003 - 16:13:22 CST