OracleBackup & recovery
Guaranteed restore point for a release
Create one before a risky change so you can flash the whole database back. Drop it as soon as the change is signed off.
Not yet verified. How scripts are tested
1-- Before the change2CREATE RESTORE POINT before_release GUARANTEE FLASHBACK DATABASE;3 4-- After the change is confirmed good (run separately)5-- DROP RESTORE POINT before_release;Save it as ora-restore-point.sql and run it with SQL> @ora-restore-point.
More Oracle scripts: Backup & recovery
- RMAN backup history with run time in hoursRun in the target database as SYSDBA, not the recovery catalog. The first report lists every RMAN job (full, incremental and archivelog) with start,…
- RMAN backup jobs in the last 7 daysStatus, duration and output size of each RMAN job, newest first.
- Running RMAN job progressPercent complete and time remaining for each RMAN channel that's working right now.
- Datafiles without a recent backupDatafiles with no backup of any kind in the last two days, or none at all. A new datafile added after the last full backup shows up here first.
- RMAN configuration (non-default settings)The persistent CONFIGURE settings stored in the control file, the same list SHOW ALL marks as changed. Check retention and control file autobackup…
- Fast Recovery Area usageFRA size, used and reclaimable space, then what's using it by file type. Real used % is the number that matters: at 100% the database stops archiving…