{"id":842,"date":"2013-05-06T16:43:57","date_gmt":"2013-05-06T08:43:57","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=842"},"modified":"2013-05-06T16:45:56","modified_gmt":"2013-05-06T08:45:56","slug":"842","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=842","title":{"rendered":"RAC_LOACL_BACKUPSET_VALIDATE_BUG ORA-19660 ORA-19661"},"content":{"rendered":"<p><strong>\u95ee\u9898\u63cf\u8ff0\uff1a<\/strong><br \/>\n\u572811gr2\u76842\u4e2a\u8282\u70b9\u7684rac\u73af\u5883\u4e2d\uff0c\u65e0\u8bba\u5728\u54ea\u4e2a\u8282\u70b9\u53ea\u8981\u628a\u5907\u4efd\u7247\u6307\u5230\u672c\u5730\u76ee\u5f55\u4e0b\u8fdb\u884c\u5907\u4efd\uff0c\u5907\u4efd\u8fc7\u7a0b\u4e0d\u4f1a\u62a5\u9519\uff0c\u4f46\u662f\u9a8c\u8bc1\u65f6\u5c31\u4f1a\u62a5\u9519\u3002<br \/>\n\u62a5\u9519\u7684\u76f8\u5173\u6587\u4ef6\u6211\u7528dbv\u68c0\u67e5\u65f6\u662f\u6ca1\u6709\u574f\u5757\u7684\u3002<br \/>\n\u6211\u628a\u5907\u4efd\u96c6\u9ed8\u8ba4\u5728+ASM\u91cc\u7684\u65f6\u5019\uff0c\u5c31\u4e0d\u4f1a\u62a5\u9519\u3002<\/p>\n<p><strong>\u53d1\u73b0\u7684\u8fc7\u7a0b\uff1a<\/strong><br \/>\n\u672c\u6765\u60f3\u5728\u539f\u6709\u7684rac+dg\u7684\u73af\u5883\u4e0a\u5ef6\u751f\u51fa\u4e00\u4e2aOGG\u7684\u5e93\u8fdb\u884c\u707e\u5907\u6d4b\u8bd5\uff0c\u5176\u4ed6ogg\u7684\u53c2\u6570\u90fd\u914d\u597d\u4e86\uff0c\u4e00\u5f00\u59cb\u5907\u4efd\u4e3b\u5e93\u5c31\u5361\u58f3\u4e86\uff0c\u4e8e\u662f\u5c31\u7ea0\u7ed3rman\u4e86\u4e00\u5929\uff0c\u4e8e\u662f\u5c31\u6709\u4e86\u8fd9\u7bc7\u6587\u6863\u3002<\/p>\n<p><strong>\u7ed3\u8bba\uff1aoracle\u672a\u77e5\u7684BUG<\/strong><\/p>\n<p><strong>\u76f8\u5173\u73af\u5883\uff1a<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@11grac1 tmp]$ uname -a\r\nLinux 11grac1 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU\/Linux\r\n<\/pre>\n<p>ORACLE\u4fe1\u606f<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@11grac1 OPatch]$ .\/opatch lsinventory -oh \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\nInvoking OPatch 11.1.0.6.6\r\n\r\nOracle Interim Patch Installer version 11.1.0.6.6\r\nCopyright (c) 2009, Oracle Corporation.  All rights reserved.\r\n\r\n\r\nOracle Home       : \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\nCentral Inventory : \/u01\/app\/oraInventory\r\n   from           : \/etc\/oraInst.loc\r\nOPatch version    : 11.1.0.6.6\r\nOUI version       : 11.2.0.1.0\r\nOUI location      : \/u01\/app\/oracle\/product\/11.2.0\/db_1\/oui\r\nLog file location : \/u01\/app\/oracle\/product\/11.2.0\/db_1\/cfgtoollogs\/opatch\/opatch2013-05-06_15-40-42PM.log\r\n\r\nPatch history file: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/cfgtoollogs\/opatch\/opatch_history.txt\r\n\r\nLsinventory Output file location : \/u01\/app\/oracle\/product\/11.2.0\/db_1\/cfgtoollogs\/opatch\/lsinv\/lsinventory2013-05-06_15-40-42PM.txt\r\n\r\n--------------------------------------------------------------------------------\r\nInstalled Top-level Products (1): \r\n\r\nOracle Database 11g                                                  11.2.0.1.0\r\nThere are 1 products installed in this Oracle Home.\r\n\r\n\r\nThere are no Interim patches installed in this Oracle Home.\r\n\r\n\r\nRac system comprising of multiple nodes\r\n  Local node = 11grac1\r\n  Remote node = 11grac2\r\n\r\n--------------------------------------------------------------------------------\r\n\r\nOPatch succeeded.\r\n<\/pre>\n<p>CRS\u4fe1\u606f<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[grid@11grac1 OPatch]$ .\/opatch lsinventory -oh \/u01\/11.2.0\/grid\r\nInvoking OPatch 11.1.0.6.6\r\n\r\nOracle Interim Patch Installer version 11.1.0.6.6\r\nCopyright (c) 2009, Oracle Corporation.  All rights reserved.\r\n\r\n\r\nOracle Home       : \/u01\/11.2.0\/grid\r\nCentral Inventory : \/u01\/app\/oraInventory\r\n   from           : \/etc\/oraInst.loc\r\nOPatch version    : 11.1.0.6.6\r\nOUI version       : 11.2.0.1.0\r\nOUI location      :\r\n\r\n[grid@11grac1 OPatch]$ .\/opatch lsinventory -oh \/u01\/11.2.0\/grid\r\nInvoking OPatch 11.1.0.6.6\r\n\r\nOracle Interim Patch Installer version 11.1.0.6.6\r\nCopyright (c) 2009, Oracle Corporation.  All rights reserved.\r\n\r\n\r\nOracle Home       : \/u01\/11.2.0\/grid\r\nCentral Inventory : \/u01\/app\/oraInventory\r\n   from           : \/etc\/oraInst.loc\r\nOPatch version    : 11.1.0.6.6\r\nOUI version       : 11.2.0.1.0\r\nOUI location      : \/u01\/11.2.0\/grid\/oui\r\nLog file location : \/u01\/11.2.0\/grid\/cfgtoollogs\/opatch\/opatch2013-05-06_15-42-29PM.log\r\n\r\nPatch history file: \/u01\/11.2.0\/grid\/cfgtoollogs\/opatch\/opatch_history.txt\r\n\r\nLsinventory Output file location : \/u01\/11.2.0\/grid\/cfgtoollogs\/opatch\/lsinv\/lsinventory2013-05-06_15-42-29PM.txt\r\n\r\n--------------------------------------------------------------------------------\r\nInstalled Top-level Products (1): \r\n\r\nOracle Grid Infrastructure                                           11.2.0.1.0\r\nThere are 1 products installed in this Oracle Home.\r\n\r\n\r\nThere are no Interim patches installed in this Oracle Home.\r\n\r\n\r\nRac system comprising of multiple nodes\r\n  Local node = 11grac1\r\n  Remote node = 11grac2\r\n\r\n--------------------------------------------------------------------------------\r\n\r\nOPatch succeeded.\r\n<\/pre>\n<p><strong>\u8fc7\u7a0b\u5982\u4e0b\uff1a<br \/>\n\u9996\u5148\u9ed8\u8ba4\u5907\u4efd\u5230ASM\u4e2d\uff0c\u9a8c\u8bc1\u662f\u6ca1\u6709\u95ee\u9898\u7684\u3002<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nRMAN&gt; show all;\r\n\r\nusing target database control file instead of recovery catalog\r\nRMAN configuration parameters for database with db_unique_name RACDB are:\r\nCONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default\r\nCONFIGURE BACKUP OPTIMIZATION OFF; # default\r\nCONFIGURE DEFAULT DEVICE TYPE TO DISK; # default\r\nCONFIGURE CONTROLFILE AUTOBACKUP OFF; # default\r\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#039;%F&#039;; # default\r\nCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default\r\nCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\r\nCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\r\nCONFIGURE MAXSETSIZE TO UNLIMITED; # default\r\nCONFIGURE ENCRYPTION FOR DATABASE OFF; # default\r\nCONFIGURE ENCRYPTION ALGORITHM &#039;AES128&#039;; # default\r\nCONFIGURE COMPRESSION ALGORITHM &#039;BASIC&#039; AS OF RELEASE &#039;DEFAULT&#039; OPTIMIZE FOR LOAD TRUE ; # default\r\nCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default\r\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO &#039;+data\/snapcf_racdb1.f&#039;;\r\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO &#039;+DATA\/snapcf_racdb1.f&#039;;\r\n\r\nRMAN&gt; backup full database;\r\n\r\nStarting backup at 06-MAY-13\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00001 name=+DATA\/racdb\/system01.dbf\r\ninput datafile file number=00002 name=+DATA\/racdb\/sysaux01.dbf\r\ninput datafile file number=00008 name=+DATA\/racdb\/ogg01.dbf\r\ninput datafile file number=00009 name=+DATA\/racdb\/test01.dbf\r\ninput datafile file number=00003 name=+DATA\/racdb\/undotbs01.dbf\r\ninput datafile file number=00005 name=+DATA\/racdb\/undotbs02.dbf\r\ninput datafile file number=00004 name=+DATA\/racdb\/users01.dbf\r\ninput datafile file number=00006 name=+DATA\/racdb\/datafile\/yallonking.432.812066619\r\ninput datafile file number=00007 name=+DATA\/racdb\/yallonking_2.dbf\r\nchannel ORA_DISK_1: starting piece 1 at 06-MAY-13\r\nchannel ORA_DISK_1: finished piece 1 at 06-MAY-13\r\npiece handle=+DATA\/racdb\/backupset\/2013_05_06\/nnndf0_tag20130506t092236_0.506.814699357 tag=TAG20130506T092236 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:07:26\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\nincluding current control file in backup set\r\nincluding current SPFILE in backup set\r\nchannel ORA_DISK_1: starting piece 1 at 06-MAY-13\r\nchannel ORA_DISK_1: finished piece 1 at 06-MAY-13\r\npiece handle=+DATA\/racdb\/backupset\/2013_05_06\/ncsnf0_tag20130506t092236_0.502.814699819 tag=TAG20130506T092236 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16\r\nFinished backup at 06-MAY-13\r\n\r\nRMAN&gt; list backupset;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key Type LV Size Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n144 Full 994.09M DISK 00:07:23 06-MAY-13\r\nBP Key: 144 Status: AVAILABLE Compressed: NO Tag: TAG20130506T092236\r\nPiece Name: +DATA\/racdb\/backupset\/2013_05_06\/nnndf0_tag20130506t092236_0.506.814699357\r\nList of Datafiles in backup set 144\r\nFile LV Type Ckp SCN Ckp Time Name\r\n---- -- ---- ---------- --------- ----\r\n1 Full 1586465 06-MAY-13 +DATA\/racdb\/system01.dbf\r\n2 Full 1586465 06-MAY-13 +DATA\/racdb\/sysaux01.dbf\r\n3 Full 1586465 06-MAY-13 +DATA\/racdb\/undotbs01.dbf\r\n4 Full 1586465 06-MAY-13 +DATA\/racdb\/users01.dbf\r\n5 Full 1586465 06-MAY-13 +DATA\/racdb\/undotbs02.dbf\r\n6 Full 1586465 06-MAY-13 +DATA\/racdb\/datafile\/yallonking.432.812066619\r\n7 Full 1586465 06-MAY-13 +DATA\/racdb\/yallonking_2.dbf\r\n8 Full 1586465 06-MAY-13 +DATA\/racdb\/ogg01.dbf\r\n9 Full 1586465 06-MAY-13 +DATA\/racdb\/test01.dbf\r\n\r\nBS Key Type LV Size Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n145 Full 19.80M DISK 00:00:23 06-MAY-13\r\nBP Key: 145 Status: AVAILABLE Compressed: NO Tag: TAG20130506T092236\r\nPiece Name: +DATA\/racdb\/backupset\/2013_05_06\/ncsnf0_tag20130506t092236_0.502.814699819\r\nSPFILE Included: Modification time: 06-MAY-13\r\nSPFILE db_unique_name: RACDB\r\nControl File Included: Ckp SCN: 1586888 Ckp time: 06-MAY-13\r\n\r\nRMAN&gt; restore database validate;\r\n\r\nStarting restore at 06-MAY-13\r\nusing channel ORA_DISK_1\r\n\r\nchannel ORA_DISK_1: starting validation of datafile backup set\r\nchannel ORA_DISK_1: reading from backup piece +DATA\/racdb\/backupset\/2013_05_06\/nnndf0_tag20130506t092236_0.506.814699357\r\nchannel ORA_DISK_1: piece handle=+DATA\/racdb\/backupset\/2013_05_06\/nnndf0_tag20130506t092236_0.506.814699357 tag=TAG20130506T092236\r\nchannel ORA_DISK_1: restored backup piece 1\r\nchannel ORA_DISK_1: validation complete, elapsed time: 00:00:35\r\nFinished restore at 06-MAY-13\r\n<\/pre>\n<p><strong>\u4f46\u662f\u628a\u5907\u4efd\u7247\u6307\u5b9a\u5230\u672c\u5730\u65f6\uff0c\u5907\u4efd\u8fc7\u7a0b\u6ca1\u6709\u62a5\u9519\uff0c\u4f46\u662f\u9a8c\u8bc1\u4f1a\u62a5\u9519\u3002<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nRMAN&gt; run{\r\n2&gt; allocate channel a1 type disk;\r\n3&gt; allocate channel a2 type disk;\r\n4&gt; allocate channel a3 type disk;\r\n5&gt; backup full database filesperset 3 format &#039;\/tmp\/dbfullbak_%u_%s_%p_%T.bak&#039;;\r\n6&gt; sql &#039;ALTER SYSTEM switch logfile&#039;;\r\n7&gt; sql &#039;ALTER SYSTEM ARCHIVE LOG CURRENT&#039;;\r\n8&gt; backup archivelog all format &#039;\/tmp\/arc_%T_%s.bak&#039;;\r\n9&gt; backup current controlfile format &#039;\/tmp\/ctl0_%T_%s.bak&#039;;\r\n10&gt; release channel a1;\r\n11&gt; release channel a2;\r\n12&gt; release channel a3;\r\n13&gt; }\r\n\r\nusing target database control file instead of recovery catalog\r\nallocated channel: a1\r\nchannel a1: SID=66 instance=racdb2 device type=DISK\r\n\r\nallocated channel: a2\r\nchannel a2: SID=40 instance=racdb2 device type=DISK\r\n\r\nallocated channel: a3\r\nchannel a3: SID=44 instance=racdb2 device type=DISK\r\n\r\nStarting backup at 06-MAY-13\r\nchannel a1: starting full datafile backup set\r\nchannel a1: specifying datafile(s) in backup set\r\ninput datafile file number=00001 name=+DATA\/racdb\/system01.dbf\r\ninput datafile file number=00006 name=+DATA\/racdb\/datafile\/yallonking.432.812066619\r\ninput datafile file number=00007 name=+DATA\/racdb\/yallonking_2.dbf\r\nchannel a1: starting piece 1 at 06-MAY-13\r\nchannel a2: starting full datafile backup set\r\nchannel a2: specifying datafile(s) in backup set\r\ninput datafile file number=00002 name=+DATA\/racdb\/sysaux01.dbf\r\ninput datafile file number=00005 name=+DATA\/racdb\/undotbs02.dbf\r\ninput datafile file number=00004 name=+DATA\/racdb\/users01.dbf\r\n... ...\r\nFinished backup at 06-MAY-13\r\n\r\nreleased channel: a1\r\n\r\nreleased channel: a2\r\n\r\nreleased channel: a3\r\n\r\nRMAN&gt; restore database validate;\r\n\r\nStarting restore at 06-MAY-13\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=66 instance=racdb2 device type=DISK\r\n\r\nchannel ORA_DISK_1: starting validation of datafile backup set\r\nchannel ORA_DISK_1: reading from backup piece \/tmp\/dbfullbak_5do8unkp_173_1_20130506.bak\r\nchannel ORA_DISK_1: piece handle=\/tmp\/dbfullbak_5do8unkp_173_1_20130506.bak tag=TAG20130506T101029\r\nchannel ORA_DISK_1: restored backup piece 1\r\nchannel ORA_DISK_1: validation complete, elapsed time: 00:00:01\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of restore command at 05\/06\/2013 10:17:31\r\nORA-19660: some files in the backup set could not be verified\r\nORA-19661: datafile 3 could not be verified\r\nORA-19661: datafile 9 could not be verified\r\nORA-19661: datafile 8 could not be verified\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.\r\n[oracle@11grac2 tmp]$ su -\r\nPassword:\r\n[root@11grac2 ~]# mount\r\n\/dev\/sda3 on \/ type ext3 (rw)\r\nproc on \/proc type proc (rw)\r\nsysfs on \/sys type sysfs (rw)\r\ndevpts on \/dev\/pts type devpts (rw,gid=5,mode=620)\r\n\/dev\/sda1 on \/boot type ext3 (rw)\r\ntmpfs on \/dev\/shm type tmpfs (rw)\r\nnone on \/proc\/sys\/fs\/binfmt_misc type binfmt_misc (rw)\r\nsunrpc on \/var\/lib\/nfs\/rpc_pipefs type rpc_pipefs (rw)\r\n[root@11grac2 ~]# df -m\r\nFilesystem 1M-blocks Used Available Use% Mounted on\r\n\/dev\/sda3 20638 11761 7812 61% \/\r\n\/dev\/sda1 190 42 140 23% \/boot\r\ntmpfs 1007 154 853 16% \/dev\/shm\r\n[root@11grac2 ~]# ls -l \/tmp\/dbfullbak*\r\n-rw-r----- 1 oracle asmadmin 614154240 May 6 10:14 \/tmp\/dbfullbak_5bo8unkm_171_1_20130506.bak\r\n-rw-r----- 1 oracle asmadmin 422526976 May 6 10:13 \/tmp\/dbfullbak_5co8unkn_172_1_20130506.bak\r\n-rw-r----- 1 oracle asmadmin 6012928 May 6 10:11 \/tmp\/dbfullbak_5do8unkp_173_1_20130506.bak\r\n-rw-r----- 1 oracle asmadmin 20742144 May 6 10:12 \/tmp\/dbfullbak_5eo8unmn_174_1_20130506.bak\r\n-rw-r----- 1 oracle asmadmin 98304 May 6 10:13 \/tmp\/dbfullbak_5fo8unpn_175_1_20130506.bak\r\n<\/pre>\n<p><strong>\u5355\u72ec\u5bf9\u95ee\u9898\u6587\u4ef6\u8fdb\u884c\u5bf9\u6bd4\uff08ASM\u548cLOACL\uff09\u68c0\u67e5\uff0c\u6587\u4ef6\u662f\u6ca1\u6709\u95ee\u9898\u7684\u3002<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nRMAN&gt; backup database datafile 3,8,9;\r\n\r\nStarting backup at 06-MAY-13\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00001 name=+DATA\/racdb\/system01.dbf\r\ninput datafile file number=00002 name=+DATA\/racdb\/sysaux01.dbf\r\ninput datafile file number=00008 name=+DATA\/racdb\/ogg01.dbf\r\ninput datafile file number=00009 name=+DATA\/racdb\/test01.dbf\r\ninput datafile file number=00003 name=+DATA\/racdb\/undotbs01.dbf\r\ninput datafile file number=00005 name=+DATA\/racdb\/undotbs02.dbf\r\ninput datafile file number=00004 name=+DATA\/racdb\/users01.dbf\r\ninput datafile file number=00006 name=+DATA\/racdb\/datafile\/yallonking.432.812066619\r\ninput datafile file number=00007 name=+DATA\/racdb\/yallonking_2.dbf\r\nchannel ORA_DISK_1: starting piece 1 at 06-MAY-13\r\nchannel ORA_DISK_1: finished piece 1 at 06-MAY-13\r\npiece handle=+DATA\/racdb\/backupset\/2013_05_06\/nnndf0_tag20130506t093334_0.501.814700017 tag=TAG20130506T093334 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:03:05\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00008 name=+DATA\/racdb\/ogg01.dbf\r\ninput datafile file number=00009 name=+DATA\/racdb\/test01.dbf\r\ninput datafile file number=00003 name=+DATA\/racdb\/undotbs01.dbf\r\nchannel ORA_DISK_1: starting piece 1 at 06-MAY-13\r\nchannel ORA_DISK_1: finished piece 1 at 06-MAY-13\r\npiece handle=+DATA\/racdb\/backupset\/2013_05_06\/nnndf0_tag20130506t093334_0.500.814700201 tag=TAG20130506T093334 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:07\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\nincluding current control file in backup set\r\nincluding current SPFILE in backup set\r\nchannel ORA_DISK_1: starting piece 1 at 06-MAY-13\r\nchannel ORA_DISK_1: finished piece 1 at 06-MAY-13\r\npiece handle=+DATA\/racdb\/backupset\/2013_05_06\/ncsnf0_tag20130506t093334_0.499.814700223 tag=TAG20130506T093334 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:08\r\nFinished backup at 06-MAY-13\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.\r\n[oracle@11grac1 tmp]$ rman target \/\r\n\r\nRecovery Manager: Release 11.2.0.1.0 - Production on Mon May 6 09:37:31 2013\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nconnected to target database: RACDB (DBID=790139163)\r\n\r\nRMAN&gt; list backupset of datafile 3,8,9;\r\n\r\nusing target database control file instead of recovery catalog\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n144     Full    994.09M    DISK        00:07:23     06-MAY-13      \r\n        BP Key: 144   Status: AVAILABLE  Compressed: NO  Tag: TAG20130506T092236\r\n        Piece Name: +DATA\/racdb\/backupset\/2013_05_06\/nnndf0_tag20130506t092236_0.506.814699357\r\n  List of Datafiles in backup set 144\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  3       Full 1586465    06-MAY-13 +DATA\/racdb\/undotbs01.dbf\r\n  8       Full 1586465    06-MAY-13 +DATA\/racdb\/ogg01.dbf\r\n  9       Full 1586465    06-MAY-13 +DATA\/racdb\/test01.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n146     Full    994.12M    DISK        00:03:00     06-MAY-13      \r\n        BP Key: 146   Status: AVAILABLE  Compressed: NO  Tag: TAG20130506T093334\r\n        Piece Name: +DATA\/racdb\/backupset\/2013_05_06\/nnndf0_tag20130506t093334_0.501.814700017\r\n  List of Datafiles in backup set 146\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  3       Full 1587185    06-MAY-13 +DATA\/racdb\/undotbs01.dbf\r\n  8       Full 1587185    06-MAY-13 +DATA\/racdb\/ogg01.dbf\r\n  9       Full 1587185    06-MAY-13 +DATA\/racdb\/test01.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n147     Full    6.09M      DISK        00:00:05     06-MAY-13      \r\n        BP Key: 147   Status: AVAILABLE  Compressed: NO  Tag: TAG20130506T093334\r\n        Piece Name: +DATA\/racdb\/backupset\/2013_05_06\/nnndf0_tag20130506t093334_0.500.814700201\r\n  List of Datafiles in backup set 147\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  3       Full 1587393    06-MAY-13 +DATA\/racdb\/undotbs01.dbf\r\n  8       Full 1587393    06-MAY-13 +DATA\/racdb\/ogg01.dbf\r\n  9       Full 1587393    06-MAY-13 +DATA\/racdb\/test01.dbf\r\n\r\nRMAN&gt; exit\r\n\r\n\r\nRecovery Manager complete.\r\n[oracle@11grac1 tmp]$ dbv file=+DATA\/racdb\/undotbs01.dbf userid=sys\/oracle\r\n\r\nDBVERIFY: Release 11.2.0.1.0 - Production on Mon May 6 09:38:44 2013\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nDBVERIFY - Verification starting : FILE = +DATA\/racdb\/undotbs01.dbf\r\n\r\n\r\nDBVERIFY - Verification complete\r\n\r\nTotal Pages Examined         : 4480\r\nTotal Pages Processed (Data) : 0\r\nTotal Pages Failing   (Data) : 0\r\nTotal Pages Processed (Index): 0\r\nTotal Pages Failing   (Index): 0\r\nTotal Pages Processed (Other): 4479\r\nTotal Pages Processed (Seg)  : 10\r\nTotal Pages Failing   (Seg)  : 0\r\nTotal Pages Empty            : 1\r\nTotal Pages Marked Corrupt   : 0\r\nTotal Pages Influx           : 0\r\nTotal Pages Encrypted        : 0\r\nHighest block SCN            : 0 (0.0)\r\n[oracle@11grac1 tmp]$ dbv file=+DATA\/racdb\/ogg01.dbf userid=sys\/oracle\r\n\r\nDBVERIFY: Release 11.2.0.1.0 - Production on Mon May 6 09:39:23 2013\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nDBVERIFY - Verification starting : FILE = +DATA\/racdb\/ogg01.dbf\r\n\r\n\r\nDBVERIFY - Verification complete\r\n\r\nTotal Pages Examined         : 6400\r\nTotal Pages Processed (Data) : 36\r\nTotal Pages Failing   (Data) : 0\r\nTotal Pages Processed (Index): 13\r\nTotal Pages Failing   (Index): 0\r\nTotal Pages Processed (Other): 178\r\nTotal Pages Processed (Seg)  : 0\r\nTotal Pages Failing   (Seg)  : 0\r\nTotal Pages Empty            : 6173\r\nTotal Pages Marked Corrupt   : 0\r\nTotal Pages Influx           : 0\r\nTotal Pages Encrypted        : 0\r\nHighest block SCN            : 0 (0.0)\r\n[oracle@11grac1 tmp]$ dbv file=+DATA\/racdb\/test01.dbf userid=sys\/oracle\r\n\r\nDBVERIFY: Release 11.2.0.1.0 - Production on Mon May 6 09:39:35 2013\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nDBVERIFY - Verification starting : FILE = +DATA\/racdb\/test01.dbf\r\n\r\n\r\nDBVERIFY - Verification complete\r\n\r\nTotal Pages Examined         : 6400\r\nTotal Pages Processed (Data) : 0\r\nTotal Pages Failing   (Data) : 0\r\nTotal Pages Processed (Index): 0\r\nTotal Pages Failing   (Index): 0\r\nTotal Pages Processed (Other): 127\r\nTotal Pages Processed (Seg)  : 0\r\nTotal Pages Failing   (Seg)  : 0\r\nTotal Pages Empty            : 6273\r\nTotal Pages Marked Corrupt   : 0\r\nTotal Pages Influx           : 0\r\nTotal Pages Encrypted        : 0\r\nHighest block SCN            : 0 (0.0)\r\n<\/pre>\n<p><strong>\u7ed3\u8bba\uff1a<\/strong><br \/>\n\u548coracle\u5b98\u65b9\u524d\u540e\u6c9f\u901a\u4e86\u8fd11\u5929\u5de6\u53f3\uff0c\u4e5f\u4e00\u5171\u6362\u4e862\u4e2aoracle\u5de5\u7a0b\u5e08\uff0c\u6700\u540e\u7684\u7ed3\u8bba\u662f\uff1a<br \/>\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014<\/p>\n<p>Dear customer,<\/p>\n<p>\u611f\u8c22\u60a8\u7684\u914d\u5408\u3002<\/p>\n<p>\u6211\u5c06\u7a0d\u540e\u6574\u7406\u4e00\u4e0b\u95ee\u9898\uff0c\u5e76\u63d0\u4ea4\u65b0\u7684BUG\u7ed9\u7814\u53d1\u90e8\u95e8\u3002<\/p>\n<p>\u5982\u679c\u6709\u8fdb\u4e00\u6b65\u7684\u7814\u53d1\u90e8\u95e8\u7684\u56de\u590d\uff0c\u6211\u5c06\u66f4\u65b0SR\u901a\u77e5\u60a8\u3002<\/p>\n<p>\u611f\u8c22\u60a8\u7684\u914d\u5408\u3002<\/p>\n<p><strong>PS\uff1a<\/strong><br \/>\n\u5982\u679c\u771f\u7684\u662foracle\u7684\u672a\u77e5bug\uff0c\u90a3\u4ffa\u4e5f\u7b97\u662f\u7ed9oracle\u5e2e\u5fd9\u4e86\uff0c\u9760\u7740oracle\u5403\u996d\u5230\u73b0\u5728\uff0c\u7b97\u662f\u5bf9oracle\u7684\u4e00\u70b9\u70b9\u56de\u62a5\u5427.<br \/>\n\u8981\u662f\u572813gc\uff08Global cloud,\u81ea\u5df1\u731c\u7684\uff09\u7248\u672c\u4e2d\u6216\u8005\u4ec0\u4e48\u8865\u4e01\u91cc\u4fee\u8865\u7684\u8bdd\uff0c\u4ee5\u6211\u7684\u540d\u5b57\u547d\u540d\u8be5bug\u5c31\u723d\u4e86..^_^\uff0c\u54b1\u4e5f\u662f\u5728oracle\u7559\u540d\u7684\u6deb\u4e86..^_^...<br \/>\n\u867d\u7136\u6bcf\u5929\u5728oracle\u8f6f\u4ef6\u56ed\u7684\u659c\u5bf9\u9762\u4e0a\u73ed... ...<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u95ee\u9898\u63cf\u8ff0\uff1a \u572811gr2\u76842\u4e2a\u8282\u70b9\u7684rac\u73af\u5883\u4e2d\uff0c\u65e0\u8bba\u5728\u54ea\u4e2a\u8282\u70b9\u53ea\u8981\u628a\u5907\u4efd\u7247\u6307\u5230\u672c\u5730\u76ee\u5f55\u4e0b\u8fdb\u884c\u5907\u4efd\uff0c\u5907\u4efd\u8fc7\u7a0b\u4e0d [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35,36],"tags":[186,185,187],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/842"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=842"}],"version-history":[{"count":4,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/842\/revisions"}],"predecessor-version":[{"id":846,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/842\/revisions\/846"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=842"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}