ORA-19550: cannot use backup/restore functions while using dispatcher
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of delete command at 04/25/2014 19:00:37
- ORA-19550: cannot use backup/restore functions while using dispatcher
RMAN> register database;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 05/07/2007 10:32:31
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 05/07/2007 10:32:31
ORA-19550: cannot use backup/restore functions while using dispatcher
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 05/07/2007 10:32:31
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 05/07/2007 10:32:31
ORA-19550: cannot use backup/restore functions while using dispatcher
ORA-19550 cannot use backup/restore functions while using dispatcher |
Cause | An attempt was made to use backup/restore functions while connected to the dispatcher in a multi-threaded server. This is not allowed because the device that is used for backup and restore must remain allocated to a single process. |
Action | Connect directly to the instance then re-execute the backup or restore function. |
因db配置為MTS,修改tnsnames.ora檔案把connect mode改為dedicated即可。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/2317695/viewspace-1148144/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN : Consistent Backup, Restore and Recovery using RMAN (Doc ID 162855.1)REST
- SQL Server Backup & RestoreSQLServerREST
- TFS Express backup and restoreExpressREST
- backup and restore tipsREST
- Cold backup and restore the entire databaseRESTDatabase
- DBMS_BACKUP_RESTORE.DBMS_BACKUP_RESTORE用於特殊情況下的恢復REST
- read only tablespace backup restoreREST
- 轉貼_RMAN-DBMS_BACKUP_RESTOREREST
- Cannot restore segment prot after reloc:Permission deniedREST
- How to use rman backup a noarchivelog databaseHiveDatabase
- db2備份恢復(backup restore)DB2REST
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- Manually Backup - Restore or Clone a Database to Another Node [ID 562556.1]RESTDatabase
- How to Restore the Database Using AMDU after Diskgroup CorruptionRESTDatabase
- you cannot use this control in design mode。
- 使用RMAN backup和restore方式部署物理備庫REST
- 備份恢復統計資訊 backup and restore statsREST
- 11g asm md_backup md_restoreASMREST
- recover database using backup controlfileDatabase
- 通過dbms_backup_restore修改oracle的dbidRESTOracle
- 【ASM】ASMCMD 之md_backup,md_restore介紹ASMREST
- RMAN-06100: no channel to restore a backup or copy of datafileREST
- Golang Cannot use ss(type AAA) as type AAA in map indexGolangIndex
- recover database using backup controlfile理解Database
- recover database using backup control fileDatabase
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM
- cdc目標端資料庫初始化(backup restore)資料庫REST
- 使用dbms_backup_restore進行資料庫恢復REST資料庫
- RMAN-06023 no backup or copy of datafile 1 found to restoreREST
- cannot use '/dev/da1': must be a block device or regular filedevBloC
- Using RMAN REPORT NEED BACKUP with Different Retention Policies
- recover database until cancel using backup controlfileDatabase
- Recover database using backup controlfile until cancelDatabase
- You may fail to backup log or restore log after TDE certification/key rotation.AIREST
- 【MOS】How to backup or restore OLR in 11.2/12c Grid InfrastructureRESTASTStruct
- backup or restore OLR in 11.2 Grid Infrastructure (Doc ID 1193643.1)RESTASTStruct
- DBMS_BACKUP_RESTORE用於特殊情況下的恢復REST
- PHP Fatal error: Cannot use PhpParser\Node\Scalar\String as StringPHPError