Re: Flashback database question?
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: "Harvinder_Singh@xxxxxxxxx" <Harvinder_Singh@xxxxxxxxx>
- Date: Wed, 15 Apr 2009 09:25:17 +0200
What brandon said, but also:
) Falshback and archive log in on for database
2) Db_recovery_file_dest_size is set to 100GB
3) Create a restore_point for baseline database image
4) Use the database and do all the processing
5) Restore to restore_point created in step3) and start again
Surely you mean FLASHBACK DATABASE to the restorepoint, right ?
For flashback database you won't need archivelogs (or at least not a lot of
them), this feature mostly uses the flashback logs, and applies a small
amount of redo to make it consistent to be able to open it ( and not even
too sure about that, havent watched it so closely, but I'm happy to stand
corrected if someone has).
For something like this I've always ran a script to backup & delete the
archivelogs (or in test systems only delete) every n minutes to save
space... Works peachy.
On the other hand, for this type of thing, you may want to use a guaranteed
restore point, then the database will simply stop once it can no longer
guarantee that it will be able to flash back (and you can free up space by
deleteing archivelogs to let it continue).
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Tue, Apr 14, 2009 at 8:34 PM, Allen, Brandon
<Brandon.Allen@xxxxxxxxxxx>wrote:
> It sounds like maybe someone deleted the archive logs at the OS level and
> Oracle isn’t aware so you need to run a crosscheck. You might want to take
> a look at Metalink 305812.1 too.
>
>
>
> Regards,
>
> Brandon
>
>
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Harvinder Singh
>
>
>
> I checked and most of the space are taken by archive logs but physically
> files are only taking 12G but following query is showing that recovery area
> is using 95G and 88G is used by archived files
>
>
>
> ------------------------------
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
Other related posts:
