Skip to Main Content

Breadcrumb

Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Connor McDonald

Thanks for the question, David.

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

Answered by: Connor McDonald - Last updated: July 14, 2020 - 3:45 am UTC

Category: Database Administration - Version: 18

Viewed 100+ 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 we 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.


and you rated our response

  (2 ratings)

Reviews

I think you're right

July 10, 2020 - 4:42 pm UTC

Reviewer: David D. from Paris in France

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

Followup  

July 11, 2020 - 5:59 am UTC

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

July 13, 2020 - 7:17 pm UTC

Reviewer: David D.

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

Have a nice day.
Connor McDonald

Followup  

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.