oracle异机还原一个pdb,CDB中备份，以及异机恢复的测试

最新推荐文章于 2024-04-19 19:31:10 发布
最新推荐文章于 2024-04-19 19:31:10 发布
阅读量982 收藏
点赞数
文章标签： oracle异机还原一个pdb

cdb+pdb$seed全备 (由于cdb和pdb$seed种子库所占空间总容量不多，所以每次都可以执行全备，不完全恢复的时候，restore时注意选择cdb库的时间)

RUN{

ALLOCATE CHANNEL ch0 TYPE DISK;

backup as compressed backupset INCREMENTAL LEVEL=0 FILESPERSET 5 database root tag cdbfull_lv0 format '/u01/arch/bk_%s_%p_%t';

backup as compressed backupset INCREMENTAL LEVEL=0 FILESPERSET 5 database 'PDB$SEED' forcetag cdbfull_lv0 format '/u01/arch/bk_%s_%p_%t';

RELEASE CHANNEL ch0;

}

pdb全备

RUN {

# backup all archive logs

ALLOCATE CHANNEL ch0 TYPE DISK;

backup as compressed backupset INCREMENTAL LEVEL=0 FILESPERSET 5 pluggable database ERWAPDB tag pdbfull_lv0 format '/u01/arch/bk_%s_%p_%t';

sql 'alter system archive log current';

backup as compressed backupset filesperset 20 FORMAT '/u01/arch/al_%s_%p_%t' ARCHIVELOG ALL;

backup FORMAT '/u01/arch/cntrl_%s_%p_%t' CURRENT CONTROLFILE tag=cntrl_lv0;

backup FORMAT '/u01/arch/spfile_%s_%p_%t' spfile tag=sfile_lv0;

RELEASE CHANNEL ch0;

}

pdb累积差异备份

RUN {

# backup all archive logs

ALLOCATE CHANNEL ch0 TYPE DISK;

backup as compressed backupset INCREMENTAL LEVEL=1 CUMULATIVE FILESPERSET 5 pluggable database ERWAPDB tag pdbfull_lv0 format '/u01/arch/bk_%s_%p_%t';

sql 'alter system archive log current';

backup as compressed backupset filesperset 20 FORMAT '/u01/arch/al_%s_%p_%t' ARCHIVELOG ALL;

backup FORMAT '/u01/arch/cntrl_%s_%p_%t' CURRENT CONTROLFILE tag=cntrl_lv0;

backup FORMAT '/u01/arch/spfile_%s_%p_%t' spfile tag=sfile_lv0;

RELEASE CHANNEL ch0;

}

参考资料：

How to use Rman to Restore Of Single PDB in Multitenant to Alternate Server (文档 ID 2142675.1)

Missing PDB$SEED's Datafiles with no backup (文档 ID 2104370.1)

R12c 新特性：RMAN 可插拔数据库的备份和恢复 (文档 ID 1945849.1)

测试的log记录

cdb全备：

[oracle@lxtrac05 arch]$ rman target /

Recovery Manager: Release 18.0.0.0.0 - Production on Mon Aug 13 15:28:45 2018

Version 18.3.0.0.0

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

connected to target database: ORCL (DBID=1510984000)

RMAN> RUN{

2> ALLOCATE CHANNEL ch0 TYPE DISK;

3> backup as compressed backupset INCREMENTAL LEVEL=0 FILESPERSET 5 database root tag cdbfull_lv0 format '/u01/arch/bk_%s_%p_%t';

4> backup as compressed backupset INCREMENTAL LEVEL=0 FILESPERSET 5 database "PDB$SEED" tag cdbfull_lv0 format '/u01/arch/bk_%s_%p_%t';

5> RELEASE CHANNEL ch0;

6> }

using target database control file instead of recovery catalog

allocated channel: ch0

channel ch0: SID=400 device type=DISK

Starting backup at 13-AUG-18

channel ch0: starting compressed incremental level 0 datafile backup set

channel ch0: specifying datafile(s) in backup set

input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/sysaux01.dbf

input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/system01.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/undotbs01.dbf

input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/users01.dbf

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/bk_101_1_984065363 tag=CDBFULL_LV0 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:55

Finished backup at 13-AUG-18

Starting backup at 13-AUG-18

channel ch0: starting compressed incremental level 0 datafile backup set

