메뉴 건너뛰기

Korea Oracle User Group

Guru's Articles

Different MOS Notes for xTTS PERL scripts – Use V4 scripts

A long time ago my colleagues published PERL scripts to assist especially with cross platform Transportable Tablespace migrations. The PERL scripts allow you to utilize incremental backups. This way you can decrease the downtime in a migration with large databases significantly. But there are different MOS Notes for xTTS PERL scripts available. Which one should you take?

Photo by VanveenJF on Unsplash

Transportable Tablespaces and Incremental Backups

The biggest pain points in a transportable tablespace migration are usually the size of the database and its complexity. With RMAN Incrementally Rolled Forward Backups you can tackle the size aspect. Instead of having a long downtime to copy terabytes of files from A to B during the read-only phase of the transport activity (tablespaces have to remain in read-only mode for transportable tablespaces during the copy and export meta contents operation), you can leverage incremental backups.

You will always start with a Level-0 imagefile copy backup which has the same size as your database. But your tablespaces can remain read-write mode during the backup.

In the following phase you will create Level-1 incremental backups. With those, you will roll forward. Still your tablespaces remain read-write.

When you get downtime, the tablespaces need to be set into read-only mode before you trigger the final incremental backup and roll forward again. But this final incremental backup usually has just a few gigabyte. It completes much faster than a copy operation of terabytes. Then you will start the transport phase.

In order to ease that process of RMAN Incremental Backups, even cross platform and cross Endianness, we deliver PERL scripts. You can download them from MOS notes.

The PERL scripts

You can find a two showcase presentations explaining the PERL scripts a bit more in detail in the Slides Download Centeron the blog.

Migrate to ExaCC with TTS and Incremental Backups

Migrate to ExaCC with TTS and Inc Backups

VLDB Migrations - FTEX, RMAN

Large Database Migrations with
RMAN Incremental Backups and Full Transportable

The following MOS Notes give you access to PERL scripts supporting the RMAN Incremental Backup pathtogether with either Transportable Tablespaces or Full Transportable Export Import:

The last MOS Note refers to a special version for the Zero Data Loss Recovery Appliance which is a big added value if you have a ZDLRA or plan to purchase one: It can become your migration vehicle. See the Migrate to ExaCC slides above for more details.

Which PERL scripts should you use?

Clearly you should use the PERL scripts V4 delivered via MOS Note: 2471245.1.

We keep the previous versions of the scripts on MOS only in case you started a project already. The V3 version got updated with the most recent fixes but MOS Note: 2471245.1 has the new and improved version of the scripts (V4) which you should use from now on.

To point to the new V4 release, the older notes have now this INFORMATION BOX:

NOTE: Consider using the new release of this procedure, version 4. This version has drastically simplified the steps and procedure. Before proceeding, review: 
V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup Note 2471245.1

–Mike

Link : https://mikedietrichde.com/2019/01/28/different-mos-notes-for-xtts-perl-scripts-use-v4-scripts/

번호 제목 글쓴이 날짜 조회 수
공지 Guru's Article 게시판 용도 ecrossoug 2015.11.18 600
44 Explain the Explain Plan: Join Methods 명품관 2021.02.10 730
43 Explain the Explain Plan: Access Methods 명품관 2021.02.10 945
42 Explain the Explain Plan: Cardinality Estimates 명품관 2021.02.09 614
41 Explaining the Explain Plan – How to Read and Interpret Execution Plans 명품관 2021.02.09 487
40 SQL Window Functions Cheat Sheet 명품관 2020.05.26 436
39 SQL Tuning Workshop 명품관 2020.02.20 8152
38 New initialization parameters, data dictionary views & dynamic performance views in Oracle Database 19c 명품관 2019.02.08 1910
37 More New Features in Oracle Database 19c 명품관 2019.02.08 6583
36 New Features of Performance Tuning in Oracle Database 19c 명품관 2019.02.08 914
35 New Features of RAC & ASM in Oracle 19c 명품관 2019.02.08 944
34 New Features of Data Guard in Oracle Database 19c 명품관 2019.02.08 2000
33 New Features of Security in Oracle Database 19c 명품관 2019.02.08 5045
32 Patch conflicts 명품관 2019.02.07 965
31 New Features in Oracle Multitenant 19c 명품관 2019.02.07 739
30 New Features of Backup & Recovery in Oracle Database 19c 명품관 2019.02.07 427
29 New Features in Oracle Database 19c 명품관 2019.02.02 538
» Different MOS Notes for xTTS PERL scripts – Use V4 scripts 명품관 2019.01.29 417
27 V$EVENT_NAME 뷰의 Name 컬럼에 정의된 event name에서 오는 오해 명품관 2017.03.08 367
26 Can I apply a BP on top of a PSU? Or vice versa? 명품관 2016.06.01 396
25 How to change the database name in 12c 명품관 2016.05.31 1932
위로