Category Archives: Oracle backup & recovery

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

How to export/import faster with export data pump with parallel clause

Example: Create database directory for physical path for backup. SQL> create directory DBBACKUP as ‘/archive/backup/’; Directory created. Grant permission to everyone. SQL> grant read,write on directory DBBACKUP to public; Grant succeeded. SQL> Start expdp with parallel clause [oracle@dbsrv ~]$ expdp … Continue reading

Posted in Oracle backup & recovery | Leave a comment

DataPump Export (EXPDP) Is Hanging While Exporting A Table With LONG Column

Symptoms DataPump export (expdp) is hanging while exporting a table with LONG column. Cause The default method that DataPump uses for loading and unloading data is direct path, when the structure of a table allows it. Note that if the table … Continue reading

Posted in Oracle backup & recovery | Leave a comment