ORACLE - TYPES OF BACKUP AND RECOVERY

1
TYPES OF BACKUP AND RECOVERY
http//oracle.filerepairtool.net/blog/types-backup
-oracle-recovery
2
About
Oracle database is a well known database that
provides complete solution over storing and
managing a large amount of relational data with
ease. It is an intelligent database but sometime
you may face errors and other issues that
prevents you to access your stored information,
to get rid of these it is suggested to create
backup of your database and update them on
regular basis. With the help of backup you can
deal with all types of errors and corruption
issues. Oracle contains four different types of
backups through which you can create the backup
of your database.
3
Types of backups in Oracle Database.
1. Cold backup 2. Hot backup 3. RMAN Backup 4.
Import Export Backup
4
1.  Cold backup This backup is helpful if your
database is in noarchive log mode, to create a
cold backup apply the below given steps Step 1
First close the database with the help of
Sqlgtshutdown immediate command Step 2 After
it copy the data files, control files and redolog
files to your desired destination manually. Step
3 Start the database with the help of
Sqlgtstartup command
5

• 2.  Hot backup
• This backup method is used when database is
  in archive log mode. Apply the below given steps
  to create hot backup without any database outage.
• Step 1 Run the below given commands in order
  to get the logs for hot backup in separate
  logfile.
• Step 2 Sqlgtalter database begin backup

6
Step 3 Copy data files, control files and redo
log files manually to your desired destination
without closing the database. Step 4 Close the
hot backup by running the command Sqlgtalter
database end backup Step 5 After completion of
hot backup switch the log file. Use below given
command Sqlgtalter system switch logfile Copy
archive files which is used to recover the
database. Copy this command to recover
database sqlgtrecover database using contolfile
autobackup untill cancel
7

• 3. RMAN Backup
• 1. RMAN Without recovery catalog
• Note Database should be in archivelog mode.
• Step 1 Apply this command RMANgtbackup database
• Step 2 To create backup of tablespace use the
  below command
• Rmangtbackup tablespace tablespace_name

8
Step 3 To create backup of datafile copy the
following command.Rmangtbackup datafile
C\oracle\product\10.2.0\oradata\orcl\datafile_na
meAll these backups will get stored in
flash_recovery_area by default.
9

• 4.   Import Export Backup
• Data guard is the new feature of Oracle that
  allows the user to transfer data from one
  location to another at high speed.
• It is packed with two utilities
• Export utility
• Import Utility
• Export utility With the help of this tool one
  can store the database objects in the storage
  media like disks outside the database.
• Import Utility This allows the user to load the
  objects to the database from the storage media.

10

• Export operation
• Step 1 First create a directory, use C\gtmkdir
  c\backup
• Step 2 After it connect to the database and
  create the directory for backup
• Sqlgtcreate directory backup as c\backup
• The directory created.
• Step 3 Move to the host mode.
• Sqlgthost

11
Step 4 Navigate to the directory
C\oracle\product\10.2.0\db_1\BINC\gtcd
C\oracle\product\10.2.0\db_1\BIN Step 5 Run
the export command. C\oracle\product\10.2.0\db_1
\BINgt expdp sys/test directorybkup
dumpfilebfull.dmp logfilebfull.log fully In
order to run import operation execute the below
given command. C\oracle\product\10.2.0\db_1\BINgt
impdp sys/test directorybkup dumpfilebfull.dmp
logfilebfull.log fully
12
/Oracle-File-Repair-Tool/539615136124686
/u/3/b/104544172490441093305
/OracleRepair
/alexwaston14/file-repair-tool
http//www.pcerror-fix.com/easily-fix-dll-errors
-windows-8-8-1