Pages

Saturday, March 14, 2015

Datafile Location Change



Contents:- Change name and location of datafile using backup

We can change name and location of data files at the time of restoring backup.

Rman> run
{
Set newname for datafile 6 to ‘+data/clone/datafile/’;
Restore datafile 6;
Switch datafile all;
Recover datafile 6;

}

No comments:

Post a Comment