Skip navigation

1. About

 

Starting with Oracle Database 12c, RMAN active database duplication supports a push or pull method:

 

Push method:

 

It relies on Oracle Net to internally transmit online image copies of the database files to the auxiliary instance. This is the same as in 11g.

 

Pull method:

 

The target database uses Oracle Net to transmit backup sets to the auxiliary location. The restore of the database to duplicate the target database is done at the auxiliary instance. To use the pull method, you specify the new "using backupset, or section size" clause. Active duplication will default to the new pull method depending on certain criteria. Please see the Oracle documentation for more information.

 

Note: Image copies or backup sets during active duplication are directly transmitted via Oracle Net and not written do disk.

 

The following demonstrates how to perform an active database duplication using backup sets, which is a new feature of 12c. The task is to duplicate database CDB1 to CDB1DUP on the same host, both using ASM.

 

System: Oracle Linux 7.3 (VM VirtualBox), Oracle Database 12.1.0.2

 

 

 

This document is the result of my private research and was written in the hope to provide useful information for members of the Oracle community. It is not meant to be a reference or to substitute any documentation provided by Oracle. Use on your own risk.

 

The information herein is provided under the terms and conditions of http://www.oracle.com/us/legal/terms/index.html.

Please do not plagiarize.

 

Copyright 2018, Dude! @ Oracle Community

 

 

2. Example

 

a) Login as user oracle:

Saturn:~ dude$ ssh oracle@10.0.70.1

oracle@10.0.70.1's password:

Last login: Mon Aug 27 09:58:26 2018 from 10.0.0.1

 

b) Set the Linux shell environment to CDB1:

[oracle@701 ~]$ . oraenv <<< CDB1 >/dev/null

 

c) Create a parameter file for the auxiliary instance CDB1DUP using CDB1 spfile:

[oracle@701 ~]$ cd $ORACLE_HOME/dbs

[oracle@701 dbs]$ echo 'create pfile from spfile;' | sqlplus -s / as sysdba

[oracle@701 dbs]$ mv initCDB1.ora initCDB1DUP.ora

 

Modify the pfile using a text editor such as gedit or vim, or command line:

[oracle@701 dbs]$ sed -i 's/cdb1/cdb1dup/g' initCDB1DUP.ora

[oracle@701 dbs]$ sed -i 's/CDB1/CDB1DUP/g' initCDB1DUP.ora

[oracle@701 dbs]$ sed -i "s/^*.control_files=.*/*.control_files='+DATA','+FRA'/" initCDB1DUP.ora

 

Example:

[oracle@701 dbs]$ cat initCDB1DUP.ora

CDB1DUP.__data_transfer_cache_size=0

CDB1DUP.__db_cache_size=704643072

CDB1DUP.__java_pool_size=16777216

CDB1DUP.__large_pool_size=33554432

CDB1DUP.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

CDB1DUP.__pga_aggregate_target=603979776

CDB1DUP.__sga_target=1140850688

CDB1DUP.__shared_io_pool_size=67108864

CDB1DUP.__shared_pool_size=301989888

CDB1DUP.__streams_pool_size=0

*._catalog_foreign_restore=FALSE

*.audit_file_dest='/u01/app/oracle/admin/cdb1dup/adump'

*.audit_trail='db'

*.compatible='12.1.0.2.0'

*.control_files='+DATA'

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_domain='example.com'

*.db_name='cdb1dup'

*.db_recovery_file_dest='+FRA'

*.db_recovery_file_dest_size=12g

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=CDB1DUPXDB)'

*.enable_pluggable_database=true

*.local_listener='LISTENER_CDB1DUP'

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=1664m

*.open_cursors=300

*.processes=300

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

 

d) Copy the Oracle password file and create directories:

[oracle@701 dbs]$ cp orapwCDB1 orapwCDB1DUP

[oracle@701 dbs]$ mkdir -p /u01/app/oracle/admin/cdb1dup/adump

 

e) Edit /etc/oratab:

[oracle@701 dbs]$ echo "CDB1DUP:/u01/app/oracle/product/12.1.0/dbhome_1:N" >> /etc/oratab

 

f) Edit tnsnames.ora:

 

Determin the locaiton of the default tnsnames.ora directory:

[oracle@701 dbs]$ tnsping cdb1

Used parameter files:

/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

 

Use a text editor to modify the file, or command line:

[oracle@701 dbs]$ cd /u01/app/oracle/product/12.1.0/dbhome_1/network/admin

[oracle@701 dbs]$ cp tnsnames.ora tnsnames.bck

