Tag: recover

Panic and Recover in Go

What is Panic? The idiomatic way to handle exceptions in Go programs is to use errors. errors are sufficient to handle most exceptions that occur in programs. **But in some cases, the program cannot continue to execute after an abnormal situation occurs. In this case, we use panic to terminate the program early. When a […]

PG physical backup and recovery pg_basebackup

PG physical backup and recovery pg_basebackup Enable WAL log archiving pg_basebackup backup tool Full database recovery: recovery.conf Database version: PostgreSQL 10.4 Enable WAL log archiving Through full database backup and WAL logs, the database can be restored to any point in time. Each WAL log file size is typically 16MB. When the number of WAL […]

RECOVER managed standby database finish ADG stops recovery processing OMF datafile copy Switch to copy

Backup library switching alter database commit to switchover to physical standby with session shutdown; //Switch to standby mode shutdown immediate startup mount select switchover_status from v$database; //Check status alter database recover managed standby database disconnect; //Enable standby application recovery mode select switchover_status from v$database; //Check the status again Switch to main library alter database commit […]

09 | Abnormal recovery, can the price paid be less?

As we discussed last time, Java’s exception handling is a factor that has an important impact on code performance. Therefore, the defects and abuse of Java error handling have become an old topic that has never diminished in popularity. However, Java’s exception handling has inherent advantages, especially its role in error troubleshooting, and it is […]

PostgreSQL logical backup and recovery

PostgreSQL logical backup and recovery Logical backup: pg_dump backup database backup table Backup Schema Logical backup: pg_dumpall Logical recovery: psql and pg_restore Restore database recovery table Restore Schema The official tools for PostgreSQL logical backup recovery are pg_dump, pg_dumpall, and pg_restore. pg_dump: Supports backup of databases or tables. The exported file can be a SQL […]

What should I do if Doris deletes the metadata of the database? Emergency recovery single copy situation

Introduction Under normal circumstances, if it is a multi-copy data store, it is easy to repair. Deleting one or two BE can also be restored according to Doris’s own recovery mechanism. However, sometimes some tables may not have multiple copies, so it is a bit confusing. . Case description: The data of the master node […]

[Algorithm Training – Backtracking Algorithm 3] [Best Practices of Backtracking Algorithms] Bracket generation and recovery of IP addresses

Without further ado, just shout a slogan to encourage yourself: Programmers will never be unemployed, programmers go to architecture! The theme of this blog is [Backtracking Algorithm], which is implemented using the basic data structure [array]. The website for this high-frequency question is: CodeTop, and the filtering conditions are: Target company + Last year + […]

MySQL–7. MySQL backup and recovery

MySQL 1. MySQL log management 1. MySQL log type 2. Error log 3. General query log 4. Slow query log 5. Binary log 5.1 Turn on logs 5.2 Management of binary logs 5.3 Log viewing 5.4 Binary log recovery data 2. MySQL backup 1. Backup type Logical backup advantages and disadvantages 2. Backup content 3. […]