My Oracle Support Banner

ORA-38780 Unable To Drop Restore Point (Doc ID 2442149.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1 to 18]
Information in this document applies to any platform.


NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Database Name: BPS2X1
Restore Point: BEFORE_UPDATE_2018081


The query below showed there isn't a restore point in the database controlfile.

SQL> select * from v$restore_point;

no rows selected

But the restore point BEFORE_UPDATE_20180810 exists in the RMAN catalog database. There is an inconsistency between the database and RMAN catalog database.

RMAN> list restore point all;

SCN RSP Time Type Time Name

---------------- --------- ---------- --------- ----
13682114514394 10-AUG-18 BEFORE_UPDATE_20180810


RMAN> drop restore point BEFORE_UPDATE_20180810;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 08/10/2018 16:38:09
ORA-38780: Restore point 'BEFORE_UPDATE_20180810' does not exist.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.