Full backup of the Oracle database and recovery on another computer

Source: Internet
Author: User
Tags mssql

because of the recent Oracle project, you need to put the database in another computer to configure the same database to test the development, before the use of MSSQL, only need to attach or restore the line,
But in Oracle, it's not that simple, but it's not that hard, but the operation is as follows:

1. Inside the server computer: Start-run-cmd and then go to a relatively large disk and directory, do the following: Exp database username/password file= generated file name. DMP log= log. DMP Full=y
This will generate a DMP file in the directory you entered, and copy the database file and the database journal file to the computer where the Oracle database is attached.

2. Install Oracle, version of the best with your server to build the same user, and the same company, permissions, table space, and so the best also, save the time to import trouble

3. On the need to add Oracle database on the computer: cmd under the directory you copied, execute: IMP database username/password file= before exported file name log= log full=y ignore=y

Summary: It feels like this method is similar to the detach-and-attach method in MSSQL. And the operation is very simple, but if the amount of data is relatively large, it is not very recommended to use this method, the feeling is relatively slow. There was no MSSQL separating, attached so quickly,
Cold backup is much faster if you want to pursue speed. You can go to the mother to check, this is very simple. Find the corresponding folder, copy, paste, OK. But I heard there would be danger.
(younger brother is the first brother, hope expert guidance.) )

Full backup of the Oracle database and recovery on another computer

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.