One FSID with two storage pool

[nikhil_1707]

Hi Team,

I need to move the data of Oracle or delete the data but have some doubt.

The Oracle team is having challenge to delete the old data of Oracle data so We thought to rename the filesystem to old and delete from TSM after 30 days but it have monthly data.

Please have a look of occupancy below.


tsm: GURAPP98_SERVER1>q occ GURAPP125

Node Name Type Filespace FSID Storage Number of Physical Logical
Name Pool Name Files Space Space
Occupied Occupied
(MB) (MB)
---------- ---- ---------- ---- ---------- ----------- ----------- -----------
GURAPP125 Bkup /db 3 ORACLE_ST- 493,871 772,365.56 772,305.88
ORAGE_PO-
OL
GURAPP125 Bkup /orc9_db 1 ORACLE_MO- 31 291,126.06 291,126.03
NTHLY_PO-
OL
GURAPP125 Bkup /orc9_db 1 ORACLE_ST- 1,253 55,723,028. 55,723,028.
ORAGE_PO- 00 00
OL


The Monthly storage pool has data with same FSID number and if I delete the other pool data it will delete the monthly also.

I need your suggestion here

Thanks

Nikhil

 

[marclant]

Typically, Oracle backups are deleted using RMAN, can't they delete the backups that are no longer needed (now or in 30 days).

If you delete the filespace, you are right you are deleting all the data in that filespace, no option to pick and choose.

If the data you want to delete is in a different storage pool than the data you want to keep, then you may have some options. You could create a new storage pool (with no next pool) and do a move nodedata: move nodedata {nodename} FROMstgpool={currentpool} TOstgpool={newpool}. In 30 days, delete that new pool.

 

[fidel]

As said marclan you cannot delete RMAN data.
Ask your DBA to delete those data thru RMAN script ("delete obscolete" command). When done the expiration process will delete data from server side.

 

[nikhil_1707]

Hi Marclant,

Oracle team are tellimg that they are expiring the data through RMAN but on TSM I can see old objects which are still active .

We have around 55 TB of data so what I thought that if I rename the filesystem to old than after next 30 days I will delete this filesystem and will get 55 TB of data.
But when I see that the same file system has Monthly backup also which has retention of one year then feel impossible to do that as we need monthly data.

As you suggested that we can move the monthly nodedata but will it change the filespace also ?

Regards,

Nikhil

 

[fidel]

The best way to recover space from objects already deleted on RMAN side is to use tdposync utility.
see
https://www.ibm.com/support/knowled...bm.itsm.db.orc.doc/r_dporc_util_tdposync.html

 

[nikhil_1707]

There is no deletion of object.
We need to delete the filespace of oracle storage pool excluding the Monthly pool but they have same filespace name so need some suggestion

 

[fidel]

There is no deletion of object.
We need to delete the filespace of oracle storage pool excluding the Monthly pool but they have same filespace name so need some suggestion

I didn't understand, what you mean by "there is no deletion of object" ? Have you try tdposync ?
If, as you said, the DBA have expired data in the RMAN catalog, those data should be expired on TSM.
If it's not the case, tdposync will do it for you.

 

[nikhil_1707]

It is not happening , no idea if they have ran the script or not.

There is a new command which is implemented in IBM Spectrum Protect is

DEACTIVATE DATA GURAPP40 todat=10/30/2015

I used that and it ran fine

12/24/2015 14:46:55 ANR2017I Administrator ADMIN issued command: DEACTIVATE
DATA GURAPP40 todat=10/30/2015 (SESSION: 1)
12/24/2015 14:46:55 ANR3349W DEACTIVATE DATA: This command will deactivate
data. Active backup files that were created for the
specified node on the deactivation date or earlier will
be deactivated. (SESSION: 1)
12/24/2015 14:46:57 ANR0984I Process 8 for DEACTIVATE DATA started in the
BACKGROUND at 14:46:57. (SESSION: 1, PROCESS: 8)
12/24/2015 14:46:57 ANR3345I Process 8 was started to deactivate data for node
GURAPP40. (SESSION: 1, PROCESS: 8)
12/24/2015 14:46:57 ANR0987I Process 8 for DEACTIVATE DATA running in the
BACKGROUND processed 37 items with a completion state of
SUCCESS at 14:46:57. (SESSION: 1, PROCESS: 8)
12/24/2015 14:50:48 ANR2017I Administrator ADMIN issued command: DEACTIVATE
DATA GURAPP66 todat=10/30/2015 (SESSION: 1)

 

[fidel]

It is not happening , no idea if they have ran the script or not.

There is a new command which is implemented in IBM Spectrum Protect is

DEACTIVATE DATA GURAPP40 todat=10/30/2015

I used that and it ran fine

12/24/2015 14:46:55 ANR2017I Administrator ADMIN issued command: DEACTIVATE
DATA GURAPP40 todat=10/30/2015 (SESSION: 1)
12/24/2015 14:46:55 ANR3349W DEACTIVATE DATA: This command will deactivate
data. Active backup files that were created for the
specified node on the deactivation date or earlier will
be deactivated. (SESSION: 1)
12/24/2015 14:46:57 ANR0984I Process 8 for DEACTIVATE DATA started in the
BACKGROUND at 14:46:57. (SESSION: 1, PROCESS: 8)
12/24/2015 14:46:57 ANR3345I Process 8 was started to deactivate data for node
GURAPP40. (SESSION: 1, PROCESS: 8)
12/24/2015 14:46:57 ANR0987I Process 8 for DEACTIVATE DATA running in the
BACKGROUND processed 37 items with a completion state of
SUCCESS at 14:46:57. (SESSION: 1, PROCESS: 8)
12/24/2015 14:50:48 ANR2017I Administrator ADMIN issued command: DEACTIVATE
DATA GURAPP66 todat=10/30/2015 (SESSION: 1)

Thanks for this information, I don't use IBM Spectrum Protect (I will plan to upgrade).
The "deactivate data" command you entered delete data backuped before 10/30, also in the monthly pool.
Is it really what you want to do ?

 

[nikhil_1707]

Yes Fidel, it has deactivated the Oracle data and will expire once it suffice the retention policy that is 30 days.