INCREMENTAL BACKUP ICIN BLOCK CHANGE TRACKING DOSYASININ OLUSTURMAK

1.AMAÇ VE KAPSAM

 

Incremental backup alımını ve restore işlemini hızlandırmak için BCT dosyasını oluşturmakta yarar vardır.

 

2.UYGULAMA

 

2.1. Veritabanı BCT moddamı diye kontrol ediyoruz.

 

SELECT filename, status, bytes FROM v$block_change_tracking;

 

2.2.  BCT mod’u aktif etmek.

 

DATABASE { ENABLE | DISABLE } BLOCK CHANGE TRACKING USING FILE ‘/home/oracle/bctracking.log’;

 

2.3. Backup aldıktan sonra kontrol için

 

SELECT file#, avg(datafile_blocks), avg(blocks_read), avg(blocks_read/datafile_blocks) * 100 “Yedekleme Yüzdesi”, avg(blocks) FROM v$backup_datafile WHERE used_change_tracking = ‘YES’ AND incremental_level > 0 GROUP BY file#;

 772 views last month,  1 views today

About tayfun inam

Computer Engineer -PostgreSql-Oracle Database Administrator I am about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 8+years experience.I have OCA,PostgreSql senior Certificates I have worked 50+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.

One comment

  1. Cookies are important to the proper functioning of a site. To improve your experience, we use cookies to remember log-in details, provide secure log-in, collect statistics to optimize site functionality, and deliver content tailored to your interests.

Leave a Reply