作者:cloner 时间:05-02-16 10:26
请教Rman无法备份数据库,执行backup时报错!
请教Rman无法备份数据库,执行backup时报错!
用Rman的backup命令备份数据库时总是报错,Oracle是8.0.5的,OS是HP TRUE64。请教问题出在哪里?
以下是操作过程:
server1 > rman Recovery Manager: Release 8.0 . 5.1 . 1 - Production RMAN > connect rcvcat rman / rman RMAN - 06008 : connected to recovery catalog database RMAN > connect target sys / internal RMAN - 06005 : connected to target database : ORCL RMAN > register database ; RMAN - 03022 : compiling command: register RMAN - 03023 : executing command: register RMAN - 03026 : error recovery releasing channel resources RMAN - 00569 : ================ error message stack follows ================ RMAN - 03006 : non - retryable error occurred during execution of command: register RMAN - 07004 : unhandled exception during command execution on channel default RMAN - 10032 : unhandled exception during execution of job step 1 : ORA - 06512 : at li ne 14 RMAN - 20002 : target database already registered in recovery catalog RMAN > run{ 2 > allocate channel c1 type disk ; 3 > backup tag ' tsbase ' format ' /u01/backup/hot/rman/ts/base.20050202 ' 4 > tablespace base; 5 > release channel c1; 6 > } RMAN - 03022 : compiling command: allocate RMAN - 03023 : executing command: allocate RMAN - 08030 : allocated channel: c1 RMAN - 08500 : channel c1: sid = 52 devtype = DISK RMAN - 03022 : compiling command: backup RMAN - 03025 : performing implicit partial resync of recovery catalog RMAN - 03023 : executing command: partial resync RMAN - 08003 : starting partial resync of recovery catalog RMAN - 08005 : partial resync complete RMAN - 03026 : error recovery releasing channel resources RMAN - 08031 : released channel: c1 RMAN - 00569 : ================ error message stack follows ================ RMAN - 03002 : failure during compilation of command RMAN - 03013 : command type: backup RMAN - 06038 : recovery catalog package detected an error RMAN - 20001 : target database not found in recovery catalog
-------------------------------------------------------------------------------
-
作者:Ora-600 时间:05-02-16 10:56
target database not found in recovery catalog
target database not found in recovery catalog
你用了恢复目录了把,你的数据库还没有注册到恢复目录中呢,先执行register吧!
-------------------------------------------------------------------------------
-
作者:cloner 时间:05-02-16 11:04
RMAN > register database ; RMAN - 03022 : compiling command: register RMAN - 03023 : executing command: register RMAN - 03026 : error recovery releasing channel resources RMAN - 00569 : ================ error message stack follows ================ RMAN - 03006 : non - retryable error occurred during execution of command: register RMAN - 07004 : unhandled exception during command execution on channel default RMAN - 10032 : unhandled exception during execution of job step 1 : ORA - 06512 : at li ne 14 RMAN - 20002 : target database already registered in recovery catalog
已经注册了。
-------------------------------------------------------------------------------
-
作者:husthxd 时间:05-02-16 11:05
805?
805?
RMAN> resync database;
或者
RMAN> reset database;
看看?
-------------------------------------------------------------------------------
-
作者:cloner 时间:05-02-16 11:24
还是一样,backup时报错
还是一样,backup时报错
=============================================================== server1 > rman Recovery Manager: Release 8.0 . 5.1 . 1 - Production RMAN > connect rcvcat rman / rman RMAN - 06008 : connected to recovery catalog database RMAN > connect target sys / internal RMAN - 06005 : connected to target database : ORCL RMAN > reset database ; RMAN - 03022 : compiling command: reset RMAN - 03023 : executing command: reset RMAN - 03026 : error recovery releasing channel resources RMAN - 00569 : ================ error message stack follows ================ RMAN - 03006 : non - retryable error occurred during execution of command: reset RMAN - 07004 : unhandled exception during command execution on channel default RMAN - 10032 : unhandled exception during execution of job step 1 : ORA - 06512 : at li ne 23 RMAN - 20009 : database incarnation already registered RMAN > =============================================================== RMAN > resync catalog; RMAN - 03022 : compiling command: resync RMAN - 03023 : executing command: resync RMAN - 08002 : starting full resync of recovery catalog RMAN - 08004 : full resync complete =============================================================== RMAN > run{ 2 > allocate channel c1 type disk ; 3 > backup tag ' ts_base ' format ' /u01/backup/hot/rman/ts_base.bak ' 4 > tablespace base; 5 > release channel c1; 6 > } RMAN - 03022 : compiling command: allocate RMAN - 03023 : executing command: allocate RMAN - 08030 : allocated channel: c1 RMAN - 08500 : channel c1: sid = 104 devtype = DISK RMAN - 03022 : compiling command: backup RMAN - 03026 : error recovery releasing channel resources RMAN - 08031 : released channel: c1 RMAN - 00569 : ================ error message stack follows ================ RMAN - 03002 : failure during compilation of command RMAN - 03013 : command type: backup RMAN - 06038 : recovery catalog package detected an error RMAN - 20001 : target database not found in recovery catalog RMAN > ===============================================================
-------------------------------------------------------------------------------
-
作者:rollingpig 时间:05-02-16 11:31
好怪
你的db 改过名字吗?
-------------------------------------------------------------------------------
作者:rollingpig 时间:05-02-16 11:37
我怀疑:
1。regster时以dbid注册,发现已经存在
2。backup时同时以dbid和dbname查询,结果出错,当然也可能以dbid + resetlog time进行查询
建议你重新注册甚至是重新create catalog看看
-------------------------------------------------------------------------------
-
作者:cloner 时间:05-02-16 11:38
应该没有改过,
应该没有改过,
再说就算改过,肯定也是在register database之前。
我想应该不会是改名造成的。
-------------------------------------------------------------------------------
-
作者:cloner 时间:05-02-16 11:44
另外请教,805的rman是不是没有create catalog tablespace 的??
-------------------------------------------------------------------------------
-
作者:cloner 时间:05-02-16 14:08
问题已经解决。
出现错误的原因可能是对dbms_rcvcat和dbms_rcvman的授权上。
我用oracle提供的catnormn.sql和catrman.sql,卸掉了原来
的rman,再重建了一下。
再要执行
grant execute on sys.dbms_rcvman to recovery_catalog_owner;
create public synonym dbms_rcvcat for sys.dbms_rcvcat;
才能正常使用。大概是805上的bug。