最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

Oracle12c32k与rmanrecovertable之间的Bug

来源:动视网 责编:小采 时间:2020-11-09 10:13:29
文档

Oracle12c32k与rmanrecovertable之间的Bug

Oracle12c32k与rmanrecovertable之间的Bug:OracleDatabase12cRelease1(12.1.0.1.0)forLinuxx86-OS:RedhatLinux5Update8bit1.按官方手册,启用 .. Oracle Database 12c Release 1 (12.1.0.1.0) for Linux x86-OS: Redhat Linux 5 U
推荐度:
导读Oracle12c32k与rmanrecovertable之间的Bug:OracleDatabase12cRelease1(12.1.0.1.0)forLinuxx86-OS:RedhatLinux5Update8bit1.按官方手册,启用 .. Oracle Database 12c Release 1 (12.1.0.1.0) for Linux x86-OS: Redhat Linux 5 U


OracleDatabase12cRelease1(12.1.0.1.0)forLinuxx86-OS:RedhatLinux5Update8bit1.按官方手册,启用 ..

Oracle Database 12c Release 1 (12.1.0.1.0) for Linux x86-

OS: Redhat Linux 5 Update 8 bit

1. 按官方手册,服务器,服务器,启用 varchar2 32k 支持

2. 使用 rman recover table 功能是,免备案空间,始终失败,报错如下:

RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 07/15/2013 13:03:14
RMAN-11003: failure during parse/execution of SQL statement: alter pluggable database PDB1 open read only
ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.

3. 在未启用 varchar2 32k 支持时, rman recover table 成功。

经过多位朋友测试,均和我测试结果一致,证明是 Oracle 12.1.0.1.0 的Bug.

详细测试过程如下:

[oracle@AS5U8 trace]$ sqlplus gao/gao

SQL*Plus: Release 12.1.0.1.0 Production on Wed Jul 10 20:37:58 2013

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Last Successful login time: Wed Jul 10 2013 19:34:02 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

一 建立测试表

SQL> create table t1 (id number(1));

Table created.

SQL> insert into t1 values(1);

1 row created.

SQL> insert into t1 values(2);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t1;

ID
———-
1
2

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'YY
——————-
2013-07-10 20:38:46

二 进行一次 全备

[oracle@AS5U8 /]$ rman target sys/oracle

Recovery Manager: Release 12.1.0.1.0 – Production on Wed Jul 10 20:39:00 2013

Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.

connected to target database: NAIL (DBID=902387349)

RMAN> backup database format '/u01/backup/bak_%f';

Starting backup at 10-JUL-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=53 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/product/oradata/nail/system01.dbf
input datafile file number=00003 name=/u01/product/oradata/nail/sysaux01.dbf
input datafile file number=00004 name=/u01/product/oradata/nail/undotbs01.dbf
input datafile file number=00006 name=/u01/product/oradata/nail/users01.dbf
channel ORA_DISK_1: starting piece 1 at 10-JUL-13
channel ORA_DISK_1: finished piece 1 at 10-JUL-13
piece handle=/u01/backup/bak_6 tag=TAG20130710T203920 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 10-JUL-13
channel ORA_DISK_1: finished piece 1 at 10-JUL-13
piece handle=/u01/backup/bak_0 tag=TAG20130710T203920 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-JUL-13

三 继续写数据

SQL> insert into t1 values(3);

1 row created.

SQL> insert into t1 values(4);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t1;

ID
———-
1
2
3
4

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'YY
——————-
2013-07-10 20:41:20

SQL>

四 删除表
SQL> drop table t1 purge;

Table dropped.

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'YY
——————-
2013-07-10 20:41:56

五 RMAN 恢复 (报错)

[oracle@AS5U8 /]$ rman target sys/oracle

文档

Oracle12c32k与rmanrecovertable之间的Bug

Oracle12c32k与rmanrecovertable之间的Bug:OracleDatabase12cRelease1(12.1.0.1.0)forLinuxx86-OS:RedhatLinux5Update8bit1.按官方手册,启用 .. Oracle Database 12c Release 1 (12.1.0.1.0) for Linux x86-OS: Redhat Linux 5 U
推荐度:
标签: oracle 间的 recover
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top