Oracle exp imp backup and recovery of table space data

Oracle exp imp backup and recovery of table space data

Oracle backup is divided into logical backup and physical backup. Logical backup is exp/imp; physical backup includes cold backup, hot backup, and RMAN backup. Exp/imp has three modes: Table mode, user mode, and full database mode.

Oracle Import and Export expdp IMPDP details

Solution to Oracle 10g expdp export error ORA-4031

Oracle 10gr2 rac expdp error UDE-00008 ORA-31626

Use of expdp/impdp to back up databases in Oracle

1. Use exp/imp to back up the tablespace

Exp user/password @ server file = filefullpathname log = logfullpathname

For example, to export a table space with the username "bsm", password "forebsm", and sid "bsm", run the following command on Linux:

Exp bsm/forebsm @ bsm owner = bsm file =/home/bsm. ump log =/home/bsmexp. log

(Bsm/forebsm @ bsm

Username/password @ Instance name, the same below)

The backup file bsm. mmp will be generated in the directory/home.

2. Use exp/imp to restore the tablespace

Imp user/password @ server ignore = y rows = y full = y commit = y buffer = 4096000 file = filefullpathname

In the preceding example, the Linux platform command is as follows:

Imp bsm/forebsm @ bsm fromuser = bsm touser = bsm file =/home/bsm. ump log =/home/bsmimp. log

When porting tablespaces in two databases, you must note which database to create a tablespace must be greater than or equal to the tablespace in the original database. Otherwise, an error is returned.

Note: When exp/imp is used to recover data, you must first create a database in the three modes, then create a tablespace, create a user, and then use the statements described above to restore the database.