Home » RDBMS Server » Server Administration » how to release the space? (Oracle 10g ,Linux)
how to release the space? [message #543573] Wed, 15 February 2012 06:43 Go to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
how to delete flashback log and to release the space?

i guess that it maybe like archive log ,it can release the space using RMAN.But when i try a test ,it fail.

don't tell me like that:
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE FLASHBACK OFF;


i want to know another idea. thank u . Smile

Report message to a moderator

Re: how to release the space? [message #543578 is a reply to message #543573] Wed, 15 February 2012 07:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
rm?

Regards
Michel

Report message to a moderator

Re: how to release the space? [message #543670 is a reply to message #543578] Thu, 16 February 2012 05:17 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
the 'rm' command also can't release the space .how i know this ,view the v$flash_recovery_area_usage.

the database must be restart?

Report message to a moderator

Re: how to release the space? [message #543674 is a reply to message #543670] Thu, 16 February 2012 05:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the 'rm' command also can't release the space


Are you sure?
Always, post what you did and got.

Regards
Michel

Report message to a moderator

Re: how to release the space? [message #543797 is a reply to message #543674] Thu, 16 February 2012 21:24 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
 

[oracle@shenzhengair flashback]$ pwd
/u01/app/oracle/flash_recovery_area/SZCARGO/flashback
[oracle@shenzhengair flashback]$ ls -lh
总计 427M
-rw-r----- 1 oracle oinstall 16M 02-17 02:39 o1_mf_7k9oz99k_.flb
-rw-r----- 1 oracle oinstall 16M 02-17 05:01 o1_mf_7k9wmkfw_.flb
-rw-r----- 1 oracle oinstall 16M 02-17 09:00 o1_mf_7kb5xlo3_.flb
-rw-r----- 1 oracle oinstall 16M 02-17 11:14 o1_mf_7kbkpchy_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 04:21 o1_mf_7kbzq8fo_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 07:00 o1_mf_7kbzqyo0_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 09:32 o1_mf_7kbzr9wx_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 14:00 o1_mf_7kc95c34_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 14:30 o1_mf_7kcnw57z_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 16:47 o1_mf_7kd2x49t_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 22:00 o1_mf_7kdb0r1m_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 22:00 o1_mf_7kdg2zr9_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 22:00 o1_mf_7kdnb8ns_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 02:00 o1_mf_7kdw1hrq_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 03:40 o1_mf_7kf6307y_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 06:18 o1_mf_7kfjn0lz_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 09:24 o1_mf_7kfn3fjo_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 14:24 o1_mf_7kfnkygw_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 16:26 o1_mf_7kfr5nvq_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 19:16 o1_mf_7kg2rhgr_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 22:00 o1_mf_7kg93cw4_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 22:00 o1_mf_7kgj7wjr_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 22:09 o1_mf_7kgtrstl_.flb
-rw-r----- 1 oracle oinstall 16M 02-17 00:01 o1_mf_7kh5bfjj_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 12:00 o1_mf_7m2t8owt_.flb
-rw-r----- 1 oracle oinstall 16M 02-16 11:30 o1_mf_7m53zwvn_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 19:06 o1_mf_7m9dmsr4_.flb
-rw-r----- 1 oracle oinstall 16M 02-15 23:00 o1_mf_7mqgn7f4_.flb
[oracle@shenzhengair flashback]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 17 11:14:46 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE                   0                         0               0
ONLINELOG                     0                         0               0
ARCHIVELOG                14.13                         0              35
BACKUPPIECE                   0                         0               0
IMAGECOPY                     0                         0               0
FLASHBACKLOG               4.16                      4.01              28

6 rows selected.

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@shenzhengair flashback]$ rm o1_mf_7*
[oracle@shenzhengair flashback]$ ls -lh
总计 0
[oracle@shenzhengair flashback]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 17 11:15:50 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected.

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE                   0                         0               0
ONLINELOG                     0                         0               0
ARCHIVELOG                14.13                         0              35
BACKUPPIECE                   0                         0               0
IMAGECOPY                     0                         0               0
FLASHBACKLOG               4.16                         0              28

6 rows selected.

Report message to a moderator

Re: how to release the space? [message #543813 is a reply to message #543797] Fri, 17 February 2012 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Flashback logs are automatically removed when:
1/ they are expired
2/ there is a lack of space in FRA.

If you want to remove it before then decrease db_flashback_retention_target.

Regards
Michel

Report message to a moderator

Re: how to release the space? [message #546069 is a reply to message #543813] Mon, 05 March 2012 03:14 Go to previous message
saravananr82
Messages: 1
Registered: March 2012
Location: Chennai
Junior Member
Hi,

Backup the archivelog using RMAN and use delete all input options. It will release the space once the backup complete.

Thanks,
Saravanan R

Report message to a moderator

Previous Topic: Alertlog monitoring
Next Topic: temp space error ORA-1652
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 13:14:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.