RMAN > could not access datafile Error

This error is occur when RMAN is not able to access the desired datafile. RMAN>  backup database skip inaccessible; Starting backup at 10-AUG-17 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=7 device type=DISK could not access datafile 10 skipping inaccessible file 10 Solutions : RMAN> restore datafile 10; … Continue reading RMAN > could not access datafile Error

How to backup Oracle Database using RMAN

This tutorial gives you an introduction on how to perform Oracle DB backup using RMAN. For the impatient, here is the quick snippet, that takes RMAN backup of both database and archive logs. We write ORACLE_SID and ORACLE_HOME in the Oracle user profile file. .bash_profile export ORACLE_SID=db12c export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_home1 We create the dbscripts folder under … Continue reading How to backup Oracle Database using RMAN