Shulou(Shulou.com)06/01 Report--

You can perform a full restore of one or more PDB without affecting the other PDB in the open state. RMAN has two ways to restore PDB:

. Connect to the root container of CDB, and then use the restore pluggable database and recover pluggable database commands. This approach allows you to restore multiple PDB using a single command.

. Connect to PDB and use restore database and recover database statements, which only restores a single PDB and allows you to use the same command to restore the non-CDB database

Restore one or more PDB using RMAN

1. Start RMAN and connect to the root container using a public user with sysdba or sysbackup privileges

[oracle@jytest1] $rman target/ catalog rco/xxxxx@jypdb_173Recovery Manager: Release 12.2.0.1.0-Production on Mon Dec 11 16:56:58 2017Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.connected to target database: JY (DBID=979425723) connected to recovery catalog database

two。 Close the PDB where you want to perform the restore operation

SQL > alter pluggable database jypdb,testpdb close immediate;Pluggable database altered.SQL > select name,open_mode from v$pdbs NAME OPEN_MODE -PDB$SEED READ ONLYJYPDB MOUNTEDTESTPDB MOUNTEDSQL >

3. Optionally, use the configure command to configure the default device type and automatic channel

4. Execute the restore pluggable database and recover pluggable database commands, and the following statement restores jypdb,testpdb

RMAN > restore pluggable database jypdb,testpdb;Starting restore at 11-DEC-17starting full resync of recovery catalogfull resync completeallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=2279 instance=jy1 device type=DISKskipping datafile 5; already restored to file + DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675skipping datafile 6; already restored to file + DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675skipping datafile 8 Already restored to file + DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile (s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00010 to + DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649channel ORA_DISK_1: restoring datafile 00011 to + DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649channel ORA_DISK_1: restoring datafile 00012 to + DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649channel ORA_DISK_1: restoring Datafile 00013 to + DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649channel ORA_DISK_1: restoring datafile 00014 to + DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649channel ORA_DISK_1: restoring datafile 00015 to + DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609channel ORA_DISK_1: reading from backup piece + TEST/rman_backup/jy_979425723_20171211_0osls830_1_1channel ORA_DISK_1: piece handle=+TEST/rman_backup/jy_979425723_20171211_0osls830_1_1 tag=TAG20171211T164446channel ORA_DISK_ 1: restored backup piece 1channel ORA_DISK_1: restore complete Elapsed time: 00:00:35channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile (s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00016 to + DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409channel ORA_DISK_1: restoring datafile 00017 to + DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409channel ORA_DISK_1: restoring datafile 00018 to + DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409channel ORA_DISK_1: restoring datafile 00019 to + DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/ DATAFILE/undo_2.266.962469409channel ORA_DISK_1: restoring datafile 00020 to + DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409channel ORA_DISK_1: restoring datafile 00021 to + DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409channel ORA_DISK_1: reading from backup piece + TEST/rman_backup/jy_979425723_20171211_0psls843_1_1channel ORA_DISK_1: piece handle=+TEST/rman_backup/jy_979425723_20171211_0psls843_1_1 tag=TAG20171211T164446channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete Elapsed time: 00:00:36Finished restore at 11-DEC-17RMAN > recover pluggable database jypdb,testpdb Starting recover at 11-DEC-17allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=2279 instance=jy1 device type=DISKstarting media recoverymedia recovery complete, elapsed time: 00:00:02Finished recover at 11-DEC-17

5.open PDB (jypdb,testpdb)

SQL > alter pluggable database jypdb,testpdb open;Pluggable database altered.SQL > select name,open_mode from v$pdbs NAME OPEN_MODE -PDB$SEED READ ONLYJYPDB READ WRITETESTPDB

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.