逻辑备份：
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;
}
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/70031606/viewspace-2982824/ ，如需转载，请注明出处，否则将追究法律责任。
