Problems with RMAN\TSM
689098Mar 4 2009 — edited Mar 5 2009Hi,
I was trying to implement a backup policy using RMAN. But, when I execute the statement BACKUP DATABASE, the RMAN returns the message above:
Starting backup at 04-MAR-09
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/04/2009 16:36:54
RMAN-10015: error compiling PL/SQL program
RMAN-10014: PL/SQL error 0 on line 27 column 3: Statement ignored
RMAN-10014: PL/SQL error 306 on line 27 column 14: wrong number or types of arguments in call to 'DEVICEALLOCATE'
RMAN's configuration is:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 28 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=C:\oracle\ora92\bin\orasbt.dll' PARMS 'ENV=(TDPO_OPTFILE=C:\Progra~1\Tivoli\TSM\AgentOBA64\tdpo.opt)';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA92\DATABASE\SNCFRIPROD27.ORA'; # default
RMAN configuration has no stored or default parameters
I have the following enviroment:
- Windows Server 2003 R2 Enterprise 64x Edition;
- Oracle9i Enterprise Edition Release 9.2.0.8.0
- IBM Tivoli Storage Manager Client for Databases - Oracle
Regards,
Thiago