1830044 Members
5618 Online
109998 Solutions
New Discussion

Oracle 9i and archivelog

 
SOLVED
Go to solution
Yogeeraj_1
Honored Contributor

Re: Oracle 9i and archivelog

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Viger Østensen
Advisor

Re: Oracle 9i and archivelog


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
Advisor

Re: Oracle 9i and archivelog


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 -