Oracle 12.2.3 2 shared appstiers
Oracle DB 19.15 multitenant one node
Oracle Linux 7.9 vm on OCI
I don't have access to create a token to use the rman backup so i have to do this as an active database. I can get access to create the token when i findout what the policy to have this access is to grant to my appsdba group.
I am trying an active database since i can't use the backup. I am far enough that i get this error:
RMAN-03002: failure of Duplicate Db command at 11/20/2022 11:28:24 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-19660: some files in the backup set could not be verified ORA-19661: datafile 0 could not be verified ORA-19865: Backup piece network has no data
this seems like an error too: dbms_backup_restore.restoreCancel() failed
Here is the output
Starting restore at 20-NOV-22_11:27:56
channel d1: starting datafile backup set restore
channel d1: using network backup set from service CDBPRD
channel d1: restoring control file
dbms_backup_restore.restoreCancel() failed
Oracle instance started
Total System Global Area 42949672008 bytes
Fixed Size 23063624 bytes
Variable Size 4966055936 bytes
Database Buffers 37849399296 bytes
Redo Buffers 111153152 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''CDBDEV2'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
}
executing Memory Script
sql statement: alter system set db_name = ''CDBDEV2'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/20/2022 11:28:24
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-19660: some files in the backup set could not be verified
ORA-19661: datafile 0 could not be verified
ORA-19865: Backup piece network has no data
Recovery Manager complete.