I have an Oracle DB which has never been backed up, along with an archive log directory with over 300 GB of space used, I need to know if I can take an RMAN backup without the archive logs included and end up with a valid recovery point. I also need to delete the archive logs in order to have enough space to hold a backup. Regards
I am not sure what you meant by the recovery point? If you mean that you would be able to restore the database till you did the backup then yes, but only if it will be a consistent backup (one taken after the database has been shut down normally and cleanly). This would mean that restoring a consistent whole database backup without applying redo logs OR media recovery. Hence, one can restore even a year-old consistent backup of a database without performing media recovery and without Oracle performing instance recovery. Otherwise, If you want POINT-IN-TIME recovery, then it might not be possible. If I were you, I would indeed take full backup with option **PLUS ARCHIVELOG DELETE ALL INPUT** (Automatic deletion of Archived logs) to some other media. The backup size would be huge but this would have indeed put me in a much comfortable position. If this is not possible, to be on safe side, you should take the consistent backup (AKA cold backup), and restore it on another server (since looks like you are running out of space on current server). This would need a bit of maintenance, but it is better than living with no database to work with. Interestingly, what would be your backup strategy after this backup? If you would delete all the archived log files without initializing the log SCN (RESET LOGS), you would only be left with cold backups to work with. Which would mean no POINT-IN-TIME recovery. So what are you plans? [This] could be helpful if you want a clone :
In my previous post I listed the steps I believe I need to take in order to crate a baseline recovery point, after further investigation I am thinking I will delete all logs present on the day I execute this process because none of the prior logs will be of any use anyway, as they aren't now. then I will log into RMAN, run the commands to clear the RMAN repository of all references to prior logs/backups,(which there are no backups), then archive the current log, backup the database plus archivelog - correct me if I am wrong but there should only be one, and then crosscheck the backup. I would still like to know if it will be necessary to specify 'resetlogs' when I alter the database open.