Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g RMAN cross-platform transfer table space     - Detailed reference Oracle 11g Partition (Database)

- Seven kinds of NIC binding mode Detail (Linux)

- C ++ precision performance test function (Programming)

- Linux Kernel 4.2 Installation Instructions (Linux)

- Java collections series (Programming)

- git checkout generated in the use of temporary br (Linux)

- Linux Network Programming - signal blocking and shielding (block, unblock) (Programming)

- Vim Getting Started Tutorial (Linux)

- Experience PHP 7.0 on CentOS 7.x / Fedora 21 (Server)

- To install Jetty server configuration in detail (Server)

- Unix system security configuration (Linux)

- OpenSSL: implementation creates a private CA, certificate signing request Explanation (Server)

- Python, and / or (Programming)

- Bootable ISO image using GRUB (Linux)

- Linux System Getting Started Learning: compile and install ixgbe driver in Ubuntu or Debian (Linux)

- Java object serialization and deserialization (Programming)

- DBCA Error: ORA-19809: limit exceeded for recovery files process (Database)

- PostgreSQL-XL installation and deployment (Database)

- Java environment to build a number of issues (Linux)

- Oracle Standby Redo Log experiment (Database)

 
         
  Oracle 11g RMAN cross-platform transfer table space
     
  Add Date : 2018-11-21      
         
       
         
  Use imp / impdp transmission table space transport_tablespace meet the following criteria
1. The same character set
2. To export the table space must be read only, and is self-contained, that is the object of the table space can not rely on other table space.
3. To export the source data transmission table space data files are copied to another database the appropriate directory.
RMAN table space and does not need to READ ONLY, because it is a backup set for transmission, but they also need the same character set and self-contained.
Based on the following test RMAN transmission table space.
test environment
Source database:
OS = RHEL 6.4;
DB = Oracle11GR2;
IP = 192.168.1.171;
SID = hjj;
ASM storage.
Target database:
OS = WIN7 64BIT;
DB = ORACLE11GR2;
IP = 192.168.1.1;
SID = orcl;
FS storage.
First, at the end of the source database
1. Create a test table space
SQL> create tablespace tt1 datafile '+ DATA_DG / hjj / datafile / test01.dbf' size 100m;

Tablespace created.
2. Create a user and authorization
SQL> create user tt1 identified by oracle default tablespace tt1;

User created.

SQL> grant connect, resource to tt1;

Grant succeeded.
3. Create a test table
SQL> create table tt1.t as select * from dba_objects;

Table created.
4. View Data
SQL> conn tt1 / oracle
Connected.
SQL> select count (*) from t;

  COUNT (*)
----------
    21293
4. Confirm internet transmission table space is compatible
At the end of the source database:
SQL> select tp * from v $ transportable_platform tp, v $ database d where tp.PLATFORM_NAME = d.PLATFORM_NAME.;

PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
--------------------------------------- ----------- ----------- --------------
        10 Linux IA (32-bit) Little
In the target database side:
SQL> select tp * from v $ transportable_platform tp, v $ database d where tp.PLATFORM_NAME = d.PLATFORM_NAME.;

PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
--------------------------------------- ----------- ----------- ----------------------------
         12 Microsoft Windows x86 64-bit Little
You can see the windows platform and linux are Little, it is compatible.
5. Verify that the source database table space whether self-contained
SQL> exec dbms_tts.transport_set_check ( 'tt1', true, true);

PL / SQL procedure successfully completed.

SQL> select * from transport_set_violations;

no rows selected
6. Back up the source database
[Oracle @ myrac1 ~] $ rman target sys / oracle @ hjj catalog rman / rman

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Mar 5 19:54:06 2014

Copyright (c) 1982, 2009, Oracle and / or its affiliates. All rights reserved.

connected to target database: HJJ (DBID = 2845675742)
connected to recovery catalog database
RMAN> sql "alter system checkpoint";

starting full resync of recovery catalog
full resync complete
sql statement: alter system checkpoint
RMAN> sql "alter system archive log current";

sql statement: alter system archive log current

RMAN> sql "alter system switch logfile";

sql statement: alter system switch logfile

