作者：cloner 时间：05-02-16 10:26
请教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
你用了恢复目录了把，你的数据库还没有注册到恢复目录中呢，先执行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?
RMAN> resync database;
或者
RMAN> reset database;
看看?
-------------------------------------------------------------------------------
-
作者：cloner 时间：05-02-16 11:24
还是一样，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。