自治區(qū)人民醫(yī)院電子病歷遷移方案

1. 目的

傳統(tǒng)的傳輸表空間方式要求數(shù)據(jù)第一次由遠(yuǎn)端到目標(biāo)端傳輸時(shí)，表空間必須置于read only模式鳍置，從而生產(chǎn)不可用。而XTTS方式則只需要在最后一次增量備份時(shí)將表空間置于read only模式，顯著的減少了停機(jī)的時(shí)間

XTTS can significantly reduce the amount of downtime required to move data between platforms using enhanced RMAN‘s bility

2. oracle建議使用場(chǎng)景

from a big endian platform to linux: XTTS
from a little endian platform to Linux: DATAGUARD

3. 平臺(tái)椭迎、數(shù)據(jù)庫版本要求

DATABASE:source端：Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.2
dest端：如果使用dbms_file_transfer（DFT）衰琐，必須是11.2.0.4以上
如何是Recovery Manager （RMAN）楷怒，版本低于11.2.0.4時(shí)需要安裝11.2.0.4的RDBMS運(yùn)行11.2.0.4的實(shí)例

OS:source端: any platform provided the prerequisites：cannot be Windows
dest端: only 64-bit Oracle Linux or RedHat Linux certified

4. 常見平臺(tái)字節(jié)

SQL> COLUMN PLATFORM_NAME FORMAT A36
SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM ORDER BY PLATFORM_NAME;

PLATFORM_ID PLATFORM_NAME                        ENDIAN_FORMAT
----------- ------------------------------------ --------------
      6 AIX-Based Systems (64-bit)           Big
     16 Apple Mac OS                         Big
     19 HP IA Open VMS                       Little
     15 HP Open VMS                          Little
      5 HP Tru64 UNIX                        Little
      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
     10 Linux IA (32-bit)                    Little
     11 Linux IA (64-bit)                    Little

PLATFORM_ID PLATFORM_NAME                        ENDIAN_FORMAT
----------- ------------------------------------ --------------
     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
      1 Solaris[tm] OE (32-bit)              Big
      2 Solaris[tm] OE (64-bit)              Big

19 rows selected.

前提

source端和dest端的要使用兼容性數(shù)據(jù)庫字符集及國(guó)家語言字符集

source端：

SQL@source> select * from nls_database_parameters where parameter='NLS_CHARACTERSET' or parameter='NLS_LANGUAGE';

PARAMETER            VALUE
-------------------- --------------------
NLS_LANGUAGE         AMERICAN
NLS_CHARACTERSET     ZHS16GBK

dest端：

SQL@dest> select * from nls_database_parameters where parameter='NLS_CHARACTERSET' or parameter='NLS_LANGUAGE';

PARAMETER                      VALUE
----------------------------------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_CHARACTERSET               ZHS16GBK

傳輸?shù)谋砜臻g必須自包涵，諸如物化視圖凹髓，分區(qū)表，索引要特別注意檢查

SQL@source> execute dbms_tts.transport_set_check('ZEMR,ZEMRT,ZEMR_IDX,ZEMRT_IDX,XJCA_TABLESPACE,ISIGNATURESERVER_DATA,ISIGNATURESERVER_LOG,ISIGNATURESERVER_INDEX,ZEMR_EMR_CONTENT_2006,ZEMR_EMR_CONTENT_2007,ZEMR_EMR_CONTENT_2008,ZEMR_EMR_CONTENT_2009,ZEMR_EMR_CONTENT_2010,ZEMR_EMR_CONTENT_2011,ZEMR_EMR_CONTENT_2012,ZEMR_EMR_CONTENT_2013,ZEMR_EMR_CONTENT_2014,ZEMR_EMR_CONTENT_2015,ZEMR_CONTENT_2016,ZEMR_CONTENT_2017,ZEMR_CONTENT_2018',true);

SQL@source> select * from transport_set_violations;
no rows selected

XTSS操作步驟: 使用dbms_file_transfer方式

