Creating Aliases on ASM

Topics about Databases, Backups, Tuning, Architecture, Systems Management, etc etc.

Creating Aliases on ASM

Postby bgrenn » Thu Dec 30, 2010 2:47 pm

I used these 2 lines to make aliases for all my datafiles, then rename them to the alias..

This helped with a smoother RMAN active database duplicate.  Otherwise it can get confused

set linesize 160
set pagesize 0

select 'alter diskgroup DATA add alias ''' || substr(name,1,instr(name,'.')) || 'dbf'' for ''' || name || ''';' from v$datafile;

set linesize 160
set pagesize 0

select 'alter database rename file '''|| name || ''' to ''' || substr(name,1,instr(name,'.')) || 'dbf'';' from v$datafile;
Posts: 91
Joined: Mon Mar 16, 2009 11:47 am
Location: Rochester, NY

Return to DBA Topics

Who is online

Users browsing this forum: No registered users and 1 guest