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

About Juan Andres
Consultant | Oracle DBA & IT Specialist | LinuxUnix Administrator | Father | Musician | Farmer | Environmentalist | Writer | Builder | Buenos Aires · burzaco.wordpress.com

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

  1. Pingback: RMAN-03002 ocurrs to restored database from backup configurated to maximize availability « DbRunas – Noticias y Recursos sobre Bases de Datos

  2. Hello, I would like to subscribe for this blog to take httest updates, therefore where can i do it please help.

  3. It’s an remarkable post for all the web users; they will get benefit from it
    I am sure.

  4. Antwan says:

    Wonderful blog! Do you have any recommendations for
    aspiring writers? I’m planning to start my own website soon but I’m a little
    lost on everything. Would you advise starting wijth a free platform like WordPress
    or go for a paid option? There are so many options out there that I’m completely confused ..
    Any ideas? Many thanks!

  5. I like reading through a post thawt will make people think.
    Also, thank you for allowing me to comment!

%d bloggers like this: