Home > database >  The use of ORACLE archive mode
The use of ORACLE archive mode

Time:09-19

there is a application system USES the ORACLE database, has used the data backup pump import and export, later leaders to use file backup, the backup file is not very familiar with, know how to enable, but do not know to what maintenance, ask a few questions
1. Whether the file backup needs a complete database, specific how to backup;
2, the backup archive is to generate a file or multiple archive files, what is the difference between;
3, after the generated file is the need to need to periodically remove; If clear, whether to need to do a perfect justice period?
4, after setting the archive mode which maintain the content need to be aware of;
5, how to use the archive log restore data
Wish you a great god glad!

CodePudding user response:

I study the RMAN this tool, can solve all the problems you mentioned above,

Be patient insisted that backup is a big deal,

CodePudding user response:

First rman backup file backup, archive backup is the backup archive logs,
I understand for what you need is rman backup,
1, rman needs a complete a level 0 backup incremental backup (behind) or full (whole database backup, no additional incremental backup)
2, multiple, parallel,
3, the space is enough don't have to clean up, clean up the back a level 0 backup,
4, pay attention to the disk space increment
5, restore a variety of ways, the simple principle is to restore the database level 0 backup, and then recover the incremental backup or log backups to you specify the origin

CodePudding user response:

Don't know if I'm wrong no rman should belong to physical mobility is similar to the various files directly copy paste,
Data backup pump is similar to directly write SQL, etc., this is the difference

CodePudding user response:

Suggested to build a environment, the actual test, you will find that is easy to understand,
  • Related