Re: flash recovery area

From: S3v3n11 <neisdsa_at_gmail.com>
Date: Tue, 13 Dec 2016 07:08:38 -0600
Message-ID: <CABP9HxNxVsQVscsSdyTWRm-eEttTFeS5iu6vM75kvy7ZoLEi6Q_at_mail.gmail.com>



Connect with RMAN and:

delete noprompt archivelog all;
delete noprompt backup of database;
delete noprompt copy of database;

Based on V$RECOVERY_AREA_USAGE there may be other objects you can remove.

On Mon, Dec 12, 2016 at 8:17 AM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:

> Came in to a database where the flash recovery area was full. Googled a
> few things but is there a simple way to fix this?
>
> It is a test system so it isn’t critical at the moment.
>
>
>
>
>
> Brian
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 13 2016 - 14:08:38 CET

Original text of this message