RMAN> backup database;

Starting backup at 05-MAR-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile (s) in backup set
input datafile file number = 00001 name = + DATA_DG / hjj / datafile / system.260.837919351
input datafile file number = 00002 name = + DATA_DG / hjj / datafile / sysaux.261.837919391
input datafile file number = 00005 name = + DATA_DG / hjj / datafile / tbs01.dbf
input datafile file number = 00003 name = + DATA_DG / hjj / datafile / undotbs1.262.837919417
input datafile file number = 00007 name = + DATA_DG / hjj / datafile / tt01.dbf
input datafile file number = 00006 name = + DATA_DG / hjj / datafile / rman_tbs0.dbf
input datafile file number = 00004 name = + DATA_DG / hjj / datafile / users.264.837919457
channel ORA_DISK_1: starting piece 1 at 05-MAR-14
channel ORA_DISK_1: finished piece 1 at 05-MAR-14
piece handle = + DG_FRA / hjj / backupset / 2014_03_05 / nnndf0_tag20140305t215129_0.265.841441893 tag = TAG20140305T215129 comment = NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
Finished backup at 05-MAR-14

Starting Control File and SPFILE Autobackup at 05-MAR-14
piece handle = + DG_FRA / hjj / autobackup / 2014_03_05 / s_841441968.267.841441969 comment = NONE
Finished Control File and SPFILE Autobackup at 05-MAR-14

RMAN> backup archivelog all;

Starting backup at 05-MAR-14
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log (s) in backup set
input archived log thread = 1 sequence = 88 RECID = 47 STAMP = 841355567
input archived log thread = 1 sequence = 89 RECID = 48 STAMP = 841366180
input archived log thread = 1 sequence = 90 RECID = 49 STAMP = 841433642
input archived log thread = 1 sequence = 91 RECID = 50 STAMP = 841434920
input archived log thread = 1 sequence = 92 RECID = 51 STAMP = 841434930
input archived log thread = 1 sequence = 93 RECID = 52 STAMP = 841435200
input archived log thread = 1 sequence = 94 RECID = 53 STAMP = 841439190
input archived log thread = 1 sequence = 95 RECID = 54 STAMP = 841439198
input archived log thread = 1 sequence = 96 RECID = 55 STAMP = 841439439
input archived log thread = 1 sequence = 97 RECID = 56 STAMP = 841439759
input archived log thread = 1 sequence = 98 RECID = 57 STAMP = 841440347
input archived log thread = 1 sequence = 99 RECID = 58 STAMP = 841441558
input archived log thread = 1 sequence = 100 RECID = 59 STAMP = 841441564
input archived log thread = 1 sequence = 101 RECID = 60 STAMP = 841442014
channel ORA_DISK_1: starting piece 1 at 05-MAR-14
channel ORA_DISK_1: finished piece 1 at 05-MAR-14
piece handle = + DG_FRA / hjj / backupset / 2014_03_05 / annnf0_tag20140305t215336_0.264.841442017 tag = TAG20140305T215336 comment = NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
Finished backup at 05-MAR-14

Starting Control File and SPFILE Autobackup at 05-MAR-14
piece handle = + DG_FRA / hjj / autobackup / 2014_03_05 / s_841442025.263.841442027 comment = NONE
Finished Control File and SPFILE Autobackup at 05-MAR-14

RMAN> backup current controlfile;

