rman备份异机恢复部分pdb

rman备份异机恢复部分pdb
参考资料：
How to use Rman to Restore Of Single PDB in Multitenant to Alternate Server (文档 ID 2142675.1)
recover database skip forever tablespace CFMDB_PRD:SYSTEM,CFMDB_PRD:SYSAUX,CFMDB_PRD:UNDOTBS1,CFMDB_PRD:TS_CFM,CFMDB_PRD:TS_CFM_HIS;

1.恢复参数文件+控制文件
[oracle@dm0101vm01 ~]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Fri Aug 17 16:45:54 2018

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

connected to target database (not started)

RMAN> startup nomount;

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u02/app/oracle/product/12.2.0/dbhome_6/dbs/initHLCDB1.ora'

starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started

Total System Global Area 2147483648 bytes

Fixed Size 8641256 bytes
Variable Size 788530456 bytes
Database Buffers 1337982976 bytes
Redo Buffers 12328960 bytes

RMAN> restore spfile to '/home/oracle/hlcdb.ora' from '/u02/rmanbackup/arch/spfile_2666_1_984387742'; <<<<恢复参数文件

Starting restore at 17-AUG-2018 16:46:51
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1601 device type=DISK

channel ORA_DISK_1: restoring spfile from AUTOBACKUP /u02/rmanbackup/arch/spfile_2666_1_984387742
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 17-AUG-2018 16:46:54

RMAN> restore controlfile to '/home/oracle/hlcdbstoretest/control01.ctl' from '/u02/rmanbackup/arch/cntrl_2665_1_984387739'; <<<<恢复控制文件

Starting restore at 17-AUG-2018 16:49:55
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1601 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 17-AUG-2018 16:49:58

RMAN>

2.使用参数文件启动到mount状态
oracle@dm0101vm01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 17 16:55:23 2018

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

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1.6267E+11 bytes
Fixed Size 30036928 bytes
Variable Size 2.5770E+10 bytes
Database Buffers 1.3637E+11 bytes
Redo Buffers 506830848 bytes
SQL> show parameter control

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
control_file_record_keep_time integer
7
control_files string
+DATA_SSD/HLCDB/CONTROLFILE/cu
rrent.260.975773507, +FRA/HLCD
B/CONTROLFILE/current.270.9757
73507
control_management_pack_access string
DIAGNOSTIC+TUNING
SQL> alter system set control_files='/home/oracle/hlcdbstoretest/control01.ctl' scope=spfile;

System altered.

SQL> startup mount force;
ORACLE instance started.

Total System Global Area 1.6267E+11 bytes
Fixed Size 30036928 bytes
Variable Size 2.5770E+10 bytes
Database Buffers 1.3637E+11 bytes
Redo Buffers 506830848 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production
[oracle@dm0101vm01 dbs]$

3.注册备份集
[oracle@dm0101vm01 ~]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Fri Aug 17 17:05:09 2018

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

connected to target database: HLCDB (DBID=3169528770, not open)

RMAN> catalog start with '/u02/rmanbackup/arch';

Starting implicit crosscheck backup at 17-AUG-2018 17:05:28
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2648 device type=DISK
Crosschecked 77 objects
Finished implicit crosscheck backup at 17-AUG-2018 17:05:38

Starting implicit crosscheck copy at 17-AUG-2018 17:05:38
using channel ORA_DISK_1
Finished implicit crosscheck copy at 17-AUG-2018 17:05:38

searching for all files in the recovery area
cataloging files...
no files cataloged

searching for all files that match the pattern /u02/rmanbackup/arch

