Common Database Restore commands

1. Show current directory
Pwd

2 Remote Replication
SCP ics20140902_0200.dmp [Email protected]:./hpdata

3 Restarting the database
LSNRCTL stop;--Monitoring Service stopped
Shutdown immediate;
Startup

4 Entering Oracle
Sqlplus "/as sysdba"

5 Delete User
Sql>drop user HLJ Cascade;

6 Build Users
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;

7 Building the Catalogue
Sql>create directory Hljdir as '/home/oracle/hpdata ';
Sql>grant read,write on directory Dumpdir to LH;

8 Importing libraries
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 database

Common Database Restore commands