Database Reference
In-Depth Information
Backups taken in the good time or when the database is up and
running perfectly fine really help in time of failure or when files
get corrupted. It's exactly like what they say, “Make Hay While
the Sun shines”.
User-Managed Online/Offline Backup
We are starting the discussion with User Managed path. Using
the User-Managed path we can do both Oracle database backup
as well as recovery. Let's first start with learning User-Managed
Backups. User-Managed Backups can be taken either by first
making the database “offline” or even when the database is up
and running. The steps of implementation are different in both
the cases.
Figure 10-2: Zoomed area of Figure 10-1 with focus on User-Managed
online/offline backup. User-Managed Backups can be taken when the
database is SHUTDOWN NORMAL or even when it's running. There
is a difference between Restore & Recovery. Restore basically means
putting the stuff back from backed up location to original location using
OS level copy command. Recovery process is performed after the
Restoration of data files from backed up location to original location
happens. Recovery process is a must if the backup was an online/hot
backup.
Search WWH ::
Custom Search