List of Files Unknown to the Database
=====================================
File Name: /u02/rmanbackup/arch/cntrl_2665_1_984387739
File Name: /u02/rmanbackup/arch/spfile_2666_1_984387742
File Name: /u02/rmanbackup/arch/bk_2660_1_984387481
File Name: /u02/rmanbackup/arch/al_2663_1_984387680
File Name: /u02/rmanbackup/arch/bk_2656_1_984387450
File Name: /u02/rmanbackup/arch/bk_2659_1_984387481
File Name: /u02/rmanbackup/arch/bk_2654_1_984387429
File Name: /u02/rmanbackup/arch/bk_2661_1_984387481
File Name: /u02/rmanbackup/arch/bk_2652_1_984387429
File Name: /u02/rmanbackup/arch/bk_2657_1_984387450
File Name: /u02/rmanbackup/arch/bk_2655_1_984387450
File Name: /u02/rmanbackup/arch/rman.txt
File Name: /u02/rmanbackup/arch/bk_2651_1_984387429
File Name: /u02/rmanbackup/arch/bk_2653_1_984387429
File Name: /u02/rmanbackup/arch/al_2664_1_984387680
File Name: /u02/rmanbackup/arch/bk_2658_1_984387481

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u02/rmanbackup/arch/cntrl_2665_1_984387739
File Name: /u02/rmanbackup/arch/spfile_2666_1_984387742
File Name: /u02/rmanbackup/arch/bk_2660_1_984387481
File Name: /u02/rmanbackup/arch/al_2663_1_984387680
File Name: /u02/rmanbackup/arch/bk_2656_1_984387450
File Name: /u02/rmanbackup/arch/bk_2659_1_984387481
File Name: /u02/rmanbackup/arch/bk_2654_1_984387429
File Name: /u02/rmanbackup/arch/bk_2661_1_984387481
File Name: /u02/rmanbackup/arch/bk_2652_1_984387429
File Name: /u02/rmanbackup/arch/bk_2657_1_984387450
File Name: /u02/rmanbackup/arch/bk_2655_1_984387450
File Name: /u02/rmanbackup/arch/bk_2651_1_984387429
File Name: /u02/rmanbackup/arch/bk_2653_1_984387429
File Name: /u02/rmanbackup/arch/al_2664_1_984387680
File Name: /u02/rmanbackup/arch/bk_2658_1_984387481

List of Files Which Were Not Cataloged
=======================================
File Name: /u02/rmanbackup/arch/rman.txt
RMAN-07517: Reason: The file header is corrupted

RMAN>

RUN {
set newname for database to '+DATAC1';
restore database root;
restore database "PDB$SEED";
restore pluggable database BPMDB_PRD;
}

RMAN> RUN {
2> set newname for database to '+DATAC1';
3> restore database root;
4> restore database "PDB$SEED";
5> restore pluggable database BPMDB_PRD;
6> }

executing command: SET NEWNAME

Starting restore at 19-AUG-2018 23:53:28
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00007 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2654_1_984387429
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2654_1_984387429 tag=CDBFULL_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2653_1_984387429
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2653_1_984387429 tag=CDBFULL_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2652_1_984387429
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2652_1_984387429 tag=CDBFULL_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2651_1_984387429
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2651_1_984387429 tag=CDBFULL_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 19-AUG-2018 23:53:41

Starting restore at 19-AUG-2018 23:53:41
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00008 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2657_1_984387450
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2657_1_984387450 tag=PDBSEED_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00005 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2656_1_984387450
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2656_1_984387450 tag=PDBSEED_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00006 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2655_1_984387450
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2655_1_984387450 tag=PDBSEED_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 19-AUG-2018 23:53:45

Starting restore at 19-AUG-2018 23:53:45
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00009 to +DATAC1
channel ORA_DISK_1: restoring datafile 00010 to +DATAC1
channel ORA_DISK_1: restoring datafile 00011 to +DATAC1
channel ORA_DISK_1: restoring datafile 00016 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2658_1_984387481
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2658_1_984387481 tag=PDBFULL_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00015 to +DATAC1
channel ORA_DISK_1: restoring datafile 00019 to +DATAC1
channel ORA_DISK_1: restoring datafile 00020 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2659_1_984387481
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2659_1_984387481 tag=PDBFULL_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00012 to +DATAC1
channel ORA_DISK_1: restoring datafile 00013 to +DATAC1
channel ORA_DISK_1: restoring datafile 00017 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2660_1_984387481
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2660_1_984387481 tag=PDBFULL_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00014 to +DATAC1
channel ORA_DISK_1: restoring datafile 00018 to +DATAC1
channel ORA_DISK_1: restoring datafile 00021 to +DATAC1
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/bk_2661_1_984387481
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/bk_2661_1_984387481 tag=PDBFULL_LV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:35
Finished restore at 19-AUG-2018 23:59:46

RMAN>

RUN {
switch database "PDB$SEED" to copy;
switch pluggable database BPMDB_PRD to copy;
switch database root to copy;
}

RMAN> switch database "PDB$SEED" to copy;

switch pluggable database BPMDB_PRD to copy;
}datafile 5 switched to datafile copy "+DATAC1/HLCDB/6BD6957B1D89CA27E053017AA8C07FED/DATAFILE/system.377.984614023"
datafile 6 switched to datafile copy "+DATAC1/HLCDB/6BD6957B1D89CA27E053017AA8C07FED/DATAFILE/sysaux.379.984614025"
datafile 8 switched to datafile copy "+DATAC1/HLCDB/6BD6957B1D89CA27E053017AA8C07FED/DATAFILE/undotbs1.390.984614023"