[oracle@701 dbs]$ cat >> tnsnames.ora <<EOM

 

LISTENER_CDB1DUP =

  (ADDRESS = (PROTOCOL = TCP)(HOST = 701.example.com)(PORT = 1521))

 

CDB1DUP =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 701.example.com)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = cdb1dup.example.com)

    )

  )

 

EOM

 

g) Edit listener.ora

 

Determine the location of the listener configuration file. The Listener is typcialy owned by the Gi installation:

[oracle@701 admin]$ lsnrctl status

Listener Parameter File   /u01/app/grid/product/12.1.0/grid/network/admin/listener.ora

 

The following applies to Grid role separation:

[oracle@701 admin]$ su - grid

Password:

[grid@701 grid]$ . oraenv <<< +ASM >/dev/null

[grid@701 grid]$ cd /u01/app/grid/product/12.1.0/grid/network/admin/

 

[grid@701 admin]$ cp listener.ora listener.bck

[grid@701 admin]$ cat >> listener.ora <<EOM

 

SID_LIST_LISTENER =

  (SID_LIST =

      (SID_DESC =

      (SID_NAME = CDB1DUP)

      (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/db_1)

      (GLOBAL_DBNAME = cdb1dup.example.com)

    )

  )

 

EOM

 

For the change to take affect, the listener needs to be reloaded - this will not interrupt existing connections.

[grid@701 admin]$ lsnrctl services

...

Service "cdb1dup.example.com" has 1 instance(s).

  Instance "CDB1DUP", status UNKNOWN, has 1 handler(s) for this service...

 

You can now logoff from the Grid account and return back to the Oracle user:

 

h) Create spfile and start the auxiliary instance (CDB1DUP):

[oracle@701 ~]$ . oraenv <<< CDB1DUP >/dev/null

[oracle@701 ~]$ cd $ORACLE_HOME/dbs

[oracle@701 dbs]$ echo 'create spfile from pfile;' | sqlplus -s / as sysdba

[oracle@701 dbs]$ echo "startup nomount;" | sqlplus / as sysdba

 

i) Connect RMAN to target and auxiliary database:

[oracle@701 ~]$ rman target sys/oracle_4U@CDB1 auxiliary sys/oracle_4U@CDB1DUP

 

connected to target database: CDB1 (DBID=909549395)

connected to auxiliary database: CDB1DUP (not mounted)

 

j) Duplicate the database:

RMAN> duplicate target database to cdb1dup from active database using backupset;

 

Starting Duplicate Db at 27-AUG-18

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=251 device type=DISK

current log archived

 

contents of Memory Script:

{

   sql clone "alter system set  control_files =

  ''+DATA/CDB1DUP/CONTROLFILE/current.271.985264461'', ''+FRA/CDB1DUP/CONTROLFILE/current.305.985264461'' comment=

''Set by RMAN'' scope=spfile";

   sql clone "alter system set  db_name =

''CDB1'' comment=

''Modified by RMAN duplicate'' scope=spfile";

   sql clone "alter system set  db_unique_name =

''CDB1DUP'' comment=

''Modified by RMAN duplicate'' scope=spfile";

   shutdown clone immediate;

   startup clone force nomount

   restore clone from service  'CDB1' primary controlfile;

   alter clone database mount;

}

executing Memory Script

 

sql statement: alter system set  control_files =   ''+DATA/CDB1DUP/CONTROLFILE/current.271.985264461'', ''+FRA/CDB1DUP/CONTROLFILE/current.305.985264461'' comment= ''Set by RMAN'' scope=spfile

 

sql statement: alter system set  db_name =  ''CDB1'' comment= ''Modified by RMAN duplicate'' scope=spfile

 

sql statement: alter system set  db_unique_name =  ''CDB1DUP'' comment= ''Modified by RMAN duplicate'' scope=spfile

 

Oracle instance shut down

 

Oracle instance started

 

Total System Global Area    1744830464 bytes

 

Fixed Size                     2925312 bytes

Variable Size               1023413504 bytes

Database Buffers             704643072 bytes

Redo Buffers                  13848576 bytes

 

Starting restore at 27-AUG-18

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=249 device type=DISK

 

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service CDB1

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:06

output file name=+DATA/CDB1DUP/CONTROLFILE/current.271.985264461

output file name=+FRA/CDB1DUP/CONTROLFILE/current.305.985264461

Finished restore at 27-AUG-18

 

database mounted

 

contents of Memory Script:

{

   set newname for clone datafile  1 to new;

   set newname for clone datafile  3 to new;

   set newname for clone datafile  4 to new;

   set newname for clone datafile  5 to new;

   set newname for clone datafile  6 to new;

   set newname for clone datafile  7 to new;

   set newname for clone datafile  8 to new;

   set newname for clone datafile  9 to new;

   set newname for clone datafile  10 to new;

   set newname for clone datafile  11 to new;

   restore

   from service  'CDB1'   clone database

   ;

   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

 

Starting restore at 27-AUG-18

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 CDB1

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to +DATA

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:56

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service CDB1

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00003 to +DATA

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:55

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service CDB1

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00004 to +DATA

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 CDB1

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00005 to +DATA

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:26

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service CDB1

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00006 to +DATA

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 CDB1

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00007 to +DATA

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service CDB1

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00008 to +DATA

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:26

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service CDB1

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00009 to +DATA

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:46

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: using network backup set from service CDB1

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00010 to +DATA

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 CDB1

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00011 to +DATA

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:26

Finished restore at 27-AUG-18

 

sql statement: alter system archive log current

current log archived

 

contents of Memory Script:

{

   restore clone force from service  'CDB1'

           archivelog from scn  3086144;

   switch clone datafile all;

}

executing Memory Script

 

Starting restore at 27-AUG-18

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 CDB1

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=56

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02

channel ORA_AUX_DISK_1: starting archived log restore to default destination

channel ORA_AUX_DISK_1: using network backup set from service CDB1

channel ORA_AUX_DISK_1: restoring archived log

archived log thread=1 sequence=57

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

Finished restore at 27-AUG-18

 

datafile 1 switched to datafile copy

input datafile copy RECID=17 STAMP=985265074 file name=+DATA/CDB1DUP/DATAFILE/system.257.985264723

datafile 3 switched to datafile copy

input datafile copy RECID=18 STAMP=985265074 file name=+DATA/CDB1DUP/DATAFILE/sysaux.258.985264779

datafile 4 switched to datafile copy

input datafile copy RECID=19 STAMP=985265075 file name=+DATA/CDB1DUP/DATAFILE/undotbs1.279.985264833

datafile 5 switched to datafile copy

input datafile copy RECID=20 STAMP=985265075 file name=+DATA/CDB1DUP/48661CA91C1513F6E0530146000AA754/DATAFILE/system.280.985264849

datafile 6 switched to datafile copy

input datafile copy RECID=21 STAMP=985265075 file name=+DATA/CDB1DUP/DATAFILE/users.281.985264875

datafile 7 switched to datafile copy

input datafile copy RECID=22 STAMP=985265075 file name=+DATA/CDB1DUP/48661CA91C1513F6E0530146000AA754/DATAFILE/sysaux.282.985264877

datafile 8 switched to datafile copy

input datafile copy RECID=23 STAMP=985265075 file name=+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/system.283.985264913

datafile 9 switched to datafile copy

input datafile copy RECID=24 STAMP=985265075 file name=+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/sysaux.284.985264939

datafile 10 switched to datafile copy

input datafile copy RECID=25 STAMP=985265075 file name=+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/users.285.985264985

datafile 11 switched to datafile copy

input datafile copy RECID=26 STAMP=985265075 file name=+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/example.286.985264985

 

contents of Memory Script:

{

   set until scn  3086475;

   recover

   clone database

    delete archivelog

   ;

}

executing Memory Script

 

executing command: SET until clause

 

Starting recover at 27-AUG-18

using channel ORA_AUX_DISK_1

 

starting media recovery

 

archived log for thread 1 with sequence 56 is already on disk as file +FRA/CDB1DUP/ARCHIVELOG/2018_08_27/thread_1_seq_56.306.985265073

archived log for thread 1 with sequence 57 is already on disk as file +FRA/CDB1DUP/ARCHIVELOG/2018_08_27/thread_1_seq_57.307.985265073

archived log file name=+FRA/CDB1DUP/ARCHIVELOG/2018_08_27/thread_1_seq_56.306.985265073 thread=1 sequence=56

archived log file name=+FRA/CDB1DUP/ARCHIVELOG/2018_08_27/thread_1_seq_57.307.985265073 thread=1 sequence=57

media recovery complete, elapsed time: 00:00:01

Finished recover at 27-AUG-18

Oracle instance started

 

Total System Global Area    1744830464 bytes

 

Fixed Size                     2925312 bytes

Variable Size               1023413504 bytes

Database Buffers             704643072 bytes

Redo Buffers                  13848576 bytes

 

contents of Memory Script:

{

   sql clone "alter system set  db_name =

''CDB1DUP'' 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 =  ''CDB1DUP'' 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    1744830464 bytes

 

Fixed Size                     2925312 bytes

Variable Size               1023413504 bytes

Database Buffers             704643072 bytes

Redo Buffers                  13848576 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CDB1DUP" 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

  '+DATA/CDB1DUP/DATAFILE/system.257.985264723',

  '+DATA/CDB1DUP/48661CA91C1513F6E0530146000AA754/DATAFILE/system.280.985264849',

  '+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/system.283.985264913'

CHARACTER SET AL32UTF8

 

contents of Memory Script:

{

   set newname for clone tempfile  1 to new;

   set newname for clone tempfile  2 to new;

   set newname for clone tempfile  3 to new;

   switch clone tempfile all;

   catalog clone datafilecopy  "+DATA/CDB1DUP/DATAFILE/sysaux.258.985264779",

"+DATA/CDB1DUP/DATAFILE/undotbs1.279.985264833",

"+DATA/CDB1DUP/DATAFILE/users.281.985264875",

"+DATA/CDB1DUP/48661CA91C1513F6E0530146000AA754/DATAFILE/sysaux.282.985264877",

"+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/sysaux.284.985264939",

"+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/users.285.985264985",

"+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/example.286.985264985";

   switch clone datafile all;

}

executing Memory Script

 

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

 

renamed tempfile 1 to +DATA in control file

renamed tempfile 2 to +DATA in control file

renamed tempfile 3 to +DATA in control file

 

cataloged datafile copy

datafile copy file name=+DATA/CDB1DUP/DATAFILE/sysaux.258.985264779 RECID=1 STAMP=985265125

cataloged datafile copy

datafile copy file name=+DATA/CDB1DUP/DATAFILE/undotbs1.279.985264833 RECID=2 STAMP=985265125

cataloged datafile copy

datafile copy file name=+DATA/CDB1DUP/DATAFILE/users.281.985264875 RECID=3 STAMP=985265125

cataloged datafile copy

datafile copy file name=+DATA/CDB1DUP/48661CA91C1513F6E0530146000AA754/DATAFILE/sysaux.282.985264877 RECID=4 STAMP=985265125

cataloged datafile copy

datafile copy file name=+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/sysaux.284.985264939 RECID=5 STAMP=985265125

cataloged datafile copy

datafile copy file name=+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/users.285.985264985 RECID=6 STAMP=985265125

cataloged datafile copy

datafile copy file name=+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/example.286.985264985 RECID=7 STAMP=985265125

 

datafile 3 switched to datafile copy

input datafile copy RECID=1 STAMP=985265125 file name=+DATA/CDB1DUP/DATAFILE/sysaux.258.985264779

datafile 4 switched to datafile copy

input datafile copy RECID=2 STAMP=985265125 file name=+DATA/CDB1DUP/DATAFILE/undotbs1.279.985264833

datafile 6 switched to datafile copy

input datafile copy RECID=3 STAMP=985265125 file name=+DATA/CDB1DUP/DATAFILE/users.281.985264875

datafile 7 switched to datafile copy

input datafile copy RECID=4 STAMP=985265125 file name=+DATA/CDB1DUP/48661CA91C1513F6E0530146000AA754/DATAFILE/sysaux.282.985264877

datafile 9 switched to datafile copy

input datafile copy RECID=5 STAMP=985265125 file name=+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/sysaux.284.985264939

datafile 10 switched to datafile copy

input datafile copy RECID=6 STAMP=985265125 file name=+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/users.285.985264985

datafile 11 switched to datafile copy

input datafile copy RECID=7 STAMP=985265125 file name=+DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/example.286.985264985

 

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

 

database opened

 

contents of Memory Script:

{

   sql clone "alter pluggable database all open";

}

executing Memory Script

 

sql statement: alter pluggable database all open

Finished Duplicate Db at 27-AUG-18

 

RMAN>

 

k) Database files and RMAN backup data of CDB1:

[oracle@701 ~]$ . oraenv <<< CDB1 >/dev/null

[oracle@701 ~]$ rman target /

 

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Aug 27 12:48:43 2018

 

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

 

connected to target database: CDB1 (DBID=909549395)

 

RMAN> list backup;

using target database control file instead of recovery catalog

specification does not match any backup in the repository

 

RMAN> list copy of database;

specification does not match any datafile copy in the repository

 

RMAN> report schema;

using target database control file instead of recovery catalog

Report of database schema for database with db_unique_name CDB1

 

List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

---- -------- -------------------- ------- ------------------------

1    800      SYSTEM               YES     +DATA/CDB1/DATAFILE/system.261.935831869

3    790      SYSAUX               NO      +DATA/CDB1/DATAFILE/sysaux.273.935831823

4    380      UNDOTBS1             YES     +DATA/CDB1/DATAFILE/undotbs1.278.935831915

5    250      PDB$SEED:SYSTEM      NO      +DATA/CDB1/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/system.264.935831965

6    5        USERS                NO      +DATA/CDB1/DATAFILE/users.262.935831913

7    550      PDB$SEED:SYSAUX      NO      +DATA/CDB1/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/sysaux.265.935831965

8    260      PDBORCL:SYSTEM       NO      +DATA/CDB1/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/system.276.935832599

9    590      PDBORCL:SYSAUX       NO      +DATA/CDB1/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/sysaux.275.935832599

10   5        PDBORCL:USERS        NO      +DATA/CDB1/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/users.270.935832599

11   1243     PDBORCL:EXAMPLE      NO      +DATA/CDB1/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/example.277.935832599

 

List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

---- -------- -------------------- ----------- --------------------

1    197      TEMP                 32767       +DATA/CDB1/TEMPFILE/temp.266.935831961

2    100      PDB$SEED:TEMP        32767       +DATA/CDB1/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/pdbseed_temp012017-02-13_09-19-53-am.dbf

3    197      PDBORCL:TEMP         32767       +DATA/CDB1/FD9BD2B44413096FE043B6A9E80ABC28/DATAFILE/pdborcl_temp012017-02-13_09-30-37-am.dbf

 

RMAN> select name from v$controlfile;

+DATA/CDB1/CONTROLFILE/current.272.935831955

+FRA/CDB1/CONTROLFILE/current.256.935831955

 

l) Database files and RMAN backup data of CDB1DUP:

[oracle@701 ~]$ . oraenv <<< CDB1DUP >/dev/null

[oracle@701 ~]$ rman target /

 

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Aug 27 12:49:59 2018

 

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

 

connected to target database: CDB1DUP (DBID=1460864354)

 

RMAN> list backup;

using target database control file instead of recovery catalog

 

List of Backup Sets

===================

 

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1       Full    17.52M     DISK        00:00:04     27-AUG-18    

        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20180827T124602

        Piece Name: +FRA/CDB1DUP/AUTOBACKUP/2018_08_27/s_985265162.311.985265165

  SPFILE Included: Modification time: 27-AUG-18

  SPFILE db_unique_name: CDB1DUP

  Control File Included: Ckp SCN: 3088089      Ckp time: 27-AUG-18

 

RMAN> list copy of database;

specification does not match any datafile copy in the repository

 

RMAN> report schema;

Report of database schema for database with db_unique_name CDB1DUP

 

List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

---- -------- -------------------- ------- ------------------------

1    800      SYSTEM               YES     +DATA/CDB1DUP/DATAFILE/system.257.985264723

3    790      SYSAUX               NO      +DATA/CDB1DUP/DATAFILE/sysaux.258.985264779

4    380      UNDOTBS1             YES     +DATA/CDB1DUP/DATAFILE/undotbs1.279.985264833