channel ch0: specifying datafile(s) in backup set

input datafile file number=00006 name=/u01/app/oracle/oradata/ORCL/pdbseed/sysaux01.dbf

input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/pdbseed/system01.dbf

input datafile file number=00008 name=/u01/app/oracle/oradata/ORCL/pdbseed/undotbs01.dbf

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/bk_102_1_984065418 tag=CDBFULL_LV0 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:25

Finished backup at 13-AUG-18

Starting Control File and SPFILE Autobackup at 13-AUG-18

piece handle=/u01/arch/ORCL/autobackup/2018_08_13/o1_mf_s_984065444_fq2dx43y_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 13-AUG-18

released channel: ch0

RMAN>

pdb全备+归档日志备份：

[oracle@lxtrac05 arch]$ rman target /

Recovery Manager: Release 18.0.0.0.0 - Production on Mon Aug 13 15:32:51 2018

Version 18.3.0.0.0

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

connected to target database: ORCL (DBID=1510984000)

RMAN> RUN {

2> # backup all archive logs

3> ALLOCATE CHANNEL ch0 TYPE DISK;

4> backup as compressed backupset INCREMENTAL LEVEL=0 FILESPERSET 5 pluggable database ERWAPDB tag pdbfull_lv0 format '/u01/arch/bk_%s_%p_%t';

5> sql 'alter system archive log current';

6> backup as compressed backupset filesperset 20 FORMAT '/u01/arch/al_%s_%p_%t' ARCHIVELOG ALL;

7> backup FORMAT '/u01/arch/cntrl_%s_%p_%t' CURRENT CONTROLFILE tag=cntrl_lv0;

8> backup FORMAT '/u01/arch/spfile_%s_%p_%t' spfile tag=sfile_lv0;

9> RELEASE CHANNEL ch0;

10> }

using target database control file instead of recovery catalog

allocated channel: ch0

channel ch0: SID=397 device type=DISK

Starting backup at 13-AUG-18

channel ch0: starting compressed incremental level 0 datafile backup set

channel ch0: specifying datafile(s) in backup set

input datafile file number=00010 name=/u01/app/oracle/oradata/ORCL/erwapdb/sysaux01.dbf

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/bk_104_1_984065573 tag=PDBFULL_LV0 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:25

channel ch0: starting compressed incremental level 0 datafile backup set

channel ch0: specifying datafile(s) in backup set

input datafile file number=00009 name=/u01/app/oracle/oradata/ORCL/erwapdb/system01.dbf

input datafile file number=00011 name=/u01/app/oracle/oradata/ORCL/erwapdb/undotbs01.dbf

input datafile file number=00013 name=/u01/app/oracle/oradata/ORCL/erwapdb/erwa01.dbf

input datafile file number=00012 name=/u01/app/oracle/oradata/ORCL/erwapdb/users01.dbf

input datafile file number=00014 name=/u01/app/oracle/oradata/ORCL/erwapdb/test02.dbf

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/bk_105_1_984065598 tag=PDBFULL_LV0 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:15

Finished backup at 13-AUG-18

Starting Control File and SPFILE Autobackup at 13-AUG-18

piece handle=/u01/arch/ORCL/autobackup/2018_08_13/o1_mf_s_984065613_fq2f2g3p_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 13-AUG-18

sql statement: alter system archive log current

Starting backup at 13-AUG-18

current log archived

channel ch0: starting compressed archived log backup set

channel ch0: specifying archived log(s) in backup set

input archived log thread=1 sequence=61 RECID=39 STAMP=984047671

input archived log thread=1 sequence=62 RECID=40 STAMP=984047671

input archived log thread=1 sequence=63 RECID=41 STAMP=984048277

input archived log thread=1 sequence=64 RECID=42 STAMP=984048277

input archived log thread=1 sequence=65 RECID=43 STAMP=984059334

input archived log thread=1 sequence=66 RECID=44 STAMP=984059384

input archived log thread=1 sequence=67 RECID=45 STAMP=984059387

input archived log thread=1 sequence=68 RECID=46 STAMP=984059627

input archived log thread=1 sequence=69 RECID=47 STAMP=984059627

input archived log thread=1 sequence=70 RECID=48 STAMP=984059630

input archived log thread=1 sequence=71 RECID=49 STAMP=984059630

