메뉴 건너뛰기

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 49
38 New initialization parameters, data dictionary views & dynamic performance views in Oracle Database 19c 명품관 2019.02.08 9
37 More New Features in Oracle Database 19c 명품관 2019.02.08 10
36 New Features of Performance Tuning in Oracle Database 19c 명품관 2019.02.08 9
35 New Features of RAC & ASM in Oracle 19c 명품관 2019.02.08 8
34 New Features of Data Guard in Oracle Database 19c 명품관 2019.02.08 9
33 New Features of Security in Oracle Database 19c 명품관 2019.02.08 14
32 Patch conflicts 명품관 2019.02.07 10
31 New Features in Oracle Multitenant 19c 명품관 2019.02.07 7
30 New Features of Backup & Recovery in Oracle Database 19c 명품관 2019.02.07 9
29 New Features in Oracle Database 19c 명품관 2019.02.02 10
» Different MOS Notes for xTTS PERL scripts – Use V4 scripts 명품관 2019.01.29 12
27 V$EVENT_NAME 뷰의 Name 컬럼에 정의된 event name에서 오는 오해 명품관 2017.03.08 107
26 Can I apply a BP on top of a PSU? Or vice versa? 명품관 2016.06.01 170
25 How to change the database name in 12c 명품관 2016.05.31 100
24 How to Recover Data (Without a Backup!) 명품관 2016.05.11 152
23 On ROWNUM and Limiting Results (오라클 매거진 : AskTom) 명품관 2016.04.28 182
22 DDL Logging - 12c (조나단 루이스) 명품관 2016.04.26 1109
21 11.1.0.6 부터 지원하는 Oracle Online Patching New Feature 명품관 2016.04.22 239
20 Quick tip on Function Based Indexes 명품관 2016.04.19 105
19 Oracle Linux 6.7 with Oracle 11.2.0.4 RAC 명품관 2016.04.15 1483
위로