Backup and upgrade of Oracle database

The server where the Oracle user logs on to the database, such as home directory/home./oracle. Execute the following command to perform a backup operation.

Sqlplus/nolog

Connect/as SYSDBA

Sql>createdirectory DUMP_BX as ' specifies a directory where DMP files are stored ';

Sql>grantread,write the user name on the directory DUMP_BX to boss database;

Sql>exit

ORACLE>EXPDP Boss Database user name/password directory=dump_bxdumpfile=boss1220.dmp logfile=out_boss1220.log schemas = The user name of the boss database;

Here is a sample of the export we are developing, for reference:

Sqlplus/nolog

Connect/as SYSDBA

Sql>createdirectory dump_bx as '/home/oracle/db_backup20140715 ';

Sql>grantread,write on directory dump_bx to boss0923;

Oracle>expdpboss/bossnyl directory=dump_bx dumpfile=boss20140715.dmp Logfile=in_boss20140715.log schemas= boss0923;

Assuming that the script file to be upgraded has been uploaded to the database server, the script file is inside the package update_db.zip and stored in the directory update_db20140715. Execute the following command to upgrade

$ cd/home/oracle/update_db20140715

$ unzip–o Update_db.zip

$ CD update_db

$ export Export Nls_lang=american_america. UTF8

$ sqlplus "username/password"

> @UPDATE. sql

>exit