there is one little detail I want to make sure you attend to. Jared was the only one who mentioned it in his script. Just make sure your very last statement in the script is a 'backup controlfile'. this is done automatically for you when you use 'backup database plus....'. This is important so when you restore, you are using a CF where your current backup has been registered.
goran bogdanovic wrote:
if you use "plus archivelog" in rman backup then rman do the following: - alter system archive log current - backup all archive logs i.e. backup archivelog all - database backup is done specified by your backup stmt. - the "alter system archive log current" statement is executed - back up of archived redo logs created by previous stmt.On 8/28/07, * Sweetser, Joe* <JSweetser@xxxxxxxx <mailto:JSweetser@xxxxxxxx>> wrote:Hi all - My question is what do people around here do? Backup database and backup archivelog? Backup database...plus archivelog? I realize this is somewhat "nuancy" but, personally, I like the idea of at least being able to get the database back (and opened) with a single night's backup that is copied to tape. Opinions/thoughts/experiences? Thanks, -joe -- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l