Common Database restoration commands and restoration commands

Common Database restoration commands and restoration commands

1. display the current directory
Pwd

2. remote replication
Scp ics20140902_0200.DMP oracle@10.10.16.40:./hpdata

3. Restart the database
Lsnrctl stop; -- the listening service is stopped.
Shutdown immediate;
Startup;

4. Go to Oracle
Sqlplus "/as sysdba"

5. delete users
SQL> drop user hlj cascade;

6. User Creation
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. Create a directory
SQL> create directory HLJDIR as '/home/oracle/hpdata ';
SQL> Grant read, write on directory DUMPDIR to lh;

8 Import to Warehouse
Impdp hlj/hlj DIRECTORY = dumpdir dumpfile = ics20140912_1408.DMP remap_schema = ics: hlj FULL = y ignore = Y -- create a database
Impdp hlj2/hlj DIRECTORY = hljdir dumpfile = ics20140919_081_dmp remap_schema = ics: hlj2 TABLE_EXISTS_ACTION = REPLACE -- REPLACE an existing database

What is the SQL database backup and restoration command? How to use it? Urgent !!!

Restore database name from disk = 'backup location'

Www.baidu.com/baidu? Word = RESTORE + DATABASE
Reference: www.baidu.com/baidu? Word = RESTORE + DATABASE

How can I use commands to back up and restore an Oracle database?

Exp and imp. For more information, see the Oracle documentation.