Database Backup and Recovery (MOSC)

MOSC Banner

Recover database - rename datafiles from original name to name+%u.

edited Nov 15, 2024 12:03AM in Database Backup and Recovery (MOSC) 2 commentsAnswered

Hi,

we have to recover database from rman backup. The problem is that the files are during the recover process automatically renamed from original name to unique name
Example :
original file name

undotbs_001.dbf is recovered as undotbs_X124TCXX.dbf
rman logs shows

set newname for datafile {id} to undotbs_%u.dbf

for every file except the files we explicitly set the name.

Is there some quick workaround or set hot to disable this feature ?

The one way is just explicitly set new name to every datafile in the recover script (we have this possibility as we already have original database so we can query dba_data_files) , but is there another option (rman configure, or some other set)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center