Dear all,
i have oracle 10g r2 on windows server 2003.i have a SHARED SERVER database.
i have created a DEDICATED entry for RMAN in tnsnames.ora file.
i have the following backup script for RMAN
RUN {
ALLOCATE CHANNEL ch00 TYPE DISK FORMAT 'E:\BACKUP\rmanbackup\db\%d_DB_%u_%s_%p';
backup
filesperset 4
INCREMENTAL LEVEL 0 AS COMPRESSED BACKUPSET database include current controlfile;
backup spfile;
sql "alter system archive log current";
release channel ch00;
ALLOCATE CHANNEL CH01 TYPE DISK FORMAT 'E:\BACKUP\rmanbackup\ar\al_%U';
backup
filesperset 4
AS COMPRESSED BACKUPSET archivelog all delete input;
restore database validate;
RELEASE CHANNEL CH01;
}
i have the following .bat file to run this script
set ORACLE_HOME=G:\oracle\product\10.1.0\db_1
set PATH=G:\oracle\product\10.1.0\db_1\bin
set RMAN_SCRIPT=rman_backup_L0.rcv
SET ORACLE_SID=orcl
set day=%date:~0,3%
set mm=%date:~4,2%
set dd=%date:~7,2%
set yy=%date:~-4%
set RMAN_LOG_NAME=rman_backup_L0_%yy%%mm%%dd%.log
rman target sys/etcsys@rman CMDFILE=E:\BACKUP\rmanbackup\scripts\%RMAN_SCRIPT% LOG=E:\BACKUP\rmanbackup\log\%RMAN_LOG_NAME%
when i double click the bat file , i give the following error in the logs
Recovery Manager: Release 10.1.0.2.0 - Production
Copyright (c) 1995, 2004, 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-12520: TNS:listener could not find available handler for requested type of server
it was working fine before some days. but now it is not working.
any idea how to overcome this?
Edited by: Maahjoor on 25-Feb-2013 19:59