RMAN>
datafile 9 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/system.389.984614027"
datafile 10 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/sysaux.392.984614027"
datafile 11 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/undotbs1.348.984614025"
datafile 12 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/ts_bpm.384.984614197"
datafile 13 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/ts_bpm.375.984614197"
datafile 14 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/ts_bpm.376.984614291"
datafile 15 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/ts_bpm.380.984614091"
datafile 16 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/ts_bpm.382.984614027"
datafile 17 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/ts_bpm.385.984614197"
datafile 18 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/ts_bpm.394.984614291"
datafile 19 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/ts_bpm.387.984614091"
datafile 20 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/ts_bpm.388.984614091"
datafile 21 switched to datafile copy "+DATAC1/HLCDB/6BD6EF5CB29C242EE053017AA8C0ADF1/DATAFILE/ts_bpm.381.984614291"

RMAN>
RMAN> switch database root to copy;

datafile 1 switched to datafile copy "+DATAC1/HLCDB/DATAFILE/system.391.984614011"
datafile 3 switched to datafile copy "+DATAC1/HLCDB/DATAFILE/sysaux.383.984614015"
datafile 4 switched to datafile copy "+DATAC1/HLCDB/DATAFILE/undotbs1.378.984614011"
datafile 7 switched to datafile copy "+DATAC1/HLCDB/DATAFILE/users.386.984614011"

RMAN>
RMAN> recover database skip forever tablespace CFMDB_PRD:SYSTEM,CFMDB_PRD:SYSAUX,CFMDB_PRD:UNDOTBS1,CFMDB_PRD:TS_CFM,CFMDB_PRD:TS_CFM_HIS;

Starting recover at 20-AUG-2018 08:18:34
using channel ORA_DISK_1

