I have a regular Oracle 12c database already created, named ECLS. I've been given a pile of .BKP files, not from this database, and have been told to replace everything in ECLS with the contents of these files.
With the files, I was also told to use this command to do it:
RMAN> duplicate database to ECLS backup location '/u01/dumpfilesgohere';
No other directions were provided.
I found that my database needs to be an auxiliary with nothing mounted. So I did the following:
$ sqlplus / as sysdba
SQL> shutdown immediate;
SQL> startup nomount;
SQL> exit
$ rman auxiliary /
RMAN> duplicate database to ECLS backup location '/u01/dumpfilesgohere';
This looks like it's working properly for the first few seconds... it says that it's able to restore the control files from the BKP files. But then it ends up failing. Here's the last few lines before the failure:
contents of Memory Script:
{
sql clone "alter system set db_name =
''ECLS'' 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 = ''ECLS'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/30/2017 14:59:06
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-65093: multitenant container database not set up properly
What am I doing wrong? What files do I need to change to get this error message to stop occurring?
Alternatively... if my whole database install isn't going to work, can someone tell me what I need to do differently when reinstalling the database?