পৃষ্ঠাসমূহ

এই ব্লগটি সন্ধান করুন

রবিবার, ২৪ সেপ্টেম্বর, ২০১৭

Oracle Full Database Backup Process

full db backup from 224 in NBR Test machine:
=============================================
mkdir backups
ll
[oracle@biserver backups]$ pwd
/u01/backups

SQL> conn sys as sysdba
Enter password:
Connected.
SQL> create directory data_pump_bkup as '/u01/backups';

Directory created.

SQL> grant read, write on directory data_pump_bkup to system;

Grant succeeded.

SQL> grant exp_full_database to system;

Grant succeeded.

SQL> select directory_path from dba_directories;

DIRECTORY_PATH
--------------------------------------------------------------------------------
/u01/backups
/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/xml
/u01/app/oracle/product/11.2.0/dbhome_1/ccr/hosts/biserver.spectrum-bd.com/state
/u01/data/bidata/data_pump_dir
/u01/app/oracle/product/11.2.0/dbhome_1/ccr/state


expdp system/secl2015 directory=data_pump_bkup dumpfile=full_db_export_23092017.dmp logfile=full_db_export_log_23092017.log full=y

কোন মন্তব্য নেই:

একটি মন্তব্য পোস্ট করুন