Executing: alter database datafile 22 offline drop
Executing: alter database datafile 23 offline drop
Executing: alter database datafile 24 offline drop
Executing: alter database datafile 66 offline drop
Executing: alter database datafile 67 offline drop
Executing: alter database datafile 68 offline drop
Executing: alter database datafile 69 offline drop
Executing: alter database datafile 70 offline drop
Executing: alter database datafile 71 offline drop
Executing: alter database datafile 72 offline drop
Executing: alter database datafile 73 offline drop
Executing: alter database datafile 74 offline drop
Executing: alter database datafile 75 offline drop
Executing: alter database datafile 25 offline drop
Executing: alter database datafile 26 offline drop
Executing: alter database datafile 27 offline drop
Executing: alter database datafile 28 offline drop
Executing: alter database datafile 29 offline drop
Executing: alter database datafile 30 offline drop
Executing: alter database datafile 37 offline drop
Executing: alter database datafile 38 offline drop
Executing: alter database datafile 39 offline drop
Executing: alter database datafile 40 offline drop
Executing: alter database datafile 41 offline drop
Executing: alter database datafile 42 offline drop
Executing: alter database datafile 43 offline drop
Executing: alter database datafile 44 offline drop
Executing: alter database datafile 45 offline drop
Executing: alter database datafile 46 offline drop
Executing: alter database datafile 47 offline drop
Executing: alter database datafile 48 offline drop
Executing: alter database datafile 49 offline drop
Executing: alter database datafile 50 offline drop
Executing: alter database datafile 51 offline drop
Executing: alter database datafile 52 offline drop
Executing: alter database datafile 53 offline drop
Executing: alter database datafile 54 offline drop
Executing: alter database datafile 55 offline drop
Executing: alter database datafile 56 offline drop
Executing: alter database datafile 57 offline drop
Executing: alter database datafile 58 offline drop
Executing: alter database datafile 59 offline drop
Executing: alter database datafile 60 offline drop
Executing: alter database datafile 61 offline drop
Executing: alter database datafile 62 offline drop
Executing: alter database datafile 63 offline drop
Executing: alter database datafile 64 offline drop
Executing: alter database datafile 65 offline drop
Executing: alter database datafile 76 offline drop
Executing: alter database datafile 77 offline drop
Executing: alter database datafile 78 offline drop
Executing: alter database datafile 79 offline drop
Executing: alter database datafile 80 offline drop
Executing: alter database datafile 81 offline drop
Executing: alter database datafile 82 offline drop
Executing: alter database datafile 83 offline drop
Executing: alter database datafile 84 offline drop
Executing: alter database datafile 85 offline drop
Executing: alter database datafile 86 offline drop
Executing: alter database datafile 87 offline drop
Executing: alter database datafile 88 offline drop
Executing: alter database datafile 89 offline drop
Executing: alter database datafile 90 offline drop
Executing: alter database datafile 91 offline drop
Executing: alter database datafile 92 offline drop
Executing: alter database datafile 93 offline drop
Executing: alter database datafile 94 offline drop
Executing: alter database datafile 95 offline drop
Executing: alter database datafile 96 offline drop
Executing: alter database datafile 97 offline drop
Executing: alter database datafile 98 offline drop
Executing: alter database datafile 99 offline drop
Executing: alter database datafile 100 offline drop
Executing: alter database datafile 101 offline drop
Executing: alter database datafile 102 offline drop
Executing: alter database datafile 103 offline drop
Executing: alter database datafile 104 offline drop
Executing: alter database datafile 105 offline drop
Executing: alter database datafile 106 offline drop
Executing: alter database datafile 107 offline drop
Executing: alter database datafile 108 offline drop
Executing: alter database datafile 109 offline drop
Executing: alter database datafile 110 offline drop
Executing: alter database datafile 111 offline drop
Executing: alter database datafile 112 offline drop
Executing: alter database datafile 113 offline drop
Executing: alter database datafile 114 offline drop
Executing: alter database datafile 115 offline drop
Executing: alter database datafile 116 offline drop
Executing: alter database datafile 117 offline drop
Executing: alter database datafile 118 offline drop
Executing: alter database datafile 119 offline drop
Executing: alter database datafile 120 offline drop
Executing: alter database datafile 121 offline drop
Executing: alter database datafile 122 offline drop
Executing: alter database datafile 123 offline drop
Executing: alter database datafile 124 offline drop
Executing: alter database datafile 125 offline drop
Executing: alter database datafile 126 offline drop
Executing: alter database datafile 127 offline drop
Executing: alter database datafile 128 offline drop
Executing: alter database datafile 129 offline drop
Executing: alter database datafile 130 offline drop
Executing: alter database datafile 131 offline drop
Executing: alter database datafile 132 offline drop
Executing: alter database datafile 133 offline drop
Executing: alter database datafile 134 offline drop
Executing: alter database datafile 135 offline drop
Executing: alter database datafile 136 offline drop
Executing: alter database datafile 137 offline drop
Executing: alter database datafile 138 offline drop
Executing: alter database datafile 139 offline drop
Executing: alter database datafile 140 offline drop
Executing: alter database datafile 141 offline drop
Executing: alter database datafile 142 offline drop
Executing: alter database datafile 143 offline drop
Executing: alter database datafile 144 offline drop
Executing: alter database datafile 145 offline drop
Executing: alter database datafile 146 offline drop
Executing: alter database datafile 147 offline drop
Executing: alter database datafile 148 offline drop
Executing: alter database datafile 149 offline drop
Executing: alter database datafile 150 offline drop
Executing: alter database datafile 151 offline drop
Executing: alter database datafile 152 offline drop
Executing: alter database datafile 153 offline drop
Executing: alter database datafile 154 offline drop
Executing: alter database datafile 155 offline drop
Executing: alter database datafile 156 offline drop
Executing: alter database datafile 157 offline drop
Executing: alter database datafile 158 offline drop
Executing: alter database datafile 159 offline drop
Executing: alter database datafile 160 offline drop
Executing: alter database datafile 161 offline drop
Executing: alter database datafile 162 offline drop
Executing: alter database datafile 163 offline drop
Executing: alter database datafile 164 offline drop
Executing: alter database datafile 165 offline drop
Executing: alter database datafile 166 offline drop
Executing: alter database datafile 167 offline drop
Executing: alter database datafile 168 offline drop
Executing: alter database datafile 169 offline drop
Executing: alter database datafile 170 offline drop
Executing: alter database datafile 171 offline drop
Executing: alter database datafile 172 offline drop
Executing: alter database datafile 173 offline drop
Executing: alter database datafile 174 offline drop
Executing: alter database datafile 175 offline drop
Executing: alter database datafile 176 offline drop
Executing: alter database datafile 177 offline drop
Executing: alter database datafile 178 offline drop
Executing: alter database datafile 179 offline drop
Executing: alter database datafile 180 offline drop
Executing: alter database datafile 181 offline drop
Executing: alter database datafile 182 offline drop
Executing: alter database datafile 183 offline drop
Executing: alter database datafile 184 offline drop
Executing: alter database datafile 185 offline drop
Executing: alter database datafile 186 offline drop
Executing: alter database datafile 187 offline drop
Executing: alter database datafile 188 offline drop
Executing: alter database datafile 189 offline drop
Executing: alter database datafile 190 offline drop
Executing: alter database datafile 191 offline drop
Executing: alter database datafile 192 offline drop
Executing: alter database datafile 193 offline drop
Executing: alter database datafile 194 offline drop
Executing: alter database datafile 195 offline drop
Executing: alter database datafile 196 offline drop
Executing: alter database datafile 197 offline drop
Executing: alter database datafile 198 offline drop
Executing: alter database datafile 199 offline drop
Executing: alter database datafile 200 offline drop
Executing: alter database datafile 201 offline drop
Executing: alter database datafile 202 offline drop
Executing: alter database datafile 203 offline drop
Executing: alter database datafile 204 offline drop
Executing: alter database datafile 205 offline drop
Executing: alter database datafile 206 offline drop
Executing: alter database datafile 31 offline drop
Executing: alter database datafile 32 offline drop
Executing: alter database datafile 33 offline drop
Executing: alter database datafile 34 offline drop
Executing: alter database datafile 35 offline drop
Executing: alter database datafile 36 offline drop
Executing: alter database datafile 207 offline drop
Executing: alter database datafile 208 offline drop
Executing: alter database datafile 209 offline drop
Executing: alter database datafile 210 offline drop
Executing: alter database datafile 211 offline drop
Executing: alter database datafile 212 offline drop
Executing: alter database datafile 213 offline drop
Executing: alter database datafile 214 offline drop
Executing: alter database datafile 215 offline drop
Executing: alter database datafile 216 offline drop
Executing: alter database datafile 217 offline drop
Executing: alter database datafile 218 offline drop
Executing: alter database datafile 219 offline drop
Executing: alter database datafile 220 offline drop
Executing: alter database datafile 221 offline drop
Executing: alter database datafile 222 offline drop
Executing: alter database datafile 223 offline drop
Executing: alter database datafile 224 offline drop
Executing: alter database datafile 225 offline drop
Executing: alter database datafile 226 offline drop
Executing: alter database datafile 227 offline drop
Executing: alter database datafile 228 offline drop
Executing: alter database datafile 229 offline drop
Executing: alter database datafile 230 offline drop
Executing: alter database datafile 231 offline drop
Executing: alter database datafile 232 offline drop
Executing: alter database datafile 233 offline drop
Executing: alter database datafile 234 offline drop
Executing: alter database datafile 235 offline drop
Executing: alter database datafile 236 offline drop
Executing: alter database datafile 237 offline drop
Executing: alter database datafile 238 offline drop
Executing: alter database datafile 239 offline drop
Executing: alter database datafile 240 offline drop
Executing: alter database datafile 241 offline drop
Executing: alter database datafile 242 offline drop
Executing: alter database datafile 243 offline drop
Executing: alter database datafile 244 offline drop
Executing: alter database datafile 245 offline drop
Executing: alter database datafile 246 offline drop
Executing: alter database datafile 247 offline drop
Executing: alter database datafile 248 offline drop
Executing: alter database datafile 249 offline drop
Executing: alter database datafile 250 offline drop
Executing: alter database datafile 251 offline drop
Executing: alter database datafile 252 offline drop
Executing: alter database datafile 253 offline drop
Executing: alter database datafile 254 offline drop
Executing: alter database datafile 255 offline drop
Executing: alter database datafile 256 offline drop
Executing: alter database datafile 257 offline drop
Executing: alter database datafile 258 offline drop
Executing: alter database datafile 259 offline drop
Executing: alter database datafile 260 offline drop
Executing: alter database datafile 261 offline drop
Executing: alter database datafile 262 offline drop
Executing: alter database datafile 263 offline drop
Executing: alter database datafile 264 offline drop
Executing: alter database datafile 265 offline drop
Executing: alter database datafile 266 offline drop
Executing: alter database datafile 267 offline drop
Executing: alter database datafile 268 offline drop
Executing: alter database datafile 269 offline drop
Executing: alter database datafile 270 offline drop
Executing: alter database datafile 271 offline drop
Executing: alter database datafile 272 offline drop
Executing: alter database datafile 273 offline drop
Executing: alter database datafile 274 offline drop
Executing: alter database datafile 275 offline drop
Executing: alter database datafile 276 offline drop
Executing: alter database datafile 277 offline drop
Executing: alter database datafile 278 offline drop
Executing: alter database datafile 279 offline drop
Executing: alter database datafile 280 offline drop
Executing: alter database datafile 281 offline drop
Executing: alter database datafile 282 offline drop
Executing: alter database datafile 283 offline drop
Executing: alter database datafile 284 offline drop
Executing: alter database datafile 285 offline drop
Executing: alter database datafile 286 offline drop
Executing: alter database datafile 287 offline drop
Executing: alter database datafile 288 offline drop
Executing: alter database datafile 289 offline drop
Executing: alter database datafile 290 offline drop
Executing: alter database datafile 291 offline drop
Executing: alter database datafile 292 offline drop
Executing: alter database datafile 293 offline drop
Executing: alter database datafile 294 offline drop
Executing: alter database datafile 295 offline drop
Executing: alter database datafile 296 offline drop
Executing: alter database datafile 297 offline drop
Executing: alter database datafile 298 offline drop
Executing: alter database datafile 299 offline drop
Executing: alter database datafile 300 offline drop
Executing: alter database datafile 301 offline drop
Executing: alter database datafile 302 offline drop
Executing: alter database datafile 303 offline drop
Executing: alter database datafile 304 offline drop
Executing: alter database datafile 305 offline drop
Executing: alter database datafile 306 offline drop
Executing: alter database datafile 307 offline drop
Executing: alter database datafile 308 offline drop
Executing: alter database datafile 309 offline drop
Executing: alter database datafile 310 offline drop
Executing: alter database datafile 311 offline drop
Executing: alter database datafile 312 offline drop
Executing: alter database datafile 313 offline drop
Executing: alter database datafile 314 offline drop
Executing: alter database datafile 315 offline drop
Executing: alter database datafile 316 offline drop
Executing: alter database datafile 317 offline drop
Executing: alter database datafile 318 offline drop
Executing: alter database datafile 319 offline drop
Executing: alter database datafile 320 offline drop
Executing: alter database datafile 321 offline drop
Executing: alter database datafile 322 offline drop
Executing: alter database datafile 323 offline drop
Executing: alter database datafile 324 offline drop
Executing: alter database datafile 325 offline drop
Executing: alter database datafile 326 offline drop
Executing: alter database datafile 327 offline drop
Executing: alter database datafile 328 offline drop
Executing: alter database datafile 329 offline drop
Executing: alter database datafile 330 offline drop
Executing: alter database datafile 331 offline drop
Executing: alter database datafile 332 offline drop
starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=50762
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/al_2663_1_984387680
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/al_2663_1_984387680 tag=TAG20180817T090120
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
archived log file name=+RECOC1/HLCDB/ARCHIVELOG/2018_08_20/thread_1_seq_50762.894.984644329 thread=1 sequence=50762
channel default: deleting archived log(s)
archived log file name=+RECOC1/HLCDB/ARCHIVELOG/2018_08_20/thread_1_seq_50762.894.984644329 RECID=12414 STAMP=984644372
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=50763
channel ORA_DISK_1: reading from backup piece /u02/rmanbackup/arch/al_2664_1_984387680
channel ORA_DISK_1: piece handle=/u02/rmanbackup/arch/al_2664_1_984387680 tag=TAG20180817T090120
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+RECOC1/HLCDB/ARCHIVELOG/2018_08_20/thread_1_seq_50763.894.984644375 thread=1 sequence=50763
channel default: deleting archived log(s)
archived log file name=+RECOC1/HLCDB/ARCHIVELOG/2018_08_20/thread_1_seq_50763.894.984644375 RECID=12415 STAMP=984644376
unable to find archived log
archived log thread=1 sequence=50764
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/20/2018 08:19:37
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 50764 and starting SCN of 799273265

RMAN>

 

重建控制文件，是由于redo问题，resetlogs打开时，找不到对应的asm磁盘组。如果异机存在同名的磁盘组，应该可以resetlogs正常打开
SQL> @/home/oracle/hlcdbstoretest/aa.sql

Control file created.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 _###_UNKNOWN_PDB_#_3 MOUNTED
SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open resetlogs;

Database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 BPMDB_PRD MOUNTED
4 CFMDB_PRD MOUNTED
SQL> alter pluggable database BPMDB_PRD open;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 BPMDB_PRD READ WRITE NO
4 CFMDB_PRD MOUNTED
SQL>

 

转载于:https://www.cnblogs.com/erwadba/p/9532559.html