Oracle backup and Restoration

I. Backup is divided into physical backup and logical backup.

1. Physical backup is a backup of physical files (including data files, control files, and redo log files. Physical backup is further divided into hot backup/online backup and cold backup/offline backup.

2. Logical backup refers to export the database's logical objects (such as tables and stored procedures) to a binary file, which is usually a dmp file. Import the file to the target database. This method is commonly used export/import to implement oracle backup and restoration.

My current requirement is as follows: Move the oracle9i database of machine A to the oracle9i server of machine B.

So I tried to use the oracle 9i export/import tool to move the database. However, such problems always occur in this process. Now let's talk about my operation process.

II. Environment:

OS: Windows XP

DB: Oracle 9i

3. Export and import processes

Export: exp system/manager @ TEST file = d: daochu. dmp full = y. No warning or error is reported during this process.

Import: Create a new database named TEST2 on the target machine. Then run imp system/aichannel @ TEST2 full = y file = daochu. dmp ignore = y on the command line. For testing, I continuously import different databases into new databases. I found that different databases always report such warnings or errors during import. Obviously, this is unacceptable. After the import, it is very painful for me to correct the errors during the import process.

Why does this problem occur? Is the name of the source database different from that of the target database? Is the password of the system in the source database different from that in the target database? Or is it difficult to use the export tool for oracle import? Or is there a problem with my operations? Of course, the first two are unlikely.