Some DBAs with very large databases back up the various datafiles over several runs.
Some DBAs back up the datafiles that contain data subject to frequent changes more
frequently (for example, daily), and back up datafiles containing more static data less
276 | Chapter 11: Oracle and High Availability
often (for example, weekly). There are commands to back up the control file as well;
this should be done after all the datafiles have been backed up.
If the database isn??™t archiving redo logs (this is known as running in NOARCHIVELOG
mode and is described in Chapter 2), youcan take only complete cold
backups. If the database is archiving redo logs, it can be backed up while running.
Regardless of backup type, you should also back up the INIT.ORA or SPFILE file
and password files??”these are key files for the operation of your Oracle database.
While not required, you should also back up the various scripts used to create and
further develop the database. These scripts represent an important part of the documentation
of the structure and evolution of the database.
Pages:
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604