Can you suggest some other tool or facility which will give ILM Assistant like features?
We want to archive data on date basis. ILM Assistant does not provide archiving solution. Is there any other tool available for the same?
Oracle does not offer a specific archiving tool although depending on how you want to archive the data you can build something using tools like Oracle Warehouse Builder.
Otherwise there are several popular Archiving products available such as Princeton Softech, Solix, Applimation and Outerbay which is now called HP RIM. These products are often used for packaged applications such as Oracle E-Business Suite because archiving routines for these applications have already been written.
Oracle has two solutions for archiving.
One is DBFS HSM. Oracle SecureFiles provide fast and file storage on an Oracle database. DBFS provides a file system interface to SecureFiles data. DBFS HSM store allows archiving and transparent recall of SecureFiles data to tape. See http://www.oracle.com/technetwork/database/features/secure-files/dbfs-sf-oow2009-v2-160969.pdf for more info. SecureFiles can be coupled with Oracle's Enterprise Content Management suite so that the content can be automatically stored, and recalled when necessary, on tape.
The other is Storage Archive Manager. SAM presents a file interface and any files written to and stored on SAM can be managed in a multi tiered storage environment which also provides multi-tier transparent archiving. See http://www.oracle.com/us/products/servers-storage/storage/storage-software/031715.htm for more info. SAM can be coupled with Oracle's Enterprise Content Management suite so that the content can be automatically stored, and recalled when necessary, on SAM.