xtts 检查和日志记录

最新推荐文章于 2024-04-13 15:11:22 发布

rgb_rgb

最新推荐文章于 2024-04-13 15:11:22 发布

阅读量465

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle

本文链接：https://blog.youkuaiyun.com/rgb_rgb/article/details/78018943

oracle 专栏收录该内容

90 篇文章

订阅专栏

本文介绍了一个Oracle数据库跨平台迁移的实例，展示了如何使用RMAN工具准备源端表空间以实现从旧平台到新平台的数据迁移。涉及的平台包括AIX、Linux x86_64、Solaris等，并说明了不同平台的字节序格式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

sql>select tp.PLATFORM_ID platformid,d.platform_name, endian_format from v$transportable_platform tp, v$database d where tp.platform_name = d.platform_name;
old:
PLATFORMID PLATFORM_NAME                                                                                         ENDIAN_FORMAT
---------- ----------------------------------------------------------------------------------------------------- --------------
         6 AIX-Based Systems (64-bit)                                                                            Big
new:
PLATFORMID PLATFORM_NAME                       ENDIAN_FORMAT
---------- ----------------------------------- --------------
        13 Linux x86 64-bit                    Little

new-sql>col platform_name for a35
select * from v$transportable_platform order by 3,2;


PLATFORM_ID PLATFORM_NAME                       ENDIAN_FORMAT
----------- ----------------------------------- --------------
          6 AIX-Based Systems (64-bit)          Big
         16 Apple Mac OS                        Big
          3 HP-UX (64-bit)                      Big
          4 HP-UX IA (64-bit)                   Big
         18 IBM Power Based Linux               Big
          9 IBM zSeries Based Linux             Big
          1 Solaris[tm] OE (32-bit)             Big
          2 Solaris[tm] OE (64-bit)             Big
         21 Apple Mac OS (x86-64)               Little
         19 HP IA Open VMS                      Little
         15 HP Open VMS                         Little
          5 HP Tru64 UNIX                       Little
         10 Linux IA (32-bit)                   Little
         11 Linux IA (64-bit)                   Little
         13 Linux x86 64-bit                    Little
          7 Microsoft Windows IA (32-bit)       Little
          8 Microsoft Windows IA (64-bit)       Little
         12 Microsoft Windows x86 64-bit        Little
         17 Solaris Operating System (x86)      Little
         20 Solaris Operating System (x86-64)   Little

20 rows selected.


--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------

--------------------------------------------------------------------
Starting prepare phase
--------------------------------------------------------------------
Prepare source for Tablespaces:
                  'TEST01','TEST02','TESTIDX01','TESTIDX02'  /tmpfs/rman-file/backup
xttpreparesrc.sql for 'TEST01','TEST02','TESTIDX01','TESTIDX02' started at Fri Sep 15 21:09:23 2017
xttpreparesrc.sql for  ended at Fri Sep 15 21:09:24 2017
Prepare source for Tablespaces:
                  'TBS_03','TBS_04'  /tmpfs/rman-file/backup
xttpreparesrc.sql for 'TBS_03','TBS_04' started at Mon Sep 18 04:16:05 2017
xttpreparesrc.sql for  ended at Mon Sep 18 04:16:05 2017

--------------------------------------------------------------------
Done with prepare phase
--------------------------------------------------------------------