I have a questions regarding RMAN restores, will my RMAN backup restore all datafiles and archived redologs using the restore, recover database. This will only bring my database to when I took the last backup.
Are online logs that have not been archived included in this type of restore or only if I do a Point in Time restore. Until sequence ____, thread____?
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…