Shulou(Shulou.com)06/01 Report--

There are many contents of backup and recovery in ocp053. After listening to Mr. Cui about a backup and recovery course, I felt that his knowledge network in this area was well organized, so I sorted out the knowledge points of backup and recovery according to his lectures, and then reorganized the knowledge of backup and recovery according to the following knowledge network. When dealing with backup and recovery problems, the train of thought will be much clearer. First, backup knowledge points: backup classification cold backup hot backup management physical (physical file level backup) cp begin/end backup (will generate logs) user management mount state backup database (before backup will be checked Check for data block damage) RMAN backup classification backup mode management logic (data level backup) imp/exp user management (OS command) impdp/expdp oracle server command Note: copy: cp os command exp/imp: you can import and export directly on this machine (operating system life) Expdp/impdp: you must log in to the server to import and export (oracle server command) RMAN backup type: backupset, Copy full backup: full library backup incremental backup (with a level 0 backup as the basis of incremental backup): differential backup, cumulative backup differential backup: level 1 means since level 0 backup When there is no level 0 backup for a backup with a changed block, a level 1 backup can be backed up successfully Complete database 2, restore ideas: restore: restore physical files recover: synchronous SCN number recovery principle recovery mode management restore cp recover user management restore restore recover RMAN instance recovery: SMON forces the recovery operation to the database, restore to the latest SCN number, without intervention on the database. Media recovery: media recovery means that the disk media is damaged, so that the data file cannot be accessed. At this time, the backup file must be used to recover the data file on the new disk. DBA is required to determine which case the media recovery belongs to. Flashback recovery: using flashback technology to restore the database, flashback can be divided into: database level: Flashback Database table level: Flashback Drop and Flashback Table,Flashback Data Archive record level: Flashback Version Query and Flashback Transaction Query where media recovery can be divided into full recovery and incomplete recovery: full recovery: restore the database to the state it was in the event of a failure, and the name completely means that there is no data loss To achieve this goal, certain conditions must be met: backup, from all archived logs after backup, online logs are available. A full restore is the simplest recovery and requires only two commands: restore database and recover database. Incomplete recovery: it is mostly used to solve the failure. Generally, timestamp is not fully recovered to a certain point in time (resetlogs is required when opening the database). After the lost data is recovered, the data is exported and a complete recovery is carried out.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.