News

  1. Home
  2. All posts
All posts, Backup, Oracle by Team Ajara

Error while creating Restore Point

Error while creating Restore Point.

Error:

SQL> create restore point before_patch guarantee flashback database ;
create restore point before_patch guarantee flashback database
*
ERROR at line 1:
ORA-38784: Cannot create restore point ‘BEFORE_PATCH’.
ORA-01153: an incompatible media recovery is active

 

Error:

$oerr ora 01153

Cause:

Attempted to start an incompatible media recovery or open resetlogs during media recovery or RMAN backup . Media recovery sessions are incompatible if they attempt to recover the same data file. Incomplete media recovery or open resetlogs is incompatible with any media recovery. Backup or restore by RMAN is incompatible with open resetlogs

Action:

Complete or cancel the other media recovery session or RMAN backup

Root cause:

Continuously archive backups are running from 2 scripts.

 

Backup process Verification:

$ lsof ORCL_arch_backup_11_21_23_09_30.log
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
rman 25631 oracle 5w REG 253,82 3681 3336087 ORCL_arch_backup_11_21_23_09_30.log
$

 

Note: ” lsof “means list of open files. It is a command in Unix/Linux to get the process details that is used by a particular user. Here, in this case RMAN is a user.

Solution:

comment the the archive backup in crontab

SQL> create restore point before_patch guarantee flashback database ;

Restore point created.

SQL> select name from v$restore_point
2 ;

NAME
——————————————————————————–
BEFORE_PATCH

SQL>

 

See Also: