miércoles, 9 de agosto de 2017

Oracle RMAN TIP: Solucionar RMAN-03014, RMAN-03009, RMAN-03002

Cometiste un error a la hora de configurar los parámetros de RMAN y ahora no puedes continuar con la configuración requerida?

Intentas resetear el parámetro al valor de facto y no funciona.?

Puedes utilizar el paquete "SYS.DBMS_BACKUP_RESTORE" conectándose directamente a la instancia que deseas respaldar y cambiar el parámetro con problemas. En este ejemplo, tienes un problema con la configuración definida para el auto respaldo del "controlfile".

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 08/09/2017 21:45:39
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 08/09/2017 21:45:39
ORA-01580: error creating control backup file F:\OPT\APP\ORACLE\RMANBCK\SNCF_PROD_ORCL_ORA;\
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 123) The filename, directory name, or volume label syntax is incorrect.

RMAN> exit


Recovery Manager complete.

Ahora me conecto a la base de datos, con el usuario SYS y procedo a indicar el valor correcto.

C:\opt\app\oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN>sqlplus sys/Oraclesysqwerty as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 9 21:47:23 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

SQL> EXECUTE SYS.DBMS_BACKUP_RESTORE.CFILESETSNAPSHOTNAME('F:\opt\app\oracle\rmanbck\snapcf_db1-orcl.f');

PL/SQL procedure successfully completed.

SQL> exit
Disconnected from Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Ahora me conecto nuevamente al catalog con RMAN y verifico que pueda visualizar correctamente la configuración y ahora sí, proceder a realizar mi respaldo.

C:\opt\app\oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN>rman target sys/Oraclesysqwerty catalog rman/repo@repo

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Aug 9 21:47:54 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1477745898)
connected to recovery catalog database

RMAN> show all;

starting full resync of recovery catalog
full resync complete
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'F:\opt\app\oracle\rmanbck\PROD_ORCL_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'F:\opt\app\oracle\rmanbck/PROD_ORCL_%U' MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\OPT\APP\ORACLE\RMANBCK\SNAPCF_DB1-ORCL.F';

RMAN>

No hay comentarios:

Publicar un comentario

Te agradezco tus comentarios. Te esperamos de vuelta.