input archived log thread=1 sequence=72 RECID=50 STAMP=984059712

input archived log thread=1 sequence=73 RECID=51 STAMP=984059713

input archived log thread=1 sequence=74 RECID=52 STAMP=984059723

input archived log thread=1 sequence=75 RECID=53 STAMP=984059723

input archived log thread=1 sequence=76 RECID=54 STAMP=984064487

input archived log thread=1 sequence=77 RECID=55 STAMP=984064487

input archived log thread=1 sequence=78 RECID=56 STAMP=984065615

input archived log thread=1 sequence=79 RECID=57 STAMP=984065615

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/al_107_1_984065615 tag=TAG20180813T153335 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:07

Finished backup at 13-AUG-18

Starting backup at 13-AUG-18

channel ch0: starting full datafile backup set

channel ch0: specifying datafile(s) in backup set

including current control file in backup set

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/cntrl_108_1_984065623 tag=CNTRL_LV0 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:01

Finished backup at 13-AUG-18

Starting backup at 13-AUG-18

channel ch0: starting full datafile backup set

channel ch0: specifying datafile(s) in backup set

including current SPFILE in backup set

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/spfile_109_1_984065625 tag=SFILE_LV0 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:01

Finished backup at 13-AUG-18

Starting Control File and SPFILE Autobackup at 13-AUG-18

piece handle=/u01/arch/ORCL/autobackup/2018_08_13/o1_mf_s_984065626_fq2f2tk0_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 13-AUG-18

released channel: ch0

RMAN>

pdb累积增量备份

[oracle@lxtrac05 arch]$ rman target /

Recovery Manager: Release 18.0.0.0.0 - Production on Mon Aug 13 15:40:42 2018

Version 18.3.0.0.0

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

connected to target database: ORCL (DBID=1510984000)

RMAN> RUN {

2> # backup all archive logs

3> ALLOCATE CHANNEL ch0 TYPE DISK;

4> backup as compressed backupset INCREMENTAL LEVEL=1 CUMULATIVE FILESPERSET 5 pluggable database ERWAPDB tag pdbfull_lv0 format '/u01/arch/bk_%s_%p_%t';

5> sql 'alter system archive log current';

6> backup as compressed backupset filesperset 20 FORMAT '/u01/arch/al_%s_%p_%t' ARCHIVELOG ALL;

7> backup FORMAT '/u01/arch/cntrl_%s_%p_%t' CURRENT CONTROLFILE tag=cntrl_lv0;

8> backup FORMAT '/u01/arch/spfile_%s_%p_%t' spfile tag=sfile_lv0;

9> RELEASE CHANNEL ch0;

10> }

using target database control file instead of recovery catalog

allocated channel: ch0

channel ch0: SID=397 device type=DISK

Starting backup at 13-AUG-18

channel ch0: starting compressed incremental level 1 datafile backup set

channel ch0: specifying datafile(s) in backup set

input datafile file number=00010 name=/u01/app/oracle/oradata/ORCL/erwapdb/sysaux01.dbf

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/bk_111_1_984066053 tag=PDBFULL_LV0 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:01

channel ch0: starting compressed incremental level 1 datafile backup set

channel ch0: specifying datafile(s) in backup set

input datafile file number=00009 name=/u01/app/oracle/oradata/ORCL/erwapdb/system01.dbf

input datafile file number=00011 name=/u01/app/oracle/oradata/ORCL/erwapdb/undotbs01.dbf

input datafile file number=00013 name=/u01/app/oracle/oradata/ORCL/erwapdb/erwa01.dbf

input datafile file number=00012 name=/u01/app/oracle/oradata/ORCL/erwapdb/users01.dbf

input datafile file number=00015 name=/u01/app/oracle/oradata/ORCL/erwapdb/test03.dbf

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/bk_112_1_984066055 tag=PDBFULL_LV0 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:01

Finished backup at 13-AUG-18

Starting Control File and SPFILE Autobackup at 13-AUG-18

piece handle=/u01/arch/ORCL/autobackup/2018_08_13/o1_mf_s_984066056_fq2fj895_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 13-AUG-18

sql statement: alter system archive log current

Starting backup at 13-AUG-18

current log archived

channel ch0: starting compressed archived log backup set

