OraFAQ Forum: RAC & Failsafe » RMAN command to reduce the space usage

Home » Server Options » RAC & Failsafe » RMAN command to reduce the space usage (Oracle10g Rel 10.2.0.3 on Solaris 10)

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

RMAN command to reduce the space usage [message #476075]

Tue, 21 September 2010 04:29

fpalero
Messages: 2
Registered: September 2010
Location: macau

Junior Member

Hi,

Anyone can help me on how to reduce the space usage in RMAN commands.

Thank you,
FPalero

Report message to a moderator

Re: RMAN command to reduce the space usage [message #476091 is a reply to message #476075]

Tue, 21 September 2010 05:49

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

Senior Member
Account Moderator

You mean,
size of backupsets?
You can compress them, but it comes with some CPU consumption.

Report message to a moderator

Re: RMAN command to reduce the space usage [message #476107 is a reply to message #476091]

Tue, 21 September 2010 07:28

fpalero
Messages: 2
Registered: September 2010
Location: macau

Junior Member

hi mahesh,

maybe i dont like to use the cpu consumption. is there a way that i can changed the retention to 3days instead of 7days? what would be th safest commands.

here my rman generated files;

/backup/RMAN
$ ls -alh
total 401988372
drwxr-xr-x 2 oracle oinstall 1.0K Sep 21 00:13 .
drwxr-xr-x 5 oracle oinstall 512 Aug 27 10:05 ..
-rw-r----- 1 oracle oinstall 15M Sep 18 00:11 c-4191729446-20100918-01
-rw-r----- 1 oracle oinstall 15M Sep 19 00:06 c-4191729446-20100919-00
-rw-r----- 1 oracle oinstall 15M Sep 19 00:09 c-4191729446-20100919-01
-rw-r----- 1 oracle oinstall 15M Sep 20 00:06 c-4191729446-20100920-00
-rw-r----- 1 oracle oinstall 15M Sep 20 00:09 c-4191729446-20100920-01
-rw-r----- 1 oracle oinstall 15M Sep 21 00:07 c-4191729446-20100921-00
-rw-r----- 1 oracle oinstall 15M Sep 21 00:11 c-4191729446-20100921-01
-rw-r--r-- 1 oracle oinstall 715 Mar 11 2008 full_export.log
-rw-r----- 1 oracle oinstall 17G Sep 15 00:07 jhlntn8c_1_1
-rw-r----- 1 oracle oinstall 8.8G Sep 15 00:10 jjlntnml_1_1
-rw-r----- 1 oracle oinstall 17G Sep 16 00:06 jllo0bke_1_1
-rw-r----- 1 oracle oinstall 9.2G Sep 16 00:09 jnlo0c1e_1_1
-rw-r----- 1 oracle oinstall 18G Sep 17 00:07 jplo300d_1_1
-rw-r----- 1 oracle oinstall 9.4G Sep 17 00:10 jrlo30f8_1_1
-rw-r----- 1 oracle oinstall 18G Sep 18 00:07 jtlo5kcd_1_1
-rw-r----- 1 oracle oinstall 9.9G Sep 18 00:11 jvlo5krs_1_1
-rw-r----- 1 oracle oinstall 18G Sep 19 00:06 k1lo88ob_1_1
-rw-r----- 1 oracle oinstall 9.4G Sep 19 00:09 k3lo895s_1_1
-rw-r----- 1 oracle oinstall 18G Sep 20 00:06 k5loat4b_1_1
-rw-r----- 1 oracle oinstall 9.3G Sep 20 00:09 k7loati0_1_1
-rw-r----- 1 oracle oinstall 18G Sep 21 00:07 k9lodhgc_1_1
-rw-r----- 1 oracle oinstall 11G Sep 21 00:11 kblodi00_1_1
-rw-r--r-- 1 oracle oinstall 15K Sep 21 00:13 rman_backup.log

Report message to a moderator

Re: RMAN command to reduce the space usage [message #476124 is a reply to message #476107]

Tue, 21 September 2010 09:24

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

Senior Member
Account Moderator

Well, that is your "retention policy". Your business requirements should decide that.
You need to look into your "recovery window" and set it accordingly.
Search this forum/google/Oracle documentation for more information.
First hit from google.
http://www.ucertify.com/article/what-is-backup-retention-policy.html

Report message to a moderator

Previous Topic:	Unable to communicate with CRS services
Next Topic:	adding/extending datafile for tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 13 15:56:52 CDT 2025