Home » RDBMS Server » Backup & Recovery » deleting the flashback recovery area and the files (10.2.0.3 on Solaris 8)
deleting the flashback recovery area and the files [message #376024] Mon, 15 December 2008 13:26 Go to next message
orausern
Messages: 817
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta023.htm#sthref409

Regards
Michel
Re: deleting the flashback recovery area and the files [message #376026 is a reply to message #376024] Mon, 15 December 2008 13:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
orausern
Messages: 817
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
Re: deleting the flashback recovery area and the files [message #376030 is a reply to message #376028] Mon, 15 December 2008 13:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
orausern
Messages: 817
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
Re: deleting the flashback recovery area and the files [message #376036 is a reply to message #376034] Mon, 15 December 2008 13:48 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: Restoring database from full export backup
Next Topic: I've got some thing wrong with my backupset RMAN
Goto Forum:
  


Current Time: Sun Dec 04 20:26:10 CST 2016

Total time taken to generate the page: 0.08556 seconds