Archivo

Entradas Etiquetadas ‘RMAN’

RMAN NO SE CONECTA POR PRIVILEGIOS INSUFICIENTES

Martes, 21 de abril de 2009 Sin comentarios

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 !!!