How to take entire oracle db schema backup
Jun 16, 2011
2:03 AM
Labels: .dmp , backup , expdb , export database , oracle , oracle database backup , schema
Labels: .dmp , backup , expdb , export database , oracle , oracle database backup , schema
Q. How to take entire oracle schema backup in UNIX using terminal?
There are very few simple steps to take entire db schema backup.
1. Create one physical directory in your Unix node where you want to take backup.
mkdir /tmp/my_backup_dirGive read/write/execute permission to this directory.
chmod 777 my_backup_dir2. Now map this physical directory to one logical directory of oracle. For this step you have to login to the sqlplus terminal with DB admin access.
CREATE OR REPLACE DIRECTORY logical_dir as '/tmp/my_backup_dir';
