|
d.
connected to target database: STLDB (DBID=3188959514)
RMAN> BACKUP FOR TRANSPORT AS COMPRESSED BACKUPSET PLUGGABLE DATABASE 'PDB3' FORMAT '/u02/pdb/pdb3.dfb';
Starting backup at 18-MAR-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=258 instance=stldb1 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00049 name=+DATA/pdb3/pdb3_sysaux01.dbf
input datafile file number=00048 name=+DATA/pdb3/pdb3_system01.dbf
input datafile file number=00051 name=+DATA/pdb3/pdb3_kiwi01.dbf
input datafile file number=00050 name=+DATA/pdb3/pdb3_users01.dbf
channel ORA_DISK_1: starting piece 1 at 18-MAR-15
channel ORA_DISK_1: finished piece 1 at 18-MAR-15
piece handle=/u02/pdb/pdb3.dfb tag=TAG20150318T215139 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
Finished backup at 18-MAR-15
然后在另外的库上转储进行恢复这个数据库
RMAN> run
2> {
3> set command id to 'pdb3';
4> RESTORE FOREIGN DATAFILE 48 TO NEW ,49 TO NEW ,50 TO NEW,51 TO NEW FROM BACKUPSET
5> '/u02/pdb/pdb3.dfb' ;
6> };
executing command: SET COMMAND ID
Starting restore at 19-MAR-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=142 instance=prod1 device type=DISK
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 foreign file 00048
channel ORA_DISK_1: restoring foreign file 00049
channel ORA_DISK_1: restoring foreign file 00050
channel ORA_DISK_1: restoring foreign file 00051
channel ORA_DISK_1: reading from backup piece /u02/pdb/pdb3.dfb
channel ORA_DISK_1: restoring foreign file 48 to +DATA/PROD/1191435B2E309449E0536506A8C02DFC/DATAFILE/system.351.874714735
channel ORA_DISK_1: restoring foreign file 49 to +DATA/PROD/1191435B2E309449E0536506A8C02DFC/DATAFILE/sysaux.350.874714735
channel ORA_DISK_1: restoring foreign file 50 to +DATA/PROD/1191435B2E309449E0536506A8C02DFC/DATAFILE/users.353.874714735
channel ORA_DISK_1: restoring foreign file 51 to +DATA/PROD/1191435B2E309449E0536506A8C02DFC/DATAFILE/kiwi.352.874714735
channel ORA_DISK_1: foreign piece handle=/u02/pdb/pdb3.dfb
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:06
Finished restore at 19-MAR-15
创建pdb
create pluggable database pdb3 as clone using '/u02/pdb/pdb3.xml'
source_file_name_convert = (
'+DATA/pdb3/pdb3_system01.dbf',
'+DATA/PROD/1191435B2E309449E0536506A8C02DFC/DATAFILE/system.351.874714735',
'+DATA/pdb3/pdb3_sysaux01.dbf',
'+DATA/PROD/1191435B2E309449E0536506A8C02DFC/DATAFILE/sysaux.350.874714735',
'+DATA/pdb3/pdb3_users01.dbf',
'+DATA/PROD/1191435B2E309449E0536506A8C02DFC/DATAFILE/users.353.874714735',
'+DATA/pdb3/pdb3_temp01.dbf',
'+DATA/PROD/1191435B2E309449E0536506A8C02DFC/DATAFILE/temp01.dbf',
'+DATA/pdb3/pdb3_kiwi01.dbf',
'+DATA/PROD/1191435B2E309449E0536506A8C02DFC/DATAFILE/kiwi.352.874714735')
file_name_convert=NONE NOCOPY;
00:45:17 sys@prod> select con_id, dbid, guid, name , open_mode from v$pdbs;
CON_ID DBID GUID NAME OPEN_MODE
---------- |