Making User-Managed Backups

Making User-Managed Backups of Archived Redo Logs

To save disk space in our primary location, we may need to backup archived log file to tape drive or alternative disk.
if we have multiple archivelog location then only back up one copy of each log sequence number.

To back up archived redo logs:
To determine which archived redo log files that the database has generated

SELECT THREAD#,SEQUENCE#,NAME FROM V$ARCHIVED_LOG;

NOte: backup up copy of archivelog through OS utility.


Making Logical Backups with Oracle Export Utilities

Oracle import and export utilities move Oracle data in and out of Oracle databases. Export utilities write exported database objects to operating system files in an Oracle-proprietary format. Import utilities can read the files produced by export utilities and re-create database objects. Logical exports of data can be a useful supplement to physical database backups in some situations, especially in backing up recovery catalog databases.

There are two sets of Oracle database import and export utilities: Original Import and Export (which were used in previous releases(<= 10g) and Data Pump Import and Export (new for Oracle Database Release 10g). The Data Pump utilities offer better performance and more complete support of features of Oracle Database Release 10g.

Export
Import
Export Dump Pump


Making User-Managed Backups of Miscellaneous Oracle Files

Always back up initialization parameter files, networking and configuration files, and password files. If a media failure destroys these files, then you may have difficulty re-creating your environment. For example, if you back up the database and server parameter file but do not back up the networking files, then you can restore and recover the database but will not be able to authenticate users through Oracle Net until you re-create the networking files.

INIT PARAMETER FILES


Keeping Records of Current and Backup Database Files

One of the most important aspects of user-managed backup and recovery is keeping records of all current database files as well as the backups of these files. For example, you should have records for the location of the following files:

Datafiles and control files
Online and archived redo logs (note that online logs are never backed up)
Initialization parameter files
Password files
Networking-related files


Recording the Locations of Datafiles, Control Files, and Online Redo Logs


select name from v$datafile
union all
select name from v$controlfile
union all
select member from v$logfile;


Recording the Locations of Archived Redo Logs


SELECT NAME, VALUE
FROM V$PARAMETER
WHERE NAME LIKE 'log_archive_dest_%'
AND VALUE IS NOT NULL


Determine the format for archived logs by running SHOW as follows


SHOW PARAMETER LOG_ARCHIVE_FORMAT