1.初始化

step 1:source創(chuàng)建directory：sourcedir怯屉，路徑使用當(dāng)前數(shù)據(jù)文件使用的路徑

SQL@source> create or replace directory sourcedir as '/u01/app/oracle/oradata/rmyyzemr/';

step 2:dest創(chuàng)建directory：destdir蔚舀，路徑使用當(dāng)前數(shù)據(jù)文件使用的路徑

SQL@dest> create or replace directory destdir as '/u01/app/oracle/oradata/rmyyzemr/';

step 3：創(chuàng)建dest端到source端的dblink

SQL@dest> create public database link ttslink connect to system identified by **** using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST =192.168.1.71)(PORT = 1521)) )(CONNECT_DATA = (SERVICE_NAME = rmyyzemr )) )';

SQL@dest> select * from v$version@ttslink;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

step 4：source端和dest端創(chuàng)建migration需要使用的目錄

[oracle@source]$ mkdir -p /u01/rman-xttconvert
[oracle@dest]$ mkdir -p /u01/rman-xttconvert

在source端解壓XTTS使用的腳本，同時(shí)將解壓后的文件傳到dest端

[oracle@source]$ pwd                                   
/u01
[oracle@source]$ unzip rman-xttconvert_2.0.zip -d rman-xttconvert
Archive:  rman-xttconvert_2.0.zip
inflating: rman-xttconvert/xttcnvrtbkupdest.sql  
inflating: rman-xttconvert/xttdbopen.sql  
inflating: rman-xttconvert/xttdriver.pl   
inflating: rman-xttconvert/xttprep.tmpl   
inflating: rman-xttconvert/xtt.properties  
inflating: rman-xttconvert/xttstartupnomount.sql
[oracle@source]$ scp -r rman-xttconvert 192.168.1.180:/u01

設(shè)置環(huán)境變量

[oracle@source]$ export TMPDIR=/u01/rman-xttconvert
[oracle@dest]$ export TMPDIR=/u01/rman-xttconvert

編輯xtt.properties

[oracle@source]$ vi xtt.properties
[oracle@source]$ scp xtt.properties 192.168.1.180:/u01/rman-xttconvert

2.準(zhǔn)備階段

[oracle@source]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -S
[oracle@source]$ scp xttnewdatafiles.txt getfile.sql 192.168.1.180:/u01/rman-xttconvert

3.目標(biāo)端開始抽取數(shù)據(jù)

[oracle@dest]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -G

4.源端第一次增量備份

[oracle@source]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -i
[oracle@source]$ scp xttplan.txt tsbkupmap.txt 192.168.1.180:/u01/rman-xttconvert

5.目標(biāo)端應(yīng)用增量備份

[oracle@dest]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -r

6.源端推進(jìn)scn

[oracle@source]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -s

7.源端最后一次增量備份

先將所有需傳輸?shù)谋砜臻g修改為只讀

SQL@source> ALTER TABLESPACE ZEMR READ ONLY;
SQL@source> ALTER TABLESPACE ZEMRT READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_IDX READ ONLY;
SQL@source> ALTER TABLESPACE ZEMRT_IDX READ ONLY;
SQL@source> ALTER TABLESPACE XJCA_TABLESPACE READ ONLY;
SQL@source> ALTER TABLESPACE ISIGNATURESERVER_DATA READ ONLY;
SQL@source> ALTER TABLESPACE ISIGNATURESERVER_LOG READ ONLY;
SQL@source> ALTER TABLESPACE ISIGNATURESERVER_INDEX READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_EMR_CONTENT_2006 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_EMR_CONTENT_2007 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_EMR_CONTENT_2008 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_EMR_CONTENT_2009 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_EMR_CONTENT_2010 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_EMR_CONTENT_2011 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_EMR_CONTENT_2012 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_EMR_CONTENT_2013 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_EMR_CONTENT_2014 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_EMR_CONTENT_2015 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_CONTENT_2016 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_CONTENT_2017 READ ONLY;
SQL@source> ALTER TABLESPACE ZEMR_CONTENT_2018 READ ONLY;

