Recreate Database Using Only Datafile and Logfile

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 D:\oracle\product\10.2.0\admin\dba71\pfile\init.ora

set the environment and start the database in nomount

D:\>set oracle_home=D:\oracle\product\10.2.0\db_1
 (more...)

Recover From Redo Log File

This post explains about the steps are used by DBA for recovery From Redo Log File.

Check the archive log status

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     2
Current log sequence              4

List the tablespaces

SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP

SQL> select file_name from dba_data_files;
FILE_NAME
-----------------------------------------------------------
D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA02\USERS01.DBF
D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA02\SYSAUX01.DBF
 (more...)