Oracle Data Quick Backup Recovery

xiaoxiao2021-03-06  33

The old post of the Ktop version of the space, was found, and the method was more old, but there is a benefit to deal with it can be easily integrated into the program to quickly back up the ORANT / BIN. Exp80.exe in the directory, for example, you want to back up all Table in the Scott User database to the C: /Bak.dmp file, the instructions are as follows: Exp80 system / manager @ service = c: /bak.dmp where System is SYSTEM Login Name, Manager for PasswordService_name is the service name set in Oracle Net8 Easy Config, Scott is very fast for the user's backup movement of Database.

Restore the ORACLE's backup data Restore method In / ORANT / BIN directory to execute IMP80.EXE, for example, to restore C: /Bak.dmp within the Scott User database, the instructions are as follows: IMP80 system / manager @ service_name Owner = Scott File = C: /BAK.DMP wherein the system is login name, manager for passwordService_name is the service name set in Oracle Net8 Easy Config, Scott is very fast for Database, which is very fast, and remember to make the database first. Clear, you can use the removal user scott to rebuild the user's method to empty

转载请注明原文地址:https://www.9cbs.com/read-64965.html

New Post(0)