Oracle 9i and archivelog

[Yogeeraj_1]

hi again!

YES, you will "lose the changes that have been done to the database while the "BACKUP DATABASE" command was running" and also all changes made afterwards.

kind regards
yogeeraj

[Viger Østensen]

The question asked is "Why do I want to do this?"

We were first thinking about doing a backup once a week. With this backup strategy, we could afford loosing a week of data and a full backup once a week would suffice.

New requirements have arisen since then (sounds familiar?). Now, backups have do be done once a day and with this strategy we would do daily backups of arhive logs and weekly full backups of the database. This is kinda what you have suggested all along for us, I just has to take a detour to get there :-)

What about this rman script for performing full, weekly backups:

run {
allocate channel t1 type disk;
backup format '/opt/oracle/backup/%d' (database);
sql 'alter system archive log current';
backup arhivelog all delete input format '/opt/oracle/backup/%d-al-%u.%p';
release channel t1;
}

And for daily backups, we'll just drop the "backup ... (database)" command and keep the rest.

Regards,
- Viger -

[Viger Østensen]

Thanks all for your input on this!

With the comments from you, I have implemented a backup strategy with RMAN. Weekly database backups and daily archive log backups.

Now it only remains to see if we're able to do recovery. Yes, we WILL test this :-)

Regards,
- Viger -