[oracle@source]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -i
[oracle@source]$ scp xttplan.txt tsbkupmap.txt 192.168.1.180:/u01/rman-xttconvert

8.目標(biāo)端最后一次應(yīng)用增量備份

[oracle@dest]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -r

9.目標(biāo)端數(shù)據(jù)庫創(chuàng)建數(shù)據(jù)庫用戶

SQL@dest> CREATE USER ZEMR IDENTIFIED BY VALUES 'S:0F179388CE209C1F80D631E8B835DC25B997CEDC00AC3CE2E3B8EEEC4916;62535043B5AD5628';
SQL@dest> CREATE USER XJCAAUTH IDENTIFIED BY VALUES 'S:78667D3EFB0C05CD004C8867983446D3C9E9FFA753ABA585C0D7C7CED689;79E27982953ED7D1';
SQL@dest> CREATE USER GGSADMIN IDENTIFIED BY VALUES 'S:B5B383610EB30B0D7D7BD54B44EB3DF4ECCE75ACA0B52A82588954FD42A6;2942F3992588BDB4';
SQL@dest> CREATE USER ZABBIX IDENTIFIED BY VALUES 'S:62EA44321560A0AF5BC58274C399E8C819BC432E1237D257FF2A3EA9996B;9A31F4B8D0743A01';
SQL@dest> CREATE USER KINGGRID IDENTIFIED BY VALUES 'S:796496A0586D2B3AD15CE9B38D1D70F324BC1D4D9542235B14577DA24DFD;CCE9EA3CCF642DD1';
SQL@dest> CREATE USER DSG IDENTIFIED BY VALUES 'S:FEC505CC032D4EB0DC81DDDD3E8389A90003A37D23A2B2BAA203B4BA8D07;4360B1302DA4165F';
SQL@dest> CREATE USER XHLIS IDENTIFIED BY VALUES 'S:9CA74C2497FD002518D79754F54E2B507E15B5CA04DB4E0740F57EADE6D8;C202B88557552391';
SQL@dest> CREATE USER ZEMRNIS IDENTIFIED BY VALUES 'S:3045F8A7BFCF250CBA872D1F27E529703AAA04E0002BF34090D0917D4B01;D7C1F52A5EFCDAED';

SQL@dest> GRANT DBA TO ZEMR;
SQL@dest> GRANT CONNECT TO XJCAAUTH;
SQL@dest> GRANT CONNECT TO GGSADMIN;
SQL@dest> GRANT RESOURCE TO GGSADMIN;
SQL@dest> GRANT DBA TO GGSADMIN;
SQL@dest> GRANT CONNECT TO ZABBIX;
SQL@dest> GRANT CONNECT TO KINGGRID;
SQL@dest> GRANT RESOURCE TO KINGGRID;
SQL@dest> GRANT CONNECT TO DSG;
SQL@dest> GRANT DBA TO DSG;
SQL@dest> GRANT CONNECT TO XHLIS;
SQL@dest> GRANT CONNECT TO ZEMRNIS;

10.目標(biāo)端元數(shù)據(jù)的恢復(fù)

