Refresh Database

STEPS TO REFRESH DATABASE 1)ftp all the datafiles from the provided location 2)gunzip 3)shutdown database 4)remove old datafiles and replace them with new files 5)make the required changes sql script for creating control file 6)startup nomount 7)create new control file thru script 8)recover database until cancel using backup controlfile; 9)select name,open_mode from v$database; 10)alter database open resetlogs 11)alter system switch logfile;

0