About ArchivePlus | Contact Us

1. What are the pre-requisites of the application?

Following requirements must be fulfilled before installing the ArchivePlus Application:

 

System Requirements

• Oracle Client or MS SQL Server
• Operating System: Microsoft Windows 2000 / Microsoft Windows 2000 Server/Microsoft Windows 2003 Server / Microsoft Windows XP / Microsoft Vista

Application Requirements

• Application Database entry must be there in TNS.ORA in client machine.
• The Application user should have rights to create/drop Tables and Database links and triggers on application database and target database
• The Application can be accessed with Administrator Access Level during the first run.

2. Who can use this Application?

Any DBA or super user who has enough admin rights on both source and target database can use this application.

3. Does the archiving take care of relationships of the tables in the database?

Yes, Application takes care of the constraints and relationships that are already there in the table(s) for each child and parent, we can also add relationship soft-coded without really adding relations physically.

4. Can the same version run more than one time?

Yes, we can run the same version more than one time for archiving with different instances.

5. What should I know before using this application? Some training is required?

The user must know the basics of RDBMS and should be familiar with Query Structures. No special training is required; the application is self explanatory with help.

6. What if I don't have a target database?

If there is no target database then the user can use XML files as storage and access the archived data back from those files whenever required

7. Is the data transferring secure?

Yes it is secured as Oracle takes care of the transfer itself giving it a shield of its own security.

8. Under what circumstances data can be compromised?

1. If the access to the source / target is compromised.
2. Generated XML files are let loose on the disk.
3. Sniffing while transferring non-encrypted xml files on the network.

9. Will all the parent/child tables also be archived/purged/restored?

Yes, depending upon the relationships the parent and/ or child will be archived/restored.

10. Can I add a relationship that does not exist on the database?

Yes, we can also add non-existing relationships to take the backup of the database without really affecting database, as we do not create hardcore relationship instead we make soft coded one.

11. What if I add new relationship and the definition is older one?

Any change in the relationship will be automatically reflected.

12. Can we use it across remote servers?

Yes, it is ready to be used across anywhere on the remote database to which Oracle can talk.

13. Is there a facility to know whether the archived data has been tampered?

Yes we can know whether the data has been tampered through logging which will be enabled as soon as it is connected to target database.

14. Can there be more than one running instance on the same table?

No, the table to be archived will be locked and will not be available for other purposes.

15. What all do I need to start using the application?

All you got to do is install the application using help given in the manual and then start working.

16. Can I see the preview of the data that will be archived/purge before really archiving/purging the same?

Yes there is a preview of data before archiving/purging, it allows user to see the total count as well as top 20 records that will be archived.

17. Can I also see the child / parent table records preview?

Yes, each table will be shown on a separate instance for top 20 records with the number of records.

18. Can I ignore some data within the included data definition?

Yes, creating an exclusion rule on an already created definition will ignore chunk of data that is not meant to be operated.

19. Can the tool be scheduled to run on its own?

Yes, we have a scheduler defined that will take care of the same.