RMAN CONVERT DATABASE 的限制
普通的RMAN DUPLICATE/RESTORE/RECOVER(非convert database 方式) 對平臺有一定的要求:
對於不滿足以上要求的需要使用CONVERT DATABASE 進行跨平臺遷移
但是也有一定的限制具體如下:
---必須有相同的endian format
可以透過以下檢視查詢
SQL> COLUMN PLATFORM_NAME FORMAT A32
SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM;PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- -------------------------------- --------------
1 Solaris[tm] OE (32-bit) Big
2 Solaris[tm] OE (64-bit) Big
7 Microsoft Windows IA (32-bit) Little
10 Linux IA (32-bit) Little
6 AIX-Based Systems (64-bit) Big
3 HP-UX (64-bit) Big
5 HP Tru64 UNIX Little
4 HP-UX IA (64-bit) Big
11 Linux IA (64-bit) Little
15 HP Open VMS Little
8 Microsoft Windows IA (64-bit) Little
9 IBM zSeries Based Linux Big
13 Linux 64-bit for AMD Little
16 Apple Mac OS Big
12 Microsoft Windows 64-bit for AMD Little
17 Solaris Operating System (x86) Little
18 IBM Power Based Linux Big
17 rows selected
----以下部分不能被傳輸
1 redo file
2 controlfile
3 外部表和目錄
4 密碼檔案
官方文件說明:
The principal restriction on cross-platform. transportable database is that the source and destination platform. must share the same endian format. For example, while you can transport a database from Microsoft Windows to Linux for x86 (both little-endian), or from HP-UX to AIX (both big-endian), you cannot transport a whole database from HP_UX to Linux for x86 using this feature. You can, however, create a new database on a destination platform. manually, and transport needed tablespaces from the source database using cross-platform. transportable tablespace as described in "Cross-Platform. Tranportable Tablespace: CONVERT DATAFILE or TABLESPACE".
Also note that some parts of the database cannot be transported directly:
Redo log files and control files from the source database are not transported. New control files and redo log files are created for the new database during the transport process, and an OPEN RESETLOGS is performed once the new database is created.
Note:
The control file for the converted database does not contain a copy of the RMAN repository information from the source database. Backups from the source database cannot be used with the converted database.
BFILEs are not transported. RMAN provides a list of objects using the BFILE datatype in the output for the CONVERT DATABASE command, but users must copy the BFILEs themselves and fix their locations on the destination database.
Tempfiles belonging to locally managed temporary tablespaces are not transported. The temporary tablespace will be re-created on the target platform. when the transport script. is run.
External tables and directories are not transported. RMAN provides a list of affected objects as part of the output of the CONVERT DATABASE command, but users must redefine these on the destination platform. See Oracle Database Administrator's Guide for more information on managing external tables and directories.
Password files are not transported. If a password file was used with the source database, the output of CONVERT DATABASE includes a list of all usernames and their associated privileges. Create a new password file on the destination database using this information. See Oracle Database Security Guide for more information on managing password files.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15747463/viewspace-758178/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Can Tapes Be Used For RMAN Convert Database (Doc ID 563816.1)Database
- To use Rman to duplicate database be careful of db_file_name_convertDatabase
- CONVERT DATABASE命令(三)Database
- CONVERT DATABASE命令(二)Database
- CONVERT DATABASE命令(一)Database
- 利用RMAN Convert database特性進行跨平臺遷移資料Database
- oracle10g_rman_cross os_同位元組序_convert databaseOracleROSDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- RMAN duplicat databaseDatabase
- rman recover databaseDatabase
- RMAN duplicate databaseDatabase
- RMAN之CONVERT整庫遷移
- Rman backup standby databaseDatabase
- 通過rman duplicate database!Database
- rman backup database force 功能Database
- 使用rman建立standby database的過程Database
- RMAN duplicate database到新主機Database
- rman 建 Standby Database 筆記Database筆記
- Duplicate Database from ASM to Non- ASM Database Using RMANDatabaseASM
- oracle rconfig convert single instance to rac databaseOracleDatabase
- oracle 9i single instance convert to rac databaseOracleDatabase
- How to use rman backup a noarchivelog databaseHiveDatabase
- Making Whole Database Backups with RMANDatabase
- 同事總結的 : 用RMAN建立Physical Standby DatabaseDatabase
- 【RMAN】RMAN-20001: target database not found in recoveryDatabase
- 【RMAN】RMAN-05001: auxiliary filename conflicts with the target databaseUXDatabase
- 11g rman新特性 duplicate target database for standby from active databaseDatabase
- 理解RMAN backup database plus archivelog命令DatabaseHive
- rman restore database(spfile,controlfile, datafile)RESTDatabase
- Oracle 11g Rman Active database duplicateOracleDatabase
- 【RMAN】RMAN-20020: DATABASE INCARNATION NOT SETDatabase
- rman duplicate target database RMAN-03002 RMAN-03015 RMAN-06136Database
- Oracle 11g RMAN備份-RMAN的backup database plus archivelog命令背後的操作OracleDatabaseHive
- 使用rman執行recover database 的時候出現RMAN-06054的錯誤提示Database
- 使用RMAN複製資料庫 active database資料庫Database
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- RMAN 6217 not connected to auxiliary database with a net service nameUXDatabase
- RMAN database plus archivelog實現順序DatabaseHive