Monday, December 8, 2014

Renaming datafile using RMAN

Rename datafile using online for non system datafile :
========================================================
sql 'alter tablespace users offline';
run {
allocate channel c1 type disk;
set newname for datafile 6 to F:\ORADATA\ORCL\USERS02_latest.DBF;
restore datafile 6;
switch datafile 6;
release channel c1;
}

No comments:

Post a Comment

Followers