Hello Masters,
I hope you are OK, it was impossible to ask TOM during many days...
Two weeks ago I was testing, with RMAN, the "RECOVER TABLE" command. It helped me to restore a dropped table, with RMAN backups : a very powerful and useful feature, thanks to Oracle for that tool.
I droped the table HR.ZZRMAN01 of the PDB ORCL and, to restore it, my command was :
RMAN> RECOVER TABLE HR.ZZRMAN01 OF PLUGGABLE DATABASE ORCL UNTIL SCN 2331673 AUXILIARY DESTINATION '/u01/app/oracle/RMAN_TEMP' REMAP TABLE 'HR'.'ZZRMAN01':'ZZRMAN01_PREV';
And, surprise, on the screen I saw that Oracle creates an instance named dvil...
Starting recover at 20-JUN-20
using channel ORA_DISK_1
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace ORCL:SYSTEM
Tablespace ORCL:UNDOTBS1
Tablespace UNDOTBS2
Here!
<u><b>Creating automatic instance, with SID='dvil'</b></u>
initialization parameters used for automatic instance:
db_name=ORCL12C
db_unique_name=dvil_pitr_ORCL_ORCL12C
compatible=12.2.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_system_trig_enabled=FALSE
sga_target=800M
processes=200
db_create_file_dest=/u01/app/oracle/RMAN_TEMP
log_archive_dest_1='location=/u01/app/oracle/RMAN_TEMP'
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance ORCL12C
Oracle instance started
Total System Global Area 838860800 bytes
Fixed Size 8798312 bytes
Variable Size 239079320 bytes
Database Buffers 583008256 bytes
Redo Buffers 7974912 bytes
Automatic instance created
...
Well, my little question is just : does Dvil mean devil? You agree with me or I am wrong?
I was so amused that I wanted to talk about it with Oracle experts :-)
Have a nice day,
David D.
I floated the question around the Product Managers and no-one knows the reason, so it looks like it was at the whim of a developer.
My *guess* would be (D)atabase reco(V)ery (I)instance (L)ight.