03-15-2013 04:43 PM
I'm trying to backup the oracle db to my MSDP diskpool. Me and the Oracle admin followed this guide http://www.symantec.com/connect/articles/quick-oracle-backup-templete.
We went through all the steps but when running the backup it fails with status 6. The error in the RMAN log shows the following. Just seeing if anybody knows what this error means. "cannot use backup/restore functions while using dispatcher".
INF - Begin progress logging for process: (18801) INF - Using policy p01_oracle_bronze_disk to perform a server directed Oracle Stream Based backup. INF - Starting Oracle Recovery Manager. INF - Using: /u01/sq/ora_1/db/11.2.0.3/bin/rman INF - Connection info: target 'SYS/*****@BBIVR01D' nocatalog INF - Start of Recovery Manager input. INF - # ----------------------------------------------------------------- INF - # RMAN command section INF - # ----------------------------------------------------------------- INF - RUN { INF - ALLOCATE CHANNEL ch00 INF - TYPE 'SBT_TAPE'; INF - SEND 'NB_ORA_CLIENT=cavdcdds003-bkp,NB_ORA_SID=BBIVR01D,NB_ORA_SERV=cavnbu,NB_ORA_POLICY=p01_oracle_bronze_disk,NB_ORA_PARENT_JOBID=210792'; INF - BACKUP INF - INCREMENTAL LEVEL=0 INF - FORMAT 'bk_u%u_s%s_p%p_t%t' INF - DATABASE; INF - RELEASE CHANNEL ch00; INF - # Backup Archived Logs INF - sql 'alter system archive log current'; INF - ALLOCATE CHANNEL ch00 INF - TYPE 'SBT_TAPE'; INF - SEND 'NB_ORA_CLIENT=cavdcdds003-bkp,NB_ORA_SID=BBIVR01D,NB_ORA_SERV=cavnbu,NB_ORA_POLICY=p01_oracle_bronze_disk,NB_ORA_PARENT_JOBID=210792'; INF - BACKUP INF - FORMAT 'arch_u%u_s%s_p%p_t%t' INF - ARCHIVELOG INF - ALL INF - DELETE INPUT; INF - RELEASE CHANNEL ch00; INF - # Control file backup INF - ALLOCATE CHANNEL ch00 INF - TYPE 'SBT_TAPE'; INF - SEND 'NB_ORA_CLIENT=cavdcdds003-bkp,NB_ORA_SID=BBIVR01D,NB_ORA_SERV=cavnbu,NB_ORA_POLICY=p01_oracle_bronze_disk,NB_ORA_PARENT_JOBID=210792'; INF - BACKUP INF - FORMAT 'ctrl_u%u_s%s_p%p_t%t' INF - CURRENT CONTROLFILE; INF - RELEASE CHANNEL ch00; INF - } INF - End of Recovery Manager input. INF - Start of Recovery Manager output. INF - Usage: ulimit [-HSalimits] [limit] INF - Recovery Manager: Release 11.2.0.3.0 - Production on Fri Mar 15 14:30:13 2013 INF - connected to target database: BBIVR01D (DBID=4054444068) INF - using target database control file instead of recovery catalog INF - RMAN-00571: =========================================================== INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== INF - RMAN-00571: =========================================================== INF - RMAN-03009: failure of allocate command on ch00 channel at 03/15/2013 14:30:18 INF - ORA-19550: cannot use backup/restore functions while using dispatcher INF - Recovery Manager complete. INF - End of Recovery Manager output. INF - End Oracle Recovery Manager. |
03-17-2013 09:34 AM
Does this link help ?
https://forums.oracle.com/forums/thread.jspa?threadID=762494
03-18-2013 03:01 PM
Thanks for the link Nicolai, That helped but now we get another error. Just waiting for the Oracle DBA to help me look into this one as well. Hes new to this as well so its trial and error for now.
INF - ORA-12520: TNS:listener could not find available handler for requested type of server