Rmanconvert migrate win64-bit oracle to linuxoracle + asm manuscript
startup mountalter database open read only;select open_mode from v$database;set serveroutput ondeclarev_check boolean;beginv_check:=dbms_tdb.check_db('Linux x86 64-bit',dbms_tdb.skip_none);end;/declarev_ext boolean;beginv_ext:=dbms_tdb.check_external;end;/select name from v$database;rman target /convert database new database 'lixora'transport script 'c:\bak\trans.sql' to platform 'Linux x86 64-bit'db_file_name_convert 'C:\APP\ADMINISTRATOR\ORADATA\LIXORA\' 'c:\bak\'log_file_name_convert 'C:\APP\ADMINISTRATOR\ORADATA\LIXORA\' 'c:\bak\';
++
C: \ Users \ Administrator> rman target/
Recovery MANAGER: Release 11.2.0.1.0-Production on Wednesday August 5 16:08:23 2015
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect to the target database: LIXORA (DBID = 3300564341)
RMAN> convert database new database 'lixora'
2> transport script 'C: \ bak \ trans. SQL 'to platform 'linux x86 64-bit'
3> db_file_name_convert 'C: \ APP \ ADMINISTRATOR \ ORADATA \ LIXORA \ 'C: \ Bak ';
Start conversion at source from April 8 to April 15
Use the target database control file to replace the recovery directory
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: SID = 17 device type = DISK
Find the External table SH. SALES_TRANSACTIONS_EXT in the database.
Find the SYS. ORACLE_OCM_CONFIG_DIR directory in the database.
Find the SYS. DATA_PUMP_DIR directory in the database.
Find the SYS. XMLDIR directory in the database.
Find the SYS. DATA_FILE_DIR directory in the database.
Find the SYS. LOG_FILE_DIR directory in the database.
Find the SYS. MEDIA_DIR directory in the database.
Find the SYS. SS_OE_XMLDIR directory in the database.
Find the SYS. SUBDIR directory in the database.
Find bfile pm. PRINT_MEDIA in the database
Find the user SYS in the password file (with SYSDBA and SYSOPER permissions)
Channel ORA_DISK_1: starts data file conversion
Input data file: File No. = 00001 name = C: \ APP \ ADMINISTRATOR \ ORADATA \ LIXORA \ SYSTEM01.DBF
Converted data file = C: \ BAKSYSTEM01.DBF
Channel ORA_DISK_1: the data file has been converted, after 00:00:45
Channel ORA_DISK_1: starts data file conversion
Input data file: File No. = 00002 name = C: \ APP \ ADMINISTRATOR \ ORADATA \ LIXORA \ SYSAUX01.DBF
Converted data file = C: \ BAKSYSAUX01.DBF
Channel ORA_DISK_1: the data file has been converted, after 00:00:25
Channel ORA_DISK_1: starts data file conversion
Enter the data file: File No. = 00005 name = C: \ APP \ ADMINISTRATOR \ ORADATA \ LIXORA \ EXAMPLE01.DB
F
Converted data file = C: \ BAKEXAMPLE01.DBF
Channel ORA_DISK_1: the data file has been converted, after 00:00:07
Channel ORA_DISK_1: starts data file conversion
Enter the data file: File No. = 00003 name = C: \ APP \ ADMINISTRATOR \ ORADATA \ LIXORA \ UNDOTBS01.DB
F
Converted data file = C: \ BAKUNDOTBS01.DBF
Channel ORA_DISK_1: the data file has been converted, after 00:00:03
Channel ORA_DISK_1: starts data file conversion
Input data file: File No. = 00004 name = C: \ APP \ ADMINISTRATOR \ ORADATA \ LIXORA \ USERS01.DBF
Converted data file = C: \ BAKUSERS01.DBF
Channel ORA_DISK_1: the data file has been converted, after 00:00:01
Edit the init. ora file C: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_2 \ DATABASE \ INIT_00
Qdrm4i_00000.ora. This PFILE will be used to create database data on the Target Platform
Run the SQL script C: \ BAK \ TRANS. SQL on the target platform to create a database.
To recompile all PL/SQL modules, run utlirp. SQL and utlrp. SQL on the target platform.
To change the internal database identifier, use the DBNEWID Utility
Conversion at source is completed from April 8 to April 15
RMAN>
++
The target production environment is asm Storage
Copy the file to asm;
Export ORACLE_SID = LIXORA
Rman target/
Copy datafile ''to '+ data/lixora/datafile ';
Copy datafile ''to '+ data/lixora/datafile ';
Modify the control file creation script according to the trans. SQL content. The corresponding data file name in the control file must match the actual location in asm:
-The trans. SQL text is as follows:
-- The following commands will create a new control file and use it
-- To open the database.
-- Data used by Recovery Manager will be lost.
-- The contents of online logs will be lost and all backups will
-- Be invalidated. Use this only if online logs are damaged.
-- After mounting the created controlfile, the following SQL
-- Statement will place the database in the appropriate
-- Protection mode:
-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE
Startup nomount pfile = 'C: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_2 \ DATABASE \ init_00qdrm4i_00000.ora'
Create controlfile reuse set database "LIXORA" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
# MAXLOGHISTORY 292
LOGFILE
GROUP 1 'C: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_2 \ DATABASE \ ARCH_D-LIXORA_ID-3300564341_S-4_T-1_A-886951607_03QDRM4I 'SIZE 50 m blocksize 512,
GROUP 2 'C: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_2 \ DATABASE \ ARCH_D-LIXORA_ID-3300564341_S-5_T-1_A-886951607_04QDRM4I 'SIZE 50 m blocksize 512,
GROUP 3 'C: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_2 \ DATABASE \ ARCH_D-LIXORA_ID-3300564341_S-6_T-1_A-886951607_05QDRM4I 'SIZE 50 m blocksize 512
DATAFILE
'C: \ baksystem01.dbf ',
'C: \ baksysaux01.dbf ',
'C: \ bakundotbs01.dbf ',
'C: \ bakusers01.dbf ',
'C: \ bakexample01.dbf'
Character set ZHS16GBK
;
-- Database can now be opened zeroing the online logs.
Alter database open resetlogs;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
Alter tablespace temp add tempfile 'C: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_2 \ DATABASE \ DATA_D-LIXORA_I-3300564341_TS-TEMP_FNO-1_06QDRM4I'
SIZE 30408704 autoextend on next 655360 MAXSIZE 32767 M;
-- End of tempfile additions.
--
Set echo off
Prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Prompt * Your database has been created successfully!
Prompt * There are running things to think about for the new database. Here
Prompt * is a checklist to help you stay on track:
Prompt * 1. You may want to redefine the location of the directory objects.
Prompt * 2. You may want to change the internal database identifier (DBID)
Prompt * or the global database name for this database. Use
Prompt * NEWDBID Utility (nid ).
Prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SHUTDOWN IMMEDIATE
Startup upgrade pfile = 'C: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_2 \ DATABASE \ init_00qdrm4i_00000.ora'
@@? /Rdbms/admin/utlirp. SQL
SHUTDOWN IMMEDIATE
Startup pfile = 'C: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_2 \ DATABASE \ init_00qdrm4i_00000.ora'
-- The following step will recompile all PL/SQL modules.
-- It may take serveral hours to complete.
@@? /Rdbms/admin/utlrp. SQL
Set feedback 6;
Pfile generated in the appendix:
# Please change the values of the following parameters:control_files = "C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\CF_D-LIXORA_ID-3300564341_01QDRM4I"db_recovery_file_dest = "C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\flash_recovery_area"db_recovery_file_dest_size= 4102029312audit_file_dest = "C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\ADUMP"db_name = "LIXORA"# Please review the values of the following parameters:# __oracle_base = "C:\app\Administrator"__shared_pool_size = 100663296__large_pool_size = 4194304__java_pool_size = 4194304__streams_pool_size = 0__sga_target = 176160768__db_cache_size = 58720256__shared_io_pool_size = 0remote_login_passwordfile= "EXCLUSIVE"db_domain = ""dispatchers = "(PROTOCOL=TCP) (SERVICE=lixoraXDB)"__pga_aggregate_target = 100663296# The values of the following parameters are from source database:processes = 150nls_language = "SIMPLIFIED CHINESE"nls_territory = "CHINA"memory_target = 276824064db_block_size = 8192compatible = "11.2.0.0.0"undo_tablespace = "UNDOTBS1"audit_trail = "OS"open_cursors = 30# diagnostic_dest = "C:\APP\ADMINISTRATOR"