oracle 创建备份用户,【oracle】创建一个使用expdp备份其他用户的backup用户

数据库版本：11.2.0.4；系统版本：Oracle Linux6.4https://www.cndba.cn/debimeng/article/3124

CREATE TABLESPACE BACKUP_DATA DATAFILE

'+RACASMGROUP/rac/datafile/backup_data1.ora' SIZE 4096M

LOGGING ONLINE PERMANENT BLOCKSIZE 8192

EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT

NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;

—创建用户

https://www.cndba.cn/debimeng/article/3124

CREATE USER backup IDENTIFIED BY back_123

ACCOUNT UNLOCK

DEFAULT TABLESPACE BACKUP_DATA

TEMPORARY TABLESPACE TEMP;

https://www.cndba.cn/debimeng/article/3124https://www.cndba.cn/debimeng/article/3124

GRANT CONNECT,RESOURCE TO backup;

create directory DUMP_BACKUP1 as '/oracle/backup/backup/1';

create directory DUMP_BACKUP2 as '/oracle/backup/backup/2';

create directory DUMP_BACKUP3 as '/oracle/backup/backup/3';

create directory DUMP_BACKUP4 as '/oracle/backup/backup/4';

create directory DUMP_BACKUP5 as '/oracle/backup/backup/5';

create directory DUMP_BACKUP6 as '/oracle/backup/backup/6';

create directory DUMP_BACKUP7 as '/oracle/backup/backup/7';

grant read,write on directory DUMP_BACKUP1 to backup;

grant read,write on directory DUMP_BACKUP2 to backup;

grant read,write on directory DUMP_BACKUP3 to backup;

grant read,write on directory DUMP_BACKUP4 to backup;

grant read,write on directory DUMP_BACKUP5 to backup;

grant read,write on directory DUMP_BACKUP6 to backup;

grant read,write on directory DUMP_BACKUP7 to backup;

—授权有备份其他用户的权限

https://www.cndba.cn/debimeng/article/3124

grant exp_full_database,imp_full_database to backup;

grant flashback any table to backup;

grant select any table to backup;

版权声明：本文为博主原创文章，未经博主允许不得转载。

expdp备份用户