smallwei
7:37 pm on June 8, 2010 |
Answers: 1
Tags: backup (8), data (36), database (51), export (5), import (23) 
Loading ...How to Backup and Restore Oracle database using Data Pump or Export/Import
It is always a good idea to have a backup method to backup your data. RMAN can be the primary tool. You can consider using Oracle Data Pump or Export/Import as the backup method depending on how much activities you have on your database.
This article will talk about how you can use Data Pump or Export/Import to backup and restore your database.
Two Simple Commands to Export and Import (backup and Restore) mysql Database
Step by Step Tutorial on How to Use Oracle Data Pump Export and ImportHow to Check/View/Show Oracle Data Pump Directory PathHow to Properly Kill, Stop, Delete or Clean Up Oracle Data Pump JobsResolve ORA-39000 ORA-31619 ORA-17500 Errors when Using Oracle Data Pump
smallwei 7:37 pm on June 8, 2010
It is easy to do the full database backup. You just the the following commands (Data Pump is recommended):
- To backup
Export method:
exp "sys/password@SID as sysdba" full=y file=SID_full_timestamp.dmp consistent=yData Pump method:
expdp "sys/password@SID as sysdba" full=y DIRECTORY=dpump_dir1 JOB_NAME=hr file=SID_full_timestamp_%u.dmp PARALLEL=8(make sure you create directory first)To restore using the dump file is a little tricky. In case you lost your database and you need to restore it using the dump file, follow the steps below:
1. Create a brand new database instance using Oracle Database Assistant tool. Use the same database SID (optional).
2. Use the following command to restore your database:
Import method:
imp "sys/password@SID as sysdba" full=y file=SID_full_timestamp.dmp ignore=yData Pump method:
impdp "sys/password@SID as sysdba" full=y DIRECTORY=dpump_dir1 JOB_NAME=hr file=SID_full_timestamp_%u.dmp PARALLEL=8 TABLE_EXISTS_ACTION=SKIP(make sure you create directory first)Hope this is useful!