Tuesday, February 18, 2014

adrci reports and error DIA-48448: This command does not support multiple ADR homes

I was trying to purge data using adrci and getting error below.
adrci> purge -age 240
DIA-48448: This command does not support multiple ADR homes
adrci>
It is good to know that the purge can be done on one home at a time and for that you need to set the home first and then you will do it
adrci> show homes
ADR Homes:
diag/rdbms/rac/RAC1
diag/tnslsnr/rac1/listener
diag/asm/+asm/+ASM1
adrci> set HOME diag/rdbms/rac/RAC1
adrci> show homes
ADR Homes:
diag/rdbms/rac/RAC1
adrci> purge -age 240
adrci> 

Note:
Command to show current purging policy is

show control
show control will  have a parameter SHORTP_POLICY and LONGP_POLICY these are number of hours.

But purge -age 240 . Here 240 is number of Minutes.

Be cautious.

No comments: