What is data hot backup?

Data hot backupYesOne span>kindinshipOKStatusdownpreparation< span data-offset-key="2qfnu-327-0">partsnumberaccording totechnology technique,ItcanwithinnotmiddlebrokensystemsystemRunOKcasecaseNextBackupBackup< /span>numberdata,fromwhileraisehigh Preparationparteffective rate.

Hot backup is a method of backing up the database in the archivelog mode when the database is running. So, if you have a cold backup from last night and today’s hot backup file, you can use these data to restore more information when a problem occurs. Hot backup requires the database to operate in Archivelog mode and requires a large amount of archive space. Once the database is running in the archivelog state, it can be backed up.

Hot backup: data hot backup What is it?
Data hot backup

1. Datafiles are backed up tablespace by tablespace.

(1) Set the tablespace to backup state

(2) Back up the data files of the tablespace

(3) Restore the tablespace to normal state

2. Backup and archive log files

(1) Temporarily stop the archiving process

(2) Those files in the archive rede log target directory under the log

(3) Restart the archive process

(4) Backup archived redo log files

3. The advantages of using the alter database bachup controlfile command to back up the control file hot backup are:

1. It can be backed up at the table space or database file level, and the backup time is short.

2. The database can still be used while backing up.

3. Second-level recovery (recovery to a certain point in time) can be achieved.

4. Can restore almost all database entities

5. Recovery is fast and in most cases loves recovery while the database is still working.

Like (0)
Previous 2023-08-27 21:42
Next 2023-08-27 21:46


  • Glossary: ​​Glossary for getting started with blockchain (1)

    If you want to understand and learn blockchain, you must first start with the explanation of nouns, just like learning English requires knowing the 26 letters. Recently, we specially compiled an explanation of introductory nouns, let’s take a look! I hope the following knowledge sharing will be helpful to everyone. 1.Blockchain——Blockchain Definition: Blockchain is a new application model of computer technologies such as distributed data storage, point-to-point transmission, consensus mechanism, and encryption algorithms. is a shared distributed ledger where transactions are permanently recorded through appended blocks. 2.Block——Block Explanation: In the…

  • What is a blockchain protocol in blockchain terms?

    What is a blockchain protocol in blockchain terms? Blockchain protocols: refers to the different types of blockchain platforms available for application development. Each blockchain protocol adopts basic blockchain principles to suit specific industry or application needs. Some examples of blockchain protocols are provided below: Hyperledger Fabric Hyperledger Fabric is an open source project that includes a set of tools and libraries. Enterprises can use it to build private blockchain applications quickly and efficiently. It is a modular, general-purpose framework that provides unique identity management and access control capabilities. These capabilities…

  • The development trend of blockchain WEB3.0

    WEB 3.0 is the next Internet era. We missed the PC Internet era and passed by the mobile Internet. Now is the best time to lay out WEB 3.0. So, how do ordinary people enter the market early and get the first pot of gold? After all, WEB 3.0 has entry barriers. Today we will talk about the basics of the basics, including basic knowledge about public chains, blockchains, and Bitcoin. This is the first step for us to swim in WEB 3.0. What ispublic chain and private chain? Public…

  • Distribution system development-12 assessment criteria for level promotion in WeChat distribution mall

    Distribution system development丨12 assessment criteria for level promotion in WeChat distribution mall The level of commission refers to how many people get paid. For example, if we are doing secondary distribution, then two people will get the commission. The level of commission is a matter of how much money you get. Generally, when we make a model, we will set three to five levels for promotion. So the question is, what conditions must be met before a junior can be promoted to an intermediate level, and an intermediate level can…

  • What problems will you encounter if you use agile development for software project development?

    Agile development in software development is suitable for products, but not suitable for projects, because the pace of product development can be controlled, while projects will be greatly affected by customers. So, what problems will you encounter when using agile development for software project development? 1. Don’t bring the ultimate goal into agile development What agile development needs to solve is how to gradually and accurately describe user needs and gradually present products, because users don’t know what the product they want looks like before the final product comes out….

  • Shanghai Software Development Company-How to choose a software development company that suits you?

    Direct selling system software design and development丨How to choose a software development company How to choose a software development company that suits you? First, let’s take a look at what kinds of software development companies there are. 1. Personal technology development I understand front-end and back-end language development, and I can take on some private work during work. The development cost is low. The disadvantage is that it is a personal software, and the quality and after-sales service of the software cannot be guaranteed. It is suitable for simple system…