Re: to much archivelog

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Wed, 22 Jan 2003 22:15:28 +0100
Message-ID: <3e2f09f2$0$49101$e4fe514c@news.xs4all.nl>

It is a method, if it's good for you, I don't know. If your goal is to have less downtime to do the backup, it can be a good method.
But:
- db is down for a short time twice
- you can't recover over the timestamps of switching archive log mode on or off.

Another method that can only be used when *all* files are on mirrored disks is:

- stop the database
- break the mirror
- start the database
- backup the "offline" mirror disks
- synchronise the disks after backup

The database does not need to run in archive log mode and is down only once for a few minutes but is not protected against disk crashes during backup. In 9i there is the new command "alter system suspend" (and "alter system resume") to "freeze" disk IO so you can break the mirror without really shutting down. But the documentation says you can only use it in archive log mode, so not usefull for you.

zeb <thierry.constant2_at_wanadoo.fr> schreef in berichtnieuws b0mvvk$qc6$1_at_news-reader10.wanadoo.fr...
| Hi,
|
| We have a datawarehouse, ( 8.1.7, AIX 4.3.3 )
| the database is in archivelog and we have disk space problem.
| we have a lot of archive we don't need
| we only need them to do the hot backup.
|
| do you know a method to get the archive only for the backup
| something like:
| - noarchive log
| - put the database archive log
| - do the hot backup
| - put the database no archive log
|
| Is a good method ???
|
| Thanks in advance
|
|
|
|
|
|
Received on Wed Jan 22 2003 - 15:15:28 CST