{"id":38083,"date":"2025-04-22T23:07:17","date_gmt":"2025-04-22T21:07:17","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=38083"},"modified":"2025-04-22T23:07:21","modified_gmt":"2025-04-22T21:07:21","slug":"restore-a-database-using-veeam-rman-plug-in-on-an-oda","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/","title":{"rendered":"Restore a database using Veeam RMAN plug-in on an ODA"},"content":{"rendered":"\n

I recently wrote a blog to show how to configure Veeam RMAN plug-in to take database backups. As all DBA knows, configuring a backup, will not go without testing a restore. In this blog I will show how I tested my previous Veeam configuration and backups performed with this Veeam RMAN plug-in on the same ODA. In order to test that the Veeam backups are usable, we will create a new CVEEAMT container database on the ODA and restore existing CDB1 container database into CVEEAMT using a previous existing VEEAM backup we took after configuring the plug-in. The restore will be done through a duplicate.<\/p>\n\n\n\n\n\n\n\n

Pay attention<\/h3>\n\n\n\n

As we will restore an existing production container database, named CDB1, hosting a PDB named, PDB1, into new CVEEAMT container database, we will have a duplicate PDB. As we know that each PDB is registered into the listener, both PDB1 will be reachable through the same service, which, if the PDB1 is in use, could have dramatical consequence. There before doing the restore into the new container database we will change the domain of the newly created one.<\/p>\n\n\n\n

Create new container database CVEEAMT<\/h3>\n\n\n\n

With odacli we will create the new container databasse named CVEEAMT.<\/p>\n\n\n\n

\n[root@ODA2 ~]# odacli list-dbhomes\nID                                       Name                 DB Version           DB Edition Home Location                                            Status\n---------------------------------------- -------------------- -------------------- ---------- -------------------------------------------------------- ----------\n3941f574-77bd-4f9e-a1f6-db2bb654f334     OraDB19000_home1     19.25.0.0.241015     SE         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1     CONFIGURED\nb922980f-cecd-4bf8-a688-eb41dd4b5b4b     OraDB19000_home2     19.25.0.0.241015     SE         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2     CONFIGURED\n\n[root@ODA2 ~]# odacli create-database -dh 3941f574-77bd-4f9e-a1f6-db2bb654f334 -n CVEEAMT -u CVEEAMT_SITE1 -cl OLTP -c -p VEEAMT -no-co -cs AL32UTF8 -ns UTF8 -l AMERICAN -dt AMERICA -s odb1 -r ACFS\nEnter SYS, SYSTEM and PDB Admin user password:\nRetype SYS, SYSTEM and PDB Admin user password:\n\nJob details\n----------------------------------------------------------------\n                     ID:  7d99e795-31e8-4c96-af15-376405180978\n            Description:  Database service creation with DB name: CVEEAMT\n                 Status:  Created\n                Created:  February 19, 2025 11:37:16 CET\n                Message:\n\nTask Name                                Start Time                               End Time                                 Status\n---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------\n\n[root@ODA2 ~]# odacli describe-job -i 7d99e795-31e8-4c96-af15-376405180978\n\nJob details\n----------------------------------------------------------------\n                     ID:  7d99e795-31e8-4c96-af15-376405180978\n            Description:  Database service creation with DB name: CVEEAMT\n                 Status:  Success\n                Created:  February 19, 2025 11:37:16 CET\n                Message:\n\nTask Name                                Start Time                               End Time                                 Status\n---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------\nSetting up SSH equivalence               February 19, 2025 11:37:20 CET           February 19, 2025 11:37:20 CET           Success\nSetting up SSH equivalence               February 19, 2025 11:37:20 CET           February 19, 2025 11:37:20 CET           Success\nCreating volume datCVEEAMT               February 19, 2025 11:37:20 CET           February 19, 2025 11:37:35 CET           Success\nCreating volume rdoCVEEAMT               February 19, 2025 11:37:35 CET           February 19, 2025 11:37:50 CET           Success\nCreating ACFS filesystem for DATA        February 19, 2025 11:37:50 CET           February 19, 2025 11:38:14 CET           Success\nCreating ACFS filesystem for RECO        February 19, 2025 11:38:14 CET           February 19, 2025 11:38:37 CET           Success\nDatabase Service creation                February 19, 2025 11:38:38 CET           February 19, 2025 11:52:54 CET           Success\nDatabase Creation by RHP                 February 19, 2025 11:38:38 CET           February 19, 2025 11:50:16 CET           Success\nChange permission for xdb wallet files   February 19, 2025 11:50:16 CET           February 19, 2025 11:50:17 CET           Success\nAdd Startup Trigger to Open all PDBS     February 19, 2025 11:50:17 CET           February 19, 2025 11:50:18 CET           Success\nPlace SnapshotCtrlFile in sharedLoc      February 19, 2025 11:50:18 CET           February 19, 2025 11:50:21 CET           Success\nSqlPatch upgrade                         February 19, 2025 11:51:35 CET           February 19, 2025 11:51:55 CET           Success\nRunning dbms_stats init_package          February 19, 2025 11:51:55 CET           February 19, 2025 11:51:56 CET           Success\nSet log_archive_dest for Database        February 19, 2025 11:51:56 CET           February 19, 2025 11:51:58 CET           Success\nUpdating the Database version            February 19, 2025 11:51:58 CET           February 19, 2025 11:52:02 CET           Success\nCreate Users tablespace                  February 19, 2025 11:52:54 CET           February 19, 2025 11:52:57 CET           Success\nClear all listeners from Database        February 19, 2025 11:52:57 CET           February 19, 2025 11:52:58 CET           Success\nCopy Pwfile to Shared Storage            February 19, 2025 11:53:00 CET           February 19, 2025 11:53:01 CET           Success\n\n[root@ODA2 ~]#\n<\/pre>\n<\/br>\n\n\n\n
Change the domain<\/h3>\n\n\n\n
As explained previously, for the newly created container database, we will change the existing domain domain.ch to test.ch, in order not to conflict connecting to both PDB1 once the restore is done.<\/p>\n\n\n\n
Existing listener registration for the new CVEEAMT container database and PDB:<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] lsnrctl status | grep -i veeam\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"CVEEAMTXDB.domain.ch\" has 1 instance(s).\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"CVEEAMT_SITE1.domain.ch\" has 1 instance(s).\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"veeamt.domain.ch\" has 1 instance(s).\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\n<\/pre>\n<\/br>\n\n\n\n
As we can see new CDB and new PDB are registered into the listener using existing ODA domain domain.ch.<\/p>\n\n\n\n
Let’s change it to test.ch.<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 19 11:59:25 2025\nVersion 19.25.0.0.0\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production\nVersion 19.25.0.0.0\n\nSQL> show parameter domain\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_domain                            string      domain.ch\n\nSQL> alter system set db_domain='test.ch' scope=spfile;\n\nSystem altered.\n<\/pre>\n<\/br>\n\n\n\n
We will restart the database for the changes to take effects.<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] srvctl stop database -d CVEEAMT_SITE1\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] srvctl start database -d CVEEAMT_SITE1\n<\/pre>\n<\/br>\n\n\n\n
We will check listener registration:<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] lsnrctl status | grep -i veeam\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"CVEEAMTXDB.test.ch\" has 1 instance(s).\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"CVEEAMT_SITE1.test.ch\" has 1 instance(s).\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"veeamt.test.ch\" has 1 instance(s).\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\n<\/pre>\n<\/br>\n\n\n\n
As well as domain instance parameter:<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 19 12:02:23 2025\nVersion 19.25.0.0.0\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production\nVersion 19.25.0.0.0\n\nSQL> show parameter db_domain\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_domain                            string      test.ch\n<\/pre>\n<\/br>\n\n\n\n
Listener configuration<\/h3>\n\n\n\n
As we will duplicate CDB1 to CVEEAMT, the database name will be renamed. This implies a database restart, which will be done through a listener connection. Therefore, for RMAN to connect to a closed database remotely, we will need to add a static entry that will be used for RMAN duplicate auxiliary connection.<\/p>\n\n\n\n
Static registration:<\/p>\n\n\n\n
\nSID_LIST_LISTENER =\n  (SID_LIST =\n    (SID_DESC =\n      (GLOBAL_DBNAME = CVEEAMT_SITE1.test.ch)\n      (ORACLE_HOME   = \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1)\n      (SID_NAME      = CVEEAMT)\n     )\n  )\n<\/pre>\n<\/br>\n\n\n\n
Backup existing listener configuration on the ODA:<\/p>\n\n\n\n
\ngrid@ODA2:~\/ [rdbms1900] grinf19\ngrid@ODA2:~\/ [grinf19] cdt\ngrid@ODA2:\/u01\/app\/19.25.0.0\/grid\/network\/admin\/ [grinf19] ls -ltrh\ntotal 28K\n-rw-r--r-- 1 grid oinstall 1.5K Feb 14  2018 shrept.lst\ndrwxr-xr-x 2 grid oinstall 4.0K Apr 17  2019 samples\n-rw-r--r-- 1 grid oinstall  266 Dec  3 17:33 listener.ora.bak.ODA2.grid\n-rw-r--r-- 1 grid oinstall  504 Dec  3 17:34 listener.ora\n-rw-r----- 1 grid oinstall  504 Dec  3 17:34 listener2412035PM3433.bak\n-rw-r----- 1 grid oinstall  179 Dec  3 17:34 sqlnet.ora.20250204\n-rw-r----- 1 grid oinstall  200 Feb  4 15:00 sqlnet.ora\ngrid@ODA2:\/u01\/app\/19.25.0.0\/grid\/network\/admin\/ [grinf19] mkdir history\ngrid@ODA2:\/u01\/app\/19.25.0.0\/grid\/network\/admin\/ [grinf19] cp -p listener.ora .\/history\/listener.ora.202502191205\n<\/pre>\n<\/br>\n\n\n\n
Add listener static entry:<\/p>\n\n\n\n
\ngrid@ODA2:\/u01\/app\/19.25.0.0\/grid\/network\/admin\/ [grinf19] vi listener.ora\ngrid@ODA2:\/u01\/app\/19.25.0.0\/grid\/network\/admin\/ [grinf19] diff listener.ora .\/history\/listener.ora.202502191205\n7,15d6\n<\n< SID_LIST_LISTENER =\n<   (SID_LIST =\n<     (SID_DESC =\n<       (GLOBAL_DBNAME = CVEEAMT_SITE1.test.ch)\n<       (ORACLE_HOME   = \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1)\n<       (SID_NAME      = CVEEAMT)\n<      )\n<   )\ngrid@ODA2:\/u01\/app\/19.25.0.0\/grid\/network\/admin\/ [grinf19]\n<\/pre>\n<\/br>\n\n\n\n
Reload the listener:<\/p>\n\n\n\n
\ngrid@ODA2:\/u01\/app\/19.25.0.0\/grid\/network\/admin\/ [grinf19] lsnrctl reload\n\nLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-FEB-2025 13:01:10\n\nCopyright (c) 1991, 2024, Oracle.  All rights reserved.\n\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))\nThe command completed successfully\n<\/pre>\n<\/br>\n\n\n\n
And check running static registration, that we can recognize with the UNKNOWN status:<\/p>\n\n\n\n
\ngrid@ODA2:\/u01\/app\/19.25.0.0\/grid\/network\/admin\/ [grinf19] lsnrctl status | grep -i veeam\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"CVEEAMTXDB.test.ch\" has 1 instance(s).\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"CVEEAMT_SITE1.test.ch\" has 2 instance(s).\n  Instance \"CVEEAMT\", status UNKNOWN, has 1 handler(s) for this service...\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"veeamt.test.ch\" has 1 instance(s).\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\n<\/pre>\n<\/br>\n\n\n\n\n
Configure Oracle network connections<\/h3>\n\n\n\n
We will configure appropriate tnsnames.ora entries that will be used to connect to target and auxiliary database.<\/p>\n\n\n\n
We just need to add new auxiliary entry. The target entry for CDB1 connection is still existing and will permit connection to existing CDB1 production container database.<\/p>\n\n\n\n
tnsnames connection to add:<\/p>\n\n\n\n
\nCVEEAMT_SITE1 =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = ODA2)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = CVEEAMT_SITE1.test.ch)\n    )\n  )\n<\/pre>\n<\/br>\n\n\n\n
tnsnames.ora backup and configuration changes. Entry for CVEEAMT_SITE1 already exist and was performed initially by odacli:<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] cdt\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/network\/admin\/ [CVEEAMT (CDB$ROOT)] ls -ltrh\ntotal 112K\n-rw-r--r-- 1 oracle oinstall 1.5K Feb 14  2018 shrept.lst\ndrwxr-xr-x 2 oracle oinstall  20K Apr 17  2019 samples\ndrwxr-xr-x 2 oracle oinstall  20K Dec 18 14:01 history\n-rw-r----- 1 oracle oinstall 2.6K Feb 19 11:45 tnsnames.ora\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/network\/admin\/ [CVEEAMT (CDB$ROOT)] cp -p tnsnames.ora .\/history\/tnsnames.ora.202502191305\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/network\/admin\/ [CVEEAMT (CDB$ROOT)] vi tnsnames.ora\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/network\/admin\/ [CVEEAMT (CDB$ROOT)] diff tnsnames.ora .\/history\/tnsnames.ora.202502191305\n115c115\n       (SERVICE_NAME = CVEEAMT_SITE1.domain.ch)\n<\/pre>\n<\/br>\n\n\n\n
Test target and auxiliary connections<\/h3>\n\n\n\n
Test connection to auxiliary database, CVEEAMT:<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/network\/admin\/ [CVEEAMT (CDB$ROOT)] sqlplus sys@CVEEAMT_SITE1 as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 19 13:07:24 2025\nVersion 19.25.0.0.0\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\nEnter password:\n\nConnected to:\nOracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production\nVersion 19.25.0.0.0\n\nSQL> set line 300\nSQL> select instance_name, host_name from v$instance;\n\nINSTANCE_NAME    HOST_NAME\n---------------- ----------------------------------------------------------------\nCVEEAMT          ODA2.domain.ch\n\nSQL>\n<\/pre>\n<\/br>\n\n\n\n
Test connection to target database, CDB1:<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/network\/admin\/ [CVEEAMT (CDB$ROOT)] sqlplus sys@CDB1_SITE1 as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 19 13:08:53 2025\nVersion 19.25.0.0.0\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\nEnter password:\n\nConnected to:\nOracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production\nVersion 19.25.0.0.0\n\nSQL> set line 300\nSQL> select instance_name, host_name from v$instance;\n\nINSTANCE_NAME    HOST_NAME\n---------------- ----------------------------------------------------------------\nCDB1            ODA2.domain.ch\n\nSQL>\n<\/pre>\n<\/br>\n\n\n\n\n
 Delete CVEEAMT DB files<\/h3>\n\n\n\n
