RMAN-20001: target database not found in recovery catalog
1、使用catalog時,show all報錯
[oracle@liuqi1 ~]$ rman target system/oracle@test1 catalog cata/cata@catadb
Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 5 15:02:00 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: test1 (DBID=2082231315)
connected to recovery catalog database
RMAN> show all;
RMAN configuration parameters for database with db_unique_name test1 are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 05/05/2015 15:02:03
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
2、將資料庫註冊到catalog
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
3、成功
RMAN> show all;
RMAN configuration parameters for database with db_unique_name test1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_test1.f'; # default
RMAN>
[oracle@liuqi1 ~]$ rman target system/oracle@test1 catalog cata/cata@catadb
Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 5 15:02:00 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: test1 (DBID=2082231315)
connected to recovery catalog database
RMAN> show all;
RMAN configuration parameters for database with db_unique_name test1 are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 05/05/2015 15:02:03
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
2、將資料庫註冊到catalog
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
3、成功
RMAN> show all;
RMAN configuration parameters for database with db_unique_name test1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_test1.f'; # default
RMAN>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/27126919/viewspace-1623907/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【RMAN】RMAN-20001: target database not found in recoveryDatabase
- Duplicating a Database Without Recovery Catalog or Target ConnectionDatabase
- RMAN-20002: target database already registered in recovery catalog 解決方法Database
- RMAN-05541: no archived logs found in target databaseHiveDatabase
- Creation Of Rman Duplicate Without Target And Recovery Catalog Connec-1113713.1
- RMAN 11GR2 : DUPLICATE Without Target And Recovery Catalog Connection_874352.1
- Create recovery catalog Configure Recovery Manager
- Recovery Catalog creation and MaintenanceAINaN
- As 除錯 no target device found除錯dev
- 解決RMAN中 recovery catalog database: ORA-00955: name is already used by an existing objectDatabaseObject
- oracle 之recovery directory databaseOracleDatabase
- 對於Database recovery的理解Database
- Impact of Database Recovery and Flashback Database on the TDE Wallet_1327519.1Database
- 11g rman新特性 duplicate target database for standby from active databaseDatabase
- Oracle OCP IZ0-053 Q241(RMAN Recovery Catalog Keep)Oracle
- Bug 13250486 : ADD STANDBY DATABASE FOR TARGET WITH FLASHBACK ON FAILS WITH ERRDatabaseAI
- ORA-02062: distributed recovery 引起的 ORA-02019: connection description for remote database not foundREMDatabase
- Common Causes and Solutions on ORA-376 Error Found in Backup & RecoveryError
- 恢復目錄資料庫(Recovery Catalog)作用及演示例項資料庫
- 釋出android apk,Error running app: No target device found.AndroidAPKErrorAPPdev
- oracle database backup and recovery user's guide part IVOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part IIIOracleDatabaseGUIIDE
- 第4章 資料庫恢復 Database Recovery資料庫Database
- RMAN-20005: target database name is ambiguousDatabase
- ORA-02024: database link not foundDatabase
- OCP-IZO-053_QUESTION390_ Flashback Database recovery point parametersDatabase
- oracle database backup and recovery user's guide part VII & VIIIOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part V & VIOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part I & IIOracleDatabaseGUIIDE
- 【RMAN】RMAN-05001: auxiliary filename conflicts with the target databaseUXDatabase
- Incorrect MEMORY_MAX_TARGET (> Available RAM) Can Lead To Database HangsAIDatabase
- 使用Duplicate target database命令恢復線上oracle datagard備庫DatabaseOracle
- RMAN-05517: temporary file conflicts with file used by target database(zt)Database
- Causes and Solutions on ORA-1113 Error Found in Backup & Recovery_183367.1Error
- ORA-1578 Corrupt Block Found in Encrypted Database (Doc ID 1329437.1)BloCDatabase
- PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.16.00.00 in TARGET database isSQLPackageRESTDatabase
- 編譯opencv 提示opencv_sfm links to target absl::log but not found解決辦法編譯OpenCV
- Catalog backuppiece ( regsiter a backup piece to the catalog )