Oracle Database 19c REFRESH using RMAN and DATA PUMP
#oracle #refresh #rman
Related Videos:
Oracle Database: ACTIVE Database DUPLICATION using RMAN
• Oracle Database: ACTIV...
How to establish a BASIC SQL Developer connection to an Oracle Database
• How to establish a BAS...
Oracle Database 11gR2 Migration/Upgrade to 19c using Data Pump
• Oracle Database 11gR2 ...
Follow me:
----------
LinkedIn: / atsohmofor
Twitter: / bindag OR @Bindag
email: bobsukki@gmail.com
Telegram: NI TSOH
RU-vid: / @bobsukki OR NI TSOH
RMAN Backup
-----------------------
RUN {
sql 'alter system archive log current';
BACKUP DATABASE FORMAT '/u01/stage/primdb/DB_%d_%p_%T_%s.rbkp' TAG FULLDB_BKUP;
BACKUP ARCHIVELOG ALL FORMAT '/u01/stage/primdb/ARCH_%d_%p_%T_%s.rbkp' TAG ARCHIVE_BKUP;
BACKUP CURRENT CONTROLFILE FORMAT '/u01/stage/primdb/CNTRL_%d_%p_%T_%s.rbkp' TAG CONTROLFILE_BKP;
BACKUP SPFILE FORMAT '/u01/stage/primdb/SPFILE_%d_%p_%T_%s.rbkp' TAG SPFILE_BKP;
}
RMAN refresh
-----------------------
RUN {
DUPLICATE DATABASE TO primtst
SPFILE
parameter_value_convert ('primdb','primtst')
BACKUP LOCATION '/u01/stage/primdb'
UNTIL TIME "TO_DATE('2022-02-25 18:15:00', 'YYYY-MM-DD HH24:MI:SS')"
NOFILENAMECHECK;
}
3 окт 2024