channel ch0: specifying archived log(s) in backup set

input archived log thread=1 sequence=61 RECID=39 STAMP=984047671

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/al_114_1_984066057 tag=TAG20180813T154057 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:07

channel ch0: starting compressed archived log backup set

channel ch0: specifying archived log(s) in backup set

input archived log thread=1 sequence=62 RECID=40 STAMP=984047671

input archived log thread=1 sequence=63 RECID=41 STAMP=984048277

input archived log thread=1 sequence=64 RECID=42 STAMP=984048277

input archived log thread=1 sequence=65 RECID=43 STAMP=984059334

input archived log thread=1 sequence=66 RECID=44 STAMP=984059384

input archived log thread=1 sequence=67 RECID=45 STAMP=984059387

input archived log thread=1 sequence=68 RECID=46 STAMP=984059627

input archived log thread=1 sequence=69 RECID=47 STAMP=984059627

input archived log thread=1 sequence=70 RECID=48 STAMP=984059630

input archived log thread=1 sequence=71 RECID=49 STAMP=984059630

input archived log thread=1 sequence=72 RECID=50 STAMP=984059712

input archived log thread=1 sequence=73 RECID=51 STAMP=984059713

input archived log thread=1 sequence=74 RECID=52 STAMP=984059723

input archived log thread=1 sequence=75 RECID=53 STAMP=984059723

input archived log thread=1 sequence=76 RECID=54 STAMP=984064487

input archived log thread=1 sequence=77 RECID=55 STAMP=984064487

input archived log thread=1 sequence=78 RECID=56 STAMP=984065615

input archived log thread=1 sequence=79 RECID=57 STAMP=984065615

input archived log thread=1 sequence=80 RECID=58 STAMP=984066057

input archived log thread=1 sequence=81 RECID=59 STAMP=984066057

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/al_115_1_984066064 tag=TAG20180813T154057 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:01

Finished backup at 13-AUG-18

Starting backup at 13-AUG-18

channel ch0: starting full datafile backup set

channel ch0: specifying datafile(s) in backup set

including current control file in backup set

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/cntrl_116_1_984066066 tag=CNTRL_LV0 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:01

Finished backup at 13-AUG-18

Starting backup at 13-AUG-18

channel ch0: starting full datafile backup set

channel ch0: specifying datafile(s) in backup set

including current SPFILE in backup set

channel ch0: starting piece 1 at 13-AUG-18

channel ch0: finished piece 1 at 13-AUG-18

piece handle=/u01/arch/spfile_117_1_984066068 tag=SFILE_LV0 comment=NONE

channel ch0: backup set complete, elapsed time: 00:00:01

Finished backup at 13-AUG-18

Starting Control File and SPFILE Autobackup at 13-AUG-18

piece handle=/u01/arch/ORCL/autobackup/2018_08_13/o1_mf_s_984066069_fq2fjomg_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 13-AUG-18

released channel: ch0

RMAN>

CDB异机恢复操作

1.恢复spfile文件，恢复控制文件

RMAN> restore spfile to '/u01/app/oracle/oradata/ORCL/spfileORCL.ora' from '/u01/arch/spfile_58_1_984048287';

Starting restore at 13-AUG-2018 10:55:10

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=2543 device type=DISK

channel ORA_DISK_1: restoring spfile from AUTOBACKUP /u01/arch/spfile_58_1_984048287

channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete

Finished restore at 13-AUG-2018 10:55:12

RMAN>

控制文件

RMAN> restore controlfile to '/u01/app/oracle/oradata/ORCL/control01.ctl' from '/u01/arch/cntrl_57_1_984048285';

Starting restore at 13-AUG-2018 10:56:50

using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

Finished restore at 13-AUG-2018 10:56:51

RMAN>

2.使用恢复的spfile+控制文件，将数据库启动到mount状态。spfile的一些参数可能需要修改

[oracle@lenovotest2 arch]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Aug 13 11:03:47 2018

Version 18.3.0.0.0

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

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 4966054640 bytes

Fixed Size 8907504 bytes

Variable Size 2063597568 bytes

Database Buffers 2868903936 bytes

Redo Buffers 24645632 bytes

SQL> alter database mount;

Database altered.

SQL>

3.查看备份文件，然后restore database

RMAN> catalog start with '/u01/arch'; <<

