逻辑备份：

col scn for 999999999999999

select current_scn as scn from v$database;

expdp  bkadmin/bkadmin  directory=mppdump dumpfile=mes_innoprod_%U_20230913.dmp filesize=5120M logfile=expdp_mes_innoprod_20230913.log flashback_scn=xxxxxx schemas=innoprod parallel=2 cluster=N compression=all  job_name=my_job1

RMAN备份：

rman target / log=/home/oracle/mppdump/mes_full_20230913.log

run{

allocate channel ch01 device type disk;

allocate channel ch02 device type disk;

allocate channel ch03 device type disk;

allocate channel ch04 device type disk;

backup as compressed backupset incremental level=0 database format '/home/oracle/mppdump/%d_db_%s_%p_%T' tag backup_db_level0;

sql 'alter system archive log current';

sql 'alter system archive log current';

#backup archivelog all

backup as compressed backupset archivelog all format '/home/oracle/mppdump/al_%d_%T_%U' tag backup_archive_log0;

release channel ch01;

release channel ch02;

release channel ch03;

release channel ch04;

#backup controlfile 2

allocate channel ch00 device type disk;

backup current controlfile format '/home/oracle/mppdump/ctl_%d_%T_%U_2';

release channel ch00;

}