OraFAQ Forum: Server Administration » ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions

Home » RDBMS Server » Server Administration » ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions (RHEL5 Oracle 11g 11.2.0.3 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions [message #670159]

Tue, 12 June 2018 13:02

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
I get this error on transportable tablespace.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Master table "MARCOSVVSDBAHML"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Source time zone version is 14 and target time zone version is 18.
Starting "MARCOSVVSDBAHML"."SYS_IMPORT_TRANSPORTABLE_01": marcosvvsdbahml/******** parfile=parm.f
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
Processing object type TRANSPORTABLE_EXPORT/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/COMMENT
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions

Job "MARCOSVVSDBAHML"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at Mon Jun 11 18:49:10 2018 elapsed 0 00:01:23

The transport finish with two tablespace on read only mode.

In the source database:

1. I shutting with immediate.

2. After, startup with restrict mode.

3. Turn the tablespace on read only.

4. And export with TTS.

Thanks,

Report message to a moderator

Re: ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions [message #670160 is a reply to message #670159]

Tue, 12 June 2018 13:12

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions
 *Cause: An attempt was made to alter a tablespace read-only while there were
         changes in the tablespace made by in-doubt distributed transactions.
         The in-doubt transactions must commit or rollback to ensure that
         there is no undo for a tablespace before it can be made read-only.
 *Action: Any in-doubt transactions that made changes to the tablespace must
          be resolved.

Query DBA_2PC_PENDING.

[Updated on: Tue, 12 June 2018 13:12]

Report message to a moderator

Previous Topic:	patching 12c database in read only mode ?
Next Topic:	ORA-29701: unable to connect to Cluster Synchronization Service

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 16:57:25 CST 2025