恢复cdb+pdb$seed lv0

RMAN> run {

2> # set newname for to '+ASM'

3> restore database root ;

4> restore database "PDB$SEED";

5> }

Starting restore at 13-AUG-2018 15:48:16

Starting implicit crosscheck backup at 13-AUG-2018 15:48:16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=33 device type=DISK

Crosschecked 15 objects

Finished implicit crosscheck backup at 13-AUG-2018 15:48:17

Starting implicit crosscheck copy at 13-AUG-2018 15:48:17

using channel ORA_DISK_1

Finished implicit crosscheck copy at 13-AUG-2018 15:48:17

searching for all files in the recovery area

cataloging files...

no files cataloged

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 00001 to /u01/app/oracle/oradata/ORCL/system01.dbf

channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ORCL/sysaux01.dbf

channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ORCL/undotbs01.dbf

channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/ORCL/users01.dbf

channel ORA_DISK_1: reading from backup piece /u01/arch/bk_101_1_984065363

channel ORA_DISK_1: piece handle=/u01/arch/bk_101_1_984065363 tag=CDBFULL_LV0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:01:05

Finished restore at 13-AUG-2018 15:49:23

Starting restore at 13-AUG-2018 15:49:23

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 00005 to /u01/app/oracle/oradata/ORCL/pdbseed/system01.dbf

channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/ORCL/pdbseed/sysaux01.dbf

channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/ORCL/pdbseed/undotbs01.dbf

channel ORA_DISK_1: reading from backup piece /u01/arch/bk_102_1_984065418

channel ORA_DISK_1: piece handle=/u01/arch/bk_102_1_984065418 tag=CDBFULL_LV0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:25

Finished restore at 13-AUG-2018 15:49:48

RMAN>

恢复pdb lv0

RMAN> restore database erwapdb;

Starting restore at 13-AUG-2018 15:59:23

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 00010 to /u01/app/oracle/oradata/ORCL/erwapdb/sysaux01.dbf

channel ORA_DISK_1: reading from backup piece /u01/arch/bk_104_1_984065573

channel ORA_DISK_1: piece handle=/u01/arch/bk_104_1_984065573 tag=PDBFULL_LV0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:15

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 /u01/app/oracle/oradata/ORCL/erwapdb/system01.dbf

channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/ORCL/erwapdb/undotbs01.dbf

channel ORA_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/ORCL/erwapdb/users01.dbf

channel ORA_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/ORCL/erwapdb/erwa01.dbf

channel ORA_DISK_1: reading from backup piece /u01/arch/bk_105_1_984065598

channel ORA_DISK_1: piece handle=/u01/arch/bk_105_1_984065598 tag=PDBFULL_LV0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:15

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 /u01/app/oracle/oradata/ORCL/erwapdb/test03.dbf

channel ORA_DISK_1: reading from backup piece /u01/arch/bk_112_1_984066055

channel ORA_DISK_1: piece handle=/u01/arch/bk_112_1_984066055 tag=PDBFULL_LV0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

Finished restore at 13-AUG-2018 15:59:55

RMAN>

recover database cdb+pdb(执行不完全恢复的 时间/logseq)

RMAN> recover database;

Starting recover at 13-AUG-2018 16:47:00

using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 78 is already on disk as file /u01/arch/ORCL/archivelog/2018_08_13/o1_mf_1_78_fq2j7tvk_.arc

archived log for thread 1 with sequence 79 is already on disk as file /u01/arch/ORCL/archivelog/2018_08_13/o1_mf_1_79_fq2j7vb3_.arc

archived log for thread 1 with sequence 80 is already on disk as file /u01/arch/ORCL/archivelog/2018_08_13/o1_mf_1_80_fq2j7tx4_.arc

archived log for thread 1 with sequence 81 is already on disk as file /u01/arch/ORCL/archivelog/2018_08_13/o1_mf_1_81_fq2j7vb6_.arc

archived log file name=/u01/arch/ORCL/archivelog/2018_08_13/o1_mf_1_78_fq2j7tvk_.arc thread=1 sequence=78

archived log file name=/u01/arch/ORCL/archivelog/2018_08_13/o1_mf_1_79_fq2j7vb3_.arc thread=1 sequence=79

