I have done a rman offline backup of my database which was in noarchivelog mode.

The back went successfully .

The backup was done under the file name D:\BACKUP\DF_ORCL_1_1


How do i restore the database in the same server ...

I need the complete procedure to do the restore of the database in the same server..


RMAN> list backupset of database;

RMAN-03022: compiling command: list

List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
25 1 420861650 0 420861608 1 05-FEB-01

List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
26 1 1 AVAILABLE 05-FEB-01 D:\BACKUP\DF_ORCL_1_1

List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
1 D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 0 Full 300675 05-FEB-01
2 D:\ORACLE\ORADATA\ORCL\RBS01.DBF 0 Full 300675 05-FEB-01
3 D:\ORACLE\ORADATA\ORCL\USERS01.DBF 0 Full 300675 05-FEB-01
4 D:\ORACLE\ORADATA\ORCL\TEMP01.DBF 0 Full 300675 05-FEB-01
5 D:\ORACLE\ORADATA\ORCL\TOOLS01.DBF 0 Full 300675 05-FEB-01
6 D:\ORACLE\ORADATA\ORCL\INDX01.DBF 0 Full 300675 05-FEB-01
7 D:\ORACLE\ORADATA\ORCL\DR01.DBF 0 Full 300675 05-FEB-01

RMAN>