Database Backup and Recovery (MOSC)

MOSC Banner

when rename redolog and temp file during db restore? after restore or after recover?

edited Sep 23, 2021 7:45PM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓
I am restoring and old rman backup in the same server with a different instance name,
I rename datafile with set newname. I don't want to overwrite the original redo and temp. 

RUN
{
set newname for datafile 1 to '/restore/aux/SIADB/datafile/system01.dbf';
set newname for datafile 2 to '/restore/aux/SIADB/datafile/datossiagpsdesa01.dbf';
set newname for datafile 3 to '/restore/aux/SIADB/datafile/sysaux01.dbf';
set newname for datafile 4 to '/restore/aux/SIADB/datafile/undo01.dbf';
set newname for datafile 5 to '/restore/aux/SIADB/datafile/undo02.dbf';
..
set newname for datafile 75 to '/restore/aux/SIADB/datafile/datossiagpsdesa65.dbf';

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