Starting backup at 05-MAR-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile (s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 05-MAR-14
channel ORA_DISK_1: finished piece 1 at 05-MAR-14
piece handle = + DG_FRA / hjj / backupset / 2014_03_05 / ncnnf0_tag20140305t215401_0.262.841442045 tag = TAG20140305T215401 comment = NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 05-MAR-14

Starting Control File and SPFILE Autobackup at 05-MAR-14
piece handle = + DG_FRA / hjj / autobackup / 2014_03_05 / s_841442048.261.841442051 comment = NONE
Finished Control File and SPFILE Autobackup at 05-MAR-14

Note: As used herein, a full backup, because in addition to the backup target table space, RMAN also need SYSTEM, SYSAUX, and backup UNDO table space, if any one of the backup table space does not exist, it will lead to "RMAN-06019: Unable to conversion table space name "TTB1" "error.

7. Generate the transport set (the source database)
RMAN> transport tablespace tt1 tablespace destination '/ s01 / dd' auxiliary destination '/ s01 / dd';

Creating automatic instance, with SID = 'CDty'

initialization parameters used for automatic instance:
db_name = HJJ
db_unique_name = CDty_tspitr_HJJ
compatible = 11.2.0.0.0
db_block_size = 8192
db_files = 200
sga_target = 280M
processes = 50
db_create_file_dest = / s01 / dd
log_archive_dest_1 = 'location = / s01 / dd'
#No Auxiliary parameter file used


starting up automatic instance HJJ

Oracle instance started

Total System Global Area 292933632 bytes

Fixed Size 1336092 bytes
Variable Size 100666596 bytes
Database Buffers 184549376 bytes
Redo Buffers 6381568 bytes
Automatic instance created
Running TRANSPORT_SET_CHECK on recovery set tablespaces
TRANSPORT_SET_CHECK completed successfully

contents of Memory Script:
{
# Set requested point in time
set until scn 2004003;
# Restore the controlfile
restore clone controlfile;
# Mount the controlfile
sql clone 'alter database mount clone database';
# Archive current online log
sql 'alter system archive log current';
# Resync catalog
resync catalog;
}
executing Memory Script

executing command: SET until clause

Starting restore at 05-MAR-14
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID = 59 device type = DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece + DG_FRA / hjj / autobackup / 2014_03_05 / s_841441968.267.841441969
channel ORA_AUX_DISK_1: piece handle = + DG_FRA / hjj / autobackup / 2014_03_05 / s_841441968.267.841441969 tag = TAG20140305T215248
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08
output file name = / s01 / dd / HJJ / controlfile / o1_mf_9kj3fpmt_.ctl
Finished restore at 05-MAR-14

sql statement: alter database mount clone database

sql statement: alter system archive log current

starting full resync of recovery catalog
full resync complete

contents of Memory Script:
{
# Set requested point in time
set until scn 2004003;
# Set destinations for recovery set and auxiliary set datafiles
set newname for clone datafile 1 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 2 to new;
set newname for clone tempfile 1 to new;
set newname for datafile 7 to
 "/s01/dd/tt01.dbf";
# Switch all tempfiles
switch clone tempfile all;
# Restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile 1, 3, 2, 7;
switch clone datafile all;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /s01/dd/HJJ/datafile/o1_mf_temp_%u_.tmp in control file

Starting restore at 05-MAR-14
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile (s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /s01/dd/HJJ/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /s01/dd/HJJ/datafile/o1_mf_undotbs1_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00002 to /s01/dd/HJJ/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00007 to /s01/dd/tt01.dbf
channel ORA_AUX_DISK_1: reading from backup piece + DG_FRA / hjj / backupset / 2014_03_05 / nnndf0_tag20140305t215129_0.265.841441893
channel ORA_AUX_DISK_1: piece handle = + DG_FRA / hjj / backupset / 2014_03_05 / nnndf0_tag20140305t215129_0.265.841441893 tag = TAG20140305T215129
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:56
Finished restore at 05-MAR-14

datafile 1 switched to datafile copy
input datafile copy RECID = 5 STAMP = 841442234 file name = / s01 / dd / HJJ / datafile / o1_mf_system_9kj3g6mv_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID = 6 STAMP = 841442234 file name = / s01 / dd / HJJ / datafile / o1_mf_undotbs1_9kj3g77n_.dbf
datafile 2 switched to datafile copy
input datafile copy RECID = 7 STAMP = 841442234 file name = / s01 / dd / HJJ / datafile / o1_mf_sysaux_9kj3g706_.dbf
datafile 7 switched to datafile copy
input datafile copy RECID = 8 STAMP = 841442234 file name = / s01 / dd / tt01.dbf

contents of Memory Script:
{
# Set requested point in time
set until scn 2004003;
# Online the datafiles restored or switched
sql clone "alter database datafile 1 online";
sql clone "alter database datafile 3 online";
sql clone "alter database datafile 2 online";
sql clone "alter database datafile 7 online";
# Recover and open resetlogs
recover clone database tablespace "TT1", "SYSTEM", "UNDOTBS1", "SYSAUX" delete archivelog;
alter clone database open resetlogs;
}
executing Memory Script

executing command: SET until clause

sql statement: alter database datafile 1 online

sql statement: alter database datafile 3 online

sql statement: alter database datafile 2 online

sql statement: alter database datafile 7 online

Starting recover at 05-MAR-14
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 101 is already on disk as file /s01/app/oracle/archivelog/1_101_837919326.dbf
archived log file name = / s01 / app / oracle / archivelog / 1_101_837919326.dbf thread = 1 sequence = 101
media recovery complete, elapsed time: 00:00:00
Finished recover at 05-MAR-14

database opened

contents of Memory Script:
{
# Make read only the tablespace that will be exported
sql clone 'alter tablespace TT1 read only';
# Create directory for datapump export
sql clone "create or replace directory STREAMS_DIROBJ_DPDIR as ''
/ S01 / dd '' ";
}
executing Memory Script

sql statement: alter tablespace TT1 read only

sql statement: create or replace directory STREAMS_DIROBJ_DPDIR as '' / s01 / dd ''

Performing export of metadata ...
  . EXPDP> Starting "SYS" "TSPITR_EXP_CDty":
  EXPDP> Processing object type TRANSPORTABLE_EXPORT / PLUGTS_BLK
  EXPDP> Processing object type TRANSPORTABLE_EXPORT / TABLE
  EXPDP> Processing object type TRANSPORTABLE_EXPORT / POST_INSTANCE / PLUGTS_BLK
  EXPDP> Master table "SYS". "TSPITR_EXP_CDty" successfully loaded / unloaded
  EXPDP> ************************************************ ******************************
  EXPDP> Dump file set for SYS.TSPITR_EXP_CDty is:
  EXPDP> /s01/dd/dmpfile.dmp
  EXPDP> ************************************************ ******************************
  EXPDP> Datafiles required for transportable tablespace TT1:
  EXPDP> /s01/dd/tt01.dbf
  EXPDP> Job "SYS". "TSPITR_EXP_CDty" successfully completed at 22:00:01
Export completed


-------------------------------------------------- ------------
- Start of sample PL / SQL script for importing the tablespaces
-------------------------------------------------- ------------
- Creating directory objects
CREATE DIRECTORY STREAMS $ DIROBJ $ 1 AS '/ s01 / dd /';
CREATE DIRECTORY STREAMS $ DIROBJ $ DPDIR AS '/ s01 / dd';

DECLARE
  - The datafiles
  tbs_files dbms_streams_tablespace_adm.file_set;
  cvt_files dbms_streams_tablespace_adm.file_set;
  - The dumpfile to import
  dump_file dbms_streams_tablespace_adm.file;
  dp_job_name VARCHAR2 (30): = NULL;
  - Names of tablespaces that were imported
  ts_names dbms_streams_tablespace_adm.tablespace_set;
BEGIN
  - Dump file name and location
  dump_file.file_name: = 'dmpfile.dmp';
  dump_file.directory_object: = 'STREAMS $ DIROBJ $ DPDIR';
  - Forming list of datafiles for import
  tbs_files (1) .file_name: = 'tt01.dbf';
  tbs_files (1) .directory_object: = 'STREAMS $ DIROBJ $ 1';
  - Import tablespaces
  dbms_streams_tablespace_adm.attach_tablespaces (
    datapump_job_name => dp_job_name,
    dump_file => dump_file,
    tablespace_files => tbs_files,
    converted_files => cvt_files,
    tablespace_names => ts_names);
  - Output names of imported tablespaces
  IF ts_names IS NOT NULL AND ts_names.first IS NOT NULL THEN
    FOR i IN ts_names.first .. ts_names.last LOOP
      dbms_output.put_line ( 'imported tablespace' || ts_names (i));
    END LOOP;
  END IF;
END;
/
- Dropping directory objects
DROP DIRECTORY STREAMS $ DIROBJ $ 1;
DROP DIRECTORY STREAMS $ DIROBJ $ DPDIR;
-------------------------------------------------- ------------
- End of sample PL / SQL script
-------------------------------------------------- ------------

Removing automatic instance
shutting down automatic instance
database closed
database dismounted
Oracle instance shut down
Automatic instance removed
auxiliary instance file /s01/dd/HJJ/datafile/o1_mf_temp_9kj3l8ph_.tmp deleted
auxiliary instance file /s01/dd/HJJ/onlinelog/o1_mf_3_9kj3l3lr_.log deleted
auxiliary instance file /s01/dd/HJJ/onlinelog/o1_mf_2_9kj3l20t_.log deleted
auxiliary instance file /s01/dd/HJJ/onlinelog/o1_mf_1_9kj3l0b0_.log deleted
auxiliary instance file /s01/dd/HJJ/datafile/o1_mf_sysaux_9kj3g706_.dbf deleted
auxiliary instance file /s01/dd/HJJ/datafile/o1_mf_undotbs1_9kj3g77n_.dbf deleted
auxiliary instance file /s01/dd/HJJ/datafile/o1_mf_system_9kj3g6mv_.dbf deleted
auxiliary instance file /s01/dd/HJJ/controlfile/o1_mf_9kj3fpmt_.ctl deleted
Will automatically delete the temporary directory / s01 file under dd / transfer is complete.
Check the directory / s01 / dd
[Root @ myrac1 dd] # ll
total 102508
-rw-r ----- 1 oracle asmadmin 90112 Mar 5 22:00 dmpfile.dmp
drwxr-x --- 5 oracle asmadmin 4096 Mar 5 21:25 HJJ
-rw-r - r-- 1 oracle oinstall 2022 Mar 5 22:00 impscrpt.sql
-rw-r ----- 1 oracle asmadmin 104865792 Mar 5 21:57 tt01.dbf
impscrpt.sql - metadata information, the target database must exist in the corresponding object is the main data file path inconsistent even modify the script.
dmpfile.dmp - also metadata information, if you use dump file import metadata information is no upper limit.
tt01.dbf - data files can be found in the data files generated and original data file exactly the same.
HJJ is a temporary directory / s01 / dd under.

8. The target database to import metadata set
a. Use asm storage system using dump Import
convert datafile '/opt/tts/td/tts.288.755520393' format '+ datagroup';
If you need to make os asm is used above files into asm inside the above command can convert data files between os and asm.
impdp system / oracle @ orcl directory = dp dumpfile = dmpfile.dmp nologfile = y transport_datafiles = '+ DATAGROUP / ORCL / DATAFILE / TTS.290.755528197';
b. Use the file system, use the dump import.
impdp system / oracle @ orcl directory = dp dumpfile = dmpfile.dmp nologfile = y transport_datafiles = '/ opt / oradata / tts.288.755520393';
c. @ / opt / tts / td / impsctpt.sql
9. Copy the source database / s01 / dd directory and data files to the destination database D: \ dd
D: \ dd> ls
dmpfile.alg dmpfile.dmp impscrpt.sql tt01.dbf
10. Check the source data block size and target databases are the same
Source database:
SQL> select block_size from dba_tablespaces where tablespace_name = 'TT1';

BLOCK_SIZE
----------
      8192
Target database:
SQL> show parameter db_block_size

NAME TYPE VALUE
------------------------------------ -------------- -------- ---------
db_block_size integer 8192
11. Create a user on the target data
C: \> sqlplus / as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Thu Mar 6 14:25:09 2014

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user tt1 identified by oracle;

User created.

SQL> grant connect, resource to tt1;

Grant succeeded.
Run the script impscrpt.sql
SQL> @D: \ dd \ impscrpt.sql
Directory created.


Directory created.

DECLARE
*
ERROR at line 1:
ORA-06512: at "SYS.DBMS_STREAMS_TABLESPACE_ADM", line 1854
ORA-06512: at line 18

 

Directory dropped.


Directory dropped.
See dmpfile.alg files found
Master table "SYS". "SYS_IMPORT_TRANSPORTABLE_04" successfully loaded / unloaded
Starting "SYS" "SYS_IMPORT_TRANSPORTABLE_04".:
Processing object type TRANSPORTABLE_EXPORT / PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-29345: can not plug a tablespace into a database using an incompatible character set
Job "SYS". "SYS_IMPORT_TRANSPORTABLE_04" stopped due to fatal error at 14:58:40
Tip table space can not be imported into the database character set is not compatible
View the source database character set and the target database
Source database:
SQL> select userenv ( 'language') from dual;

USERENV ( 'LANGUAGE')
-------------------------------------------------- -
AMERICAN_AMERICA.WE8MSWIN1252
Target database:
SQL> select userenv ( 'language') from dual;

USERENV ( 'LANGUAGE')
------------------------------------------
AMERICAN_AMERICA.AL32UTF8

Character set does not match, but I can use impdp manually import settings in the win set NLS_LANG
In accordance with their own ideas to try
SQL> create directory dp as 'd: \ dd';

Directory created.
D: \ dd> impdp system / oracle @ orcl directory = dp dumpfile = dmpfile.dmp nologfile = y transport_datafiles = 'tt01.dbf';

Import: Release 11.2.0.1.0 - Production on Thu Mar 6 14:51:07 2014

Copyright (c) 1982, 2009, Oracle and / or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM". "SYS_IMPORT_TRANSPORTABLE_01" successfully loaded / unloaded
. Starting "SYSTEM" "SYS_IMPORT_TRANSPORTABLE_01": system / ******** @ orcl directory = dp dumpfile = dmpfile.dmp nologfile = y transport_datafiles = 'tt01.dbf';
Processing object type TRANSPORTABLE_EXPORT / PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-29345: can not plug a tablespace into a database using an incompatible character set

Job "SYSTEM". "SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 14:51:15
Found not compatible reported the same mistakes, character set. Modify the target database character set for the source database character set
SQL> conn / as sysdba
Connected to an idle instance.
SQL> alter database character set INTERNAL_USE WE8MSWIN1252;
alter database character set INTERNAL_USE WE8MSWIN1252
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> startup mount
ORACLE instance started.

Total System Global Area 1235959808 bytes
Fixed Size 2175288 bytes
Variable Size 956305096 bytes
Database Buffers 268435456 bytes
Redo Buffers 9043968 bytes
Database mounted.
SQL> alter database character set INTERNAL_USE WE8MSWIN1252;
alter database character set INTERNAL_USE WE8MSWIN1252
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode


SQL> alter system enable restricted session;

System altered.

SQL> alter database character set internal_use WE8MSWIN1252;
alter database character set internal_use WE8MSWIN1252
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01109: database not open


SQL> alter database open;

Database altered.

SQL> alter database character set internal_use WE8MSWIN1252;

Database altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1235959808 bytes
Fixed Size 2175288 bytes
Variable Size 956305096 bytes
Database Buffers 268435456 bytes
Redo Buffers 9043968 bytes
Database mounted.
SQL> alter system disable restricted session;

System altered.

SQL> alter database open;

Database altered.

SQL> select userenv ( 'language') from dual;

USERENV ( 'LANGUAGE')
-------------------------------------------------- -
AMERICAN_AMERICA.WE8MSWIN1252

Use impdp reintroduced
D: \ dd> impdp system / oracle @ orcl directory = dp dumpfile = dmpfile.dmp nologfile = y transport_datafiles = 'd: \ dd \ tt01.dbf'

Import: Release 11.2.0.1.0 - Production on Thu Mar 6 15:59:43 2014

Copyright (c) 1982, 2009, Oracle and / or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM". "SYS_IMPORT_TRANSPORTABLE_01" successfully loaded / unloaded
. Starting "SYSTEM" "SYS_IMPORT_TRANSPORTABLE_01": system / ******** @ orcl directory = dp dumpfile = dmpfile.dmp nologfile = y transport_datafiles = 'd: \ dd \ tt01.dbf'
Processing object type TRANSPORTABLE_EXPORT / PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT / TABLE
Processing object type TRANSPORTABLE_EXPORT / POST_INSTANCE / PLUGTS_BLK
Job "SYSTEM". "SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 15:59:57
impdp execution, you can run impscrpt.sql, also successful. Because the two methods are the same error message.
D: \ dd> sqlplus / as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Thu Mar 6 16:02:02 2014

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter user tt1 defalut tablespace tt1;
alter user tt1 defalut tablespace tt1
              *
ERROR at line 1:
ORA-00922: missing or invalid option


SQL> alter user tt1 default tablespace tt1;

User altered.
Target end into default table space is READ-ONLY; tablespace to READ WRITE
SQL> select tablespace_name, status from dba_tablespaces where tablespace_name = 'TT1';

TABLESPACE_NAME STATUS
------------------------------ ---------
TT1 READ ONLY
SQL> alter tablespace tt1 read write;

Tablespace altered.

SQL> select tablespace_name, status from dba_tablespaces where tablespace_name = 'TT1';

TABLESPACE_NAME STATUS
------------------------------ ---------
TT1 ONLINE
SQL> conn tt1 / oracle
Connected.
SQL> select count (*) from t;

  COUNT (*)
----------
    21293
Thus the table space migration from linux ASM disk group to the next win FS systems.
Problems encountered and note items
1. The name of the source database table space can not test, because the test is RMAN keywords.
RMAN> transport tablespace test tablespace destination "/ s01 / dd" auxiliary destination "/ s01 / dd";

RMAN-00571: ============================================== =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ============================================== =============
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "test": expecting one of: "double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 1 column 22 file: standard input
http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmcomma001.htm#RCMRF909 a note
2. If the byte order of the two platforms are inconsistent, you can use rman for transformation.
RMAN> convert tablespace tt1 to platform 'Microsoft Windows IA (32-bit)' format '/ tmp /% N_% F';
RMAN> convert datafile '/ tmp / BOOKS_5' db_file_name_convert '/tmp/BOOKS_5','/tmp/books01.dbf';
3. Create a transfer process set being given as follows
ORA-19502: write error on file "/s01/dd/HJJ/datafile/o1_mf_system_9kj14qc1_.dbf", block number 82816 (block size = 8192)
ORA-27072: File I / O error
Linux Error: 25: Inappropriate ioctl for device
Additional information: 4
Additional information: 82816
Additional information: 344064
auxiliary instance file /s01/dd/HJJ/controlfile/o1_mf_9kj148lp_.ctl deleted
RMAN-00571: ============================================== =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ============================================== =============
RMAN-03002: failure of transport tablespace command at 03/05/2014 21:18:59
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01180: can not create datafile 1
ORA-01110: data file 1: '+ DATA_DG / hjj / datafile / system.260.837919351'
Because when you create a transfer set and requires a temporary directory / s01 / dd, will backup set datafile, onlinelog, controlfile stored here, so good estimate of the space in advance.
This error is caused because of lack of space.

Reflection: Using RMAN cross-platform transfer table space, personal very troublesome, first back up the whole library, archive logs and control files, and finally had to use imp / impdp import. Then why not just use imp / expdp import simple question complicated, is not known where the advantages of this approach.
     
         
       
         
  More:      
 
- Use LKM change the default linux security level (Linux)
- ORA-00911 invalid character error Solution (Database)
- How x2go set up Remote Desktop on Linux (Linux)
- Linux operating system boot manager -GRUB (Linux)
- Command line tool Tmux (Linux)
- Fast Learning Clojure (Programming)
- Installation and Configuration Munin monitoring server on Linux (Server)
- Talking about the shortcomings and deficiencies of the firewall (Linux)
- IP configuration under Linux (Linux)
- Single-node Hadoop installation notes distributed pseudo & (Server)
- Sysdig: system troubleshooting tool (Linux)
- MySQL optimization resulting order by using filesort (Database)
- C ++ pointer of the (error-prone model) (Programming)
- Multi-core CPU, multi-threading and parallel computation (Linux)
- How to back up Debian system backupninja (Linux)
- Oracle 12c In-Memory Study (Database)
- Unix / Linux commonly used to clean up disk space command (Linux)
- C # socket udp broadcast (Programming)
- awk variables (Linux)
- Simple configuration shell scripts virtual machine environment experiment (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.