[oracle@dest]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl -e
[oracle@dest]$ cat xttplugin.txt
[oracle@dest]$ impdp directory=DATA_PUMP_DIR logfile=tts_imp.log \
network_link=ttslink transport_full_check=no \
transport_tablespaces=ZEMRT,ZEMRT_IDX,XJCA_TABLESPACE,ISIGNATURESERVER_DATA,ISIGNATURESERVER_LOG,ISIGNATURESERVER_INDEX,ZEMR,ZEMR_EMR_CONTENT_2006,ZEMR_EMR_CONTENT_2007,ZEMR_EMR_CONTENT_2008,ZEMR_EMR_CONTENT_2009,ZEMR_CONTENT_2016,ZEMR_CONTENT_2017,ZEMR_CONTENT_2018,ZEMR_EMR_CONTENT_2010,ZEMR_EMR_CONTENT_2011,ZEMR_EMR_CONTENT_2012,ZEMR_IDX,ZEMR_EMR_CONTENT_2013,ZEMR_EMR_CONTENT_2014,ZEMR_EMR_CONTENT_2015 \
transport_datafiles='/u01/app/oracle/oradata/rmyyzemr/ZEMRT02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMRT01.ORA','/u01/app/oracle/oradata/rmyyzemr/zemrt03.ora','/u01/app/oracle/oradata/rmyyzemr/zemr04.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt05.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt06.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt07.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt08.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt09.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt10.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt11.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt12.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt14.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt15.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt16.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt17.ora','/u01/app/oracle/oradata/rmyyzemr/zemrt13.ora','/u01/app/oracle/oradata/rmyyzemr/ZEMRT_IDX02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMRT_IDX01.ORA','/u01/app/oracle/oradata/rmyyzemr/xjca01.ora','/u01/app/oracle/oradata/rmyyzemr/ISIGNATURESERVER_DATA.DBF','/u01/app/oracle/oradata/rmyyzemr/ISIGNATURESERVER_LOG.DBF','/u01/app/oracle/oradata/rmyyzemr/ISIGNATURESERVER_INDEX.DBF','/u01/app/oracle/oradata/rmyyzemr/ZEMR01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2006_02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2006_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2007_02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2007_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2008_02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2008_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2008_03.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2009_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2009_02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2016_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2016_02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2016_03.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2016_04.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2016_05.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2016_06.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2017_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2017_02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2017_03.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2017_04.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2017_05.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2017_06.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2018_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2018_02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2018_03.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2018_04.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2010_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2010_02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2011_02.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_CONTENT_2011_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_EMR_CONTENT_2012_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_EMR_CONTENT_2012_02','/u01/app/oracle/oradata/rmyyzemr/ZEMR_IDX_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_EMR_CONTENT_2013_01.ORA','/u01/app/oracle/oradata/rmyyzemr/ZEMR_EMR_CONTENT_2013_02.ORA','/u01/app/oracle/oradata/rmyyzemr/zemr_emr_content_2014_01.ora','/u01/app/oracle/oradata/rmyyzemr/zemr_emr_content_2014_02.ora','/u01/app/oracle/oradata/rmyyzemr/zemr_emr_content_2014_03.ora','/u01/app/oracle/oradata/rmyyzemr/zemr_emr_content_2015_01.ora','/u01/app/oracle/oradata/rmyyzemr/zemr_emr_content_2015_02.ora','/u01/app/oracle/oradata/rmyyzemr/zemr_emr_content_2015_03.ora','/u01/app/oracle/oradata/rmyyzemr/zemr_emr_content_2015_04.ora','/u01/app/oracle/oradata/rmyyzemr/zemr_emr_content_2015_05.ora'

SQL@dest> ALTER TABLESPACE ZEMR READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMRT READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_IDX READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMRT_IDX READ WRITE;
SQL@dest> ALTER TABLESPACE XJCA_TABLESPACE READ WRITE;
SQL@dest> ALTER TABLESPACE ISIGNATURESERVER_DATA READ WRITE;
SQL@dest> ALTER TABLESPACE ISIGNATURESERVER_LOG READ WRITE;
SQL@dest> ALTER TABLESPACE ISIGNATURESERVER_INDEX READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_EMR_CONTENT_2006 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_EMR_CONTENT_2007 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_EMR_CONTENT_2008 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_EMR_CONTENT_2009 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_EMR_CONTENT_2010 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_EMR_CONTENT_2011 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_EMR_CONTENT_2012 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_EMR_CONTENT_2013 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_EMR_CONTENT_2014 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_EMR_CONTENT_2015 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_CONTENT_2016 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_CONTENT_2017 READ WRITE;
SQL@dest> ALTER TABLESPACE ZEMR_CONTENT_2018 READ WRITE;

