recover a nonsystem datafile in archivelog mode
First check that your database is working on archivelog mode: SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 32 Next log sequence to archive 34 Current log sequence 34 If not, follow this post database in archivelog mode Second, perform a full backup of your database. RMAN> backup database; Starting backup at 27-SEP-17 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=29 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00003 name=/oracle/db/oradata/orcl/sysaux01.dbf input datafile file number=00001 name=/oracle/db/oradata/orcl/system01.dbf input datafile file number=00013 name=/oracle/db/oradata/orcl/WCPVM_iasactivities.dbf input datafile file number=00012 name=/oracle/db/oradata/orcl/WCPVM_ocs.dbf input da...