-
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>
-
from rman,
run {
allocate channel d1 type disk;
restore (database);
release channel d1;
}
-
Mount the Database and then do the Rman Restore.
