Oracle DBA Tips and Techniques

By Arjun Raja

DSMC – RETAIN FOR 2 YEARS AND QUERY MANAGEMENT CLASS

Posted by Arjun Raja on December 1, 2009

To query the MANAGMENT CLASS set up for your machine by the TSM administrator –

dsmc q mgmt

Domain Name : XXXUNIX
Activated Policy Set Name : STANDARD
Activation date/time : 05/11/09 13:16:54
Default Mgmt Class Name : STANDARD
Grace Period Backup Retn. : 30 day(s)
Grace Period Archive Retn.: 730 day(s)

MgmtClass Name : XXXXXXX_DB
Description : Dont include in daily incremental

MgmtClass Name : RETAIN2YEARS
Description : Retention period of Two Years

ON XXXXXX –

cd $COMMON_TOP/admin/out/XXXXXX

dsmc archive -archmc=RETAIN2YEARS -description=”ebus_logs”
“/u01/fXXXXX/finXXXXX/admin/out/XXXXXX/*.*” -su=yes > EBUS_COPY.logs

cd $COMMON_TOP/admin/log/XXXXXX

dsmc archive -archmc=RETAIN2YEARS -description=”ebus_admin_logs” “/u01/XXXX/XXXXXcomn/admin/log/XXXXXXX/*.*” -su=yes > EBUS_ADMIN_COPY.logs

On XXXXXXX – 2 YEARS RETENTION.

cd /u01/XX/XX/admin/log/XXXXX

nohup dsmc archive -archmc=ARCY2 -description=”ebus_web_admin_logs” “/u01/fXX/fXXn/admin/log/XXX/*.*” -su=yes > EBUS_WEB_ADMIN_COPY.logs &

To query archived files –

dsmc query archive -description=”ebus_web_admin_logs” “/u01/fXX/fXXn/admin/log/XXX/*.*” -su=yes > archived_files.logs

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: