Database Backup and Recovery (MOSC)

MOSC Banner

ORA-01455, While trying to drop a restore point

edited Nov 9, 2015 4:03AM in Database Backup and Recovery (MOSC) 3 commentsAnswered ✓

Hi,

I have two restore points and getting the following error while trying to drop any of the restore point.

DB Version: 11.2.0.3, Single instance, Non-ASM

OS: Windows Server 2008 R2 Standard 64 bit

RMAN> list restore point all;

using target database control file instead of recovery catalog

SCN              RSP Time  Type       Time      Name

---------------- --------- ---------- --------- ----

110673777357               GUARANTEED 22-JUN-15 AFTER_RESTORE

113344128039               GUARANTEED 01-JUL-15 AT_20160701

RMAN> drop restore point AFTER_RESTORE;

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

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

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

RMAN-03002: failure of drop restore point command at 11/09/2015 09:13:11

ORA-01455: converting column overflows integer datatype

RMAN> drop restore point AT_20160701;

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

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center