This action (filesToImport) is used to list the files needed to import the data between the given dates into the following supported tables:
SQL Server
HIST_EVENTS
HIST_CORRELATED_EVENTS
Note: The tables are imported in Oracle with the same name they are archived with.
If these files have been moved to another location since the original archiving operation (F, moved to tape), they must be restored to a directory accessible from the database server with their original file names.
This command uses the following flags:
-action |
filesToImport |
-tableName |
<table name> |
-startDate |
<mm/dd/yyyy hh24:mi:ss> |
-endDate |
<mm/dd/yyyy hh24:mi:ss> |
-connectFile |
<filePath> |
Note: hh24 is hours represented in 24 hour format. For example, 1:15:00 p.m. is 13:15:00 and 3:00:00 a.m. is 03:00:00.
To run filesToImport:
Execute this command as follows:
-action filesToImport -tableName <table name> -startDate <mm/dd/yyyy hh24:mi:ss> -endDate <mm/dd/yyyy hh24:mi:ss> -connectFile <filePath>
The following example lists all files containing data between dates "09/25/2007 00:00:00" (Sep 25th midnight) and "09/26/2007 00:00:00" (Sep 26th midnight) that have been previously archived.
Oracle Example:
./sdm action filesToImport -tableName Events startDate 09/25/2007 00:00:00 endDate 09/26/2007 00:00:00 connectFile sdm.connect
SQL Server Example:
sdm action filesToImport -tableName Events startDate 09/25/200\7 00:00:00 endDate 09/26/2007 00:00:00 connectFile sdm.connect
The following example lists all the files containing the data between dates "09/25/2007 16:00:00" (Sep 25th 4 PM) and "09/26/2007 18:00:00" (SEP 26, 6 PM) that has been archived earlier and can be imported back.
Oracle Example:
./sdm action filesToImport -tableName Events startDate 09/25/2007 16:00:00 endDate 09/26/2007 18:00:00 connectFile sdm.connect
SQL Server Example:
sdm action filesToImport -tableName Events startDate 09/25/2007 16:00:00 endDate 09/26/2007 18:00:00 connectFile sdm.connect