archived log file name=/u01/arch/ORCL/archivelog/2018_08_13/o1_mf_1_80_fq2j7tx4_.arc thread=1 sequence=80

archived log file name=/u01/arch/ORCL/archivelog/2018_08_13/o1_mf_1_81_fq2j7vb6_.arc thread=1 sequence=81

unable to find archived log

archived log thread=1 sequence=82

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 08/13/2018 16:47:02

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 82 and starting SCN of 2945920 <<<

RMAN>

用restlogs打开数据库

RMAN> alter database open resetlogs;

Statement processed

RMAN>

备注：

由于配置了CONFIGURE BACKUP OPTIMIZATION ON; 在备份的时候会跳过read only的表空间。也就是说pdb$seed会被跳过。在脚本里面加force即可。保证每次都会备份

继小驹
关注
oracle 19c rman定时全库备份与cdb/pdb/全库恢复操作
it知识分享 free for nothing..
09-27 2877
oracle 19c 定时全库备份与cdb/pdb/全库恢复操作
oracle rman pdb异机恢复,使用RMAN来PDB执行完全恢复
weixin_30131105的博客
04-16 832
可以对一个或多个PDB执行完全恢复而不影响其它为open状态的PDB的操作。RMAN有两种方法来恢复PDB:.连接到CDB的root容器，然后使用restore pluggable database与recover pluggable database命令。这种方法能让你使用单个命令来恢复多个PDB。.连接到PDB并使用restore database与recover database语句，这种方...
Oracle pdb 不停库异机恢复测试
Th record of huo.
06-28 715
一、不同CDB恢复 1、打开数据库归档模式 alter system set log_archive_dest_1='location=+oradata/arch'; ORACLE instance started. Total System Global Area 1543500832 bytes Fixed Size 9135136 bytes Variable Size 1291845632 bytes Database Buffers ...
oracle异机还原一个pdb,Oracle12c多租户数据库备份与恢复 - 恢复一个PDB
weixin_35500243的博客
04-12 557
单独恢复一个PDB例子：a. 查看某测试表wh.wh_PAY_GROUP_LOG的数据SQL> alter session set container=plugdb ;Session altered.SQL> select count(1) from wh.wh_PAY_GROUP_LOG ;COUNT(1)----------330594b. 备份pluggable datab...
Oracle 11g rman 异机还原再升级到 12c PDB
03-23
oracle 11.2.0.4异机还原升级到12c，然后再从non-pdb转成pdb整理详细文档。
[Oracle][PDB]PDB restore/recover 过程记录
weixin_34195142的博客
09-29 185
友人给的PDB restore / recover 的过程。实际上会创建一个辅助Instance，然后抽取出PDB,进行恢复。   (10:31:59) frank.yan: [Administrator.WIN-7ZFXNFKSD8P] ➤ ./rman target /Recovery Manager: Release 12.1.0.1.0 - Production on Fri May ...
oracle rman 异机恢复单个PDB
03-28
以下是异机恢复单个PDB的基本步骤： 1. 在源数据库中备份PDB，使用RMAN备份命令。 2. 在目标服务器上创建一个新的CDB（容器数据库）。 3. 将备份文件复制到目标服务器上。 4. 在目标服务器上使用RMAN还原备份...
oracle 19c 容器数据库rman备份与恢复配置（一）
m0_70247753的博客
09-05 843
当需要配置多个归档日志文件位置用log_archive_dest_n。当只需要配置一个归档日志文件位置用log_archive_dest。如果启用了闪回区，oracle默认把归档日志文件放在了闪回区。
oracle pdb 临时表空间,12C关于CDB、PDB 临时temp表空间的总结
weixin_42339061的博客
04-06 1088
官方文档1、每个容器都有属于的自己的temp表空间，PDB不共享CDB的temp表空间，CDB有自己的temp表空间，每个PDB也有自己的tmep表空间2、当前容器下创建的tempfile只属于当前容器的temp表空间，也就是说CDB下创建的tempfile只属于CDB，某个PDB创建的tempfile只属于这个PDB自己3、当前容器可以删除CDB和任意PDB的tempfile，也就是说CDB可以...
Oracle 19c多租户下的NBU备份恢复性测试
wujiahua的博客
07-15 1440
一：环境介绍 整个实验都是基于生产环境下的需求集成，如果有需要复现的可以基于虚拟机进行 二：测试方法 基本测试思路为在保障数据库存在全备的情况下，关闭数据库然后删除数据文件，启动数据库，由于数据库丢失数据文件数据库启动失败，此时利用备份及恢复数据文件并启动数据库 针对多租户数据库首先克隆一个pdb,然后发起数据库备份，备份完成后保持原有的pdb读写打开状态，关闭新克隆pdb并删除此pdb的...
centosoracle异机还原.docx
06-10
NBU一体机异机恢复linux下oracle数据库完整过程文档。
数据库异机恢复(RMAN)
05-10
本文详细描述如果通过RMAN备份，及将备份在异机恢复的详细流程及操作方法
rman异机恢复实践全图解析(PDF)
11-08
RMAN异机恢复实践。 下面仍以linux为例来说明利用上面的全备来做异机恢复测试。 Windows平台需要将下面存放在$ORACLE_HOME/dbs下的文件房在$ORACLE_HOME/database下，同时需要使用oradim配置一个OracleServiceSID的服务。
Oracle数据库从入门到精通系列之二十：Linux上使用容器数据库(CDB)方式部署Oracle数据库19c详细步骤
最新发布
zhengzaifeidelushang的博客
04-19 337
这个命令授予名为debezium的用户在所有容器中创建会话的权限。这个命令授予名为debezium的用户在所有容器中设置当前容器的权限这个命令授予名为debezium的用户在所有容器中查询V_KaTeX parse error: Expected group after ‘_’ at position 22: …SE视图的SELECT权限。V_̲DATABASE视图提供了与数据库实例相关的信息，如数据库名称、版本、状态、控制文件、日志文件等等。
oracle 12c中CDB和PDB的备份还原实验
conghe6716的博客
07-19 2093
本文档分为两部分： 1.单个pdb备份还原 2.只cdb备份还原 1.rman只备份pdb SQL> show pdbs CON_ID CON_NAME...
ORACLE_OCP多租户之CDB与PDB的备份恢复和闪回
XiaoHG_CSDN的博客
01-10 708
ORACLE_OCP多租户之CDB与PDB的备份恢复和闪回 文章目标： 执行CDB和PDB备份 使用RMAN备份插入或未插入的PDB 从基本文件丢失中恢复CDB 从PDB数据文件丢失中恢复PDB 执行闪回数据库 复制PDB 验证CDB和PDB 一、目标 独立备份CDB和应用程序: CDB级别的ARCHIVELOG模式（尽在CDB级别） CDB备份和PDB备份 CDB和PDB级别的热备份 恢复不同级别的CDB或PDB : CDB的实例级恢复 完整的介质恢复: CDB或PDB临时文件 控制
Oracle CDB PDB的备份与恢复
dbhang的博客
09-07 4160
PDB的备份与恢复： 一：备份恢复整个CDB： 备份整个多租户容器数据库（CDB）类似于备份非CDB数据库。 备份整个CDB时，RMAN会备份根容器以及所有可插拔数据库（PDB）和归档重做日志。 备份整个CDB后，可以从CDB备份中恢复整个CDB，或者仅恢复根容器，或者恢复一个或多个PDB。 1.连接至根容器 [oracle@server1]$ rman target / 2.备份整个CDB RMAN>BACKUP DATABASE; RMAN>BACKUP DATABASE P
Oracle CDB与PDB的不完全恢复
dbhang的博客
09-07 598
CDB与PDB的不完全恢复 1.CDB的不完全恢复： 1.备份： RMAN> backup database ; RMAN> backup archivelog all; 2.误删除操作： SQL> create table test as select * from dba_objects; SQL> select current_scn from v$database; CURRENT_SCN ----------- 2361330 SQL> drop table
oracle pdb启动日志,案例:Oracle 12C 数据库pdb丢失数据文件后的完整恢复过程
weixin_39545310的博客
04-03 620
天萃荷净Oracle 12C数据库PDB中的数据文件丢失，导致整个cdb crash，pdb正常运行丢失数据文件相关恢复Oracle 12C数据库cdb本来就是open的，PDB中的数据文件丢失1.查询Oracle数据库相关状态C:\Users\oracleplus>sqlplus / as sysdbaSQL*Plus: Release 12.1.0.1.0 Production on 星...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值