Oracle 19c - I am trying to recover a table.
RECOVER TABLE PCM.PANEL of pluggable database D2159PDB
UNTIL TIME "TO_DATE('22-JUN-2022 05:00', 'DD-MON-YYYY HH24:MI')"
auxiliary destination 'G:\backup6'
remap table 'PCM'.'PANEL':'PANEL_JJ6';
It runs for about 5 hours and gets this set of errors:
Creating automatic instance, with SID='Elnn'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/24/2022 17:07:43
ORA-19852: error creating services for auxiliary instance Elnn (error 0)
ORA-27302: failure occurred at:
ORA-27303: additional information: failed to start instance
I ran this using the temp Sid that was created during the restore and tried to run it again and it fails after 5 hours. It creates datafiles, controlfiles, etc. for the clone instance again:
sql> exec dbms_backup_restore.manageAuxInstance('zrvk',1);
Any ideas? I have a lot of free disk space and I added memory to ensure the new instance can start. Thanks.