1. <tt id="5hhch"><source id="5hhch"></source></tt>
    1. <xmp id="5hhch"></xmp>

  2. <xmp id="5hhch"><rt id="5hhch"></rt></xmp>

    <rp id="5hhch"></rp>
        <dfn id="5hhch"></dfn>

      1. Oracle認證:Oracle控制件文件修復

        時間:2024-07-27 05:06:43 Oracle認證 我要投稿
        • 相關推薦

        Oracle認證:Oracle控制件文件修復

          查看文件頭SCN號:

          SQL> select file#, checkpoint_change# from v;

          FILE# CHECKPOINT_CHANGE#

          1 18120070

          2 18120070

          3 18120070

          4 18120070

          5 18120070

          6 18120070

          7 18120070

          8 18120070

          9 18120070

          10 18120070

          11 18121207

          FILE# CHECKPOINT_CHANGE#

          12 18121196

          12 rows selected.

          查看控制文件SCN號:

          SQL> select file#, checkpoint_change# from v;

          FILE# CHECKPOINT_CHANGE#

          1 18120070

          2 18120070

          3 18120070

          4 18120070

          5 18120070

          6 18120070

          7 18120070

          8 18120070

          9 18120070

          10 18120070

          11 18121207

          FILE# CHECKPOINT_CHANGE#

          12 18121196

          12 rows selected.

          SQL>

          當數據文件SCN號大于控制文件scn號,即會發生控制文件太久的提示,

          當數據文件SCN號小于控制文件scn號時, 則提示mediea recovery提示

          當數據文件sCN號等于控制文件scn號,正常啟動實例

          SQL> alter database backup controlfile to trace as '/u01/Oracle/admin/ora9i/udump/c.trc';

          Database altered.

          SQL>

          /u01/Oracle/oradata/ora9i

          [oracle@test ora9i]$ rm control0*

          [oracle@test ora9i]$

          SQL> shutdown immediate;

          ORA-00210: cannot open the specified controlfile

          ORA-00202: controlfile: '/u01/Oracle/oradata/ora9i/control01.ctl'

          ORA-27041: unable to open file

          Linux Error: 2: No such file or directory

          Additional information: 3

          SQL> shutdown abort;

          ORACLE instance shut down.

          SQL>

          修改備份c.trc文件使用第一個sql

          STARTUP NOMOUNT

          CREATE CONTROLFILE REUSE DATABASE "ORA9I" NORESETLOGS ARCHIVELOG

          MAXLOGFILES 50

          MAXLOGMEMBERS 5

          MAXDATAFILES 100

          MAXINSTANCES 1

          MAXLOGHISTORY 226

          LOGFILE

          GROUP 1 '/u01/Oracle/oradata/ora9i/redo01.log' SIZE 100M,

          GROUP 2 '/u01/Oracle/oradata/ora9i/redo02.log' SIZE 100M,

          GROUP 3 '/u01/Oracle/oradata/ora9i/redo03.log' SIZE 100M

          DATAFILE

          '/u01/Oracle/oradata/ora9i/system01.dbf',

          '/u01/Oracle/oradata/ora9i/undotbs01.dbf',

          '/u01/Oracle/oradata/ora9i/cwmlite01.dbf',

          '/u01/Oracle/oradata/ora9i/drsys01.dbf',

          '/u01/Oracle/oradata/ora9i/example01.dbf',

          '/u01/Oracle/oradata/ora9i/indx01.dbf',

          '/u01/Oracle/oradata/ora9i/odm01.dbf',

          '/u01/Oracle/oradata/ora9i/tools01.dbf',

          '/u01/Oracle/oradata/ora9i/users01.dbf',

          '/u01/Oracle/oradata/ora9i/xdb01.dbf',

          '/u01/Oracle/oradata/ora9i/app2.dbf',

          '/u01/Oracle/oradata/ora9i/app1_01.dbf'

          CHARACTER SET ZHS16GBK

          ;

          # Configure RMAN configuration record 1

          VARIABLE RECNO NUMBER;

          EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON');

          # Recovery is required if any of the datafiles are restored backups,

          # or if the last shutdown was not normal or immediate.

          RECOVER DATABASE

          # All logs need archiving and a log switch is needed.

          ALTER SYSTEM ARCHIVE LOG ALL;

          # Database can now be opened normally.

          ALTER DATABASE OPEN;

          # Commands to add tempfiles to temporary tablespaces.

          # Online tempfiles have complete space information.

          # Other tempfiles may require adjustment.

          ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/Oracle/oradata/ora9i/temp01.dbf' REUSE;

          # End of tempfile additions.

          #

        【Oracle認證:Oracle控制件文件修復】相關文章:

        Oracle認證:ORACLE綁定變量BINDPEEKING03-08

        Oracle認證作用03-19

        Oracle認證簡介11-30

        Oracle最新認證03-09

        Oracle認證途徑03-20

        Oracle認證:Oracle內存結構研究-PGA篇03-08

        Oracle認證:Oracle避免全表掃描方式03-08

        Oracle認證職業前景03-19

        Oracle認證考試技巧03-19

        国产高潮无套免费视频_久久九九兔免费精品6_99精品热6080YY久久_国产91久久久久久无码

        1. <tt id="5hhch"><source id="5hhch"></source></tt>
          1. <xmp id="5hhch"></xmp>

        2. <xmp id="5hhch"><rt id="5hhch"></rt></xmp>

          <rp id="5hhch"></rp>
              <dfn id="5hhch"></dfn>