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>