What Is the File “_rm_dup_.dat” Under ORACLE_HOME/dbs of Auxiliary Host

“_rm_dup_.dat” file is for “restore optimization” purpose to record which datafiles have been restored/copied onto auxiliary host, when running RMAN “duplicate target database for standby from active database”.

There is a file with name  “_rm_dup_<dup_db>.dat” under $ORACLE_HOME/dbs of clone database.  This file is from executing “duplicate target database for standby from active database”. 

“_rm_dup_<dup_db>.dat” stores the names of datafilecopy already created by duplicate. Inside this file,  rman can find the name of the datafiles already copied to auxiliary host. if, for some reasons, the duplicate failed, the second duplicate will check this file. If the datafilecopy has been created on auxilary host, and the vital information of the datafile (file number, database id, creation scn, database name) and its checkpoint scn is behind the until scn, then the datafilecopy can be used by this new duplicate and restore/copy is not necessary.

So this file helps for “restore optimization” purpose when running RMAN “duplicate target database for standby from active database”. 

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: