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