standby db creation with RMAN-06136 and ORA-19723

From: <hongfeng.sun_at_gmail.com>
Date: 31 Mar 2006 02:39:09 -0800
Message-ID: <1143801549.128494.230340@e56g2000cwe.googlegroups.com>

Hi,
My primary db (10g R2 Soalris) has a tablespace created by transported it from other database (using oracle transportable tablespace ). it has two datafiles (aa01 and bb02.dbf). The tablespace is read writeable.

I then tred to create a logical standby db for the primary db using RMAN. During creation, Oracle report such error:

Part one:
ORA-19502: write error on file "/oracle/oradata/**/aa01.dbf" ORA-27063: number of bytes read/written is incorrect SVR4 Error: 28: No space left on device

This is weird since there are plenty space left on disk

Part two:
creating datafile fno=7 name=/oracle/oradata/**/bb02.dbf RMAN-06136: ORACLE error from auxiliary database: ORA-19723: Cannot recreate plugged in read-only datafile 7

The message is misleading. bb02.dbf belongs to a read write tablespace.

did anyone know anything about that? is it a bug either in transportable db or logical standby?

thanks in advance. Received on Fri Mar 31 2006 - 04:39:09 CST