My database is in non-archive mode and its size is 5 TB (monthly 200 GB increment). Currently we are taking the full backup monthly. As database growth is high, backup size and time had increased behold the acceptable limit. Hence we would like to take online RMAN backup by enabling the archive mode before starting the online backup and disable the archive mode after completion of online backup.
1) Are we able to recover the database till last backup using above backup policy? 2) Is it required to take archive log backup as well?
This DB only contains historical data and on daily basis an import will be done using dump files from the source DB. One month export dumps will be kept as backup, hence complete recovery till point of failure is not desired. Export dumps can be used to recover the database.