Description summary Oracle Data Collection

Before giving you a detailed introduction to Oracle Data Collection, let's first understand why data collection exists, and then give a comprehensive introduction to Oracle data collection. With the development of society, various large databases are also widely used by audited organizations. Collecting the data we need from large data has become a task for auditors. I have summarized some experiences from the data collection experience and shared them with you.

Oracle Data Collection

Oracle Data Collection generally adopts two methods:

The first method is the backup method, that is, using Oracle's logical backup and restoration function ExpImp) to back up the data and restore it locally;

The second method is direct connection, that is, using ole db or ODBC to directly connect to the Oracle database and export data.

1) backup method: fully utilizes Oracle's support for data backup and restoration across operating systems.

The first step is to back up all or part of the database using Oracle's logical backup Function Exp. It is a file suffixed with dmp. If there is a log, is a file with the suffix log. The operation is as follows: exp system/manager @ sjsjjj owner = system file = c :. dmp log = c :. the preceding log command is used to export all the data under the user system in the database sjsjjj, and export the file location and file name c :. dmp, Log File Location and file name c :. log.

Step 2: The auditor should install the Oracle database software version on his computer, preferably the same as the Oracle database version of the audited Organization) and create relevant users. Restore the database by using Oracle logical restoration feature Imp on your computer. The operation is as follows: imp system/sys @ sjsjjj fromuser = system to user = aa file = c :. the above dmp commands mean: From the file c :. in dmp, all data under user system is imported to user aa in database sjsjjj. Because the ExpImp command has many parameters, it is not described one by one. You can use the exp help = y or imp help = y command to understand the usage of the ExpImp command parameters, such as how to import and export some tables, and how to import and export only data rows, ignore other information ).

Auditors can also use the PL/SQL Developer tool, which also provides the logical backup and restoration functions of the Oracle database, and is a graphical interface without entering commands, convenient for auditors. After completing the above work, the remaining thing is to import the data from Oracle on the local machine to the database used by the Auditor, taking SQL Server as an example), the operation method is the same as 2) direct connection method, this is omitted.

Note: The audited organization is required to provide the log files for logical backup. There are several advantages: first, the character set used by the database; and second, the ability to initially understand which tables are in the database; third, the number of records for each table is provided in the log, which helps us to check the data when it is imported into other databases.

2) Direct Connection: You can directly connect to the Oracle database through ole db or ODBC, making full use of the management resources of the audited organization.

The audited organization generally does not directly operate the Oracle database on the server. It usually sets up one or more client management machines, installs and configures the Windows operating system and the Oracle client software on the management machine, enabling Oracle Database Maintenance and Management provides auditors with another way to collect Oracle data.
◆ The auditee is required to provide a computer with the Oracle client installed and able to access the Oracle database on the server.
◆ Install a database software on this computer. This document uses SQL Server as an example.
◆ Open the SQL Server Import and Export wizard. In the Select data source step, select Oracle Provider for OLE DB or Microsoft OLE DB Provider for Oracle as a data driver provided by Microsoft, one is the data driver provided by Oracle. There is no big difference in usage). Click "properties" on the page and enter the connection information.

In the enter Server Name box, enter the name of the database to be connected, for example, sjsjjj, the database that is restored locally. In the input database information, enter the user name and password, for example, the user aa and password aa mentioned above. Click "test connection" to check whether the connection is successfully established. The remaining steps are the same as general data import and export.

1. Analysis and Discussion on Oracle Database Restoration
2. Oracle remote disk image
3. New Oracle 11g function display
4. Detailed analysis of Oracle XML data
5. Oracle Data Guard