<div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">最近单位在整合oracle 10g数据库，将许多不常用的小库合并到一个大库中（oracle10g）。这里的大小指的是数据少，并发低的数据库。整合方案有两种，一种是在一套10gRAC中创建多个实例，每个实例对应整合前的数据库。另一种方案是在RAC中之创建一个实例，将整合进来的小库转换成同名的表空间。这两种做法各有优缺点，给我的感觉第二种做法更像是12C的多租户模式。可能有反对的意见，认为第一种方式才更接近于多租户的方式，因为每个整合过来的数据库都是一个独立的instance，独立的instance具备独立的系统表空间，redo日志.... 这个没错。我们可以通过一个实验，看看12c自己是怎么说的，看看它（CDB）自己是怎样看待PDB的。 </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <br /> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">实验步骤如下： </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">1. 创建pdb1的rman备份 </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">2. rm pdb1的数据文件 </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">3. 重启pdb1数据库 </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">4. 使用oracle advise方式自我诊断，自我修复。 advise就是oracle的语言，看看它怎么说。 </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <br /> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">Let’s get started. </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <br /> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">（1）使用sysdba权限登录rman </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><span style="font-family:Courier New;">[oracle@snow ~]$ </span><b><span style="font-family:Courier New;">rman target /</span></b></span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Recovery Manager: Release 12.1.0.1.0 - Production on Mon May 4 07:35:00 2015</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">connected to target database: CDB (DBID=1995215983)</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">（2）12c中支持RMAN中直接写SQL语句，在此出查询当前的pdb状况</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><span style="font-family:Courier New;">RMAN> </span><b><span style="font-family:Courier New;">select name,total_size/1024/1024 mb,open_mode from v$pdbs;</span></b></span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">using target database control file instead of recovery catalog</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">NAME                                   MB OPEN_MODE </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">------------------------------ ---------- ----------</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">PDB$SEED                              270 READ ONLY </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">PDB1                                  385 READ WRITE</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">PDB2                                  275 READ WRITE</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">（3）采用传统的方式备份可插拔库pdb1</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><span style="font-family:Courier New;">RMAN> </span><b><span style="font-family:Courier New;">backup pluggable database pdb1 include current controlfile plus archivelog;</span></b></span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">（4）人为删除pdb1在磁盘上的物理文件，破坏该数据库</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">[oracle@snow cdb]$ cd pdb1 </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">[oracle@snow pdb1]$ ll </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">total 1874840 </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">-rw-r----- 1 oracle oinstall 374874112 May  4 07:35 example01.dbf </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">-rw-r----- 1 oracle oinstall 558899200 May  3 09:00 pdb1_temp01.dbf </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">-rw-r----- 1 oracle oinstall   5251072 May  4 07:35 SAMPLE_SCHEMA_users01.dbf </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">-rw-r----- 1 oracle oinstall 734011392 May  4 07:35 sysaux01.dbf </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">-rw-r----- 1 oracle oinstall 283123712 May  4 07:35 system01.dbf </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">[oracle@snow pdb1]$ </span><b><span style="font-family:Courier New;">rm -rf *</span></b> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">（5）关闭可插拔数据库pdb1</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><span style="font-family:Courier New;">RMAN> </span><b><span style="font-family:Courier New;">alter pluggable database pdb1 close;</span></b></span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Statement processed</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">（6）重新打开可插拔数据库pdb1，报错。在这里并没有像以往的数据库提示system01.dbf 如何如何，而是提示这个非重要表空间。</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">RMAN> alter pluggable database pdb1 open;</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">RMAN-00571: ===========================================================</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">RMAN-00571: ===========================================================</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">RMAN-03002: failure of sql statement command at 05/04/2015 07:41:10</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">ORA-01157: cannot identify/lock data file 11 - see DBWR trace file</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">ORA-01110: data file 11: '/home/oracle/dbfile/cdb/pdb1/example01.dbf'</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <br /> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">（7）使用oracle的advise方式检查错误</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><span style="font-family:Courier New;">RMAN> </span><b><span style="font-family:Courier New;">list failure;</span></b></span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Database Role: PRIMARY</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">List of Database Failures</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">=========================</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Failure ID Priority Status    Time Detected Summary</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">---------- -------- --------- ------------- -------</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">3082       CRITICAL OPEN      04-MAY-15     System datafile 8: '/home/oracle/dbfile/cdb/pdb1/system01.dbf' is missing</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">8          HIGH     OPEN      04-MAY-15     One or more non-system datafiles are missing</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">（8）继续使用oracle的advise来给出恢复建议</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><span style="font-family:Courier New;">RMAN> </span><b><span style="font-family:Courier New;">advise failure;</span></b></span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Database Role: PRIMARY</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">List of Database Failures</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">=========================</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Failure ID Priority Status    Time Detected Summary</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">---------- -------- --------- ------------- -------</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">3082       CRITICAL OPEN      04-MAY-15     System datafile 8: '/home/oracle/dbfile/cdb/pdb1/system01.dbf' is missing</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">8          HIGH     OPEN      04-MAY-15     One or more non-system datafiles are missing</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">analyzing automatic repair options; this may take some time</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">allocated channel: ORA_DISK_1</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: SID=42 device type=DISK</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">analyzing automatic repair options complete</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Mandatory Manual Actions</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">========================</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">no manual actions available</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Optional Manual Actions</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">=======================</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">1. If file /home/oracle/dbfile/cdb/pdb1/system01.dbf was unintentionally renamed or moved, restore it</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">2. Automatic repairs may be available if you shutdown the database and restart it in mount mode</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">3. If file /home/oracle/dbfile/cdb/pdb1/sysaux01.dbf was unintentionally renamed or moved, restore it</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">4. If file /home/oracle/dbfile/cdb/pdb1/SAMPLE_SCHEMA_users01.dbf was unintentionally renamed or moved, restore it</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">5. If file /home/oracle/dbfile/cdb/pdb1/example01.dbf was unintentionally renamed or moved, restore it</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Automated Repair Options</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">========================</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Option Repair Description</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">------ ------------------</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">1      Restore and recover datafile 8; Restore and recover datafile 9; Restore and recover datafile 10; ...</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">  Strategy: The repair includes complete media recovery with no data loss</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">  Repair script: /u01/app/oracle/diag/rdbms/cdb/cdb/hm/reco_383443975.hm</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;color:#4C33E5;">（9）根据提示，查看一下恢复脚本。发现并没有看到我预期的语法，如： </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;color:#4C33E5;"> restore pluggable database pdb1<br /> recover pluggable database pdb1 <br /> alter pluggable database pdb1 open<br /> 而是基于数据文件号来恢复的。从这个角度看，pdb更像是表空间了，而不是数据库。如果在oracle 11g中使用advise是不会出现下面的datafile 8,9,..offline的。这就是我开篇提到的那种感觉</span> </div> <div style="font-family:'Courier New';font-size:13px;"> <br /> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">[oracle@snow pdb1]$ </span><b><span style="font-family:Courier New;">cat /u01/app/oracle/diag/rdbms/cdb/cdb/hm/reco_383443975.hm</span></b> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">   # restore and recover datafile </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">   sql 'PDB1' 'alter database datafile 8, 9, 10, 11 offline'; </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">   restore ( datafile 8, 9, 10, 11 ); </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">   recover datafile 8, 9, 10, 11; </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-family:Courier New;">   sql 'PDB1' 'alter database datafile 8, 9, 10, 11 online'; </span> </div> <div style="font-family:'Courier New';font-size:13px;"> <br /> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">（10）执行oracle的advise恢复脚本</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><span style="font-family:Courier New;">RMAN> </span><b><span style="font-family:Courier New;">repair failure;</span></b></span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Strategy: The repair includes complete media recovery with no data loss</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Repair script: /u01/app/oracle/diag/rdbms/cdb/cdb/hm/reco_383443975.hm</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">contents of repair script:</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">   # restore and recover datafile</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">   sql 'PDB1' 'alter database datafile 8, 9, 10, 11 offline';</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">   restore ( datafile 8, 9, 10, 11 );</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">   recover datafile 8, 9, 10, 11;</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">   sql 'PDB1' 'alter database datafile 8, 9, 10, 11 online';</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><span style="font-family:Courier New;">Do you really want to execute the above repair (enter YES or NO)? </span><b><span style="font-family:Courier New;">yes</span></b></span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">executing repair script</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">sql statement: alter database datafile 8, 9, 10, 11 offline</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Starting restore at 04-MAY-15</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">using channel ORA_DISK_1</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: starting datafile backup set restore</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: specifying datafile(s) to restore from backup set</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: restoring datafile 00008 to /home/oracle/dbfile/cdb/pdb1/system01.dbf</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: restoring datafile 00009 to /home/oracle/dbfile/cdb/pdb1/sysaux01.dbf</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: restoring datafile 00010 to /home/oracle/dbfile/cdb/pdb1/SAMPLE_SCHEMA_users01.dbf</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: restoring datafile 00011 to /home/oracle/dbfile/cdb/pdb1/example01.dbf</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/12.1.0.1/db_1/dbs/3fq62sqs_1_1</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: piece handle=/u01/app/oracle/product/12.1.0.1/db_1/dbs/3fq62sqs_1_1 tag=TAG20150504T073556</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: restored backup piece 1</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">channel ORA_DISK_1: restore complete, elapsed time: 00:00:07</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Finished restore at 04-MAY-15</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Starting recover at 04-MAY-15</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">using channel ORA_DISK_1</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">starting media recovery</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">media recovery complete, elapsed time: 00:00:00</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Finished recover at 04-MAY-15</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">sql statement: alter database datafile 8, 9, 10, 11 online</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">repair failure complete</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">（11）恢复完成后CDB并不会将PDB置为open状态，需要我们手工open</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">RMAN> list failure;</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Database Role: PRIMARY</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">no failures found that match specification</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">RMAN> select name,open_mode from v$pdbs;</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">NAME                           OPEN_MODE </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">------------------------------ ----------</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">PDB$SEED                       READ ONLY </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">PDB1                           MOUNTED   </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">PDB2                           READ WRITE</span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><span style="font-family:Courier New;">RMAN> </span><b><span style="font-family:Courier New;">alter pluggable database pdb1 open;</span></b></span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">Statement processed<br /> <br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;"><span style="font-family:TheSansMonoConNormal;"><br /> </span></span> </div> <div style="font-family:'Courier New';font-size:13px;"> <span style="font-size:9pt;font-family:Courier New;"><span style="font-family:Courier New;">全文完</span></span> </div> <div id="xunlei_com_thunder_helper_plugin_d462f475-c18e-46be-bd10-327458d045bd"> </div>

ITPub博客

12c PDB备份与恢复初体验

最新文章