Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PITR of tablespace returns error

User_A7RKTJun 4 2017 — edited Jun 5 2017

Hi guys,

It's Oracle 12.2 on Linux 6.7 64-bit, CDB database, local undo enabled.

I am doing point-in-time recovery (PITR) of a tablespace in PDB.

I made the tablespace offline and then executed the RMAN command as follows:

RECOVER TABLESPACE pdb2:USERS UNTIL SCN 4081853 AUXILIARY  DESTINATION='/home/oracle/backup';

...

..

auxiliary instance file tspitr_nqzn_19689.dmp deleted

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 06/05/2017 01:36:31

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of sql command on default channel at 06/05/2017 01:36:29

RMAN-11003: failure during parse/execution of SQL statement: drop tablespace  USERS including contents keep datafiles cascade constraints

ORA-12919: Can not drop the default permanent tablespace

Full RMAN output attached.

Thanks!

This post has been answered by JuanM on Jun 4 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2017
Added on Jun 4 2017
1 comment
261 views