5    250      PDB$SEED:SYSTEM      NO      +DATA/CDB1DUP/48661CA91C1513F6E0530146000AA754/DATAFILE/system.280.985264849

6    5        USERS                NO      +DATA/CDB1DUP/DATAFILE/users.281.985264875

7    550      PDB$SEED:SYSAUX      NO      +DATA/CDB1DUP/48661CA91C1513F6E0530146000AA754/DATAFILE/sysaux.282.985264877

8    260      PDBORCL:SYSTEM       NO      +DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/system.283.985264913

9    600      PDBORCL:SYSAUX       NO      +DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/sysaux.284.985264939

10   5        PDBORCL:USERS        NO      +DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/users.285.985264985

11   1243     PDBORCL:EXAMPLE      NO      +DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/DATAFILE/example.286.985264985

 

List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

---- -------- -------------------- ----------- --------------------

1    197      TEMP                 32767       +DATA/CDB1DUP/TEMPFILE/temp.290.985265141

2    100      PDB$SEED:TEMP        32767       +DATA/CDB1DUP/48661CA91C1513F6E0530146000AA754/TEMPFILE/temp.291.985265149

3    197      PDBORCL:TEMP         32767       +DATA/CDB1DUP/486643159D4918D8E0530146000A75B0/TEMPFILE/temp.292.985265155

 

RMAN> select name from v$controlfile;

+DATA/CDB1DUP/CONTROLFILE/current.271.985264461

+FRA/CDB1DUP/CONTROLFILE/current.305.985264461

 

End