业务软件系统升级前数据库备份

逻辑备份： 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; }