OraFAQ Forum: Backup & Recovery » deleting the flashback recovery area and the files

Home » RDBMS Server » Backup & Recovery » deleting the flashback recovery area and the files (10.2.0.3 on Solaris 8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

deleting the flashback recovery area and the files [message #376024]

Mon, 15 December 2008 13:26

orausern
Messages: 826
Registered: December 2005

Senior Member

Hi,

We have a dev. db which is small about 3 gb in all (crd files). for this I had enabled flashback and also put it in archivelog mode. then the db_recovery_file_dest_size grew to 3 gb. since space is an issue, I turned off the flashback feature. (by the command: ALTER DATABASE FLASHBACK OFF;)

Tomorrow I will also make it into noarchivelog mode. My question is: it is having lots of archived logs (may be 3 gb or more) in the flashback recovey area. What is the correct syntax to delete them? There is a warning in alert log which says that use RMAN delete command but I am not aware of exact syntax.

Thanks
Nirav

[Updated on: Mon, 15 December 2008 13:28]

Report message to a moderator

Re: deleting the flashback recovery area and the files [message #376025 is a reply to message #376024]

Mon, 15 December 2008 13:29

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta023.htm#sthref409

Regards
Michel

Report message to a moderator

Re: deleting the flashback recovery area and the files [message #376026 is a reply to message #376024]

Mon, 15 December 2008 13:31

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>What is the correct way to delete them?
backing the database + archived logs using RMAN and deleting.
If you do not care to backup (hot backup, not exported dumps), there is no point in having the database in archived log mode.
In the simplest

RMAN> backup database plus archivelog delete input

will do the job

[Updated on: Mon, 15 December 2008 13:34]

Report message to a moderator

Re: deleting the flashback recovery area and the files [message #376028 is a reply to message #376026]

Mon, 15 December 2008 13:36

orausern
Messages: 826
Registered: December 2005

Senior Member

we are in a disk space problem in which the server has no space left to store any backup. So if I give
this command , will it not create a space issue? because it involves a backup of the database?

Thanks
Nirav

Report message to a moderator

Re: deleting the flashback recovery area and the files [message #376030 is a reply to message #376028]

Mon, 15 December 2008 13:40

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>because it involves a backup of the database?
That is what i said before.
If you do not care/afford to backup the database, there is no point in having the database in archived log mode, let the database generate archives and continue to deal with space issue with generated archives and maintaining it.
Long story short, turn off the archiving.

[Updated on: Mon, 15 December 2008 13:40]

Report message to a moderator

Re: deleting the flashback recovery area and the files [message #376034 is a reply to message #376030]

Mon, 15 December 2008 13:44

orausern
Messages: 826
Registered: December 2005

Senior Member

Yes, I am turning it off tomorrow, but after that what command to use to delete those files in the flashback area? the command which you suggested involves backup of database for which there is no space.

backup database plus archivelog delete input

so after I turn it to noarchivelog mode, which rman command i should use (which doesn't involve any backup) to delete all those files in flashback area?

Thanks
Nirav

Report message to a moderator

Re: deleting the flashback recovery area and the files [message #376036 is a reply to message #376034]

Mon, 15 December 2008 13:48

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Honestly,
If you do worry about backup/restore on that database,
any method would be fine.
Just delete them (even If it is accessible from direct OS commands or not)
Please look into the piece of documentation Michel suggested.

Report message to a moderator

Previous Topic:	Restoring database from full export backup
Next Topic:	I've got some thing wrong with my backupset RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 10:18:13 CST 2024