Shulou(Shulou.com)05/31 Report--

This article mainly introduces "Oracle12 cross-platform to complete PDB backup migration method is what", in the daily operation, I believe that many people in Oracle12 cross-platform to complete PDB backup migration method is what the problem is, the editor consulted all kinds of information, sorted out a simple and useful method of operation, hope to answer the "Oracle12 cross-platform to complete PDB backup migration method is what" the doubt is helpful! Next, please follow the editor to study!

Using Rman,Pluggable database (PDBs) can be transferred to different platforms and inserted into the target's CDB, along with backups of PDB

Rman will also copy the necessary metadata to the target CDB side. The source CDB and destination CDB must be the same byte order (Endian)

The following steps show how to migrate a closed PDB to an AIX (Big Endian) platform from Solaris (Big Endian).

SQL > select name,open_mode,platform_name from v$database

Source:

NAME OPEN_MODE PLATFORM_NAME

-

SRC122 READ WRITE Solaris [tm] OE (64-bit)

Destination:

NAME OPEN_MODE PLATFORM_NAME

DEST122 READ WRITE AIX-Based Systems (64-bit)

Solution

1. Close the source PDB:

SQL > alter pluggable database PDB1 close immediate

two。 Backup source PDB:

RMAN > backup for transport

2 > unplug into'/ bugmnt7/ap/celcsol2/SR1.12121212121/oradata/backup/PDB1_Metadata.xml'

3 > format'/ bugmnt7/ap/celcsol2/SR1.12121212121/oradata/backup/PDB1_BKP_%U'

4 > pluggable database PDB1

3. Use SCP to send backup collections and PDB metadata (metadata) to the destination:

4. Use dbms_pdb.check_plug_compatibility on the destination side to check whether pluggin is possible:

Set serveroutput on

Declare

C boolean

Begin

C:=dbms_pdb.check_plug_compatibility ('/ home/bugmnt/oradata/backup/PDB1_Metadata.xml','PDB1')

If (c) then dbms_output.put_line ('True')

Else dbms_output.put_line ('False')

End if

End

/

5. Restore (Restore) PDB on the destination side:

RMAN > restore using'/ home/bugmnt/oradata/backup/PDB1_Metadata.xml'

2 > foreign pluggable database PDB1

3 > format'/ home/bugmnt/oradata/DEST122/%U'

4 > from backupset'/ home/bugmnt/oradata/backup/PDB1_BKP_02s9sj0u_1_1'

6. Open PDB1 on the destination side:

SQL > alter pluggable database PDB1 open

Note: this document covers the cross-platform migration strategy for PDB using consistent backups.

In order to reduce downtime, the migration can also use inconsistent backups in the case of archives.

The backup in this case is PDB in the case of open read write, using FOR TRANSPORT and ALLOW INCONSISTENT to backup PDB level0.

Then, when pdb is turned off, the backup of level 1 is done through FROM SCN and UNPLUG INTO (12.2 new keywords), while also getting the metadata of PDB

At this point, on the "Oracle12 cross-platform to complete PDB backup migration method is what is the end of the study, I hope to be able to solve your doubts." The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.