Essential Oracle Database Restore Commands: Step-by-Step Guide

Common Oracle database restore commands

Show current directory : pwd Remote copy : scp ics20140902_0200.DMP [email protected]:./hpdata Restart database :

lsnrctl stop

shutdown immediate;

startup;

Enter Oracle as sysdba : sqlplus "/as sysdba" Drop user : SQL> drop user hlj cascade; Create user and grant privileges :

SQL> create user hlj identified by hlj default tablespace users;

SQL> grant resource to hlj;

SQL> grant connect to hlj;

SQL> grant dba to hlj;

Create directory and grant access :

SQL> create directory HLJDIR as '/home/oracle/hpdata';

SQL> grant read,write on directory DUMPDIR to lh;

Import dump files :

impdp hlj/hlj DIRECTORY=DUMPDIR DUMPFILE=ics20140912_1408.DMP remap_schema=ics:hlj FULL=Y IGNORE=Y

(new database)

impdp hlj2/hlj DIRECTORY=HLJDIR DUMPFILE=ics20140919_0820.DMP remap_schema=ics:hlj2 TABLE_EXISTS_ACTION=REPLACE

(replace existing)