Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, David.

Asked: July 05, 2020 - 3:16 pm UTC

Last updated: July 14, 2020 - 3:45 am UTC

Version: 18

Viewed 1000+ times

You Asked


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.

and Connor said...

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.


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

I think you're right

David D., July 10, 2020 - 4:42 pm UTC

Thank you Connor for this answer, I think you are right, it sounds more professional.

One last question : if my table is 10Mo and it was in a 1To datafile, does RMAN restored a 1To datafile in the auxiliary databasea or just a portion of this big big datafile containing the table?

Have a nice day,

David D.
Connor McDonald
July 11, 2020 - 5:59 am UTC

The restoration will be at datafile level, because we need to physically open the transient database

David D., July 13, 2020 - 7:17 pm UTC

OK, I thought it was that; thank you for the response.

Have a nice day.
Connor McDonald
July 14, 2020 - 3:45 am UTC

glad we could help

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.