Oracle 9i Backup. ARCHIVELOG vs. NOARCHIVELOG mode User-managed backups: Logical vs. Physical Export utility Whole and Partial backups Hot and cold backups. Noarchivelog Mode vs. Archivelog Mode. Source: http://www.adp-gmbh.ch/ora/concepts/backup_recovery/archive_vs_noarchive_log.html.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
ARCHIVELOG vs. NOARCHIVELOG mode
User-managed backups: Logical vs. Physical
Whole and Partial backups
Hot and cold backups
(This information is from the following documentation: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96572/intro.htm#433631 )
More on using the Export and Import utilities: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1004671
SQL> ALTER TABLESPACE BEGIN BACKUP
Oracle stops recording checkpoints to the tablespace's datafiles.
copy datafiles in that tablespace on OS level
SQL> ALTER TABLESPACE ... END BACKUP (or ALTER DATABASE END BACKUP)
SQL> ALTER TABLESPACE tablespacename OFFLINE
Recovery Manager (RMAN)