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
=============================================
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
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন