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 )
ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions [message #670159] Tue, 12 June 2018 13:02 Go to next message
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,
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 Go to previous message
Michel Cadot
Messages: 66053
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Mon Dec 17 08:15:12 CST 2018