NOTE: The user names and passwords referred to in this topic are ORACLE Database user names and passwords. Before performing this procedure, contact Customer Service to obtain this information.
1. Stop all daemon processes.
2. Log in as oracle.
3. When prompted, enter the ORACLE password that was set during the Workflow Manager installation.
4. Export the audit log files.
For example, to export the audit log files to audit.032303.dmp, type:
exp system owner=auditing file=/var/tmp/audit.032303.dmp log=/var/tmp/audit.032303.log compress=n buffer=20000000 feedback=10000
Enter system password when prompted.
5. Copy the exported audit log to a secure location and create a backup copy.
NOTE: After the audit_log table is truncated, you cannot retrieve the former contents after the next scheduled database backup runs.
1. Type: sqlplus system
2. Press Enter.
3. Enter the password when prompted.
4. Delete the current audit log entries from Online Storage Manager.
5. At the SQL> prompt, type: truncate table audit_log;
6. Press Enter.
NOTE: A truncate cannot be rolled back.
7. Exit sqlplus. Type: quit
8. Press Enter.
9. Start the daemon processes.
NOTE: An exported audit log can be imported into another instance of an ORACLE database, separate from the CARESTREAM PACS system. You can do this both for off-site backup and for off-line analysis by someone experienced in the use of applicable ORACLE Database tools and utilities. The Audit Viewer tool works only with the online Audit Log in the CARESTREAM PACS system.
1. Type: sqlplus
2. Press Enter.
3. Enter the user name and password when prompted.
4. To import the audit log files you must first drop the table.
CAUTION: Dropping the audit_log table deletes all data in the table. There is no undo. Perform this step only if the entire table must be cleared.
To drop the table, at the SQL prompt, type: drop table audit_log;
5. Exit sqlplus. Type: quit
6. Press Enter.
7. Import the audit log files. Type: imp file=audit.032303.dmp full=yes
8. Press Enter.
9. Enter the user name and password when prompted.
NOTE: Be sure to take proper care to ensure confidentiality and integrity on the exported data. If you clear the Audit Log after an export, the exported file is the only copy. It is important to exercise due diligence and ensure compliance with your organization's privacy and security policies.