We will now delete CVEEAMT database files before executing the restore.<\/p>\n\n\n\n
We will first check spfile:<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] cdh\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/ [CVEEAMT (CDB$ROOT)] cd dbs\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] ls -ltrh *CVEEAMT*\n-rw-r----- 1 oracle asmadmin   24 Feb 19 11:39 lkCVEEAMT_SITE1\n-rw-r----- 1 oracle asmadmin   24 Feb 19 11:40 lkCVEEAMT\n-rw-r----- 1 oracle oinstall   69 Feb 19 11:48 initCVEEAMT.ora\n-rw-rw---- 1 oracle asmadmin 1.6K Feb 19 12:01 hc_CVEEAMT.dat\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] cat initCVEEAMT.ora\nSPFILE='\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/dbs\/spfileCVEEAMT.ora'\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] srvctl config database -d CVEEAMT_SITE1 | grep -i spfile\nSpfile: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/dbs\/spfileCVEEAMT.ora\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)]\n<\/pre>\n<\/br>\n\n\n\n\n
We will stop the database:<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] srvctl stop database -d CVEEAMT_SITE1\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] CVEEAMT\n\n **************************\n INSTANCE_NAME   : CVEEAMT\n STATUS          : DOWN\n **************************\n Statustime: 2025-02-19 13:11:56\n<\/pre>\n<\/br>\n\n\n\n
We will backup the spfile:<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] cp -p \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/dbs\/spfileCVEEAMT.ora \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/dbs\/spfileCVEEAMT.ora.bak.202502191312\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] ls -ltrh \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/dbs\/\ntotal 20K\n-rw-r----- 1 oracle asmadmin 2.0K Feb 19 11:41 orapwCVEEAMT\n-rw-r----- 1 oracle oinstall 6.5K Feb 19 12:02 spfileCVEEAMT.ora.bak.202502191312\n-rw-r----- 1 oracle asmadmin 6.5K Feb 19 12:02 spfileCVEEAMT.ora\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)]\n<\/pre>\n<\/br>\n\n\n\n
We will drop CVEEAMT database:<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 19 13:14:09 2025\nVersion 19.25.0.0.0\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\nConnected to an idle instance.\n\nSQL> startup mount restrict\nORACLE instance started.\n\nTotal System Global Area 4294965864 bytes\nFixed Size                  9185896 bytes\nVariable Size             855638016 bytes\nDatabase Buffers         3388997632 bytes\nRedo Buffers               41144320 bytes\nDatabase mounted.\n\nSQL> drop database;\n\nDatabase dropped.\n\nDisconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production\nVersion 19.25.0.0.0\nSQL>\n<\/pre>\n<\/br>\n\n\n\n
We will restore the spfile that was deleted with the drop database command:<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] ls -ltrh \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/dbs\/\ntotal 12K\n-rw-r----- 1 oracle asmadmin 2.0K Feb 19 11:41 orapwCVEEAMT\n-rw-r----- 1 oracle oinstall 6.5K Feb 19 12:02 spfileCVEEAMT.ora.bak.202502191312\n\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] cp -p \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/dbs\/spfileCVEEAMT.ora.bak.202502191312 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/dbs\/spfileCVEEAMT.ora\n\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] ls -ltrh \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/dbs\/\ntotal 20K\n-rw-r----- 1 oracle asmadmin 2.0K Feb 19 11:41 orapwCVEEAMT\n-rw-r----- 1 oracle oinstall 6.5K Feb 19 12:02 spfileCVEEAMT.ora.bak.202502191312\n-rw-r----- 1 oracle oinstall 6.5K Feb 19 12:02 spfileCVEEAMT.ora\n<\/pre>\n<\/br>\n\n\n\n
Startup nomount auxiliary database<\/h3>\n\n\n\n
We will startup in nomount status the auxiliary database, CVEEAMT.<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 19 13:15:45 2025\nVersion 19.25.0.0.0\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\nConnected to an idle instance.\n\nSQL> startup nomount\nORACLE instance started.\n\nTotal System Global Area 4294965864 bytes\nFixed Size                  9185896 bytes\nVariable Size             855638016 bytes\nDatabase Buffers         3388997632 bytes\nRedo Buffers               41144320 bytes\nSQL>\n<\/pre>\n<\/br>\n\n\n\n
Database is started in nomunt and static registration available:<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)] lsnrctl status | grep -i veeam\nService \"CVEEAMT_SITE1.test.ch\" has 2 instance(s).\n  Instance \"CVEEAMT\", status UNKNOWN, has 1 handler(s) for this service...\n  Instance \"CVEEAMT\", status BLOCKED, has 1 handler(s) for this service...\noracle@ODA2:\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1\/dbs\/ [CVEEAMT (CDB$ROOT)]\n<\/pre>\n<\/br>\n\n\n\n
Check CDB1 backups<\/h3>\n\n\n\n
We will check that last automatic backups that we configured in the crontab at the end of the VEEAM RMAN plug-in configuration are successfully.<\/p>\n\n\n\n
INC0 backup:<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorabase\/oracle\/admin\/CDB1_SITE1\/log\/ [CDB1 (CDB$ROOT)] ls -ltrh *inc0* | tail -n1\n-rw-r--r-- 1 oracle oinstall 17K Feb 16 18:20 CDB1_bck_inc0_no_arc_del_tape_20250216_180002.log\n\noracle@ODA2:\/u01\/app\/odaorabase\/oracle\/admin\/CDB1_SITE1\/log\/ [CDB1 (CDB$ROOT)] tail CDB1_bck_inc0_no_arc_del_tape_20250216_180002.log\n\nRecovery Manager complete.\n\nRMAN return Code: 0\n\n#**************************************************************************************************#\n#                    END OF: CDB1_bck_inc0_no_arc_del_tape_20250216_180002.log                    #\n#--------------------------------------------------------------------------------------------------#\n#                                  timestamp: 2025-02-16_18:20:54                                  #\n#**************************************************************************************************#\n<\/pre>\n<\/br>\n\n\n\n
INC1 backup:<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorabase\/oracle\/admin\/CDB1_SITE1\/log\/ [CDB1 (CDB$ROOT)] ls -ltrh *inc1* | tail -n1\n-rw-r--r-- 1 oracle oinstall 17K Feb 18 18:01 CDB1_bck_inc1_no_arc_del_tape_20250218_180002.log\n\noracle@ODA2:\/u01\/app\/odaorabase\/oracle\/admin\/CDB1_SITE1\/log\/ [CDB1 (CDB$ROOT)] tail CDB1_bck_inc1_no_arc_del_tape_20250218_180002.log\n\nRecovery Manager complete.\n\nRMAN return Code: 0\n\n#**************************************************************************************************#\n#                    END OF: CDB1_bck_inc1_no_arc_del_tape_20250218_180002.log                    #\n#--------------------------------------------------------------------------------------------------#\n#                                  timestamp: 2025-02-18_18:01:31                                  #\n#**************************************************************************************************#\n<\/pre>\n<\/br>\n\n\n\n
Archived log backup:<\/p>\n\n\n\n
\noracle@ODA2:\/u01\/app\/odaorabase\/oracle\/admin\/CDB1_SITE1\/log\/ [CDB1 (CDB$ROOT)] ls -ltrh *arc_no_arc* | tail -n1\n-rw-r--r-- 1 oracle oinstall 7.6K Feb 19 12:40 CDB1_bck_arc_no_arc_del_tape_20250219_124002.log\n\noracle@ODA2:\/u01\/app\/odaorabase\/oracle\/admin\/CDB1_SITE1\/log\/ [CDB1 (CDB$ROOT)] tail CDB1_bck_arc_no_arc_del_tape_20250219_124002.log\n\nRecovery Manager complete.\n\nRMAN return Code: 0\n\n#**************************************************************************************************#\n#                    END OF: CDB1_bck_arc_no_arc_del_tape_20250219_124002.log                     #\n#--------------------------------------------------------------------------------------------------#\n#                                  timestamp: 2025-02-19_12:40:49                                  #\n#**************************************************************************************************#\n<\/pre>\n<\/br>\n\n\n\n
Create a new table on PDB1 existing in target CDB1<\/h3>\n\n\n\n
In order to check some data contents after the restore we will create a TEST1 table in the PDB1 from existing target CDB1 container database.<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CDB1 (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 19 14:07:35 2025\nVersion 19.25.0.0.0\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production\nVersion 19.25.0.0.0\n\nSQL> show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1                           READ WRITE NO\n\nSQL> alter session set container=PDB1;\n\nSession altered.\n\nSQL> create table TEST1 as select * from dba_users;\n\nTable created.\n<\/pre>\n<\/br>\n\n\n\n
Archived log backup on CDB1<\/h3>\n\n\n\n
Let’s take a last archived log backup to record last transaction, including our TEST1 table creation.<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CDB1 (CDB$ROOT)] \/u01\/app\/oracle\/local\/dmk_ha\/bin\/check_primary.ksh CDB1 \"\/u01\/app\/oracle\/local\/dmk_dbbackup\/bin\/dmk_rman.ksh -s CDB1 -t bck_arc_no_arc_del_tape.rcv -c \/u01\/app\/odaorabase\/oracle\/admin\/CDB1_SITE1\/etc\/rman.cfg\"\n2025-02-19_14:09:49::check_primary.ksh::SetOraEnv       ::INFO ==> Environment: CDB1 (\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1)\n2025-02-19_14:09:49::check_primary.ksh::MainProgram     ::INFO ==> Getting V$DATABASE.DB_ROLE for CDB1\n2025-02-19_14:09:49::check_primary.ksh::MainProgram     ::INFO ==> CDB1 Database Role is: PRIMARY\n2025-02-19_14:09:49::check_primary.ksh::MainProgram     ::INFO ==> Program going ahead and starting requested command\n2025-02-19_14:09:49::check_primary.ksh::MainProgram     ::INFO ==> Script : \/u01\/app\/oracle\/local\/dmk_dbbackup\/bin\/dmk_rman.ksh -s CDB1 -t bck_arc_no_arc_del_tape.rcv -c \/u01\/app\/odaorabase\/oracle\/admin\/CDB1_SITE1\/etc\/rman.cfg\n\n[OK]::EBL::RMAN::dmk_dbbackup::CDB1::bck_arc_no_arc_del_tape.rcv::RMAN_retCode::0\nLogfile is : \/u01\/app\/odaorabase\/oracle\/admin\/CDB1_SITE1\/log\/CDB1_bck_arc_no_arc_del_tape_20250219_140949.log\n\n\n2025-02-19_14:10:37::check_primary.ksh::CleanExit       ::INFO ==> Program exited with ExitCode : 0\noracle@ODA2:~\/ [CDB1 (CDB$ROOT)]\n<\/pre>\n<\/br>\n\n\n\n
Duplicate CDB1 to CVEEAMT<\/h3>\n\n\n\n
Let’s do our VEEAM RMAN Plug-in test by restoring CDB1 to CVEEAMT using duplicate from backup command.<\/p>\n\n\n\n
The run block will be the following. We will allocate an auxiliary channel using the VEEAM RMAN plug-in library connection that was configured in previous blog.<\/p>\n\n\n\n
\nrun {\nALLOCATE AUXILIARY CHANNEL VeeamAgentChannel1 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=\/opt\/veeam\/VeeamPluginforOracleRMAN\/libOracleRMANPlugin.so' FORMAT 'e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_%I_%d_%T_%U.vab';\nduplicate database CDB1 to CVEEAMT;\n}\n<\/pre>\n<\/br>\n\n\n\n
Check auxiliary database files. We can see there is no OMF datafile directory.<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] ls -lrh \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/\ntotal 168K\ndrwx------ 2 root   root     64K Feb 19 11:38 lost+found\ndrwxr-x--- 2 oracle oinstall 20K Feb 19 13:15 dbs\ndrwxrwx--- 2 oracle oinstall 20K Feb 19 11:51 arc10\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)]\n<\/pre>\n<\/br>\n\n\n\n
Restore the database using the VEEAM backups. We will only use 1 target and 1 auxiliary channel knowing we are running Oracle SE2 edition at customer side:<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] rmanh\n\nRecovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 19 14:13:30 2025\nVersion 19.25.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nRMAN> connect target sys@CDB1_SITE1\nconnect target *\ntarget database Password:\nconnected to target database: CDB1 (DBID=756666048)\n\nRMAN> connect auxiliary sys@CVEEAMT_SITE1\nconnect auxiliary *\nauxiliary database Password:\nconnected to auxiliary database: CVEEAMT (not mounted)\n\nrun {\nrun {\n2> ALLOCATE AUXILIARY CHANNEL VeeamAgentChannel1 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=\/opt\/veeam\/VeeamPluginforOracleRMAN\/libOracleRMANPlugin.so' FORMAT 'e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_%I_%d_%T_%U.vab';\nALLOCATE AUXILIARY CHANNEL VeeamAgentChannel1 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=\/opt\/veeam\/VeeamPluginforOracleRMAN\/libOracleRMANPlugin.so' FORMAT 'e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_%I_%d_%T_%U.vab';\n3> duplicate database CDB1 to CVEEAMT;\nduplicate database CDB1 to CVEEAMT;\n4> }\n}\nusing target database control file instead of recovery catalog\nallocated channel: VeeamAgentChannel1\nchannel VeeamAgentChannel1: SID=16 device type=SBT_TAPE\nchannel VeeamAgentChannel1: Veeam Plug-in for Oracle RMAN\n\nStarting Duplicate Db at 19-FEB-2025 14:15:08\ncurrent log archived\nduplicating Online logs to Oracle Managed File (OMF) location\nduplicating Datafiles to Oracle Managed File (OMF) location\n\ncontents of Memory Script:\n{\n   sql clone \"alter system set  control_files =\n  ''\/u04\/app\/oracle\/redo\/CVEEAMT\/CVEEAMT_SITE1\/controlfile\/o1_mf_mvcf9nor_.ctl'' comment=\n ''Set by RMAN'' scope=spfile\";\n   sql clone \"alter system set  db_name =\n ''CDB1'' comment=\n ''Modified by RMAN duplicate'' scope=spfile\";\n   shutdown clone immediate;\n   startup clone force nomount\n   restore clone primary controlfile;\n   alter clone database mount;\n}\nexecuting Memory Script\n\nsql statement: alter system set  control_files =   ''\/u04\/app\/oracle\/redo\/CVEEAMT\/CVEEAMT_SITE1\/controlfile\/o1_mf_mvcf9nor_.ctl'' comment= ''Set by RMAN'' scope=spfile\n\nsql statement: alter system set  db_name =  ''CDB1'' comment= ''Modified by RMAN duplicate'' scope=spfile\n\nOracle instance shut down\n\nOracle instance started\n\nTotal System Global Area    4294965864 bytes\n\nFixed Size                     9185896 bytes\nVariable Size                855638016 bytes\nDatabase Buffers            3388997632 bytes\nRedo Buffers                  41144320 bytes\nallocated channel: VeeamAgentChannel1\nchannel VeeamAgentChannel1: SID=21 device type=SBT_TAPE\nchannel VeeamAgentChannel1: Veeam Plug-in for Oracle RMAN\n\nStarting restore at 19-FEB-2025 14:15:33\n\nchannel VeeamAgentChannel1: starting datafile backup set restore\nchannel VeeamAgentChannel1: restoring control file\nchannel VeeamAgentChannel1: reading from backup piece c-756666048-20250219-09_RMAN_AUTOBACKUP.vab\nchannel VeeamAgentChannel1: piece handle=c-756666048-20250219-09_RMAN_AUTOBACKUP.vab tag=TAG20250219T141031\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:07\noutput file name=\/u04\/app\/oracle\/redo\/CVEEAMT\/CVEEAMT_SITE1\/controlfile\/o1_mf_mvcf9nor_.ctl\nFinished restore at 19-FEB-2025 14:15:56\n\ndatabase mounted\n\ncontents of Memory Script:\n{\n   set until scn  13117839;\n   set newname for clone datafile  1 to new;\n   set newname for clone datafile  3 to new;\n   set newname for clone datafile  4 to new;\n   set newname for clone datafile  5 to new;\n   set newname for clone datafile  6 to new;\n   set newname for clone datafile  7 to new;\n   set newname for clone datafile  8 to new;\n   set newname for clone datafile  9 to new;\n   set newname for clone datafile  10 to new;\n   set newname for clone datafile  11 to new;\n   set newname for clone datafile  12 to new;\n   set newname for clone datafile  13 to new;\n   set newname for clone datafile  14 to new;\n   set newname for clone datafile  15 to new;\n   set newname for clone datafile  16 to new;\n   set newname for clone datafile  17 to new;\n   set newname for clone datafile  18 to new;\n   set newname for clone datafile  19 to new;\n   set newname for clone datafile  20 to new;\n   set newname for clone datafile  21 to new;\n   set newname for clone datafile  22 to new;\n   set newname for clone datafile  23 to new;\n   set newname for clone datafile  24 to new;\n   set newname for clone datafile  25 to new;\n   set newname for clone datafile  26 to new;\n   set newname for clone datafile  27 to new;\n   set newname for clone datafile  28 to new;\n   set newname for clone datafile  29 to new;\n   set newname for clone datafile  30 to new;\n   set newname for clone datafile  31 to new;\n   set newname for clone datafile  32 to new;\n   set newname for clone datafile  33 to new;\n   set newname for clone datafile  34 to new;\n   set newname for clone datafile  35 to new;\n   set newname for clone datafile  36 to new;\n   set newname for clone datafile  37 to new;\n   restore\n   clone database\n   ;\n}\nexecuting Memory Script\n\nexecuting command: SET until clause\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nStarting restore at 19-FEB-2025 14:16:01\n\nchannel VeeamAgentChannel1: starting datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\nchannel VeeamAgentChannel1: restoring datafile 00005 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_system_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00006 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_sysaux_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00007 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_undotbs1_%u_.dbf\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250204_en3guuba_471_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250204_en3guuba_471_1_1.vab tag=INC0_20250204_133948\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:03\nchannel VeeamAgentChannel1: starting datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\nchannel VeeamAgentChannel1: restoring datafile 00010 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf\nchannel VeeamAgentChannel1: restoring section 1 of 3\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s53hv217_901_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s53hv217_901_1_1.vab tag=INC0_20250216_180002\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:07\nchannel VeeamAgentChannel1: starting datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\nchannel VeeamAgentChannel1: restoring datafile 00010 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf\nchannel VeeamAgentChannel1: restoring section 2 of 3\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s53hv217_901_2_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s53hv217_901_2_1.vab tag=INC0_20250216_180002\nchannel VeeamAgentChannel1: restored backup piece 2\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:07\nchannel VeeamAgentChannel1: starting datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\nchannel VeeamAgentChannel1: restoring datafile 00010 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf\nchannel VeeamAgentChannel1: restoring section 3 of 3\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s53hv217_901_3_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s53hv217_901_3_1.vab tag=INC0_20250216_180002\nchannel VeeamAgentChannel1: restored backup piece 3\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:03\nchannel VeeamAgentChannel1: starting datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\nchannel VeeamAgentChannel1: restoring datafile 00013 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statspac_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00014 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00017 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00020 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_inde_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00023 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_main_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00026 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_queue_ta_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00029 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00032 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00035 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_%u_.dbf\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s83hv262_904_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s83hv262_904_1_1.vab tag=INC0_20250216_180002\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:07\nchannel VeeamAgentChannel1: starting datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\nchannel VeeamAgentChannel1: restoring datafile 00008 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_system_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00015 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00018 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_idm_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00021 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00024 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00027 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00030 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_in_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00033 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00036 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_ind_%u_.dbf\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s93hv2h6_905_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s93hv2h6_905_1_1.vab tag=INC0_20250216_180002\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:07\nchannel VeeamAgentChannel1: starting datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\nchannel VeeamAgentChannel1: restoring datafile 00009 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_sysaux_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00011 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_users_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00016 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00019 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00022 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_inde_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00025 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00028 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading__%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00031 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statisti_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00034 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_uam_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00037 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_user_dat_%u_.dbf\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_sa3hv2pf_906_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_sa3hv2pf_906_1_1.vab tag=INC0_20250216_180002\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:07\nchannel VeeamAgentChannel1: starting datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\nchannel VeeamAgentChannel1: restoring datafile 00001 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_system_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00003 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_sysaux_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00004 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_undotbs1_%u_.dbf\nchannel VeeamAgentChannel1: restoring datafile 00012 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_users_%u_.dbf\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_sb3hv2pu_907_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_sb3hv2pu_907_1_1.vab tag=INC0_20250216_180002\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:07\nFinished restore at 19-FEB-2025 14:16:50\n\ncontents of Memory Script:\n{\n   switch clone datafile all;\n}\nexecuting Memory Script\n\ndatafile 1 switched to datafile copy\ninput datafile copy RECID=40 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_system_mvcpfwvf_.dbf\ndatafile 3 switched to datafile copy\ninput datafile copy RECID=41 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_sysaux_mvcpfwtl_.dbf\ndatafile 4 switched to datafile copy\ninput datafile copy RECID=42 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_undotbs1_mvcpfwt0_.dbf\ndatafile 5 switched to datafile copy\ninput datafile copy RECID=43 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_system_mvcpdmpq_.dbf\ndatafile 6 switched to datafile copy\ninput datafile copy RECID=44 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_sysaux_mvcpdmq3_.dbf\ndatafile 7 switched to datafile copy\ninput datafile copy RECID=45 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_undotbs1_mvcpdmqj_.dbf\ndatafile 8 switched to datafile copy\ninput datafile copy RECID=46 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_system_mvcpfhf3_.dbf\ndatafile 9 switched to datafile copy\ninput datafile copy RECID=47 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_sysaux_mvcpfppo_.dbf\ndatafile 10 switched to datafile copy\ninput datafile copy RECID=48 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf\ndatafile 11 switched to datafile copy\ninput datafile copy RECID=49 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_users_mvcpfpz5_.dbf\ndatafile 12 switched to datafile copy\ninput datafile copy RECID=50 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_users_mvcpfwvt_.dbf\ndatafile 13 switched to datafile copy\ninput datafile copy RECID=51 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statspac_mvcpf8jp_.dbf\ndatafile 14 switched to datafile copy\ninput datafile copy RECID=52 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__mvcpf7lt_.dbf\ndatafile 15 switched to datafile copy\ninput datafile copy RECID=53 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__mvcpfgl2_.dbf\ndatafile 16 switched to datafile copy\ninput datafile copy RECID=54 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_mvcpfost_.dbf\ndatafile 17 switched to datafile copy\ninput datafile copy RECID=55 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_mvcpf7m4_.dbf\ndatafile 18 switched to datafile copy\ninput datafile copy RECID=56 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_idm_mvcpfgls_.dbf\ndatafile 19 switched to datafile copy\ninput datafile copy RECID=57 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_mvcpfotj_.dbf\ndatafile 20 switched to datafile copy\ninput datafile copy RECID=58 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_inde_mvcpf7mq_.dbf\ndatafile 21 switched to datafile copy\ninput datafile copy RECID=59 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_mvcpfgmd_.dbf\ndatafile 22 switched to datafile copy\ninput datafile copy RECID=60 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_inde_mvcpfov5_.dbf\ndatafile 23 switched to datafile copy\ninput datafile copy RECID=61 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_main_mvcpf7nb_.dbf\ndatafile 24 switched to datafile copy\ninput datafile copy RECID=62 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_mvcpfgmz_.dbf\ndatafile 25 switched to datafile copy\ninput datafile copy RECID=63 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_mvcpfovr_.dbf\ndatafile 26 switched to datafile copy\ninput datafile copy RECID=64 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_queue_ta_mvcpf7nx_.dbf\ndatafile 27 switched to datafile copy\ninput datafile copy RECID=65 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading_mvcpfgnp_.dbf\ndatafile 28 switched to datafile copy\ninput datafile copy RECID=66 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading__mvcpfowc_.dbf\ndatafile 29 switched to datafile copy\ninput datafile copy RECID=67 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_mvcpf7oj_.dbf\ndatafile 30 switched to datafile copy\ninput datafile copy RECID=68 STAMP=1193494610 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_in_mvcpfgo9_.dbf\ndatafile 31 switched to datafile copy\ninput datafile copy RECID=69 STAMP=1193494611 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statisti_mvcpfowx_.dbf\ndatafile 32 switched to datafile copy\ninput datafile copy RECID=70 STAMP=1193494611 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpf7p2_.dbf\ndatafile 33 switched to datafile copy\ninput datafile copy RECID=71 STAMP=1193494611 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpfgow_.dbf\ndatafile 34 switched to datafile copy\ninput datafile copy RECID=72 STAMP=1193494611 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_uam_mvcpfoxh_.dbf\ndatafile 35 switched to datafile copy\ninput datafile copy RECID=73 STAMP=1193494611 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_mvcpf7pp_.dbf\ndatafile 36 switched to datafile copy\ninput datafile copy RECID=74 STAMP=1193494611 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_ind_mvcpfgph_.dbf\ndatafile 37 switched to datafile copy\ninput datafile copy RECID=75 STAMP=1193494611 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_user_dat_mvcpfoy2_.dbf\n\ncontents of Memory Script:\n{\n   set until scn  13117839;\n   recover\n   clone database\n    delete archivelog\n   ;\n}\nexecuting Memory Script\n\nexecuting command: SET until clause\n\nStarting recover at 19-FEB-2025 14:16:51\nchannel VeeamAgentChannel1: starting incremental datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\ndestination for restore of datafile 00010: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf\nchannel VeeamAgentChannel1: restoring section 1 of 3\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_u93i4ap9_969_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_u93i4ap9_969_1_1.vab tag=INC1_20250218_180002\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:03\nchannel VeeamAgentChannel1: starting incremental datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\ndestination for restore of datafile 00010: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf\nchannel VeeamAgentChannel1: restoring section 2 of 3\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_u93i4ap9_969_2_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_u93i4ap9_969_2_1.vab tag=INC1_20250218_180002\nchannel VeeamAgentChannel1: restored backup piece 2\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:03\nchannel VeeamAgentChannel1: starting incremental datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\ndestination for restore of datafile 00010: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf\nchannel VeeamAgentChannel1: restoring section 3 of 3\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_u93i4ap9_969_3_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_u93i4ap9_969_3_1.vab tag=INC1_20250218_180002\nchannel VeeamAgentChannel1: restored backup piece 3\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:03\nchannel VeeamAgentChannel1: starting incremental datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\ndestination for restore of datafile 00013: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statspac_mvcpf8jp_.dbf\ndestination for restore of datafile 00014: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__mvcpf7lt_.dbf\ndestination for restore of datafile 00017: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_mvcpf7m4_.dbf\ndestination for restore of datafile 00020: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_inde_mvcpf7mq_.dbf\ndestination for restore of datafile 00023: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_main_mvcpf7nb_.dbf\ndestination for restore of datafile 00026: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_queue_ta_mvcpf7nx_.dbf\ndestination for restore of datafile 00029: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_mvcpf7oj_.dbf\ndestination for restore of datafile 00032: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpf7p2_.dbf\ndestination for restore of datafile 00035: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_mvcpf7pp_.dbf\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_uc3i4aqd_972_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_uc3i4aqd_972_1_1.vab tag=INC1_20250218_180002\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:03\nchannel VeeamAgentChannel1: starting incremental datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\ndestination for restore of datafile 00008: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_system_mvcpfhf3_.dbf\ndestination for restore of datafile 00015: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__mvcpfgl2_.dbf\ndestination for restore of datafile 00018: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_idm_mvcpfgls_.dbf\ndestination for restore of datafile 00021: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_mvcpfgmd_.dbf\ndestination for restore of datafile 00024: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_mvcpfgmz_.dbf\ndestination for restore of datafile 00027: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading_mvcpfgnp_.dbf\ndestination for restore of datafile 00030: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_in_mvcpfgo9_.dbf\ndestination for restore of datafile 00033: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpfgow_.dbf\ndestination for restore of datafile 00036: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_ind_mvcpfgph_.dbf\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_ud3i4aqk_973_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_ud3i4aqk_973_1_1.vab tag=INC1_20250218_180002\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:03\nchannel VeeamAgentChannel1: starting incremental datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\ndestination for restore of datafile 00009: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_sysaux_mvcpfppo_.dbf\ndestination for restore of datafile 00011: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_users_mvcpfpz5_.dbf\ndestination for restore of datafile 00016: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_mvcpfost_.dbf\ndestination for restore of datafile 00019: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_mvcpfotj_.dbf\ndestination for restore of datafile 00022: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_inde_mvcpfov5_.dbf\ndestination for restore of datafile 00025: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_mvcpfovr_.dbf\ndestination for restore of datafile 00028: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading__mvcpfowc_.dbf\ndestination for restore of datafile 00031: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statisti_mvcpfowx_.dbf\ndestination for restore of datafile 00034: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_uam_mvcpfoxh_.dbf\ndestination for restore of datafile 00037: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_user_dat_mvcpfoy2_.dbf\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_ue3i4aqr_974_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_ue3i4aqr_974_1_1.vab tag=INC1_20250218_180002\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:03\nchannel VeeamAgentChannel1: starting incremental datafile backup set restore\nchannel VeeamAgentChannel1: specifying datafile(s) to restore from backup set\ndestination for restore of datafile 00001: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_system_mvcpfwvf_.dbf\ndestination for restore of datafile 00003: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_sysaux_mvcpfwtl_.dbf\ndestination for restore of datafile 00004: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_undotbs1_mvcpfwt0_.dbf\ndestination for restore of datafile 00012: \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_users_mvcpfwvt_.dbf\nchannel VeeamAgentChannel1: reading from backup piece e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_uf3i4ar2_975_1_1.vab\nchannel VeeamAgentChannel1: piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_uf3i4ar2_975_1_1.vab tag=INC1_20250218_180002\nchannel VeeamAgentChannel1: restored backup piece 1\nchannel VeeamAgentChannel1: restore complete, elapsed time: 00:00:03\n\nstarting media recovery\n\narchived log for thread 1 with sequence 236 is already on disk as file \/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_18\/o1_mf_1_236_mv9h6t7z_.arc\narchived log for thread 1 with sequence 237 is already on disk as file \/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_18\/o1_mf_1_237_mv9rjr7s_.arc\narchived log for thread 1 with sequence 238 is already on disk as file \/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_238_mvb6lr1f_.arc\narchived log for thread 1 with sequence 239 is already on disk as file \/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_239_mvbnnqvg_.arc\narchived log for thread 1 with sequence 240 is already on disk as file \/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_240_mvc2pr6m_.arc\narchived log for thread 1 with sequence 241 is already on disk as file \/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_241_mvcjrr7v_.arc\narchived log for thread 1 with sequence 242 is already on disk as file \/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_242_mvcp13py_.arc\narchived log for thread 1 with sequence 243 is already on disk as file \/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_243_mvcpbw6z_.arc\narchived log file name=\/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_18\/o1_mf_1_236_mv9h6t7z_.arc thread=1 sequence=236\narchived log file name=\/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_18\/o1_mf_1_237_mv9rjr7s_.arc thread=1 sequence=237\narchived log file name=\/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_238_mvb6lr1f_.arc thread=1 sequence=238\narchived log file name=\/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_239_mvbnnqvg_.arc thread=1 sequence=239\narchived log file name=\/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_240_mvc2pr6m_.arc thread=1 sequence=240\narchived log file name=\/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_241_mvcjrr7v_.arc thread=1 sequence=241\narchived log file name=\/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_242_mvcp13py_.arc thread=1 sequence=242\narchived log file name=\/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_19\/o1_mf_1_243_mvcpbw6z_.arc thread=1 sequence=243\nmedia recovery complete, elapsed time: 00:00:03\nFinished recover at 19-FEB-2025 14:17:17\nreleased channel: VeeamAgentChannel1\nOracle instance started\n\nTotal System Global Area    4294965864 bytes\n\nFixed Size                     9185896 bytes\nVariable Size                855638016 bytes\nDatabase Buffers            3388997632 bytes\nRedo Buffers                  41144320 bytes\n\ncontents of Memory Script:\n{\n   sql clone \"alter system set  db_name =\n ''CVEEAMT'' comment=\n ''Reset to original value by RMAN'' scope=spfile\";\n}\nexecuting Memory Script\n\nsql statement: alter system set  db_name =  ''CVEEAMT'' comment= ''Reset to original value by RMAN'' scope=spfile\nOracle instance started\n\nTotal System Global Area    4294965864 bytes\n\nFixed Size                     9185896 bytes\nVariable Size                855638016 bytes\nDatabase Buffers            3388997632 bytes\nRedo Buffers                  41144320 bytes\nsql statement: CREATE CONTROLFILE REUSE SET DATABASE \"CVEEAMT\" RESETLOGS ARCHIVELOG\n  MAXLOGFILES     16\n  MAXLOGMEMBERS      3\n  MAXDATAFILES     1024\n  MAXINSTANCES     8\n  MAXLOGHISTORY      292\n LOGFILE\n  GROUP     1  SIZE 512 M ,\n  GROUP     2  SIZE 512 M ,\n  GROUP     3  SIZE 512 M\n DATAFILE\n  '\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_system_mvcpfwvf_.dbf',\n  '\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_system_mvcpdmpq_.dbf',\n  '\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_system_mvcpfhf3_.dbf'\n CHARACTER SET AL32UTF8\n\n\ncontents of Memory Script:\n{\n   set newname for clone tempfile  1 to new;\n   set newname for clone tempfile  2 to new;\n   set newname for clone tempfile  3 to new;\n   switch clone tempfile all;\n   catalog clone datafilecopy  \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_sysaux_mvcpfwtl_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_undotbs1_mvcpfwt0_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_sysaux_mvcpdmq3_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_undotbs1_mvcpdmqj_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_sysaux_mvcpfppo_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_users_mvcpfpz5_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_users_mvcpfwvt_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statspac_mvcpf8jp_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__mvcpf7lt_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__mvcpfgl2_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_mvcpfost_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_mvcpf7m4_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_idm_mvcpfgls_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_mvcpfotj_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_inde_mvcpf7mq_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_mvcpfgmd_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_inde_mvcpfov5_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_main_mvcpf7nb_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_mvcpfgmz_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_mvcpfovr_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_queue_ta_mvcpf7nx_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading_mvcpfgnp_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading__mvcpfowc_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_mvcpf7oj_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_in_mvcpfgo9_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statisti_mvcpfowx_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpf7p2_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpfgow_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_uam_mvcpfoxh_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_mvcpf7pp_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_ind_mvcpfgph_.dbf\",\n \"\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_user_dat_mvcpfoy2_.dbf\";\n   switch clone datafile all;\n}\nexecuting Memory Script\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nexecuting command: SET NEWNAME\n\nrenamed tempfile 1 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_temp_%u_.tmp in control file\nrenamed tempfile 2 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_temp_%u_.tmp in control file\nrenamed tempfile 3 to \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temp_%u_.tmp in control file\n\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_sysaux_mvcpfwtl_.dbf RECID=1 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_undotbs1_mvcpfwt0_.dbf RECID=2 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_sysaux_mvcpdmq3_.dbf RECID=3 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_undotbs1_mvcpdmqj_.dbf RECID=4 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_sysaux_mvcpfppo_.dbf RECID=5 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf RECID=6 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_users_mvcpfpz5_.dbf RECID=7 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_users_mvcpfwvt_.dbf RECID=8 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statspac_mvcpf8jp_.dbf RECID=9 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__mvcpf7lt_.dbf RECID=10 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__mvcpfgl2_.dbf RECID=11 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_mvcpfost_.dbf RECID=12 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_mvcpf7m4_.dbf RECID=13 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_idm_mvcpfgls_.dbf RECID=14 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_mvcpfotj_.dbf RECID=15 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_inde_mvcpf7mq_.dbf RECID=16 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_mvcpfgmd_.dbf RECID=17 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_inde_mvcpfov5_.dbf RECID=18 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_main_mvcpf7nb_.dbf RECID=19 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_mvcpfgmz_.dbf RECID=20 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_mvcpfovr_.dbf RECID=21 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_queue_ta_mvcpf7nx_.dbf RECID=22 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading_mvcpfgnp_.dbf RECID=23 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading__mvcpfowc_.dbf RECID=24 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_mvcpf7oj_.dbf RECID=25 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_in_mvcpfgo9_.dbf RECID=26 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statisti_mvcpfowx_.dbf RECID=27 STAMP=1193494661\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpf7p2_.dbf RECID=28 STAMP=1193494662\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpfgow_.dbf RECID=29 STAMP=1193494662\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_uam_mvcpfoxh_.dbf RECID=30 STAMP=1193494662\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_mvcpf7pp_.dbf RECID=31 STAMP=1193494662\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_ind_mvcpfgph_.dbf RECID=32 STAMP=1193494662\ncataloged datafile copy\ndatafile copy file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_user_dat_mvcpfoy2_.dbf RECID=33 STAMP=1193494662\n\ndatafile 3 switched to datafile copy\ninput datafile copy RECID=1 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_sysaux_mvcpfwtl_.dbf\ndatafile 4 switched to datafile copy\ninput datafile copy RECID=2 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_undotbs1_mvcpfwt0_.dbf\ndatafile 6 switched to datafile copy\ninput datafile copy RECID=3 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_sysaux_mvcpdmq3_.dbf\ndatafile 7 switched to datafile copy\ninput datafile copy RECID=4 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987BF93B6232B35E063425C210AC02A\/datafile\/o1_mf_undotbs1_mvcpdmqj_.dbf\ndatafile 9 switched to datafile copy\ninput datafile copy RECID=5 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_sysaux_mvcpfppo_.dbf\ndatafile 10 switched to datafile copy\ninput datafile copy RECID=6 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf\ndatafile 11 switched to datafile copy\ninput datafile copy RECID=7 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_users_mvcpfpz5_.dbf\ndatafile 12 switched to datafile copy\ninput datafile copy RECID=8 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_users_mvcpfwvt_.dbf\ndatafile 13 switched to datafile copy\ninput datafile copy RECID=9 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statspac_mvcpf8jp_.dbf\ndatafile 14 switched to datafile copy\ninput datafile copy RECID=10 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__mvcpf7lt_.dbf\ndatafile 15 switched to datafile copy\ninput datafile copy RECID=11 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_ami_hub__mvcpfgl2_.dbf\ndatafile 16 switched to datafile copy\ninput datafile copy RECID=12 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_mvcpfost_.dbf\ndatafile 17 switched to datafile copy\ninput datafile copy RECID=13 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_base_sys_mvcpf7m4_.dbf\ndatafile 18 switched to datafile copy\ninput datafile copy RECID=14 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_idm_mvcpfgls_.dbf\ndatafile 19 switched to datafile copy\ninput datafile copy RECID=15 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_mvcpfotj_.dbf\ndatafile 20 switched to datafile copy\ninput datafile copy RECID=16 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_inde_mvcpf7mq_.dbf\ndatafile 21 switched to datafile copy\ninput datafile copy RECID=17 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_mvcpfgmd_.dbf\ndatafile 22 switched to datafile copy\ninput datafile copy RECID=18 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_inde_mvcpfov5_.dbf\ndatafile 23 switched to datafile copy\ninput datafile copy RECID=19 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_main_mvcpf7nb_.dbf\ndatafile 24 switched to datafile copy\ninput datafile copy RECID=20 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_mvcpfgmz_.dbf\ndatafile 25 switched to datafile copy\ninput datafile copy RECID=21 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_md_readi_mvcpfovr_.dbf\ndatafile 26 switched to datafile copy\ninput datafile copy RECID=22 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_queue_ta_mvcpf7nx_.dbf\ndatafile 27 switched to datafile copy\ninput datafile copy RECID=23 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading_mvcpfgnp_.dbf\ndatafile 28 switched to datafile copy\ninput datafile copy RECID=24 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_reading__mvcpfowc_.dbf\ndatafile 29 switched to datafile copy\ninput datafile copy RECID=25 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_mvcpf7oj_.dbf\ndatafile 30 switched to datafile copy\ninput datafile copy RECID=26 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_in_mvcpfgo9_.dbf\ndatafile 31 switched to datafile copy\ninput datafile copy RECID=27 STAMP=1193494661 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statisti_mvcpfowx_.dbf\ndatafile 32 switched to datafile copy\ninput datafile copy RECID=28 STAMP=1193494662 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpf7p2_.dbf\ndatafile 33 switched to datafile copy\ninput datafile copy RECID=29 STAMP=1193494662 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpfgow_.dbf\ndatafile 34 switched to datafile copy\ninput datafile copy RECID=30 STAMP=1193494662 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_uam_mvcpfoxh_.dbf\ndatafile 35 switched to datafile copy\ninput datafile copy RECID=31 STAMP=1193494662 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_mvcpf7pp_.dbf\ndatafile 36 switched to datafile copy\ninput datafile copy RECID=32 STAMP=1193494662 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_unit_ind_mvcpfgph_.dbf\ndatafile 37 switched to datafile copy\ninput datafile copy RECID=33 STAMP=1193494662 file name=\/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_user_dat_mvcpfoy2_.dbf\nReenabling controlfile options for auxiliary database\nExecuting: alter database force logging\n\ncontents of Memory Script:\n{\n   Alter clone database open resetlogs;\n}\nexecuting Memory Script\n\ndatabase opened\n\ncontents of Memory Script:\n{\n   sql clone \"alter pluggable database all open\";\n}\nexecuting Memory Script\n\nsql statement: alter pluggable database all open\nFinished Duplicate Db at 19-FEB-2025 14:17:48\n<\/pre>\n<\/br>\n\n\n\n
We can see that RMAN used INC0 VEEAM backups:<\/p>\n\n\n\n
piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250204_en3guuba_471_1_1.vab tag=INC0_20250204_133948\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s53hv217_901_1_1.vab tag=INC0_20250216_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s53hv217_901_2_1.vab tag=INC0_20250216_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s53hv217_901_3_1.vab tag=INC0_20250216_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s83hv262_904_1_1.vab tag=INC0_20250216_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_s93hv2h6_905_1_1.vab tag=INC0_20250216_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_sa3hv2pf_906_1_1.vab tag=INC0_20250216_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250216_sb3hv2pu_907_1_1.vab tag=INC0_20250216_180002<\/code><\/pre>\n\n\n\n
We can see that RMAN used INC1 VEEAM backups:<\/p>\n\n\n\n
piece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_u93i4ap9_969_1_1.vab tag=INC1_20250218_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_u93i4ap9_969_2_1.vab tag=INC1_20250218_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_u93i4ap9_969_3_1.vab tag=INC1_20250218_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_uc3i4aqd_972_1_1.vab tag=INC1_20250218_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_ud3i4aqk_973_1_1.vab tag=INC1_20250218_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_ue3i4aqr_974_1_1.vab tag=INC1_20250218_180002\n\npiece handle=e718bc55-0c60-43bc-b1f7-f8cf2c793120\/RMAN_756666048_CDB1_20250218_uf3i4ar2_975_1_1.vab tag=INC1_20250218_180002<\/code><\/pre>\n\n\n\n
RMAN duplicate did not used any of the archived log backup as archived log file was still existing in the FRA, which is ok for our tests, see media recovery message like:<\/p>\n\n\n\n
archived log for thread 1 with sequence 236 is already on disk as file \/u03\/app\/oracle\/fast_recovery_area\/CDB1_SITE1\/archivelog\/2025_02_18\/o1_mf_1_236_mv9h6t7z_.arc<\/code><\/pre>\n\n\n\n
RMAN duplicated played all archived log files as we did not specified any until_scn or until_time clause.<\/p>\n\n\n\n
Checks<\/h3>\n\n\n\n
We have 2 PDB1 pdb one for each CDB on appropriate domain registered to the listener:<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] lsnrctl status | grep -iE veeam\\|pdb1\n  Instance \"CDB1\", status READY, has 1 handler(s) for this service...\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"CDB1XDB.domain.ch\" has 1 instance(s).\n  Instance \"CDB1\", status READY, has 1 handler(s) for this service...\nService \"CDB1_SITE1.domain.ch\" has 1 instance(s).\n  Instance \"CDB1\", status READY, has 1 handler(s) for this service...\nService \"CVEEAMTXDB.test.ch\" has 1 instance(s).\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"CVEEAMT_SITE1.test.ch\" has 2 instance(s).\n  Instance \"CVEEAMT\", status UNKNOWN, has 1 handler(s) for this service...\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\nService \"PDB1_PRI.domain.ch\" has 1 instance(s).\n  Instance \"CDB1\", status READY, has 1 handler(s) for this service...\nService \"pdb1.domain.ch\" has 1 instance(s).\n  Instance \"CDB1\", status READY, has 1 handler(s) for this service...\nService \"pdb1.test.ch\" has 1 instance(s).\n  Instance \"CVEEAMT\", status READY, has 1 handler(s) for this service...\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)]\n<\/pre>\n<\/br>\n\n\n\n
Check target container database CDB1:<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CDB1 (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 19 14:46:06 2025\nVersion 19.25.0.0.0\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production\nVersion 19.25.0.0.0\n\nSQL> show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1                           READ WRITE NO\n\nSQL> select instance_name from v$instance;\n\nINSTANCE_NAME\n----------------\nCDB1\n\nSQL> set line 300\nSQL> col name for a20\nSQL> select NAME, GUID, total_size\/1024\/1024\/1024 GB from v$pdbs;\n\nNAME                 GUID                                     GB\n-------------------- -------------------------------- ----------\nPDB$SEED             2987BF93B6232B35E063425C210AC02A 1.09960938\nPDB1                 2987D4B68CF25579E063425C210AB61B 46.3935547\n\nSQL>\n<\/pre>\n<\/br>\n\n\n\n
Check auxiliary container database CVEEAMT. We will check PDB1, that our TEST1 table exists, and also database files:<\/p>\n\n\n\n
\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] CVEEAMT\n\n ******************************************************\n INSTANCE_NAME   : CVEEAMT\n DB_NAME         : CVEEAMT\n DB_UNIQUE_NAME  : CVEEAMT_SITE1\n STATUS          : OPEN READ WRITE\n LOG_MODE        : ARCHIVELOG\n USERS\/SESSIONS  : Normal: 0\/0, Oracle-maintained: 2\/7\n DATABASE_ROLE   : PRIMARY\n FLASHBACK_ON    : NO\n FORCE_LOGGING   : YES\n VERSION         : 19.25.0.0.0\n NLS_LANG        : AMERICAN_AMERICA.AL32UTF8\n CDB_ENABLED     : YES\n PDBs            : PDB1  PDB$SEED\n ******************************************************\n\n PDB color: pdbname=open read-write, pdbname=open read-only\n Statustime: 2025-02-19 14:42:03\n\noracle@ODA2:~\/ [CVEEAMT (CDB$ROOT)] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 19 14:42:05 2025\nVersion 19.25.0.0.0\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production\nVersion 19.25.0.0.0\n\nSQL> show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1                           READ WRITE NO\n\nSQL> alter session set container=PDB1;\n\nSession altered.\n\nSQL> select count(*) from test1;\n\n  COUNT(*)\n----------\n        51\n\nSQL> select instance_name from v$instance;\n\nINSTANCE_NAME\n----------------\nCVEEAMT\n\nSQL> @qdbstbssize.sql\n\nContainer                          Nb      Extent Segment     Alloc.      Space       Max.    Percent Block\nname            Name            files Type Mgmnt  Mgmnt    size (GB)  free (GB)  size (GB)     used % size  Log Encrypt Compress\n--------------- --------------- ----- ---- ------ ------- ---------- ---------- ---------- ---------- ----- --- ------- --------\nPDB1            XXX_XXX_INDEXES     1 DATA LM-SYS AUTO          1.00        .90      10.00       1.00 8 KB  YES NO      NO\n                XXX_XXX_TABLES      1 DATA LM-SYS AUTO          1.00        .91      10.00        .95 8 KB  YES NO      NO\n                XXXX_SYSTEM         1 DATA LM-SYS AUTO          1.00        .70      10.00       3.01 8 KB  YES NO      NO\n                XXXX_SYSTEM_IND     1 DATA LM-SYS AUTO          1.00        .86      10.00       1.36 8 KB  YES NO      NO\n                EXES\n\n                IDM                 1 DATA LM-SYS AUTO          1.00        .85      10.00       1.53 8 KB  YES NO      NO\n                JOB                 1 DATA LM-SYS AUTO          1.00        .92      10.00        .83 8 KB  YES NO      NO\n                JOB_INDEXES         1 DATA LM-SYS AUTO          1.00        .92      10.00        .83 8 KB  YES NO      NO\n                LOG                 1 DATA LM-SYS AUTO          1.00        .88      10.00       1.24 8 KB  YES NO      NO\n                LOG_INDEXES         1 DATA LM-SYS AUTO          1.00        .86      10.00       1.41 8 KB  YES NO      NO\n                MAIN                1 DATA LM-SYS AUTO          1.00        .93      10.00        .74 8 KB  YES NO      NO\n                XX_XXXXXXX          1 DATA LM-SYS AUTO          1.00        .92      10.00        .78 8 KB  YES NO      NO\n                XX_XX_XXXXXXX_INDE     1 DATA LM-SYS AUTO          1.00        .92      10.00        .80 8 KB  YES NO      NO\n                XES\n\n                QUEUE_TABLES        1 DATA LM-SYS AUTO          1.00        .93      10.00        .75 8 KB  YES NO      NO\n                XXXXXXX             1 DATA LM-SYS AUTO          1.00        .84      10.00       1.61 8 KB  YES NO      NO\n                XXXXXXX_INDEXES     1 DATA LM-SYS AUTO          1.00        .88      10.00       1.20 8 KB  YES NO      NO\n                SETUP               1 DATA LM-SYS AUTO          1.00        .91      10.00        .93 8 KB  YES NO      NO\n                SETUP_INDEXES       1 DATA LM-SYS AUTO          1.00        .91      10.00        .88 8 KB  YES NO      NO\n                STATISTIC           1 DATA LM-SYS AUTO          1.00        .71      10.00       2.85 8 KB  YES NO      NO\n                STATSPACK           1 DATA LM-SYS AUTO           .98        .13       2.00      42.32 8 KB  YES NO      NO\n                SYSAUX              1 DATA LM-SYS AUTO           .58        .04      10.00       5.32 8 KB  YES NO      NO\n                SYSTEM              1 DATA LM-SYS MANUAL         .62        .05       4.00      14.21 8 KB  YES NO      NO\n                TEMP                1 TEMP LM-UNI MANUAL         .22        .66      31.00      -1.40 8 KB  NO  NO      NO\n                TEMPORARY_DATA      1 DATA LM-SYS AUTO          1.00        .93      10.00        .67 8 KB  YES NO      NO\n                TEMPORARY_DATA_     1 DATA LM-SYS AUTO          1.00        .93      10.00        .66 8 KB  YES NO      NO\n                INDEXES\n\n                XXX                 1 DATA LM-SYS AUTO          1.00        .93      10.00        .68 8 KB  YES NO      NO\n                UNDOTBS1            1 UNDO LM-SYS MANUAL       20.00      19.97      20.00        .13 8 KB  YES NO      NO\n                XXXX                1 DATA LM-SYS AUTO          1.00        .92      10.00        .82 8 KB  YES NO      NO\n                XXXX_INDEXES        1 DATA LM-SYS AUTO          1.00        .91      10.00        .94 8 KB  YES NO      NO\n                USERS               1 DATA LM-SYS AUTO           .00        .00       2.00        .05 8 KB  YES NO      NO\n                USER_DATA           1 DATA LM-SYS AUTO          1.00        .93      10.00        .66 8 KB  YES NO      NO\n***************                 -----                     ---------- ---------- ----------\nTOTAL                              30                          46.39      42.14     309.00\n\nSQL> alter session set container=cdb$root;\n\nSession altered.\n\nSQL> set lines 300\nSQL> col name for a20\nSQL> select NAME, GUID, total_size\/1024\/1024\/1024 GB from v$pdbs;\n\nNAME                 GUID                                     GB\n-------------------- -------------------------------- ----------\nPDB$SEED             2987BF93B6232B35E063425C210AC02A 1.09960938\nPDB1                 2987D4B68CF25579E063425C210AB61B 46.3935547\n\n2 rows selected.\n\nSQL> set lines 300 pages 500\nSQL> col file_name for a150\nSQL> select instance_name from v$instance;\n\nINSTANCE_NAME\n----------------\nCVEEAMT\n\nSQL> show pdbs\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 PDB1                           READ WRITE NO\n\nSQL> select con_id, file_name from cdb_data_files;\n\n    CON_ID FILE_NAME\n---------- ------------------------------------------------------------------------------------------------------------------------------------------------------\n         1 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_system_mvcpfwvf_.dbf\n         1 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_sysaux_mvcpfwtl_.dbf\n         1 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_undotbs1_mvcpfwt0_.dbf\n         1 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/datafile\/o1_mf_users_mvcpfwvt_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_system_mvcpfhf3_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_sysaux_mvcpfppo_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_undotbs1_mvcpdoc3_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_users_mvcpfpz5_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statspac_mvcpf8jp_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxx_xxx__mvcpf7lt_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxx_xxx__mvcpfgl2_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxxx_sys_mvcpfost_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxxx_sys_mvcpf7m4_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxx_mvcpfgls_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_mvcpfotj_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_job_inde_mvcpf7mq_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_mvcpfgmd_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_log_inde_mvcpfov5_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxxx_mvcpf7nb_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xx_xxxxx_mvcpfgmz_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xx_xxxxx_mvcpfgmz_mvcpfovr_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_queue_ta_mvcpf7nx_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxxxxxx_mvcpfgnp_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxxxxxx__mvcpfowc_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_mvcpf7oj_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_setup_in_mvcpfgo9_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_statisti_mvcpfowx_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpf7p2_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_temporar_mvcpfgow_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxx_mvcpfoxh_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxxx_mvcpf7pp_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_xxxx_ind_mvcpfgph_.dbf\n         3 \/u02\/app\/oracle\/oradata\/CVEEAMT_SITE1\/CVEEAMT_SITE1\/2987D4B68CF25579E063425C210AB61B\/datafile\/o1_mf_user_dat_mvcpfoy2_.dbf\n\n33 rows selected.\n\nSQL>\n<\/pre>\n<\/br>\n\n\n\n
As we can see, the restore from CDB1 into CVEEAMT with RMAN duplicate command using VEEAM backups could be done successfully.<\/p>\n\n\n\n
Cleanup<\/h3>\n\n\n\n
Let’s cleanup by deleting CVEEAMT database.<\/p>\n\n\n\n
\n[root@ODA2 ~]# odacli delete-database -n CVEEAMT\n{\n  \"jobId\" : \"565aa4e3-9152-45f8-a739-dd7c53b22044\",\n  \"status\" : \"Running\",\n  \"message\" : \"\",\n  \"reports\" : [ {\n    \"taskId\" : \"TaskDcsJsonRpcExt_14309\",\n    \"taskName\" : \"Validate DB 96122ad1-182a-4059-8a26-677300d93d71 for deletion\",\n    \"nodeName\" : \"ODA2\",\n    \"taskResult\" : \"\",\n    \"startTime\" : \"February 19, 2025 14:55:01 CET\",\n    \"endTime\" : null,\n    \"duration\" : \"00:00:00.10\",\n    \"status\" : \"Running\",\n    \"taskDescription\" : null,\n    \"parentTaskId\" : \"TaskSequential_14307\",\n    \"jobId\" : \"565aa4e3-9152-45f8-a739-dd7c53b22044\",\n    \"tags\" : [ ],\n    \"reportLevel\" : \"Info\",\n    \"updatedTime\" : \"February 19, 2025 14:55:01 CET\"\n  } ],\n  \"createTimestamp\" : \"February 19, 2025 14:54:59 CET\",\n  \"resourceList\" : [ ],\n  \"description\" : \"Database service deletion with DB name: CVEEAMT with ID : 96122ad1-182a-4059-8a26-677300d93d71\",\n  \"updatedTime\" : \"February 19, 2025 14:55:01 CET\",\n  \"jobType\" : null,\n  \"cpsMetadata\" : null\n}\n\n[root@ODA2 ~]# odacli describe-job -i \"565aa4e3-9152-45f8-a739-dd7c53b22044\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  565aa4e3-9152-45f8-a739-dd7c53b22044\n            Description:  Database service deletion with DB name: CVEEAMT with ID : 96122ad1-182a-4059-8a26-677300d93d71\n                 Status:  Success\n                Created:  February 19, 2025 14:54:59 CET\n                Message:\n\nTask Name                                Start Time                               End Time                                 Status\n---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------\nValidate DB                              February 19, 2025 14:55:01 CET           February 19, 2025 14:55:01 CET           Success\n96122ad1-182a-4059-8a26-677300d93d71\nfor deletion\nDeleting the RMAN logs                   February 19, 2025 14:55:01 CET           February 19, 2025 14:55:01 CET           Success\nDatabase Deletion By RHP                 February 19, 2025 14:55:01 CET           February 19, 2025 14:56:07 CET           Success\nUnregister DB From Cluster               February 19, 2025 14:56:07 CET           February 19, 2025 14:56:08 CET           Success\nKill PMON Process                        February 19, 2025 14:56:08 CET           February 19, 2025 14:56:08 CET           Success\nDatabase Files Deletion                  February 19, 2025 14:56:08 CET           February 19, 2025 14:56:08 CET           Success\nDeleting Volume                          February 19, 2025 14:56:13 CET           February 19, 2025 14:56:17 CET           Success\nDeleting Volume                          February 19, 2025 14:56:23 CET           February 19, 2025 14:56:26 CET           Success\n<\/pre>\n<\/br>\n\n\n\n
We would also restore initial listener.ora configuration file. As you might see, there is job in the appliance that already regularly restore initial listener configuration file.<\/p>\n\n\n\n
We would also delete our TEST1 table we created in the production PDB1.<\/p>\n\n\n\n
To wrap up…<\/h3>\n\n\n\n
We could successfully restore CDB1 into CVEEAMT with RMAN duplicate command using VEEAM backups. This validates our VEEAM RMAN plug-in previous configuration and also any backup done with the VEEAM RMAN plug-in.<\/p>\n","protected":false},"excerpt":{"rendered":"
I recently wrote a blog to show how to configure Veeam RMAN plug-in to take database backups. As all DBA knows, configuring a backup, will not go without testing a restore. In this blog I will show how I tested my previous Veeam configuration and backups performed with this Veeam RMAN plug-in on the same […]<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[280,96,854,577],"type_dbi":[],"class_list":["post-38083","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-database","tag-oracle","tag-restore","tag-veeam"],"acf":[],"yoast_head":"\nRestore a database using Veeam RMAN plug-in on an ODA - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Restore a database using Veeam RMAN plug-in on an ODA\" \/>\n<meta property=\"og:description\" content=\"I recently wrote a blog to show how to configure Veeam RMAN plug-in to take database backups. As all DBA knows, configuring a backup, will not go without testing a restore. In this blog I will show how I tested my previous Veeam configuration and backups performed with this Veeam RMAN plug-in on the same […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-22T21:07:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-22T21:07:21+00:00\" \/>\n<meta name=\"author\" content=\"Marc Wagner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc Wagner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\\\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"Restore a database using Veeam RMAN plug-in on an ODA\",\"datePublished\":\"2025-04-22T21:07:17+00:00\",\"dateModified\":\"2025-04-22T21:07:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\\\/\"},\"wordCount\":940,\"commentCount\":0,\"keywords\":[\"database\",\"Oracle\",\"Restore\",\"Veeam\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\\\/\",\"name\":\"Restore a database using Veeam RMAN plug-in on an ODA - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2025-04-22T21:07:17+00:00\",\"dateModified\":\"2025-04-22T21:07:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/225d9884b8467ead9a872823acb14628\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Restore a database using Veeam RMAN plug-in on an ODA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/225d9884b8467ead9a872823acb14628\",\"name\":\"Marc Wagner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"caption\":\"Marc Wagner\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/marc-wagner\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Restore a database using Veeam RMAN plug-in on an ODA - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/","og_locale":"en_US","og_type":"article","og_title":"Restore a database using Veeam RMAN plug-in on an ODA","og_description":"I recently wrote a blog to show how to configure Veeam RMAN plug-in to take database backups. As all DBA knows, configuring a backup, will not go without testing a restore. In this blog I will show how I tested my previous Veeam configuration and backups performed with this Veeam RMAN plug-in on the same […]","og_url":"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/","og_site_name":"dbi Blog","article_published_time":"2025-04-22T21:07:17+00:00","article_modified_time":"2025-04-22T21:07:21+00:00","author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"Restore a database using Veeam RMAN plug-in on an ODA","datePublished":"2025-04-22T21:07:17+00:00","dateModified":"2025-04-22T21:07:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/"},"wordCount":940,"commentCount":0,"keywords":["database","Oracle","Restore","Veeam"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/","url":"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/","name":"Restore a database using Veeam RMAN plug-in on an ODA - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2025-04-22T21:07:17+00:00","dateModified":"2025-04-22T21:07:21+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/restore-a-database-using-veeam-rman-plug-in-on-an-oda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Restore a database using Veeam RMAN plug-in on an ODA"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628","name":"Marc Wagner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","caption":"Marc Wagner"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38083","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=38083"}],"version-history":[{"count":22,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38083\/revisions"}],"predecessor-version":[{"id":38105,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/38083\/revisions\/38105"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=38083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=38083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=38083"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=38083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}