rem oradIm -SHUTDOWN -SID ARIF  -USRPWD manager -SHUTTYPE SRVC,INST
oradIm -delete -sId ARIF
pIng localhost -n 5 > nul
del F:\oradb\ARIF\control*
del F:\oradb\ARIF\TEMP01.DBF
echo control_fIles=(F:\oradb\ARIF\CONTROL01.CTL,F:\oradb\ARIF\CONTROL02.CTL, F:\oradb\ARIF\CONTROL03.CTL)>> F:\oradb\ARIF\InIt.ora
echo db_name = ARIF>> F:\oradb\ARIF\InIt.ora
oradIm -new -Intpwd manager -sId ARIF -startmode auto -pfIle F:\oradb\ARIF\InIt.ora
pIng localhost -n 20 > nul
set oracle_sId=ARIF
sqlplus /nolog
connect sys/manager as sysdba
startup nomount pfIle=F:\oradb\ARIF\InIt.ora
create controlfIle set database "ARIF" resetlogs
logfIle
group 1 'F:\oradb\ARIF\REDO11.LOG' sIze 10M,
group 2 'F:\oradb\ARIF\REDO12.LOG' sIze 10M,
group 3 'F:\oradb\ARIF\REDO13.LOG' sIze 10M,
group 4 'F:\oradb\ARIF\REDO21.LOG' sIze 10M,
group 5 'F:\oradb\ARIF\REDO22.LOG' sIze 10M,
group 6 'F:\oradb\ARIF\REDO23.LOG' sIze 10M,
group 7 'F:\oradb\ARIF\REDO31.LOG' sIze 10M,
group 8 'F:\oradb\ARIF\REDO32.LOG' sIze 10M,
group 9 'F:\oradb\ARIF\REDO33.LOG' sIze 10M
datafIle				
'F:\oradb\ARIF\ERPAPP_DATA.DBF',
'F:\oradb\ARIF\ERPAPP_ARCHIVE_DATA.DBF',
'F:\oradb\ARIF\ERPAPP_ARCHIVE_INDEX.DBF',
'F:\oradb\ARIF\ERPAPP_INDEX.DBF',
'F:\oradb\ARIF\ERPAPP_REPORT_DATA.DBF',
'F:\oradb\ARIF\ERPAPP_REPORT_INDEX.DBF',
'F:\oradb\ARIF\SYSTEM01.DBF',
'F:\oradb\ARIF\UNDOTBS01.DBF',
'F:\oradb\ARIF\USERS01.DBF',
'F:\oradb\ARIF\TOOLS01.DBF';
alter database open resetlogs;
alter database rename global_name to "ARIF";
ALTER TABLESPACE TEMP ADD TEMPFILE 'F:\oradb\ARIF\TEMP01.DBF'
     SIZE 20M AUTOEXTEND ON MAXSIZE 1024M;
exIt