Cov txheej txheem:

Dab tsi yog log shipping hauv Oracle database?
Dab tsi yog log shipping hauv Oracle database?

Video: Dab tsi yog log shipping hauv Oracle database?

Video: Dab tsi yog log shipping hauv Oracle database?
Video: Nastya and Watermelon with a fictional story for kids 2024, Hlis ntuj nqeg
Anonim

Log shipping . Los ntawm Wikipedia, phau ntawv dawb encyclopedia. Log shipping yog tus txheej txheem ntawm automating cov thaub qab ntawm kev lag luam log cov ntaub ntawv ntawm lub hauv paus (kev tsim khoom) database server, thiab tom qab ntawd rov kho lawv mus rau lub server standby. Cov txheej txheem no txhawb nqa los ntawm Microsoft SQL Server, 4D Server, MySQL, thiab PostgreSQL.

Yog li ntawd, log shipping ua haujlwm li cas?

Log shipping hais txog tus txheej txheem ntawm kev noj cov khoom lag luam log backup cov ntaub ntawv ntawm ib lub server, shipping lawv mus rau tus neeg rau zaub mov thib ob thiab rov kho lawv. Hauv log shipping txheej txheem: kev lag luam log backups yog ua nyob rau hauv lub hauv paus database ntawm thawj SQL Server (piv txwv li cov ntaub ntawv ntau lawm).

Tsis tas li ntawd, qhov sib txawv ntawm cov log shipping thiab mirroring yog dab tsi? Log Shipping :: Ob qho tib si cog lus thiab tsis tau cog lus pauv hloov mus rau cov ntaub ntawv thib ob. Daim iav :: Tsuas yog cog lus pauv pauv mus rau lub iav database. Replication:: Tsuas yog cog lus pauv pauv mus rau tus neeg siv khoom database.

Ib tug kuj yuav nug, dab tsi yog kev siv cav shipping hauv SQL Server?

SQL Server Log shipping tso cai rau koj kom xa cov kev pauv hloov log backups los ntawm ib tug thawj database ntawm ib tug thawj server piv txwv rau ib lossis ntau dua cov ntaub ntawv thib ob ntawm cov khoom sib cais server piv txwv. Kev lag luam log thaub qab yog siv rau txhua qhov ntawm cov ntaub ntawv thib ob ntawm tus kheej.

Kuv yuav teeb tsa log shipping li cas?

Txhawm rau teeb tsa log shipping

  1. Txoj nyem rau ntawm lub database uas koj xav siv los ua koj cov ntaub ntawv tseem ceeb hauv lub log shipping configuration, thiab ces nias Properties.
  2. Nyob rau hauv Xaiv ib nplooj ntawv, nyem Transaction Log Shipping.
  3. Xaiv qhov Ua kom qhov no ua cov ntaub ntawv tseem ceeb hauv lub log xa khoom teeb tsa lub thawv kos.

Pom zoo: