Category Archives: rman

RMAN Backup On Remote Machine Disk On Windows

Objective How to take backups on shared disk of another machine on windows machine.. Steps are following Follow the below steps to take backups on remote disk : + Suppose I have a target database on Machine A and the remote … Continue reading

Posted in rman | Leave a comment

Recovery of Online Redo log file

1- Check existing online Redo log file SQL> select * from v$Logfile; GROUP# STATUS  TYPE    MEMBER 2 ONLINE C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_91MVD8GZ_.LOG YES 1 ONLINE C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_91MVD6TJ_.LOG YES 2- Add one more Redo log group to database. SQL> ALTER DATABASE ADD LOGFILE ‘C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\Redo_-01_03.LOG’ … Continue reading

Posted in rman | Leave a comment

rman recovery if the missing archive logs are required for recovery

1- ———Restore the database —————– RMAN> restore database; Starting restore at 25-AUG-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF channel ORA_DISK_1: … Continue reading

Posted in rman | Leave a comment

rman backup and Recovery, if all archive logs and redo logs are available

1-  ————Take Rman Backup——————- RMAN> run 2> { 3> ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT ‘C:\oraclexe\rman\rman%U’; 4> backup AS COMPRESSED BACKUPSET tag Full_database_open database; 5> } using target database control file instead of recovery catalog allocated channel: disk1 channel … Continue reading

Posted in rman | Leave a comment

RMAN-03002: failure of switch command

Rman restored successfully completed but at the end there is a switch statement which got failed. rman last few lines which shows it is successfully restored. RMAN> channel ORA_DISK_2: reading from backup piece /orarman2/drrmanbackup/part2/rman2jofj96j_1_1 channel ORA_DISK_5: restored backup piece 1 … Continue reading

Posted in rman | Leave a comment

ORA-01124: cannot recover data file

Applies to: Oracle Server – Enterprise Edition – Version: 9.2.0.1 to 11.2.0.3 – Release: 9.2 to 11.2 Information in this document applies to any platform. Symptoms RMAN recovery fails with an ORA-01124 error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK … Continue reading

Posted in rman | Leave a comment

How to restore archive logs from rman backup in RAC

Restore archvie logs to different path RMAN> run { set archivelog destination to ‘/ora_backup/rman/arch/’; restore archivelog from logseq=8619 until logseq=8632 thread=2; } 2> 3> 4> 5> executing command: SET ARCHIVELOG DESTINATION Starting restore at 06-NOV-12 using channel ORA_DISK_1 using channel … Continue reading

Posted in rman | 2 Comments