networker + RMAN
437541Apr 29 2008 — edited Apr 29 2008We are in process of implementing RMAN backup’s with networker. We have installed and configured mno module and have run the script manually and works fine. But when I schedule to run it from networker, I got a tns access denied problem because I had not put the user_name/password in the script and was using connect target /
Below is my script
Works manually
connect target /
run {
set command id to 'networker_testdb_bkp';
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=OracleDaily)';
backup database plus archivelog;
release channel t1;
release channel t2;
}
works only if I
connect target user/password@service_name
run {
set command id to 'networker_testdb_bkp';
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=OracleDaily)';
backup database plus archivelog;
release channel t1;
release channel t2;
}
RMAN> SHOW ALL;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oraprd/product/10.2.0/db_1/dbs/snapcf_testdb.f'; # default
Also, to clarify, can anyone advise what happens when you give
RMAN> connect target / => as which user is the db connected to from RMAN ???
can anyone advise. thanks