以下是完整的执行过程,有三个表空间可以增量备份成功的,到整个数据库时就有问题了,请大虾解惑Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production With the Partitioning option JServer Release 8.1.7.4.1 - Production
Oracle 数据库归档模式:ARCHIVELOG
SUNSERVER 分析结束,总文件个数: 1,总数据量大小: 未知大小,开始备份操作
Recovery Manager: Release 8.1.7.4.1 - Production
RMAN> connect target internal/oracle@orcl;
2>
3> run {
4> allocate channel d1 type 'SBT_TAPE';
5> backup incremental level 1 format 'ORDB_%d_%s_%p_%t' database tag '2009_7_2_16_58_51';
6> release channel d1;
7> }
8>
9> run {
10> allocate channel d1 type 'SBT_TAPE';
11> backup current controlfile format 'CTRL_%d_%s_%p_%t' tag '2009_7_2_16_58_51';
12> release channel d1;
13> }
14>
RMAN-06005: connected to target database: ORCL (DBID=1142766535)
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=16 devtype=SBT_TAPE
RMAN-08526: channel d1: WARNING: Oracle Test Disk API
RMAN-03022: compiling command: backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06003: ORACLE error from target database: ORA-06550: line 1, column 120:
PLS-00306: wrong number or types of arguments in call to 'GETINCREMENTALSCN'
ORA-06550: line 1, column 120:
PL/SQL: Statement ignored
RMAN-06097: text of failing SQL statement: declare first boolean := FALSE ; rcvRec dbms_rcvman . rcvRec_t ; begin if ( :first > 0 ) THEN first := TRUE ; end if ; dbms_rcvman . getIncrementalScn ( first => first , file# => to_number ( NULL ) , create_scn => to_number ( NULL ) , reset_scn => to_number ( NULL ) , reset_time => to_date ( NULL ) , incr_level => :incr_lvl , cumulative => :cumulat , rcvRec => rcvRec ) ; :fno := rcvRec . dfNumber_obj ; :ckpscn := rcvRec . toSCN_act ; :crescn := rcvRec . dfCreationSCN_obj ; :rlgscn := rcvRec . rlgSCN_act ; :r
RMAN-06099: error occurred in source file: krmk.pc, line: 5500
Recovery Manager complete.
警告:数据库备份时读写器为空,操作已取消。
警告:客户端 SUNSERVER 备份出错
警告:执行项 备份 oracle 数据 执行失败
Oracle 数据库归档模式:ARCHIVELOG
SUNSERVER 分析结束,总文件个数: 1,总数据量大小: 未知大小,开始备份操作
Recovery Manager: Release 8.1.7.4.1 - Production
RMAN> connect target internal/oracle@orcl;
2>
3> run {
4> allocate channel d1 type 'SBT_TAPE';
5> backup incremental level 1 format 'ORDB_%d_%s_%p_%t' database tag '2009_7_2_16_58_51';
6> release channel d1;
7> }
8>
9> run {
10> allocate channel d1 type 'SBT_TAPE';
11> backup current controlfile format 'CTRL_%d_%s_%p_%t' tag '2009_7_2_16_58_51';
12> release channel d1;
13> }
14>
RMAN-06005: connected to target database: ORCL (DBID=1142766535)
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=16 devtype=SBT_TAPE
RMAN-08526: channel d1: WARNING: Oracle Test Disk API
RMAN-03022: compiling command: backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06003: ORACLE error from target database: ORA-06550: line 1, column 120:
PLS-00306: wrong number or types of arguments in call to 'GETINCREMENTALSCN'
ORA-06550: line 1, column 120:
PL/SQL: Statement ignored
RMAN-06097: text of failing SQL statement: declare first boolean := FALSE ; rcvRec dbms_rcvman . rcvRec_t ; begin if ( :first > 0 ) THEN first := TRUE ; end if ; dbms_rcvman . getIncrementalScn ( first => first , file# => to_number ( NULL ) , create_scn => to_number ( NULL ) , reset_scn => to_number ( NULL ) , reset_time => to_date ( NULL ) , incr_level => :incr_lvl , cumulative => :cumulat , rcvRec => rcvRec ) ; :fno := rcvRec . dfNumber_obj ; :ckpscn := rcvRec . toSCN_act ; :crescn := rcvRec . dfCreationSCN_obj ; :rlgscn := rcvRec . rlgSCN_act ; :r
RMAN-06099: error occurred in source file: krmk.pc, line: 5500
Recovery Manager complete.
警告:数据库备份时读写器为空,操作已取消。
警告:客户端 SUNSERVER 备份出错
警告:执行项 备份 oracle 数据 执行失败
解决方案 »
- 请问 ORACLE进行data profiling 的工具有哪些?
- 取得远程存储过程的参数的类型和个数
- 请教PRO*C编译问题
- 求:oracle md5 函数及用法
- 请教一条语句 行变列的问题
- 请问oracle.jdbc.driver.OracleConnection怎样才能新建一个OracleConnection?
- 关于在SQL中主关键字和外部关键字的问题
- 在Oracle 8.1.6中登录到Oracle Management Server默认的用户名和密码是什么?(在线等。。)
- oracle行转列?
- 分区表怎么查询比不分区还要慢?
- Oracle自增序列的问题。
- PL/SQL 同义词 混乱.............
RMAN>run {
2> allocate channel c1 type 'sbt_tape';
3> backup incremental level 1 database;
4> }RMAN-03022:正在编译命令:allocate
RMAN-03023:正在执行命令:allocate
^C
C:\Documents and Settings\Administrator>rman nocatalog恢复管理器:版本8.1.7.4.1 - ProductionRMAN>connect target system/manager@orclRMAN-06005:连接到目标数据库:ORCL (DBID=1142766535)
RMAN-06009:正在使用目标数据库控制文件替代恢复目录RMAN>run {
2> allocate channel c1 type disk;
3> backup incremental level 1 database format 'D:/bak_incr.bak';
4> release channel c1;
5> }RMAN-03022:正在编译命令:allocate
RMAN-03023:正在执行命令:allocate
RMAN-08030:分配的通道:c1
RMAN-08500:通道 c1:sid=12 devtype=DISKRMAN-03022:正在编译命令:backup
RMAN-03026:在释放通道资源时出现错误恢复
RMAN-08031:释放的通道:c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06003: ORACLE error from target database: ORA-06550: ? 1 ?, ? 120 ?:
PLS-00306: ?? 'GETINCREMENTALSCN' ??????????
ORA-06550: ? 1 ?, ? 120 ?:
PL/SQL: Statement ignored
RMAN-06097: text of failing SQL statement: declare first boolean := FALSE ; rcvR
ec dbms_rcvman . rcvRec_t ; begin if ( :first > 0 ) THEN first := TRUE ; end if
; dbms_rcvman . getIncrementalScn ( first => first , file# => to_number ( NULL )
, create_scn => to_number ( NULL ) , reset_scn => to_number ( NULL ) , reset_ti
me => to_date ( NULL ) , incr_level => :incr_lvl , cumulative => :cumulat , rcvR
ec => rcvRec ) ; :fno := rcvRec . dfNumber_obj ; :ckpscn := rcvRec . toSCN_act ;
:crescn := rcvRec . dfCreationSCN_obj ; :rlgscn := rcvRec . rlgSCN_act ; :r
RMAN-06099: error occurred in source file: krmk.pc, line: 5500
RMAN>connect target system/manager@orcl 你看下本地备份有问题吗?先把备份到磁带去掉,直接先备份到磁盘看看
RACLE error from target database: ORA-06550: ? 1 ?, ? 120 ?:
PLS-00306: ?? 'GETINCREMENTALSCN' ??????????
ORA-06550: ? 1 ?, ? 120 ?:
这里是增量scn的相关东西。估计和你的RMAN没有使用catalog的方式有关,所以信息都是在controlfile里。 所以有可能是backup的时候,有一些业务影响导致这个scn的问题。你试着在系统不繁忙的时候做做,或者是用catalog server来做rman catalog的方式
可以调小点的.
如果使用了rman catalog,尽量两个数据库的字符集一样。
如果没有用,编辑nls_lang环境变量试试看
nls_language="american"_america.US7ASCII