Oracle 23c New Features for DBA'sRMAN backup scenarios in 12c,
With the advent of 12c PDB/CDB rman backup has changed a lot while taking backups or restoration.
Backups on PDB or CDB
"BACKUP PLUGGABLE DATABASE" - To take backups for a pluggable database
"BACKUP DATABASE" - "BACKUP DATABASE;" on root container backs up the whole container includes SEED Container and PDBs
"BACKUP DATABASE ROOT;" backs up the ROOT Container. "BACKUP DATABASE 'PDB$SEED';" backs up SEED Database
"BACKUP PLUGGABLE DATABASE
Restorations on PDB (When connected as PDB)
"RESTORE PLUGGABLE DATABASE" and "RECOVER PLUGGABLE DATABASE" are used to perform a Complete/Incomplete PDB Recovery "RESTORE DATABASE" and "RECOVER DATABASE" are used when connected to PDB "RESTORE TABLESPACE" and "RECOVER TABLESPACE" or "RESTORE DATAFILE" and "RECOVER DATAFILE"
Backups for transportation tablespace
"BACKUP FOR TRANSPORT PLUGGABLE DATABASE PDB;" or "BACKUP TO PLATFORM "platforn name" DATABASE;" is used to backup the whole database to transport to a different platform of same endian format(Big, little etc...).
Examples
1) Authenticating with "SYSBACKUP":
Direct SYSBACKUP Authentication [oracle@Geek DBA ~]$ rman target '"/ as sysbackup"' Recovery Manager: Release 12.1.0.1.0 - Production on Mon Jul 1 22:52:29 2013 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDB (DBID=1085647373) RMAN> BACKUP DATAFILE 1; Starting backup at 01-JUL-13 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 Starting Control File and SPFILE Autobackup at 01-JUL-13 piece handle=/oradata/backups/TESTDBc-1085647373-20130701-0e comment=NONE Finished Control File and SPFILE Autobackup at 01-JUL-13
2) Authenticating with SYSBACKUP Privileged user
[oracle@Geek DBA TESTDB]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Mon Jul 1 22:37:32 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options Create the C##BACKUPadmin common user (to know more about common users) SQL> CREATE USER C##BACKUPADMIN IDENTIFIED BY 123; User created. SQL> GRANT SYSBACKUP TO C##BACKUPADMIN; Grant succeeded. SQL> !rman target C##BACKUPADMIN Recovery Manager: Release 12.1.0.1.0 - Production on Mon Jul 1 22:38:07 2013 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. target database Password: connected to target database: TESTDB (DBID=1085647373) RMAN> BACKUP DATAFILE 8; Starting backup at 01-JUL-13 using target database control file instead of recovery catalog channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 01-JUL-13 Starting Control File and SPFILE Autobackup at 01-JUL-13 piece handle=/oradata/backups/TESTDBc-1085647373-20130701-0d comment=NONE Finished Control File and SPFILE Autobackup at 01-JUL-13
2) Backup of Pluggable Database (PDB)
On ROOT Container connection, Using "BACKUP PLUGGABLE DATABASE" [oracle@Geek DBA ~]$ rman target / Recovery Manager: Release 12.1.0.1.0 - Production on Mon Jul 1 17:11:07 2013 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDB (DBID=1085647373) RMAN> BACKUP PLUGGABLE DATABASE PDB PLUS ARCHIVELOG; OR On PDB Connection itself, Using "BACKUP DATABASE" on PDB [oracle@Geek DBA ~]$ rman target sys@PDB Recovery Manager: Release 12.1.0.1.0 - Production on Mon Jul 1 17:35:59 2013 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. target database Password: connected to target database: TESTDB (DBID=1085647373) RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Starting backup at 01-JUL-13 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=58 device type=DISK specification does not match any archived log in the repository backup cancelled because there are no files to backup Finished backup at 01-JUL-13 Starting backup at 01-JUL-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00009 name=/oradata/TESTDB/PDB/sysaux01.dbf input datafile file number=00011 name=/oradata/TESTDB/PDB/example01.dbf input datafile file number=00008 name=/oradata/TESTDB/PDB/system01.dbf input datafile file number=00019 name=/oradata/TESTDB/PDB/root_cdb_01.dbf input datafile file number=00022 name=/oradata/TESTDB/PDB/ts_pdb_01.dbf channel ORA_DISK_1: starting piece 1 at 01-JUL-13 channel ORA_DISK_1: finished piece 1 at 01-JUL-13 piece handle=/oradata/backups/TESTDBTESTDB_47_819653777_TESTDB tag=TAG20130701T173617 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15 Finished backup at 01-JUL-13 Starting backup at 01-JUL-13 using channel ORA_DISK_1 specification does not match any archived log in the repository backup cancelled because there are no files to backup Finished backup at 01-JUL-13 Starting Control File and SPFILE Autobackup at 01-JUL-13 piece handle=/oradata/backups/TESTDBc-1085647373-20130701-03 comment=NONE Finished Control File and SPFILE Autobackup at 01-JUL-13
3) Restore and Recovery of Pluggable Database (PDBs)
Recover one of the PDBs System Datafile
SQL> ALTER SESSION SET CONTAINER=PDB; ERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-01116: error in opening database file 8 ORA-01110: data file 8: '/oradata/TESTDB/PDB/system01.dbf' ORA-27041: unable to open file Linux-x86_64 Error: 2: No such file or directory Additional information: 3 [oracle@Geek DBA PDB]$ rman target / Recovery Manager: Release 12.1.0.1.0 - Production on Mon Jul 1 20:59:44 2013 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDB (DBID=1085647373) RMAN> SHUTDOWN ABORT; using target database control file instead of recovery catalog Oracle instance shut down RMAN> STARTUP NOMOUNT; connected to target database (not started) Oracle instance started Total System Global Area 1269366784 bytes Fixed Size 2287912 bytes Variable Size 452986584 bytes Database Buffers 805306368 bytes Redo Buffers 8785920 bytes RMAN> ALTER DATABASE MOUNT; Statement processed RMAN> REPORT SCHEMA; Report of database schema for database with db_unique_name TESTDB List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 790 SYSTEM *** /oradata/TESTDB/system01.dbf 3 740 SYSAUX *** /oradata/TESTDB/sysaux01.dbf 4 760 UNDOTBS1 *** /oradata/TESTDB/undotbs01.dbf 5 250 PDB$SEED:SYSTEM *** /oradata/TESTDB/pdbseed/system01.dbf 6 5 USERS *** /oradata/TESTDB/users01.dbf 7 590 PDB$SEED:SYSAUX *** /oradata/TESTDB/pdbseed/sysaux01.dbf 8 0 PDB:SYSTEM *** /oradata/TESTDB/PDB/system01.dbf 9 630 PDB:SYSAUX *** /oradata/TESTDB/PDB/sysaux01.dbf 10 5 PDB:USERS *** /oradata/TESTDB/PDB/SAMPLE_SCHEMA_users01.dbf 11 357 PDB:EXAMPLE *** /oradata/TESTDB/PDB/example01.dbf 15 260 SALESPDB:SYSTEM *** /oradata/TESTDB/salespdb/system01.dbf 16 620 SALESPDB:SYSAUX *** /oradata/TESTDB/salespdb/sysaux01.dbf 17 250 SALESPDB:SALES *** /oradata/TESTDB/salespdb/sales01.dbf 19 50 PDB:ROOT_CDB *** /oradata/TESTDB/PDB/root_cdb_01.dbf 22 10 PDB:TS_PDB *** /oradata/TESTDB/PDB/ts_pdb_01.dbf 23 260 PDB1:SYSTEM *** /oradata/TESTDB/PDB1/system01.dbf 24 620 PDB1:SYSAUX *** /oradata/TESTDB/PDB1/sysaux01.dbf 25 250 PDB1:PDB1 *** /oradata/TESTDB/PDB1/PDB01.dbf 38 790 ORA12C:SYSTEM *** /oradata/TESTDB/ORA12C/system01.dbf 39 700 ORA12C:SYSAUX *** /oradata/TESTDB/ORA12C/sysaux01.dbf 40 5 ORA12C:USERS *** /oradata/TESTDB/ORA12C/users01.dbf 41 358 ORA12C:EXAMPLE *** /oradata/TESTDB/ORA12C/example01.dbf List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 60 TEMP 32767 /oradata/TESTDB/temp01.dbf 2 20 PDB$SEED:TEMP 32767 /oradata/TESTDB/pdbseed/pdbseed_temp01.dbf 3 28 PDB:TEMP 32767 /oradata/TESTDB/PDB/PDB_temp01.dbf 4 20 SALESPDB:TEMP 32767 /oradata/TESTDB/salespdb/pdbseed_temp01.dbf 5 20 PDB1:TEMP 32767 /oradata/TESTDB/PDB1/pdbseed_temp01.dbf 6 60 ORA12C:TEMP 32767 /oradata/TESTDB/ORA12C/temp01.dbf RMAN> RESTORE DATAFILE 8; Starting restore at 01-JUL-13 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=20 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 datafile 00008 to /oradata/TESTDB/PDB/system01.dbf channel ORA_DISK_1: reading from backup piece /oradata/backups/TESTDBTESTDB_88_819662940_TESTDB channel ORA_DISK_1: piece handle=/oradata/backups/TESTDBTESTDB_88_819662940_TESTDB tag=TAG20130701T200740 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 Finished restore at 01-JUL-13 RMAN> RECOVER DATAFILE 8; Starting recover at 01-JUL-13 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:01 Finished recover at 01-JUL-13 RMAN> SQL 'ALTER DATABASE OPEN'; sql statement: ALTER DATABASE OPEN RMAN> SQL 'ALTER PLUGGABLE DATABASE PDB OPEN'; sql statement: ALTER PLUGGABLE DATABASE PDB OPEN
4) Backup for Transporting Pluggable Database
On PDB Container
[oracle@Geek DBA ~]$ rman target sys@PDB
Recovery Manager: Release 12.1.0.1.0 - Production on Mon Jul 1 23:13:11 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
target database Password:
connected to target database: TESTDB (DBID=1085647373)
RMAN> BACKUP TO PLATFORM "Solaris Operating System (x86-64)";
On ROOT Container
[oracle@Geek DBA ~]$ rman target /
RMAN> BACKUP TO PLATFORM "Solaris Operating System (x86-64)" PLUGGABLE DATABASE;
Starting backup at 01-JUL-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=70 device type=DISK
............................................................................................
.............................................................................................
.............................................................................................
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16
Finished backup at 01-JUL-13
5) Duplicating a Pluggable Database
TESTDB - SOURCE Database (TARGET)
AUXDB - DESTINATION Database (AUXILIARY)
[oracle@Geek DBA AUXDB]$ rman target sys@TESTDB auxiliary sys@AUXDB
Recovery Manager: Release 12.1.0.1.0 - Production on Tue Jul 2 01:40:28 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
target database Password:
connected to target database: TESTDB (DBID=1085647373)
auxiliary database Password:
connected to auxiliary database: AUXDB (not mounted)
RMAN> RUN
{
SET NEWNAME FOR DATABASE TO '/oradata/AUXDB/%U';
DUPLICATE TARGET DATABASE TO AUXDB PLUGGABLE DATABASE PDB FROM ACTIVE DATABASE NOFILENAMECHECK;
}2> 3> 4> 5>
executing command: SET NEWNAME
Starting Duplicate Db at 02-JUL-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=20 device type=DISK
current log archived
contents of Memory Script:
{
sql clone "alter system set db_name =
''TESTDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''AUXDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'TESTDB' primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''TESTDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''AUXDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 417546240 bytes
Fixed Size 2289064 bytes
Variable Size 255853144 bytes
Database Buffers 155189248 bytes
Redo Buffers 4214784 bytes
Starting restore at 02-JUL-13
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=20 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/oradata/AUXDB/control01.ctl
output file name=/fra/AUXDB/control02.ctl
Finished restore at 02-JUL-13
database mounted
Skipping pluggable database SALESPDB
Skipping pluggable database PDB1
Skipping pluggable database ORA12C
Automatically adding tablespace SYSTEM
Automatically adding tablespace SYSAUX
Automatically adding tablespace PDB$SEED:SYSTEM
Automatically adding tablespace PDB$SEED:SYSAUX
Automatically adding tablespace UNDOTBS1
Skipping tablespace USERS
contents of Memory Script:
{
set newname for datafile 1 to
"/oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-1";
set newname for datafile 3 to
"/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-3";
set newname for datafile 4 to
"/oradata/AUXDB/data_D-AUXDB_TS-UNDOTBS1_FNO-4";
set newname for datafile 5 to
"/oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-5";
set newname for datafile 7 to
"/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-7";
set newname for datafile 8 to
"/oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-8";
set newname for datafile 9 to
"/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-9";
set newname for datafile 10 to
"/oradata/AUXDB/data_D-AUXDB_TS-USERS_FNO-10";
set newname for datafile 11 to
"/oradata/AUXDB/data_D-AUXDB_TS-EXAMPLE_FNO-11";
set newname for datafile 19 to
"/oradata/AUXDB/data_D-AUXDB_TS-ROOT_CDB_FNO-19";
set newname for datafile 22 to
"/oradata/AUXDB/data_D-AUXDB_TS-TS_PDB_FNO-22";
restore
from service 'TESTDB' clone database
skip forever tablespace "USERS",
"SALESPDB":"SYSTEM",
"SALESPDB":"SYSAUX",
"SALESPDB":"SALES",
"PDB1":"SYSTEM",
"PDB1":"SYSAUX",
"PDB1":"PDB1",
"ORA12C":"USERS",
"ORA12C":"SYSTEM",
"ORA12C":"SYSAUX",
"ORA12C":"EXAMPLE" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 02-JUL-13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-3
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /oradata/AUXDB/data_D-AUXDB_TS-UNDOTBS1_FNO-4
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-5
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-7
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00008 to /oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-8
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00009 to /oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-9
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00010 to /oradata/AUXDB/data_D-AUXDB_TS-USERS_FNO-10
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00011 to /oradata/AUXDB/data_D-AUXDB_TS-EXAMPLE_FNO-11
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00019 to /oradata/AUXDB/data_D-AUXDB_TS-ROOT_CDB_FNO-19
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00022 to /oradata/AUXDB/data_D-AUXDB_TS-TS_PDB_FNO-22
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 02-JUL-13
sql statement: alter system archive log current
current log archived
contents of Memory Script:
{
restore clone force from service 'TESTDB'
archivelog from scn 2616072;
switch clone datafile all;
}
executing Memory Script
Starting restore at 02-JUL-13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=21
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service TESTDB
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=22
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 02-JUL-13
datafile 1 switched to datafile copy
input datafile copy RECID=18 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-1
datafile 3 switched to datafile copy
input datafile copy RECID=19 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-3
datafile 4 switched to datafile copy
input datafile copy RECID=20 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-UNDOTBS1_FNO-4
datafile 5 switched to datafile copy
input datafile copy RECID=21 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-5
datafile 7 switched to datafile copy
input datafile copy RECID=22 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-7
datafile 8 switched to datafile copy
input datafile copy RECID=23 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-8
datafile 9 switched to datafile copy
input datafile copy RECID=24 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-9
datafile 10 switched to datafile copy
input datafile copy RECID=25 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-USERS_FNO-10
datafile 11 switched to datafile copy
input datafile copy RECID=26 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-EXAMPLE_FNO-11
datafile 19 switched to datafile copy
input datafile copy RECID=27 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-ROOT_CDB_FNO-19
datafile 22 switched to datafile copy
input datafile copy RECID=28 STAMP=819682983 file name=/oradata/AUXDB/data_D-AUXDB_TS-TS_PDB_FNO-22
contents of Memory Script:
{
set until scn 2616267;
recover
clone database
skip forever tablespace "USERS",
"SALESPDB":"SYSTEM",
"SALESPDB":"SYSAUX",
"SALESPDB":"SALES",
"PDB1":"SYSTEM",
"PDB1":"SYSAUX",
"PDB1":"PDB1",
"ORA12C":"USERS",
"ORA12C":"SYSTEM",
"ORA12C":"SYSAUX",
"ORA12C":"EXAMPLE" delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 02-JUL-13
using channel ORA_AUX_DISK_1
Executing: alter database datafile 6 offline drop
Executing: alter database datafile 15 offline drop
Executing: alter database datafile 16 offline drop
Executing: alter database datafile 17 offline drop
Executing: alter database datafile 23 offline drop
Executing: alter database datafile 24 offline drop
Executing: alter database datafile 25 offline drop
Executing: alter database datafile 40 offline drop
Executing: alter database datafile 38 offline drop
Executing: alter database datafile 39 offline drop
Executing: alter database datafile 41 offline drop
starting media recovery
archived log for thread 1 with sequence 21 is already on disk as file /fra/AUXDB/archivelog/2013_07_02/o1_mf_1_21_8x3rpf5j_.arc
archived log for thread 1 with sequence 22 is already on disk as file /fra/AUXDB/archivelog/2013_07_02/o1_mf_1_22_8x3rpg7h_.arc
archived log file name=/fra/AUXDB/archivelog/2013_07_02/o1_mf_1_21_8x3rpf5j_.arc thread=1 sequence=21
archived log file name=/fra/AUXDB/archivelog/2013_07_02/o1_mf_1_22_8x3rpg7h_.arc thread=1 sequence=22
media recovery complete, elapsed time: 00:00:00
Finished recover at 02-JUL-13
Oracle instance started
Total System Global Area 417546240 bytes
Fixed Size 2289064 bytes
Variable Size 255853144 bytes
Database Buffers 155189248 bytes
Redo Buffers 4214784 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''AUXDB'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
}
executing Memory Script
sql statement: alter system set db_name = ''AUXDB'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started
Total System Global Area 417546240 bytes
Fixed Size 2289064 bytes
Variable Size 255853144 bytes
Database Buffers 155189248 bytes
Redo Buffers 4214784 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "AUXDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 SIZE 50 M ,
GROUP 2 SIZE 50 M ,
GROUP 3 SIZE 50 M
DATAFILE
'/oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-1',
'/oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-5',
'/oradata/AUXDB/data_D-AUXDB_TS-SYSTEM_FNO-8'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
set newname for tempfile 1 to
"/oradata/AUXDB/data_D-AUXDB_TS-TEMP_FNO-1";
set newname for tempfile 2 to
"/oradata/AUXDB/data_D-AUXDB_TS-TEMP_FNO-2";
set newname for tempfile 3 to
"/oradata/AUXDB/data_D-AUXDB_TS-TEMP_FNO-3";
switch clone tempfile all;
catalog clone datafilecopy "/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-3",
"/oradata/AUXDB/data_D-AUXDB_TS-UNDOTBS1_FNO-4",
"/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-7",
"/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-9",
"/oradata/AUXDB/data_D-AUXDB_TS-USERS_FNO-10",
"/oradata/AUXDB/data_D-AUXDB_TS-EXAMPLE_FNO-11",
"/oradata/AUXDB/data_D-AUXDB_TS-ROOT_CDB_FNO-19",
"/oradata/AUXDB/data_D-AUXDB_TS-TS_PDB_FNO-22";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /oradata/AUXDB/data_D-AUXDB_TS-TEMP_FNO-1 in control file
renamed tempfile 2 to /oradata/AUXDB/data_D-AUXDB_TS-TEMP_FNO-2 in control file
renamed tempfile 3 to /oradata/AUXDB/data_D-AUXDB_TS-TEMP_FNO-3 in control file
cataloged datafile copy
datafile copy file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-3 RECID=1 STAMP=819682999
cataloged datafile copy
datafile copy file name=/oradata/AUXDB/data_D-AUXDB_TS-UNDOTBS1_FNO-4 RECID=2 STAMP=819682999
cataloged datafile copy
datafile copy file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-7 RECID=3 STAMP=819682999
cataloged datafile copy
datafile copy file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-9 RECID=4 STAMP=819682999
cataloged datafile copy
datafile copy file name=/oradata/AUXDB/data_D-AUXDB_TS-USERS_FNO-10 RECID=5 STAMP=819682999
cataloged datafile copy
datafile copy file name=/oradata/AUXDB/data_D-AUXDB_TS-EXAMPLE_FNO-11 RECID=6 STAMP=819682999
cataloged datafile copy
datafile copy file name=/oradata/AUXDB/data_D-AUXDB_TS-ROOT_CDB_FNO-19 RECID=7 STAMP=819682999
cataloged datafile copy
datafile copy file name=/oradata/AUXDB/data_D-AUXDB_TS-TS_PDB_FNO-22 RECID=8 STAMP=819682999
datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=819682999 file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-3
datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=819682999 file name=/oradata/AUXDB/data_D-AUXDB_TS-UNDOTBS1_FNO-4
datafile 7 switched to datafile copy
input datafile copy RECID=3 STAMP=819682999 file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-7
datafile 9 switched to datafile copy
input datafile copy RECID=4 STAMP=819682999 file name=/oradata/AUXDB/data_D-AUXDB_TS-SYSAUX_FNO-9
datafile 10 switched to datafile copy
input datafile copy RECID=5 STAMP=819682999 file name=/oradata/AUXDB/data_D-AUXDB_TS-USERS_FNO-10
datafile 11 switched to datafile copy
input datafile copy RECID=6 STAMP=819682999 file name=/oradata/AUXDB/data_D-AUXDB_TS-EXAMPLE_FNO-11
datafile 19 switched to datafile copy
input datafile copy RECID=7 STAMP=819682999 file name=/oradata/AUXDB/data_D-AUXDB_TS-ROOT_CDB_FNO-19
datafile 22 switched to datafile copy
input datafile copy RECID=8 STAMP=819682999 file name=/oradata/AUXDB/data_D-AUXDB_TS-TS_PDB_FNO-22
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Executing: drop pluggable database "SALESPDB"
Executing: drop pluggable database "PDB1"
Executing: drop pluggable database "ORA12C"
contents of Memory Script:
{
sql clone "alter pluggable database all open";
}
executing Memory Script
sql statement: alter pluggable database all open
Dropping offline and skipped tablespaces
Executing: alter database default tablespace system
Executing: drop tablespace "USERS" including contents cascade constraints
Finished Duplicate Db at 02-JUL-13
To verify:
SQL> SELECT NAME,CDB,OPEN_MODE FROM V$DATABASE;
NAME CDB OPEN_MODE
--------- --- --------------------
AUXDB YES READ WRITE
SQL> SELECT NAME,OPEN_MODE FROM V$PDBS;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDB READ WRITE
Follow Me!!!