RMAN NO SE CONECTA POR PRIVILEGIOS INSUFICIENTES 

En mas de una oportunidad cuado es necesario configurar por primera vez Rman en una instancia, al intentar ingresar a RMAN se cae… Uno revisa los privilegios y no hay problema …

server orcl $ cat backup_BD_sin_delete.rmn
connect target rman/rman@orcl;
run {
crosscheck archivelog all;
allocate channel t1 type ‘SBT_TAPE’;
allocate channel t2 type ‘SBT_TAPE’;
send ‘NSR_ENV=(NSR_CLIENT=SERVER,
NSR_SERVER=SERVER_RESPALDO)’ ;
backup filesperset 2 database plus archivelog;
sql ‘alter system archive log current’;
release channel t1;
release channel t2;
}

SERVER ORCL $ rman target rman/rman@ORCL;

Recovery Manager: Release 10.2.0.4.0 – Production on Sat Apr 18 19:04:25 2009

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

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

Recuerden que para que un respaldo RMAN se ejecute es necesario que la cuenta de BD tenga privilegios de SYSDBA, para esto es necesario

SERVER ORCL $ export ORACLE_SID=ORCL
SERVER ORCL $ sqlplus “/as sysdba”

SQL*Plus: Release 10.2.0.4.0 – Production on Sat Apr 18 19:05:18 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP
—————————— —– —–
SYS                            TRUE  TRUE

SQL> grant sysdba to RMAN;

Grant succeeded.

Revisemos si la cuenta RMAN ahora tiene privilegios de SYSDBA…

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP
—————————— —– —–
SYS                            TRUE  TRUE
RMAN                           TRUE  FALSE

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Finalmente es necesario verificar si es posible realizar la conexión …

SERVER ORCL $ rman target rman/rman@ORCL;

Recovery Manager: Release 10.2.0.4.0 – Production on Sat Apr 18 19:08:02 2009

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

connected to target database: ORCL (DBID=31134823333)

Excelente … conectividad a RMAN lista !!!