Skip to main content

Available backup options in an Oracle Database

Backup and recovery is one of the most significant aspects of a DBA’s job. Usually one would schedule a hierarchy of daily, weekly and monthly backups, however consult with your users before deciding on a backup schedule.

An Oracle Database has following backing-up options. There are


  1. Export/Import – Exports are “logical” database backups in that they extract logical definitions and data from the database to a file. 
  2. Cold or Off-line Backups – Shut the database down and backup up ALL data, log, and control files.
  3. Hot or On-line Backups – If the database is available and in ARCHIVELOG mode, set the tables spaces into backup mode and backup their files. Also remember to backup the control files and archived redo log files.
  4. RMAN Backups – While the database is off-line or on-line, use the “rman” utility to backup the database.


Note that to use more than one of these methods to backup your database. For example, if you choose to do on-line database backups; also cover yourself by doing database exports. Also test ALL backup and recovery scenarios carefully. It is better to be safe than sorry.

Regardless of your strategy, also remember to backup all required software libraries, parameter files, password files, etc. If you database is in ARCHIVELOG mode, you also need to backup archived log files.


Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

ORA-01033 Oracle initialization or shutdown in progress

ORA-01033 Oracle initialization or shutdown in progress When you connect oracle 12c plug gable database, Thus time you have get oracle initialization or shutdown in progress error. This error occurred because pluggable database are not initialized. To fix this error connect as sysdba and run  ALTER PLUGGABLE DATABASE ALL OPEN    command. ALTER PLUGGABLE DATABASE ALL OPEN Thanks.
Post a Comment
Read more

AFTER LOGON Trigger not perfectly working

AFTER LOGON not perfectly working.  I have tried it on single instance oracle 12c database it's perfectly work but it's not perfectly working on multi instance Oracle 12c database. I have submitted this matter in oracle forum but not found any perfect answer. Do you know why  it's not working ???
Post a Comment
Read more

Error Initializing Opera: module 15

Solutions: You should manually remove directories name as "Opera" from  %PROGRAMFILES% ,%APPDATA% and %USERPROFILE% . RUN(Windows Logo Key + R)-> Enter '%PROGRAMFILES%' -> Then press OK Button. Open a new window, There find Opera folder and delete it. Same as %APPDATA%  and %USERPROFILE%. What programming languages should I learn to make a website How do i transfer music from my mac to my iPhone using the iTunes HOW TO FIX ICE CREAM SANDWICH UPDATE ERRORS !!! Fix an app that isn't working properly in Nexus how to reset Google nexus 7 Screen flicker problem in iPhone 5 DATE AND TIME PROBLEM IN IPHONE5 Another way: IF it's install in C drive you can delete opera folder from below location : c: \ Program Files \ Opera \ c: \ Documents and Settings \ Username \ Application Data \ Opera \ c: \ Documents and Settings \ Username \ Local Settings \ Application Data \ Opera \ Any you getting any problem give a comments. You can also see...
Post a Comment
Read more