Let’s have look on the steps are used by Oracle DBA for “Recreate Database Using Only Datafile and Logfile”. Backup of the control file in trace SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; create password file and service D:\> orapwd file=D:\oracle\product\10.2.0\db_1\database\PWDdba71.ora password=sys entries=10 D:\> oradim -new -sid dba71 -intpwd sys -maxusers 10 -startmode auto -pfile […]