11.元數(shù)據(jù)有三個(gè)表創(chuàng)建失敗锨络，使用expdp重新導(dǎo)出導(dǎo)入

SQL@source>CREATE DIRECTORY REMOTE AS '/mnt/oradata/full/';
[oracle@source]$ expdp system/***** directory=REMOTEDIR  tables=ZEMR.ZEMR_NURSE_PATIENT_INFO,ZEMR.ZEMR_SPEC_EMR_CONFIG,ZEMR.ZKB_LOGIC_MODEL_SOURCE,ZEMR.QUEST_SL_TEMP_EXPLAIN1 parallel=4 job_name=expemr1 dumpfile=expdata.DMP logfile=expdp.log

SQL@dest>CREATE DIRECTORY REMOTE AS '/u01/share/full/';
[oracle@dest]$ impdp zemr/swxp4101886 directory=REMOTEDIR  dumpfile=expdata.DMP parallel=4 logfile=impdp.log  table_exists_action=replace  job_name=impemr1

12.驗(yàn)證傳輸?shù)臄?shù)據(jù)

RMAN@dest> VALIDATE TABLESPACE ZEMR CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMRT CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_IDX CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMRT_IDX CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE XJCA_TABLESPACE CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ISIGNATURESERVER_DATA CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ISIGNATURESERVER_LOG CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ISIGNATURESERVER_INDEX CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_EMR_CONTENT_2006 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_EMR_CONTENT_2007 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_EMR_CONTENT_2008 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_EMR_CONTENT_2009 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_EMR_CONTENT_2010 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_EMR_CONTENT_2011 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_EMR_CONTENT_2012 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_EMR_CONTENT_2013 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_EMR_CONTENT_2014 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_EMR_CONTENT_2015 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_CONTENT_2016 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_CONTENT_2017 CHECK LOGICAL;
RMAN@dest> VALIDATE TABLESPACE ZEMR_CONTENT_2018 CHECK LOGICAL;

13.更改用戶默認(rèn)表空間

SQL@dest> alter user KINGGRID default tablespace ISIGNATURESERVER_DATA;
SQL@dest> alter user XJCAAUTH default tablespace XJCA_TABLESPACE;
SQL@dest> alter user ZEMR default tablespace ZEMRT;

SQL@dest> alter user KINGGRID quota unlimited on ISIGNATURESERVER_DATA;
SQL@dest> alter user XJCAAUTH quota unlimited on XJCA_TABLESPACE;
SQL@dest> alter user ZEMR quota unlimited on ZEMRT;

14.用戶權(quán)限

SQL@dest> grant SELECT on ZEMR.ITF_PAT_CHARACTER_IP to ZEMRNIS with grant option;
SQL@dest> grant SELECT on ZEMR.ITF_PAT_CHARACTER_IP to ZEMRNIS;
SQL@dest> grant SELECT on ZEMR.ITF_PAT_DIAGNOSIS_IP to ZEMRNIS with grant option;
SQL@dest> grant SELECT on ZEMR.ITF_PAT_DIAGNOSIS_IP to ZEMRNIS;
SQL@dest> grant SELECT on ZEMR.V_NIS_BASICINFO to ZEMRNIS with grant option;
SQL@dest> grant SELECT on ZEMR.V_NIS_BASICINFO to ZEMRNIS;
SQL@dest> grant SELECT on ZEMR.V_NIS_DIAGNOSIS to ZEMRNIS with grant option;
SQL@dest> grant SELECT on ZEMR.V_NIS_DIAGNOSIS to ZEMRNIS;
SQL@dest> grant SELECT on ZEMR.V_NIS_EMR to ZEMRNIS with grant option;
SQL@dest> grant SELECT on ZEMR.V_NIS_EMR to ZEMRNIS;
SQL@dest> grant SELECT on ZEMR.V_NIS_TEMPERATURE to ZEMRNIS with grant option;
SQL@dest> grant SELECT on ZEMR.V_NIS_TEMPERATURE to ZEMRNIS;
SQL@dest> grant SELECT on ZEMR.V_NIS_WEIGHT to ZEMRNIS with grant option;
SQL@dest> grant SELECT on ZEMR.V_NIS_WEIGHT to ZEMRNIS;
SQL@dest> grant SELECT on ZEMR.ZEMR_TEMPERATURE_POINT_RECORD to XHLIS with grant option;
SQL@dest> grant SELECT on ZEMR.ZEMR_TEMPERATURE_POINT_RECORD to XHLIS;

SQL@dest> grant SELECT on SYS.DBA_AUDIT_SESSION to ZABBIX;
SQL@dest> grant SELECT on SYS.DBA_DATA_FILES to ZABBIX;
SQL@dest> grant SELECT on SYS.DBA_FREE_SPACE to ZABBIX;
SQL@dest> grant SELECT on SYS.DBA_OBJECTS to ZABBIX;
SQL@dest> grant SELECT on SYS.DBA_REGISTRY to ZABBIX;
SQL@dest> grant SELECT on SYS.DBA_TABLESPACES to ZABBIX;
SQL@dest> grant SELECT on SYS.DBA_TEMP_FILES to ZABBIX;
SQL@dest> grant SELECT on SYS.DBA_USERS to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$ACTIVE_SESSION_HISTORY to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$BGPROCESS to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$INSTANCE to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$LATCH to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$LIBRARYCACHE to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$LOCK to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$LOG to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$LOG_HISTORY to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$PARAMETER to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$PGASTAT to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$PROCESS to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$SESSION to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$SGASTAT to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$SYSSTAT to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$SYSTEM_EVENT to ZABBIX;
SQL@dest> grant SELECT on SYS.GV_$TABLESPACE to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$ACTIVE_SESSION_HISTORY to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$ARCHIVED_LOG to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$BGPROCESS to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$DATABASE_INCARNATION to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$INSTANCE to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$LATCH to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$LIBRARYCACHE to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$LOCK to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$LOG to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$LOG_HISTORY to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$PARAMETER to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$PGASTAT to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$PROCESS to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$SESSION to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$SGASTAT to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$SYSSTAT to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$SYSTEM_EVENT to ZABBIX;
SQL@dest> grant SELECT on SYS.V_$TABLESPACE to ZABBIX;

最后編輯于：2018.11.21 11:28:47

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請(qǐng)聯(lián)系作者

人面猴
序言：七十年代末赌躺，一起剝皮案震驚了整個(gè)濱河市，隨后出現(xiàn)的幾起案子羡儿，更是在濱河造成了極大的恐慌礼患，老刑警劉巖，帶你破解...
沈念sama閱讀 211,348評(píng)論 6贊 491
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件掠归，死亡現(xiàn)場(chǎng)離奇詭異缅叠，居然都是意外死亡，警方通過查閱死者的電腦和手機(jī)虏冻，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 90,122評(píng)論 2贊 385
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進(jìn)店門肤粱，熙熙樓的掌柜王于貴愁眉苦臉地迎上來，“玉大人厨相，你說我怎么就攤上這事领曼。” “怎么了蛮穿？”我有些...
開封第一講書人閱讀 156,936評(píng)論 0贊 347
道士緝兇錄：失蹤的賣姜人
文/不壞的土叔我叫張陵庶骄，是天一觀的道長(zhǎng)。經(jīng)常有香客問我绪撵，道長(zhǎng)瓢姻，這世上最難降的妖魔是什么？我笑而不...
開封第一講書人閱讀 56,427評(píng)論 1贊 283
?港島之戀（遺憾婚禮）
正文為了忘掉前任音诈，我火速辦了婚禮幻碱，結(jié)果婚禮上，老公的妹妹穿的比我還像新娘细溅。我一直安慰自己褥傍，他們只是感情好，可當(dāng)我...
茶點(diǎn)故事閱讀 65,467評(píng)論 6贊 385
惡毒庶女頂嫁案：這布局不是一般人想出來的
文/花漫我一把揭開白布喇聊。她就那樣靜靜地躺著恍风，像睡著了一般。火紅的嫁衣襯著肌膚如雪。梳的紋絲不亂的頭發(fā)上朋贬，一...
開封第一講書人閱讀 49,785評(píng)論 1贊 290
城市分裂傳說
那天凯楔，我揣著相機(jī)與錄音，去河邊找鬼锦募。笑死摆屯，一個(gè)胖子當(dāng)著我的面吹牛，可吹牛的內(nèi)容都是我干的糠亩。我是一名探鬼主播虐骑，決...
沈念sama閱讀 38,931評(píng)論 3贊 406
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開眼，長(zhǎng)吁一口氣：“原來是場(chǎng)噩夢(mèng)啊……” “哼赎线！你這毒婦竟也來了廷没？” 一聲冷哼從身側(cè)響起，我...
開封第一講書人閱讀 37,696評(píng)論 0贊 266
萬榮殺人案實(shí)錄
序言：老撾萬榮一對(duì)情侶失蹤垂寥，失蹤者是張志新（化名）和其女友劉穎颠黎，沒想到半個(gè)月后，有當(dāng)?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體滞项，經(jīng)...
沈念sama閱讀 44,141評(píng)論 1贊 303
?護(hù)林員之死
正文獨(dú)居荒郊野嶺守林人離奇死亡盏缤，尸身上長(zhǎng)有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點(diǎn)故事閱讀 36,483評(píng)論 2贊 327
?白月光啟示錄
正文我和宋清朗相戀三年，在試婚紗的時(shí)候發(fā)現(xiàn)自己被綠了蓖扑。大學(xué)時(shí)的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片。...
茶點(diǎn)故事閱讀 38,625評(píng)論 1贊 340
活死人
序言：一個(gè)原本活蹦亂跳的男人離奇死亡台舱，死狀恐怖律杠，靈堂內(nèi)的尸體忽然破棺而出，到底是詐尸還是另有隱情竞惋，我是刑警寧澤柜去，帶...
沈念sama閱讀 34,291評(píng)論 4贊 329
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布，位于F島的核電站拆宛，受9級(jí)特大地震影響嗓奢，放射性物質(zhì)發(fā)生泄漏。R本人自食惡果不足惜浑厚，卻給世界環(huán)境...
茶點(diǎn)故事閱讀 39,892評(píng)論 3贊 312
男人毒藥：我在死后第九天來索命
文/蒙蒙一股耽、第九天我趴在偏房一處隱蔽的房頂上張望。院中可真熱鬧钳幅，春花似錦物蝙、人聲如沸。這莊子的主人今日做“春日...
開封第一講書人閱讀 30,741評(píng)論 0贊 21
一樁弒父案诬乞，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽。三九已至，卻和暖如春震嫉，著一層夾襖步出監(jiān)牢的瞬間森瘪，已是汗流浹背。一陣腳步聲響...
開封第一講書人閱讀 31,977評(píng)論 1贊 265
情欲美人皮
我被黑心中介騙來泰國(guó)打工票堵，沒想到剛下飛機(jī)就差點(diǎn)兒被人妖公主榨干…… 1. 我叫王不留扼睬，地道東北人。一個(gè)月前我還...
沈念sama閱讀 46,324評(píng)論 2贊 360
代替公主和親
正文我出身青樓换衬，卻偏偏與公主長(zhǎng)得像痰驱，于是被迫代替她去往敵國(guó)和親。傳聞我的和親對(duì)象是個(gè)殘疾皇子瞳浦，可洞房花燭夜當(dāng)晚...
茶點(diǎn)故事閱讀 43,492評(píng)論 2贊 348