RMAN-03002 ocurrs to restored database from backup configurated to maximize availability

RMAN-03002 ORA-03113 ORA-03114 – When restore database from dataguard set to maximize availability

Cuando tomamos un backup de una base de datos configurada en maxima disponibilidad es importante recordar que al momneto de realizar la apertura de la base con el comando OPEN RESETLOGS, previamente la pasemos a maxima performance, por que ocurre que si no lo hacemos la base cae directamente, bajo el error:

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 07/22/2010 19:34:04
ORA-03113: end-of-file on communication channel
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 07/22/2010 19:34:04
ORA-03113: end-of-file on communication channel

Entonces, luego de ejecutar las tareas de RESTORE , RECOVER y como paso previo al OPEN RESETLOGS , ejecutamos en la consola SQL el comando siguiente:

SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
Database altered.

Asi , al quedar configurada en MAXIMA PERFORMANCE, podemos abrir la base tranquilamente y sin errores.

RMAN> ALTER DATABASE OPEN;    

using target database control file instead of recovery catalog
database opened