ORA-38780 Unable To Drop Restore Point

刘泽宇

目标：
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.


处理方法：
The restore point BEFORE_UPDATE_20180810 was created before database resetlogs.

RMAN> list incarnation of database;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
12101 12116 BPS2X1 1302456789 PARENT 1 07-JUL-14
12101 12102 BPS2X1 1302456789 PARENT 1594143 05-DEC-16
12101 28177 BPS2X1 1302456789 PARENT 13682114508599 10-AUG-18
12101 28755 BPS2X1 1302456789 CURRENT 13682114514396 10-AUG-18

The restore point BEFORE_UPDATE_20180810 belongs to the prior database incarnation.

The query below returns one row.

SQL> select RSPNAME from nrsp;

RSPNAME
--------------------------------------------------------------------------------
BEFORE_UPDATE_20180810

Option 1:  Delete the restore point from the RMAN catalog database.

SQL> select * from nrsp where RSPNAME = 'BEFORE_UPDATE_20180810';
SQL>delete nrsp where RSPNAME = 'BEFORE_UPDATE_20180810';


Or

#1: Connect to the RMAN catalog database
#2: Unregister datebase  (removes all database entries from the RMAN catalog)
#3: Register database (registers all database entries from the controlfile to the RMAN catalog because of no restore points in the controlfile

so that the RMAN catalog database will be sync up with the database controlfile.)