You can restore and recover Oracle 11g R2 Database from RMAN backup on Windows 2008 R2 Server with below operations. You have to execute Command Prompt as Administrator for all operations.
Restore and Recover Database
Install Oracle software
Install PatchCreate ORACLE_HOME and ORACLE_SID in Server Environment Path.
Copy backup files to C:\orabackup
Create Oracle service with below command
cmd> oradim -NEW -SID YOURDBSID -STARTMODE manual -PFILE “$ORACLE_HOME\dbs\init.ora”
cmd> rman target /
RMAN> set dbid=12412312 Note : DBID writes in Control File backup name, if you use %F file name parameter.
RMAN> startup nomount force;
RMAN> restore spfile from ‘C:\orabackup\controlfilebackupfile’;
RMAN> exit;
cmd> sqlplus / as sysdba
SQL> create pfile=’C:\orabackup\pfile.ora’ from spfile;
You have to create archivelog directory and other directories in pfile.ora. You have to copy archivelog file to archivelog directory.
SQL> create spfile from pfile=’C:\orabackup\pfile.ora’;
SQL> shu abort;
SQL> startup nomount;
cmd> rman target /
RMAN> restore controlfile from ‘C:\orabackup\controlfilebackupfile’;
Control files restored to directories that are in pfile.ora
SQL> alter database mount;
If you use parallel backup to take backup, you can select backups like below.
RMAN> catalog backuppiece ‘C:\orabackup\backupfile1.bck’,’C:\orabackup\backupfile2.bck’;
RMAN> list backup;
You have to create directory for datafiles. Directories show in list backup;
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open resetlogs;
ORA-00392 log 3 of thread 1 is being cleared, operation not allowed
ORA-00312 online log 3 thread 1: ‘path’If you get above error, you have to create path that writes in error. You get error because system can not create directory for redo logs.
You have to execute below SQL to clear logfile, you can open database.SQL> alter database clear unarchived logfile group 3;
SQL> alter database open resetlogs;
SQL> select status from v$instance;
I read a lot of interesting articles here. Probably you
spend a lot of time writing, i know how to save you a lot of time,
there is an online tool that creates readable, SEO friendly posts in minutes, just type
in google – laranitas free content source
Excellent Work…Really helped us with our RMAN configuration
Excelllent, very thanks