Oracle 19c - Restore Pluggable Database Without CDB Backup - How to Restore PDB without CDB Backup - Demonstration!
In this video demonstrated, how to restore dropped pluggable database without CDB backup.
ORACLE 19C - RESTORING A DROPPED ORACLE PDB WITHOUT A CDB BACKUP!
In my lab environment, I have a CDB with two PDBs running. I’ll take a FULL RMAN backup of SRCDBPLUG1 only, then drop it. The requirement is to restore the backup of SRCDBPLUG1, even though there are no backups of CDB$ROOT and PDB$SEED without disrupting or incurring downtime for SRCDBPLUG2.
1. First take SRCDBPLUG1 FULL Backup, and then Copy all of the backup pieces from the Source Server (Server-A) to a Target Server with the same version of Oracle Database software installed. In my case I am using Oracle 19c version.
2. On Target Server create an instance with the same database name and start with NOMOUNT state.
3. On Target Server Restore the control file from the copied control file from autobackup backup pieces.
4. Next MOUNT the database using the restored control file on target server.
5. Next catalog the backup pieces which we already copied backup files from source server to target server, Restore the data files for SRCDBPLUG1 from the other RMAN backup set pieces.
6. Use another (up and running and fully usable) instance on the same server to generate the required XML metadata file and plug in the restored SRCDBPLUG1.
7. Clone the restored (and plugged in) PDB1 through a database link back to the original CDB.
Steps to be performed:
SQL> SELECT con_id, name, guid FROM v$containers WHERE con_id > 2;
SQL> ALTER SESSION SET container = SRCDBPLUG1;
SQL> ALTER SESSION SET container = SRCDBPLUG2;
Now using RMAN, I took an offline backup of SRCDBPLUG1 (note there are no other backups of this database):
RMAN> SHOW ALL;
RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> ALTER PLUGGABLE DATABASE SRCDBPLUG1 CLOSE IMMEDIATE;
RMAN> LIST BACKUP;
RMAN> BACKUP PLUGGABLE DATABASE SRCDBPLUG1;
Now I dropped the pluggable database SRCDBPLUG1:
SQL> show pdbs
SQL> DROP PLUGGABLE DATABASE SRCDBPLUG1 INCLUDING DATA FILES;
Now simply trying to restore pluggable database SCRDBPLUG1 as it threw an error, hence the SRCDBPLUG1 database no longer exists.
RMAN> restore pluggable database SRCDBPLUG1;
Restore process of pluggable database SRCDBPLUG1:
Since we can’t restore into the original CDB on the original server, we’ll restore it in a secondary environment. The first step is to move the RMAN backup set pieces to that secondary server.
Then I scp (not shown) them to the /tmp directory of the target server.
On the target server, I need an initialization file, which can be copied from the source server. I just need to start an instance with the same name so I can use RMAN to get the data files out of the backup set pieces.
Then the process is pretty simple, restore the control file from the copied control file autobackup, catalog the copied backup pieces and restore the data files.
One additional point: To have RMAN restore the data files into the desired ASM disk group, I also need to set the db_create_file_dest parameter
Now I can see the restored data files are in ASM and first accompalishment have been completed, but we do not have any CDBs to attach it.
The next step is to add those data files as a new PDB in another instance. For this I used another instance SRCDB2 is running on this target server.
Now I connected SRCDB2 instance and used DBMS_PDB.RECOVER to build the XML manifest file that was needed to plug in the restore database.
BEGIN
DBMS_PDB.RECOVER (
pdb_descr_file => '/home/oracle/srcdbplug1_recover.xml',
pdb_name => 'srcdbplug1',
filenames => '/oradata/data/SRCDB1/srcdbplug1/system01.dbf,/oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf,/oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf,/oradata/data/SRCDB1/srcdbplug1/users01.dbf'
);
END;
/
Then I plugged in the restored SRCDBPLUG1 on SRCDB2 instance:
SQL> CREATE PLUGGABLE DATABASE SRCDBPLUG1 USING '/home/oracle/srcdbplug1_recover.xml' NOCOPY;
SQL> show pdbs
SQL> ALTER PLUGGABLE DATABASE SRCDBPLUG1 OPEN;
SQL> show pdbs
it’s opened in MIGRATE mode initially, as the new CDB may have a slightly different patch level, there may be mismatches in CDB/PDB components installed, or there might be initialization parameter issues. Check PDB_PLUG_IN_VIOLATIONS if you need to inspect the specific details.
To resolve the MIGRATE mode status, simply close the PDB and open it again:
SQL> ALTER PLUGGABLE DATABASE SRCDBPLUG1 CLOSE;
SQL> ALTER PLUGGABLE DATABASE SRCDBPLUG1 OPEN;
SQL> show pdbs
Now we have the SRCDBPLUG1 database restored and in a usable state. But this is on the secondary SRCDB2 instance. The final step is to copy it back to the original SRCDB1 CDB.
Target CDB2:
ALTER SESSION SET CONTAINER=SRCDBPLUG1;
CREATE USER c##admin IDENTIFIED BY ora12345;
GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO c##admin container=all;
Source CDB1:
srcdbplug1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.105)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = srcdbplug1)
)
)
create database link remote_connect connect to system identified by "welcome123" using 'srcdbplug1';
SQL> SELECT * FROM dual@remote_connect;
SQL> select sysdate from dual@remote_connect;
SQL> CREATE PLUGGABLE DATABASE SRCDBPLUG1 FROM srcdbplug1@remote_connect file_name_convert=('/oradata/data/SRCDB1/srcdbplug1','/oradata/data/SRCDB1/srcdbplug1');
SQL> ALTER PLUGGABLE DATABASE SRCDBPLUG1 OPEN read write;
SQL> show pdbs
SQL> ALTER SESSION SET container = SRCDBPLUG1;
Worklog:
Source Server Session 1:
login as: oracle
oracle@192.168.56.103's password:
Last login: Sun Oct 3 11:17:01 2021
[oracle@srlab ~]$ ps -ef |grep pmon
oracle 3415 3258 0 08:26 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab ~]$ ps -ef |grep tns
root 22 2 0 08:13 ? 00:00:00 [netns]
oracle 3422 3258 0 08:26 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab ~]$
[oracle@srlab ~]$ . oraenv
ORACLE_SID = [oracle] ? srcdb1
The Oracle base has been set to /u01/app/oracle
[oracle@srlab ~]$
[oracle@srlab ~]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 08:26:36 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2382364032 bytes
Fixed Size 9137536 bytes
Variable Size 603979776 bytes
Database Buffers 1761607680 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab ~]$ cd $ORACLE_HOME/network/admin
[oracle@srlab admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_SRCDB19C =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srlab)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
LISTENER_SRCDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srlab)(PORT = 1521))
)
)
[oracle@srlab admin]$ lsnrctl start LISTENER_SRCDB1
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-OCT-2021 09:29:03
Copyright (c) 1991, 2021, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srlab/listener_srcdb1/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srlab)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SRCDB1
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 07-OCT-2021 09:29:04
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlab/listener_srcdb1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@srlab admin]$
[oracle@srlab admin]$ ps -ef |grep pmon
oracle 3495 1 0 08:27 ? 00:00:00 ora_pmon_srcdb1
oracle 8035 3258 0 09:29 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab admin]$ ps -ef |grep pmon
oracle 3495 1 0 08:27 ? 00:00:00 ora_pmon_srcdb1
oracle 8041 3258 0 09:29 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab admin]$ ps -ef |grep rns
oracle 8045 3258 0 09:29 pts/0 00:00:00 grep --color=auto rns
[oracle@srlab admin]$ ps -ef |grep tns
root 22 2 0 08:13 ? 00:00:00 [netns]
oracle 8017 1 1 09:29 ? 00:00:00 /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr LISTENER_SRCDB1 -inherit
oracle 8052 3258 0 09:29 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab admin]$
[oracle@srlab admin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 09:29:27 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 READ WRITE NO
4 SRCDBPLUG2 READ WRITE NO
SQL>
SQL> col name for a65
SQL>
SQL>
SQL> select name from v$datafile;
NAME
-----------------------------------------------------------------
/oradata/data/SRCDB1/system01.dbf
/oradata/data/SRCDB1/pdbseed/system01.dbf
/oradata/data/SRCDB1/sysaux01.dbf
/oradata/data/SRCDB1/pdbseed/sysaux01.dbf
/oradata/data/SRCDB1/undotbs01.dbf
/oradata/data/SRCDB1/pdbseed/undotbs01.dbf
/oradata/data/SRCDB1/users01.dbf
/oradata/data/SRCDB1/srcdbplug1/system01.dbf
/oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug1/users01.dbf
/oradata/data/SRCDB1/srcdbplug2/system01.dbf
/oradata/data/SRCDB1/srcdbplug2/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug2/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug2/users01.dbf
15 rows selected.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab admin]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 7 09:30:47 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB1 (DBID=835842962)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name SRCDB1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.0.0.0/db_2/dbs/snapcf_srcdb1.f'; # default
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 17.95M DISK 00:00:02 03-OCT-21
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20211003T101523
Piece Name: /oradata/fra/SRCDB1/autobackup/2021_10_03/o1_mf_s_1084961723_jolfc5nq_.bkp
SPFILE Included: Modification time: 03-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1307098 Ckp time: 03-OCT-21
RMAN> backup current controlfile;
Starting backup at 07-OCT-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=290 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 07-OCT-21
channel ORA_DISK_1: finished piece 1 at 07-OCT-21
piece handle=/oradata/fra/SRCDB1/backupset/2021_10_07/o1_mf_ncnnf_TAG20211007T093216_jowwbbm2_.bkp tag=TAG20211007T093216 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 07-OCT-21
Starting Control File and SPFILE Autobackup at 07-OCT-21
piece handle=/u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-00 comment=NONE
Finished Control File and SPFILE Autobackup at 07-OCT-21
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 17.95M DISK 00:00:02 03-OCT-21
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20211003T101523
Piece Name: /oradata/fra/SRCDB1/autobackup/2021_10_03/o1_mf_s_1084961723_jolfc5nq_.bkp
SPFILE Included: Modification time: 03-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1307098 Ckp time: 03-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 17.92M DISK 00:00:01 07-OCT-21
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093216
Piece Name: /oradata/fra/SRCDB1/backupset/2021_10_07/o1_mf_ncnnf_TAG20211007T093216_jowwbbm2_.bkp
Control File Included: Ckp SCN: 1601688 Ckp time: 07-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 17.95M DISK 00:00:00 07-OCT-21
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093220
Piece Name: /u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-00
SPFILE Included: Modification time: 07-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1601709 Ckp time: 07-OCT-21
RMAN>
RMAN> ALTER PLUGGABLE DATABASE SRCDBPLUG1 CLOSE IMMEDIATE;
Statement processed
RMAN> BACKUP PLUGGABLE DATABASE SRCDBPLUG1;
Starting backup at 07-OCT-21
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=00008 name=/oradata/data/SRCDB1/srcdbplug1/system01.dbf
input datafile file number=00010 name=/oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf
input datafile file number=00009 name=/oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf
input datafile file number=00011 name=/oradata/data/SRCDB1/srcdbplug1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 07-OCT-21
channel ORA_DISK_1: finished piece 1 at 07-OCT-21
piece handle=/oradata/fra/SRCDB1/CD6C538C9C7F5806E0536738A8C0F328/backupset/2021_10_07/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp tag=TAG20211007T093422 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 07-OCT-21
Starting Control File and SPFILE Autobackup at 07-OCT-21
piece handle=/u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-01 comment=NONE
Finished Control File and SPFILE Autobackup at 07-OCT-21
RMAN> exit
Recovery Manager complete.
[oracle@srlab admin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 09:35:05 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
---------------------------------------------------------------
SRCDB1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 MOUNTED
4 SRCDBPLUG2 READ WRITE NO
SQL>
SQL> drop pluggable database SRCDBPLUG1 including datafiles;
Pluggable database dropped.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 SRCDBPLUG2 READ WRITE NO
SQL> col name for a65
SQL> set lines 200 pages 2000
SQL> select name from v$datafile;
NAME
-----------------------------------------------------------------
/oradata/data/SRCDB1/system01.dbf
/oradata/data/SRCDB1/pdbseed/system01.dbf
/oradata/data/SRCDB1/sysaux01.dbf
/oradata/data/SRCDB1/pdbseed/sysaux01.dbf
/oradata/data/SRCDB1/undotbs01.dbf
/oradata/data/SRCDB1/pdbseed/undotbs01.dbf
/oradata/data/SRCDB1/users01.dbf
/oradata/data/SRCDB1/srcdbplug2/system01.dbf
/oradata/data/SRCDB1/srcdbplug2/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug2/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug2/users01.dbf
11 rows selected.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab admin]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 7 09:36:45 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB1 (DBID=835842962)
RMAN> restore pluggable database SRCDBPLUG1;
Starting restore at 07-OCT-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=36 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/07/2021 09:36:57
RMAN-06813: could not translate pluggable database SRCDBPLUG1
RMAN> exit
Recovery Manager complete.
[oracle@srlab admin]$ cd /oradata
[oracle@srlab oradata]$ ls -lrt
total 12
drwxr-xr-x. 3 oracle oinstall 4096 Oct 3 07:29 archive
drwxr-xr-x. 5 oracle oinstall 4096 Oct 3 07:33 data
drwxr-xr-x. 3 oracle oinstall 4096 Oct 3 07:33 fra
[oracle@srlab oradata]$ cd fra
[oracle@srlab fra]$ ls -lrt
total 4
drwxr-x---. 5 oracle oinstall 4096 Oct 7 09:34 SRCDB1
[oracle@srlab fra]$ cd SRCDB1/
[oracle@srlab SRCDB1]$ ls -lrt
total 18300
drwxr-x---. 3 oracle oinstall 4096 Oct 3 10:15 autobackup
drwxr-x---. 3 oracle oinstall 4096 Oct 7 09:32 backupset
drwxr-x---. 3 oracle oinstall 4096 Oct 7 09:34 CD6C538C9C7F5806E0536738A8C0F328
-rw-r-----. 1 oracle oinstall 18726912 Oct 7 09:37 control02.ctl
[oracle@srlab SRCDB1]$
[oracle@srlab SRCDB1]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 7 09:42:33 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB1 (DBID=835842962)
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.95M DISK 00:00:02 03-OCT-21
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20211003T101523
Piece Name: /oradata/fra/SRCDB1/autobackup/2021_10_03/o1_mf_s_1084961723_jolfc5nq_.bkp
SPFILE Included: Modification time: 03-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1307098 Ckp time: 03-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 17.92M DISK 00:00:01 07-OCT-21
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093216
Piece Name: /oradata/fra/SRCDB1/backupset/2021_10_07/o1_mf_ncnnf_TAG20211007T093216_jowwbbm2_.bkp
Control File Included: Ckp SCN: 1601688 Ckp time: 07-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 17.95M DISK 00:00:00 07-OCT-21
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093220
Piece Name: /u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-00
SPFILE Included: Modification time: 07-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1601709 Ckp time: 07-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 348.70M DISK 00:00:07 07-OCT-21
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093422
Piece Name: /oradata/fra/SRCDB1/CD6C538C9C7F5806E0536738A8C0F328/backupset/2021_10_07/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp
List of Datafiles in backup set 4
Container ID: 4099, PDB Name: UNKNOWN
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
8 Full 1601822 07-OCT-21 NO
9 Full 1601822 07-OCT-21 NO
10 Full 1601822 07-OCT-21 NO
11 Full 1601822 07-OCT-21 NO
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 17.95M DISK 00:00:01 07-OCT-21
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093438
Piece Name: /u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-01
SPFILE Included: Modification time: 07-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1601875 Ckp time: 07-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 17.95M DISK 00:00:01 07-OCT-21
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20211007T094227
Piece Name: /u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-02
SPFILE Included: Modification time: 07-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1602259 Ckp time: 07-OCT-21
RMAN> create pfile='/home/oracle/initsrcdb1.ora' from spfile;
Statement processed
RMAN> exit
Recovery Manager complete.
[oracle@srlab SRCDB1]$ cd /home/oracle
[oracle@srlab ~]$ ls -lrt initsrcdb1.ora
-rw-r--r--. 1 oracle oinstall 1222 Oct 7 09:48 initsrcdb1.ora
[oracle@srlab ~]$ scp initsrcdb1.ora 192.168.56.105:/u01/app/oracle/product/19.0.0.0/db_2/dbs/
oracle@192.168.56.105's password:
initsrcdb1.ora 100% 1222 690.1KB/s 00:00
[oracle@srlab ~]$
[oracle@srlab ~]$ hostname
srlab
[oracle@srlab ~]$
Source Server Session 1:
login as: oracle
oracle@192.168.56.105's password:
Last login: Sun Oct 3 21:09:40 2021
[oracle@srlab19c ~]$
[oracle@srlab19c ~]$
[oracle@srlab19c ~]$ cd /oradata/
[oracle@srlab19c oradata]$ ls -lrt
total 12
drwxr-xr-x. 3 oracle oinstall 4096 Oct 3 19:54 data
drwxr-xr-x. 3 oracle oinstall 4096 Oct 3 19:55 archive
drwxr-xr-x. 3 oracle oinstall 4096 Oct 7 09:43 fra
[oracle@srlab19c oradata]$ cd data
[oracle@srlab19c data]$ ls -lrt
total 4
drwxr-x---. 5 oracle oinstall 4096 Oct 3 19:54 SRCDB2
[oracle@srlab19c data]$ cd
[oracle@srlab19c ~]$ cd -
/oradata/data
[oracle@srlab19c data]$ pwd
/oradata/data
[oracle@srlab19c data]$ mkdir SRCDB1
[oracle@srlab19c data]$ ls -lrt
total 8
drwxr-x---. 5 oracle oinstall 4096 Oct 3 19:54 SRCDB2
drwxr-xr-x. 2 oracle oinstall 4096 Oct 7 09:47 SRCDB1
[oracle@srlab19c data]$ cd SRCDB1
[oracle@srlab19c SRCDB1]$ mkdir srcdbplug1
[oracle@srlab19c SRCDB1]$ mkdir srcdbplug2
[oracle@srlab19c SRCDB1]$ ls -lrt
total 8
drwxr-xr-x. 2 oracle oinstall 4096 Oct 7 09:47 srcdbplug1
drwxr-xr-x. 2 oracle oinstall 4096 Oct 7 09:48 srcdbplug2
[oracle@srlab19c SRCDB1]$ cd /u01/app/oracle/product/19.0.0.0/db_2/dbs
[oracle@srlab19c dbs]$ ls -lrt
total 12
-rw-r--r--. 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r-----. 1 oracle oinstall 2048 Oct 3 10:02 orapwsrcdb2
-rw-r--r--. 1 oracle oinstall 1222 Oct 7 09:49 initsrcdb1.ora
[oracle@srlab19c dbs]$ mv orapwsrcdb2 orapwsrcdb1
[oracle@srlab19c dbs]$ ls -lrt
total 12
-rw-r--r--. 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r-----. 1 oracle oinstall 2048 Oct 3 10:02 orapwsrcdb1
-rw-r--r--. 1 oracle oinstall 1222 Oct 7 09:49 initsrcdb1.ora
[oracle@srlab19c dbs]$ cd ..
[oracle@srlab19c db_2]$ cd network/admin/
[oracle@srlab19c admin]$ vi listener.ora
[oracle@srlab19c admin]$
[oracle@srlab19c admin]$ vi tnsnames.ora
[oracle@srlab19c admin]$
[oracle@srlab19c admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_SRCDB19C =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srlab)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
LISTENER_SRCDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.105)(PORT = 1521))
)
)
Target Server Session 1:
[oracle@srlab19c admin]$ . oraenv
ORACLE_SID = [oracle] ? srcdb1
The Oracle base has been set to /u01/app/oracle
[oracle@srlab19c admin]$ lsnrctl start LISTENER_SRCDB1
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-OCT-2021 09:52:00
Copyright (c) 1991, 2021, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srlab19c/listener_srcdb1/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.105)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.105)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SRCDB1
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 07-OCT-2021 09:52:01
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlab19c/listener_srcdb1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.105)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@srlab19c admin]$ ps -ef |grep pmon
oracle 9169 3243 0 09:52 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab19c admin]$ ps -ef |grep tns
root 22 2 0 08:13 ? 00:00:00 [netns]
oracle 9158 1 2 09:52 ? 00:00:00 /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr LISTENER_SRCDB1 -inherit
oracle 9175 3243 0 09:52 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab19c admin]$ cd ..
[oracle@srlab19c network]$ cd ..
[oracle@srlab19c db_2]$ cd dbs
[oracle@srlab19c dbs]$ ls -lrt
total 12
-rw-r--r--. 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r-----. 1 oracle oinstall 2048 Oct 3 10:02 orapwsrcdb1
-rw-r--r--. 1 oracle oinstall 1222 Oct 7 09:49 initsrcdb1.ora
[oracle@srlab19c dbs]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 09:52:44 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 2382364032 bytes
Fixed Size 9137536 bytes
Variable Size 603979776 bytes
Database Buffers 1761607680 bytes
Redo Buffers 7639040 bytes
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab19c dbs]$ ps -ef |grep pmon
oracle 9245 1 0 09:53 ? 00:00:00 ora_pmon_srcdb1
oracle 9359 3243 0 09:53 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab19c dbs]$ ps -ef |grep tns
root 22 2 0 08:13 ? 00:00:00 [netns]
oracle 9158 1 0 09:52 ? 00:00:00 /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr LISTENER_SRCDB1 -inherit
oracle 9364 3243 0 09:53 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab19c dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 7 09:55:23 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB1 (not mounted)
RMAN> restore controlfile from '/oradata/fra/o1_mf_ncnnf_TAG20211007T093216_jowwbbm2_.bkp';
Starting restore at 07-OCT-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/oradata/data/SRCDB1/control01.ctl
output file name=/oradata/fra/SRCDB1/control02.ctl
Finished restore at 07-OCT-21
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed
RMAN> CATALOG BACKUPPIECE '/oradata/fra/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp';
Starting implicit crosscheck backup at 07-OCT-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 07-OCT-21
Starting implicit crosscheck copy at 07-OCT-21
using channel ORA_DISK_1
Finished implicit crosscheck copy at 07-OCT-21
searching for all files in the recovery area
cataloging files...
no files cataloged
channel ORA_DISK_1: cataloged backup piece
backup piece handle=/oradata/fra/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp RECID=2 STAMP=1085306256
RMAN> RESTORE PLUGGABLE DATABASE SRCDBPLUG1;
Starting restore at 07-OCT-21
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 00008 to /oradata/data/SRCDB1/srcdbplug1/system01.dbf
channel ORA_DISK_1: restoring datafile 00009 to /oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /oradata/data/SRCDB1/srcdbplug1/users01.dbf
channel ORA_DISK_1: reading from backup piece /oradata/fra/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp
channel ORA_DISK_1: piece handle=/oradata/fra/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp tag=TAG20211007T093422
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 07-OCT-21
RMAN>
Source Server Session 2:
login as: oracle
oracle@192.168.56.103's password:
Last login: Sun Oct 3 11:17:01 2021
[oracle@srlab ~]$ ps -ef |grep pmon
oracle 3415 3258 0 08:26 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab ~]$ ps -ef |grep tns
root 22 2 0 08:13 ? 00:00:00 [netns]
oracle 3422 3258 0 08:26 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab ~]$
[oracle@srlab ~]$ . oraenv
ORACLE_SID = [oracle] ? srcdb1
The Oracle base has been set to /u01/app/oracle
[oracle@srlab ~]$
[oracle@srlab ~]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 08:26:36 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2382364032 bytes
Fixed Size 9137536 bytes
Variable Size 603979776 bytes
Database Buffers 1761607680 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab ~]$ cd $ORACLE_HOME/network/admin
[oracle@srlab admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_SRCDB19C =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srlab)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
LISTENER_SRCDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srlab)(PORT = 1521))
)
)
[oracle@srlab admin]$ lsnrctl start LISTENER_SRCDB1
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-OCT-2021 09:29:03
Copyright (c) 1991, 2021, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srlab/listener_srcdb1/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srlab)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SRCDB1
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 07-OCT-2021 09:29:04
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlab/listener_srcdb1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@srlab admin]$
[oracle@srlab admin]$ ps -ef |grep pmon
oracle 3495 1 0 08:27 ? 00:00:00 ora_pmon_srcdb1
oracle 8035 3258 0 09:29 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab admin]$ ps -ef |grep pmon
oracle 3495 1 0 08:27 ? 00:00:00 ora_pmon_srcdb1
oracle 8041 3258 0 09:29 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab admin]$ ps -ef |grep rns
oracle 8045 3258 0 09:29 pts/0 00:00:00 grep --color=auto rns
[oracle@srlab admin]$ ps -ef |grep tns
root 22 2 0 08:13 ? 00:00:00 [netns]
oracle 8017 1 1 09:29 ? 00:00:00 /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr LISTENER_SRCDB1 -inherit
oracle 8052 3258 0 09:29 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab admin]$
[oracle@srlab admin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 09:29:27 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 READ WRITE NO
4 SRCDBPLUG2 READ WRITE NO
SQL>
SQL> col name for a65
SQL>
SQL>
SQL> select name from v$datafile;
NAME
-----------------------------------------------------------------
/oradata/data/SRCDB1/system01.dbf
/oradata/data/SRCDB1/pdbseed/system01.dbf
/oradata/data/SRCDB1/sysaux01.dbf
/oradata/data/SRCDB1/pdbseed/sysaux01.dbf
/oradata/data/SRCDB1/undotbs01.dbf
/oradata/data/SRCDB1/pdbseed/undotbs01.dbf
/oradata/data/SRCDB1/users01.dbf
/oradata/data/SRCDB1/srcdbplug1/system01.dbf
/oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug1/users01.dbf
NAME
-----------------------------------------------------------------
/oradata/data/SRCDB1/srcdbplug2/system01.dbf
/oradata/data/SRCDB1/srcdbplug2/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug2/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug2/users01.dbf
15 rows selected.
SQL> set lines 2000 pages 2000
SQL> /
NAME
-----------------------------------------------------------------
/oradata/data/SRCDB1/system01.dbf
/oradata/data/SRCDB1/pdbseed/system01.dbf
/oradata/data/SRCDB1/sysaux01.dbf
/oradata/data/SRCDB1/pdbseed/sysaux01.dbf
/oradata/data/SRCDB1/undotbs01.dbf
/oradata/data/SRCDB1/pdbseed/undotbs01.dbf
/oradata/data/SRCDB1/users01.dbf
/oradata/data/SRCDB1/srcdbplug1/system01.dbf
/oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug1/users01.dbf
/oradata/data/SRCDB1/srcdbplug2/system01.dbf
/oradata/data/SRCDB1/srcdbplug2/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug2/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug2/users01.dbf
15 rows selected.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab admin]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 7 09:30:47 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB1 (DBID=835842962)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name SRCDB1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.0.0.0/db_2/dbs/snapcf_srcdb1.f'; # default
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 17.95M DISK 00:00:02 03-OCT-21
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20211003T101523
Piece Name: /oradata/fra/SRCDB1/autobackup/2021_10_03/o1_mf_s_1084961723_jolfc5nq_.bkp
SPFILE Included: Modification time: 03-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1307098 Ckp time: 03-OCT-21
RMAN> backup current controlfile;
Starting backup at 07-OCT-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=290 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 07-OCT-21
channel ORA_DISK_1: finished piece 1 at 07-OCT-21
piece handle=/oradata/fra/SRCDB1/backupset/2021_10_07/o1_mf_ncnnf_TAG20211007T093216_jowwbbm2_.bkp tag=TAG20211007T093216 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 07-OCT-21
Starting Control File and SPFILE Autobackup at 07-OCT-21
piece handle=/u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-00 comment=NONE
Finished Control File and SPFILE Autobackup at 07-OCT-21
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 17.95M DISK 00:00:02 03-OCT-21
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20211003T101523
Piece Name: /oradata/fra/SRCDB1/autobackup/2021_10_03/o1_mf_s_1084961723_jolfc5nq_.bkp
SPFILE Included: Modification time: 03-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1307098 Ckp time: 03-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 17.92M DISK 00:00:01 07-OCT-21
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093216
Piece Name: /oradata/fra/SRCDB1/backupset/2021_10_07/o1_mf_ncnnf_TAG20211007T093216_jowwbbm2_.bkp
Control File Included: Ckp SCN: 1601688 Ckp time: 07-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 17.95M DISK 00:00:00 07-OCT-21
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093220
Piece Name: /u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-00
SPFILE Included: Modification time: 07-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1601709 Ckp time: 07-OCT-21
RMAN>
RMAN> ALTER PLUGGABLE DATABASE SRCDBPLUG1 CLOSE IMMEDIATE;
Statement processed
RMAN> BACKUP PLUGGABLE DATABASE SRCDBPLUG1;
Starting backup at 07-OCT-21
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=00008 name=/oradata/data/SRCDB1/srcdbplug1/system01.dbf
input datafile file number=00010 name=/oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf
input datafile file number=00009 name=/oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf
input datafile file number=00011 name=/oradata/data/SRCDB1/srcdbplug1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 07-OCT-21
channel ORA_DISK_1: finished piece 1 at 07-OCT-21
piece handle=/oradata/fra/SRCDB1/CD6C538C9C7F5806E0536738A8C0F328/backupset/2021_10_07/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp tag=TAG20211007T093422 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 07-OCT-21
Starting Control File and SPFILE Autobackup at 07-OCT-21
piece handle=/u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-01 comment=NONE
Finished Control File and SPFILE Autobackup at 07-OCT-21
RMAN> exit
Recovery Manager complete.
[oracle@srlab admin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 09:35:05 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 MOUNTED
4 SRCDBPLUG2 READ WRITE NO
SQL>
SQL> drop pluggable database SRCDBPLUG1 including datafiles;
Pluggable database dropped.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 SRCDBPLUG2 READ WRITE NO
SQL> col name for a65
SQL> set lines 200 pages 2000
SQL> select name from v$datafile;
NAME
-----------------------------------------------------------------
/oradata/data/SRCDB1/system01.dbf
/oradata/data/SRCDB1/pdbseed/system01.dbf
/oradata/data/SRCDB1/sysaux01.dbf
/oradata/data/SRCDB1/pdbseed/sysaux01.dbf
/oradata/data/SRCDB1/undotbs01.dbf
/oradata/data/SRCDB1/pdbseed/undotbs01.dbf
/oradata/data/SRCDB1/users01.dbf
/oradata/data/SRCDB1/srcdbplug2/system01.dbf
/oradata/data/SRCDB1/srcdbplug2/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug2/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug2/users01.dbf
11 rows selected.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab admin]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 7 09:36:45 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB1 (DBID=835842962)
RMAN> restore pluggable database SRCDBPLUG1;
Starting restore at 07-OCT-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=36 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/07/2021 09:36:57
RMAN-06813: could not translate pluggable database SRCDBPLUG1
RMAN> exit
Recovery Manager complete.
[oracle@srlab admin]$ cd /oradata
[oracle@srlab oradata]$ ls -lrt
total 12
drwxr-xr-x. 3 oracle oinstall 4096 Oct 3 07:29 archive
drwxr-xr-x. 5 oracle oinstall 4096 Oct 3 07:33 data
drwxr-xr-x. 3 oracle oinstall 4096 Oct 3 07:33 fra
[oracle@srlab oradata]$ cd fra
[oracle@srlab fra]$ ls -lrt
total 4
drwxr-x---. 5 oracle oinstall 4096 Oct 7 09:34 SRCDB1
[oracle@srlab fra]$ cd SRCDB1/
[oracle@srlab SRCDB1]$ ls -lrt
total 18300
drwxr-x---. 3 oracle oinstall 4096 Oct 3 10:15 autobackup
drwxr-x---. 3 oracle oinstall 4096 Oct 7 09:32 backupset
drwxr-x---. 3 oracle oinstall 4096 Oct 7 09:34 CD6C538C9C7F5806E0536738A8C0F328
-rw-r-----. 1 oracle oinstall 18726912 Oct 7 09:37 control02.ctl
[oracle@srlab SRCDB1]$
[oracle@srlab SRCDB1]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 7 09:42:33 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB1 (DBID=835842962)
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.95M DISK 00:00:02 03-OCT-21
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20211003T101523
Piece Name: /oradata/fra/SRCDB1/autobackup/2021_10_03/o1_mf_s_1084961723_jolfc5nq_.bkp
SPFILE Included: Modification time: 03-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1307098 Ckp time: 03-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 17.92M DISK 00:00:01 07-OCT-21
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093216
Piece Name: /oradata/fra/SRCDB1/backupset/2021_10_07/o1_mf_ncnnf_TAG20211007T093216_jowwbbm2_.bkp
Control File Included: Ckp SCN: 1601688 Ckp time: 07-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 17.95M DISK 00:00:00 07-OCT-21
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093220
Piece Name: /u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-00
SPFILE Included: Modification time: 07-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1601709 Ckp time: 07-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 348.70M DISK 00:00:07 07-OCT-21
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093422
Piece Name: /oradata/fra/SRCDB1/CD6C538C9C7F5806E0536738A8C0F328/backupset/2021_10_07/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp
List of Datafiles in backup set 4
Container ID: 4099, PDB Name: UNKNOWN
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
8 Full 1601822 07-OCT-21 NO
9 Full 1601822 07-OCT-21 NO
10 Full 1601822 07-OCT-21 NO
11 Full 1601822 07-OCT-21 NO
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 17.95M DISK 00:00:01 07-OCT-21
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20211007T093438
Piece Name: /u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-01
SPFILE Included: Modification time: 07-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1601875 Ckp time: 07-OCT-21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 17.95M DISK 00:00:01 07-OCT-21
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20211007T094227
Piece Name: /u01/app/oracle/product/19.0.0.0/db_2/dbs/c-835842962-20211007-02
SPFILE Included: Modification time: 07-OCT-21
SPFILE db_unique_name: SRCDB1
Control File Included: Ckp SCN: 1602259 Ckp time: 07-OCT-21
RMAN> create pfile='/home/oracle/initsrcdb1.ora' from spfile;
Statement processed
RMAN> exit
Recovery Manager complete.
[oracle@srlab SRCDB1]$ cd /home/oracle
[oracle@srlab ~]$ ls -lrt initsrcdb1.ora
-rw-r--r--. 1 oracle oinstall 1222 Oct 7 09:48 initsrcdb1.ora
[oracle@srlab ~]$ scp initsrcdb1.ora 192.168.56.105:/u01/app/oracle/product/19.0.0.0/db_2/dbs/
oracle@192.168.56.105's password:
initsrcdb1.ora 100% 1222 690.1KB/s 00:00
[oracle@srlab ~]$
[oracle@srlab ~]$ hostname
srlab
[oracle@srlab ~]$
[oracle@srlab ~]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 21:09:11 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oradata/data/SRCDB1/system01.dbf
/oradata/data/SRCDB1/pdbseed/system01.dbf
/oradata/data/SRCDB1/sysaux01.dbf
/oradata/data/SRCDB1/pdbseed/sysaux01.dbf
/oradata/data/SRCDB1/undotbs01.dbf
/oradata/data/SRCDB1/pdbseed/undotbs01.dbf
/oradata/data/SRCDB1/users01.dbf
/oradata/data/SRCDB1/srcdbplug2/system01.dbf
/oradata/data/SRCDB1/srcdbplug2/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug2/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug2/users01.dbf
11 rows selected.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab ~]$ cd /u01/app/oracle/product/19.0.0.0/db_2/network/admin/
[oracle@srlab admin]$ vi listener.ora
[oracle@srlab admin]$
[oracle@srlab admin]$ vi tnsnames.ora
[oracle@srlab admin]$
[oracle@srlab admin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 22:00:15 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 SRCDBPLUG2 READ WRITE NO
SQL>
login as: oracle
oracle@192.168.56.105's password:
Last login: Sun Oct 3 21:09:40 2021
[oracle@srlab19c ~]$
[oracle@srlab19c ~]$
[oracle@srlab19c ~]$ cd /oradata/
[oracle@srlab19c oradata]$ ls -lrt
total 12
drwxr-xr-x. 3 oracle oinstall 4096 Oct 3 19:54 data
drwxr-xr-x. 3 oracle oinstall 4096 Oct 3 19:55 archive
drwxr-xr-x. 3 oracle oinstall 4096 Oct 7 09:43 fra
[oracle@srlab19c oradata]$ cd data
[oracle@srlab19c data]$ ls -lrt
total 4
drwxr-x---. 5 oracle oinstall 4096 Oct 3 19:54 SRCDB2
[oracle@srlab19c data]$ cd
[oracle@srlab19c ~]$ cd -
/oradata/data
[oracle@srlab19c data]$ pwd
/oradata/data
[oracle@srlab19c data]$ mkdir SRCDB1
[oracle@srlab19c data]$ ls -lrt
total 8
drwxr-x---. 5 oracle oinstall 4096 Oct 3 19:54 SRCDB2
drwxr-xr-x. 2 oracle oinstall 4096 Oct 7 09:47 SRCDB1
[oracle@srlab19c data]$ cd SRCDB1
[oracle@srlab19c SRCDB1]$ mkdir srcdbplug1
[oracle@srlab19c SRCDB1]$ mkdir srcdbplug2
[oracle@srlab19c SRCDB1]$ ls -lrt
total 8
drwxr-xr-x. 2 oracle oinstall 4096 Oct 7 09:47 srcdbplug1
drwxr-xr-x. 2 oracle oinstall 4096 Oct 7 09:48 srcdbplug2
[oracle@srlab19c SRCDB1]$ cd /u01/app/oracle/product/19.0.0.0/db_2/dbs
[oracle@srlab19c dbs]$ ls -lrt
total 12
-rw-r--r--. 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r-----. 1 oracle oinstall 2048 Oct 3 10:02 orapwsrcdb2
-rw-r--r--. 1 oracle oinstall 1222 Oct 7 09:49 initsrcdb1.ora
[oracle@srlab19c dbs]$ mv orapwsrcdb2 orapwsrcdb1
[oracle@srlab19c dbs]$ ls -lrt
total 12
-rw-r--r--. 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r-----. 1 oracle oinstall 2048 Oct 3 10:02 orapwsrcdb1
-rw-r--r--. 1 oracle oinstall 1222 Oct 7 09:49 initsrcdb1.ora
[oracle@srlab19c dbs]$ cd ..
[oracle@srlab19c db_2]$ cd network/admin/
[oracle@srlab19c admin]$ vi listener.ora
[oracle@srlab19c admin]$
[oracle@srlab19c admin]$ vi tnsnames.ora
[oracle@srlab19c admin]$
[oracle@srlab19c admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_SRCDB19C =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srlab)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
LISTENER_SRCDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.105)(PORT = 1521))
)
)
[oracle@srlab19c admin]$ . oraenv
ORACLE_SID = [oracle] ? srcdb1
The Oracle base has been set to /u01/app/oracle
[oracle@srlab19c admin]$ lsnrctl start LISTENER_SRCDB1
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-OCT-2021 09:52:00
Copyright (c) 1991, 2021, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srlab19c/listener_srcdb1/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.105)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.105)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SRCDB1
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 07-OCT-2021 09:52:01
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlab19c/listener_srcdb1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.105)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@srlab19c admin]$ ps -ef |grep pmon
oracle 9169 3243 0 09:52 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab19c admin]$ ps -ef |grep tns
root 22 2 0 08:13 ? 00:00:00 [netns]
oracle 9158 1 2 09:52 ? 00:00:00 /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr LISTENER_SRCDB1 -inherit
oracle 9175 3243 0 09:52 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab19c admin]$ cd ..
[oracle@srlab19c network]$ cd ..
[oracle@srlab19c db_2]$ cd dbs
[oracle@srlab19c dbs]$ ls -lrt
total 12
-rw-r--r--. 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r-----. 1 oracle oinstall 2048 Oct 3 10:02 orapwsrcdb1
-rw-r--r--. 1 oracle oinstall 1222 Oct 7 09:49 initsrcdb1.ora
[oracle@srlab19c dbs]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 09:52:44 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 2382364032 bytes
Fixed Size 9137536 bytes
Variable Size 603979776 bytes
Database Buffers 1761607680 bytes
Redo Buffers 7639040 bytes
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab19c dbs]$ ps -ef |grep pmon
oracle 9245 1 0 09:53 ? 00:00:00 ora_pmon_srcdb1
oracle 9359 3243 0 09:53 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab19c dbs]$ ps -ef |grep tns
root 22 2 0 08:13 ? 00:00:00 [netns]
oracle 9158 1 0 09:52 ? 00:00:00 /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr LISTENER_SRCDB1 -inherit
oracle 9364 3243 0 09:53 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab19c dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 7 09:55:23 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SRCDB1 (not mounted)
RMAN> restore controlfile from '/oradata/fra/o1_mf_ncnnf_TAG20211007T093216_jowwbbm2_.bkp';
Starting restore at 07-OCT-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/oradata/data/SRCDB1/control01.ctl
output file name=/oradata/fra/SRCDB1/control02.ctl
Finished restore at 07-OCT-21
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed
RMAN> CATALOG BACKUPPIECE '/oradata/fra/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp';
Starting implicit crosscheck backup at 07-OCT-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 07-OCT-21
Starting implicit crosscheck copy at 07-OCT-21
using channel ORA_DISK_1
Finished implicit crosscheck copy at 07-OCT-21
searching for all files in the recovery area
cataloging files...
no files cataloged
channel ORA_DISK_1: cataloged backup piece
backup piece handle=/oradata/fra/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp RECID=2 STAMP=1085306256
RMAN> RESTORE PLUGGABLE DATABASE SRCDBPLUG1;
Starting restore at 07-OCT-21
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 00008 to /oradata/data/SRCDB1/srcdbplug1/system01.dbf
channel ORA_DISK_1: restoring datafile 00009 to /oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /oradata/data/SRCDB1/srcdbplug1/users01.dbf
channel ORA_DISK_1: reading from backup piece /oradata/fra/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp
channel ORA_DISK_1: piece handle=/oradata/fra/o1_mf_nnndf_TAG20211007T093422_jowwg7cl_.bkp tag=TAG20211007T093422
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 07-OCT-21
RMAN> exit
Recovery Manager complete.
[oracle@srlab19c dbs]$ . oraenv
ORACLE_SID = [srcdb1] ? srcdb2
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab19c dbs]$ ps -ef |grep pmon
oracle 9245 1 0 09:53 ? 00:00:04 ora_pmon_srcdb1
oracle 29573 3243 0 20:57 pts/0 00:00:00 grep --color=auto pmon
oracle 31325 1 0 13:37 ? 00:00:04 ora_pmon_srcdb2
[oracle@srlab19c dbs]$ env |grep ORA
ORACLE_SID=srcdb2
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/db_2
[oracle@srlab19c dbs]$
[oracle@srlab19c dbs]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 21:05:34 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
SQL>
SQL> col comp_name for a40
SQL> col comp_id for a20
SQL> col version for 99999999
SQL> /
COMP_ID COMP_NAME VERSION STATUS
-------------------- ---------------------------------------- ------------------------------ --------------------
CATALOG Oracle Database Catalog Views 19.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 19.0.0.0.0 VALID
RAC Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF
JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 VALID
XML Oracle XDK 19.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 19.0.0.0.0 VALID
XDB Oracle XML Database 19.0.0.0.0 VALID
OWM Oracle Workspace Manager 19.0.0.0.0 VALID
8 rows selected.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
SQL>
SQL>
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> select name from v$datafile;
NAME
---------------------------------------------------
/oradata/data/SRCDB2/system01.dbf
/oradata/data/SRCDB2/pdbseed/system01.dbf
/oradata/data/SRCDB2/sysaux01.dbf
/oradata/data/SRCDB2/pdbseed/sysaux01.dbf
/oradata/data/SRCDB2/undotbs01.dbf
/oradata/data/SRCDB2/pdbseed/undotbs01.dbf
/oradata/data/SRCDB2/users01.dbf
7 rows selected.
SQL>
SQL>
SQL> shwo pdbs
SP2-0042: unknown command "shwo pdbs" - rest of line ignored.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
SQL>
SQL>
SQL> BEGIN
DBMS_PDB.RECOVER (
pdb_descr_file => '/home/oracle/srcdbplug1_recover.xml',
pdb_name => 'srcdbplug1',
filenames => '/oradata/data/SRCDB1/srcdbplug1/system01.dbf,/oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf,/oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf,/oradata/data/SRCDB1/srcdbplug1/users01.dbf'
);
END;
/ 2 3 4 5 6 7 8
PL/SQL procedure successfully completed.
SQL> CREATE PLUGGABLE DATABASE SRCDBPLUG1 USING '/home/oracle/srcdbplug1_recover.xml' NOCOPY;
Pluggable database created.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 MOUNTED
SQL> select * from global_name;
GLOBAL_NAME
---------------------------------------------------
SRCDB2
SQL> alter pluggable database SRCDBPLUG1 open read write;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 MIGRATE YES
SQL>
SQL> col cause for a20
SQL> col message for a65
SQL> select name,cause,message,status from pdb_plug_in_violations;
no rows selected
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 MIGRATE YES
SQL> alter session set container=srcdbplug1;
Session altered.
SQL> select name,cause,message,status from pdb_plug_in_violations;
no rows selected
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 SRCDBPLUG1 MIGRATE YES
SQL>
SQL> alter session set container=cdb$root;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 MIGRATE YES
SQL>
SQL> alter pluggable database SRCDBPLUG1 close immediate;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 MOUNTED
SQL>
SQL> alter pluggable database SRCDBPLUG1 open read write;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 READ WRITE NO
SQL>
SQL> select name from v$datafile;
NAME
---------------------------------------------------
/oradata/data/SRCDB2/system01.dbf
/oradata/data/SRCDB2/pdbseed/system01.dbf
/oradata/data/SRCDB2/sysaux01.dbf
/oradata/data/SRCDB2/pdbseed/sysaux01.dbf
/oradata/data/SRCDB2/undotbs01.dbf
/oradata/data/SRCDB2/pdbseed/undotbs01.dbf
/oradata/data/SRCDB2/users01.dbf
/oradata/data/SRCDB1/srcdbplug1/system01.dbf
/oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug1/users01.dbf
11 rows selected.
[oracle@srlab19c admin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 21:59:10 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 READ WRITE NO
[oracle@srlab19c db_2]$ cd dbs
[oracle@srlab19c dbs]$ ls -lrt
total 18324
-rw-r--r--. 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r-----. 1 oracle oinstall 2048 Oct 3 10:02 orapwsrcdb1
-rw-r--r--. 1 oracle oinstall 1222 Oct 7 09:49 initsrcdb1.ora
-rw-r-----. 1 oracle oinstall 24 Oct 7 09:56 lkSRCDB1
-rw-rw----. 1 oracle oinstall 1544 Oct 7 09:56 hc_srcdb1.dat
-rw-r-----. 1 oracle oinstall 24 Oct 7 10:12 lkSRCDB2
-rw-r-----. 1 oracle oinstall 2048 Oct 7 13:31 orapwsrcdb2
-rw-rw----. 1 oracle oinstall 1544 Oct 7 13:37 hc_srcdb2.dat
-rw-r-----. 1 oracle oinstall 18726912 Oct 7 21:43 snapcf_srcdb2.f
-rw-r-----. 1 oracle oinstall 3584 Oct 7 21:44 spfilesrcdb2.ora
[oracle@srlab19c dbs]$
[oracle@srlab19c dbs]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 7 22:04:00 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 READ WRITE NO
SQL>
SQL> show parameter sec_case_sensitive_logon
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SQL>
SQL> alter system set sec_case_sensitive_logon=false;
System altered.
[oracle@srlab ~]$ ps -ef |grep pmon
oracle 3495 1 0 Oct08 ? 00:00:08 ora_pmon_srcdb1
oracle 29020 28970 0 10:53 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab ~]$ ps -ef |grep tns
root 22 2 0 Oct08 ? 00:00:00 [netns]
oracle 8017 1 0 Oct08 ? 00:00:01 /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr LISTENER_SRCDB1 -inherit
oracle 29026 28970 0 10:54 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab ~]$ lsnrctl status LISTENER_SRCDB1
bash: lsnrctl: command not found...
[oracle@srlab ~]$ . oraenv
ORACLE_SID = [oracle] ? srcdb1
The Oracle base has been set to /u01/app/oracle
[oracle@srlab ~]$ lsnrctl status LISTENER_SRCDB1
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 09-OCT-2021 10:54:25
Copyright (c) 1991, 2021, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.103)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SRCDB1
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 07-OCT-2021 09:29:04
Uptime 2 days 1 hr. 25 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlab/listener_srcdb1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1521)))
Services Summary...
Service "cd6a36f835721b6fe0536738a8c07e91" has 1 instance(s).
Instance "srcdb1", status READY, has 1 handler(s) for this service...
Service "cd6c5646e1fd58ffe0536738a8c0503b" has 1 instance(s).
Instance "srcdb1", status READY, has 1 handler(s) for this service...
Service "srcdb1" has 1 instance(s).
Instance "srcdb1", status READY, has 1 handler(s) for this service...
Service "srcdb1XDB" has 1 instance(s).
Instance "srcdb1", status READY, has 1 handler(s) for this service...
Service "srcdbplug2" has 1 instance(s).
Instance "srcdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@srlab ~]$ cd $ORACLE_HOME/network/admin
[oracle@srlab admin]$ ls -lrt
total 32
-rw-r--r--. 1 oracle oinstall 1536 Feb 14 2018 shrept.lst
drwxr-xr-x. 2 oracle oinstall 4096 Apr 17 2019 samples
-rw-r-----. 1 oracle oinstall 200 Oct 3 07:33 sqlnet2110037AM3306.bak
-rw-r-----. 1 oracle oinstall 340 Oct 3 07:33 listener2110037AM3306.bak
-rw-r-----. 1 oracle oinstall 410 Oct 3 07:33 tnsnames2110037AM3306.bak
-rw-r-----. 1 oracle oinstall 200 Oct 3 07:33 sqlnet.ora
-rw-r-----. 1 oracle oinstall 481 Oct 7 21:57 listener.ora
-rw-r-----. 1 oracle oinstall 863 Oct 7 21:59 tnsnames.ora
[oracle@srlab admin]$ vi tnsnames.ora
[oracle@srlab admin]$
[oracle@srlab admin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Oct 9 11:06:20 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 SRCDBPLUG2 READ WRITE NO
SQL>
SQL> show parameter case
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SQL> alter user system password expire container=all;
User altered.
SQL> alter user system identified by welcome123;
User altered.
SQL> alter user system identified by welcome123 container=all;
User altered.
SQL> create database link remote_connect connect to system identified by "welcome123" using 'srcdbplug1';
Database link created.
SQL> select sysdate from dual@remote_connect;
SYSDATE
---------
09-OCT-21
SQL>
SQL> CREATE PLUGGABLE DATABASE SRCDBPLUG1 FROM srcdbplug1@remote_connect file_name_convert=('/oradata/data/SRCDB1/srcdbplug1','/oradata/data/SRCDB1/srcdbplug1');
Pluggable database created.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 MOUNTED
4 SRCDBPLUG2 READ WRITE NO
SQL> alter pluggable database SRCDBPLUG1 open;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 READ WRITE NO
4 SRCDBPLUG2 READ WRITE NO
SQL>
SQL> alter pluggable database SRCDBPLUG1 save state;
Pluggable database altered.
SQL> set lines 200 pages 2000
SQL>
SQL> select name from v$datafile;
NAME
---------------------------------------------------
/oradata/data/SRCDB1/system01.dbf
/oradata/data/SRCDB1/pdbseed/system01.dbf
/oradata/data/SRCDB1/sysaux01.dbf
/oradata/data/SRCDB1/pdbseed/sysaux01.dbf
/oradata/data/SRCDB1/undotbs01.dbf
/oradata/data/SRCDB1/pdbseed/undotbs01.dbf
/oradata/data/SRCDB1/users01.dbf
/oradata/data/SRCDB1/srcdbplug2/system01.dbf
/oradata/data/SRCDB1/srcdbplug2/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug2/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug2/users01.dbf
/oradata/data/SRCDB1/srcdbplug1/system01.dbf
/oradata/data/SRCDB1/srcdbplug1/sysaux01.dbf
/oradata/data/SRCDB1/srcdbplug1/undotbs01.dbf
/oradata/data/SRCDB1/srcdbplug1/users01.dbf
15 rows selected.
SQL> alter session set container=srcdbplug1;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 SRCDBPLUG1 READ WRITE NO
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab19c admin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Oct 9 12:07:00 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@srlab19c admin]$ clear scr
[oracle@srlab19c admin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Oct 9 12:07:10 2021
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 READ WRITE NO
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB2
SQL> show parameter case
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SQL> alter user system account lock;
User altered.
SQL> alter user system password expirte account unlock;
alter user system password expirte account unlock
*
ERROR at line 1:
ORA-02000: missing EXPIRE keyword
SQL> alter user system password expire account unlock;
User altered.
SQL> alter user system password expire account unlock container=all;
User altered.
SQL> grant sysoper, create pluggable database to system container=all;
Grant succeeded.
SQL> alter user system password expire container=all;
User altered.
SQL> alter user system identified by welcome123 container=all;
User altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG1 READ WRITE NO
SQL>
Conclusion: We've successfully restored SRCDBPLUG1 pluggable database and plugged back in to SRCDB1 container database from target server.
Hope this helps!
Ramesh.
Post a Comment: