_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 覦煙螻朱概蟲
Data Analysis(R)
Data Analysis(Python)
Statistics
Data Warehouse
Database System
SQL Server
Trino
Hive
Hadoop
Regular Expressions
Tools
Money
Working Smart
Blog
Booklog
Philosophy
Link
Miscellaneous
__ edit




Describe 覦煙螻朱概蟲 here

覲糾規....

覦煙 瑚 一危覯伎 蟆曙 る 覓語 覦蟆 蠍一ヾ  ろ朱 
讌蠍  豕 ..
覦煙 覲糾規襯  蟆...
蠏碁る 覲糾規 覦覯 手讌..
覲糾規 譬襯 螳讌螳 .. 蠏 譬襯 れ螻 螳給..

覲糾規
   - 豌 覲糾規
   - 企ろ伎 覲糾規
   - 一危  覲糾規
覿 覲糾規
   - 螳蠍磯 覲糾規
   - 豬蠍磯 覲糾規
   - 覲蟆所鍵覦 覲糾規   

 る狩伎 覦煙/覲糾規 碁Μ一 覲糾規襷る朱 蟆 螻牛螻 給...
襦 覲願給..

=====================
覲糾規 -豌 覲糾規-
=====================

覲糾規 一危覯伎れ 覓語螳 覦 蟾讌 覲糾規 蟆 襷..
蠏語 豌 覲糾規 襷蠏碁襦 一危覯伎れ 豌 覲糾規襯 覩誤..
豌企概蟲  れ螻 螳給..

   1. 一危覯伎 щれ
   2. 覦煙  覦煙 覈   ろ 覦煙 伎 覦煙 朱れ 企 蟆暑 れ 豺 
   3. 一危覯伎 襷危
   4. RECOVER DATABASE覓語 ろ
   5. 一危覯伎 ろ

SQL> connect scott/tiger
郁屋給.
SQL> delete from emp
  2  where empno = 7934;

1  給.

SQL> select * from emp
  2  where empno = 7934;

 貊螳 給.

SQL> shutdown
一危磯伎り 給.
一危磯伎り 襷危 伎給.
ORACLE 語ろ伎り 譬襭給.

SQL> !cp $ORACLE_HOME/backup/*.ctl $ORACLE_HOME/oradata/ORCL/.

SQL> !cp $ORACLE_HOME/backup/*.log $ORACLE_HOME/oradata/ORCL/.

SQL> !cp $ORACLE_HOME/backup/*.ora $ORACLE_HOME/oradata/ORCL/.

SQL> !cp $ORACLE_HOME/backup/*.dbf $ORACLE_HOME/oradata/ORCL/.

SQL> set autorecovery on
SQL> recover database;
ORA-00283: ?? ??? ??? ??? ???????      <------------ 螳 ....讒....蠍磯 覲糾規螳 れ..~
ORA-00264: ??? ???? ????


SQL> alter database open;

一危覯伎り 覲蟆暑給.

SQL> select * from scott.emp;

     EMPNO ENAME      JOB              MGR HIREDATE        SAL       COMM     DEPTNO
---------- ---------- --------- ---------- -------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 80/12/17        800                    20
      7499 ALLEN      SALESMAN        7698 81/02/20       1600        300         30
      7521 WARD       SALESMAN        7698 81/02/22       1250        500         30
      7566 JONES      MANAGER         7839 81/04/02       2975                    20
      7654 MARTIN     SALESMAN        7698 81/09/28       1250       1400         30
      7698 BLAKE      MANAGER         7839 81/05/01       2850                    30
      7782 CLARK      MANAGER         7839 81/06/09       2450                    10
      7788 SCOTT      ANALYST         7566 87/04/19       3000                    20
      7839 KING       PRESIDENT            81/11/17       5000                    10
      7844 TURNER     SALESMAN        7698 81/09/08       1500          0         30
      7876 ADAMS      CLERK           7788 87/05/23       1100                    20
      7900 JAMES      CLERK           7698 81/12/03        950                    30
      7902 FORD       ANALYST         7566 81/12/03       3000                    20
      7934 MILLER     CLERK           7782 82/01/23       1300                    10

14 螳  給.

...豌企葦 覃 語 覈 覦煙 襯 蠍磯 螻...
螳螳 蟯 殊 覈譟磯Μ   覲旧企 .....


===================
企ろ伎 覲糾規
===================

SQL> !ls $ORACLE_HOME/oradata
ORCL                   data1.dbf              data2_a.dbf            scott.dmp
archive                data1_1.dbf            local_manage_data.dbf  temp_data.dbf

SQL> alter tablespace data2 begin backup;

企  覲蟆暑給.

SQL> !cp $ORACLE_HOME/oradata/data2_a.dbf $ORACLE_HOME/data2_a.dbf

SQL> alter tablespace data2 end backup;

企  覲蟆暑給.

SQL> shutdown
一危磯伎り 給.
一危磯伎り 襷危 伎給.
ORACLE 語ろ伎り 譬襭給.
SQL> !cp $ORACLE_HOME/data2_a.dbf $ORACLE_HOME/oradata/data2_a.dbf

SQL> startup mount;
ORACLE 語ろ伎り 給.

Total System Global Area   87818400 bytes
Fixed Size                    73888 bytes
Variable Size              70795264 bytes
Database Buffers           16777216 bytes
Redo Buffers                 172032 bytes
一危磯伎り 襷危碁給.
SQL> alter database datafile '$ORACLE_HOME/oradata/data2_a.dbf' offline;

一危覯伎り 覲蟆暑給.

SQL> alter database open;

一危覯伎り 覲蟆暑給.

SQL> select tablespace_name, status from dba_tablespaces;

TABLESPACE_NAME                STATUS
------------------------------ ---------
SYSTEM                         ONLINE
TOOLS                          ONLINE
RBS                            ONLINE
TEMP                           ONLINE
USERS                          ONLINE
INDX                           ONLINE
DRSYS                          ONLINE
DATA1                          ONLINE
DATA2                          OFFLINE           <------------- 企ろ伎り ろ殊語企..
TEMP_DATA                      ONLINE
LOCAL_MANAGE_TS                ONLINE

11 螳  給.

SQL> recover tablespace data2;                <------------- 企ろ伎 覲糾規 覈
襷れ牡 覲糾規螳 襭給.
SQL> alter tablespace data2 online;

企  覲蟆暑給.                 <------------- 伎  螳ロ..

SQL> select tablespace_name, status from dba_tablespaces;

TABLESPACE_NAME                STATUS
------------------------------ ---------
SYSTEM                         ONLINE
TOOLS                          ONLINE
RBS                            ONLINE
TEMP                           ONLINE
USERS                          ONLINE
INDX                           ONLINE
DRSYS                          ONLINE
DATA1                          ONLINE
DATA2                          ONLINE
TEMP_DATA                      ONLINE
LOCAL_MANAGE_TS                ONLINE

11 螳  給.

=================
一危殊 覲糾規
=================

..覦覯 觜る企Μ..


SQL> shutdown
一危磯伎り 給.
一危磯伎り 襷危 伎給.
ORACLE 語ろ伎り 譬襭給.
SQL> !cp $ORACLE_HOME/data2_a.dbf $ORACLE_HOME/oradata/data2_a.dbf          <------- 覓語 一危殊 覦煙 一危朱 蟲豌危..

SQL> startup mount
ORACLE 語ろ伎り 給.

Total System Global Area   87818400 bytes
Fixed Size                    73888 bytes
Variable Size              70795264 bytes
Database Buffers           16777216 bytes
Redo Buffers                 172032 bytes
一危磯伎り 襷危碁給.
SQL> alter database datafile '$ORACLE_HOME/oradata/data2_a.dbf' offline;        <------- 一危 殊 ろ殊語朱 れ

一危覯伎り 覲蟆暑給.

SQL> alter database open;

一危覯伎り 覲蟆暑給.

SQL> recover datafile '$ORACLE_HOME/oradata/data2_a.dbf';           <------- 企 一危殊 覲糾規覃 螳ロ 螳 ..
襷れ牡 覲糾規螳 襭給.
SQL>


覲糾規 螳覲企 螳...~
蠏碁覃 覿 覲糾規 伎 危ｴ覲願給...

===============
螳蠍磯 覲糾規
===============

螳蠍磯 覲糾規 伎 危ｴ覲願給..
襯 る, 企 螳 れ襦 企 覈  り 螳覃...
企郁化 覲糾規 覿螳ロ.... 蠏碁 企   覈  伎 豺伎企襦蠏 殊 譟伎..
蠏碁覩襦 豺伎企 襦蠏誤殊 伎伎 螳 覲糾規  給..
襷 2001 12 14 ろ 5 30覿 豌 覦煙 覦... れ 企 螳 れ襦 企 企 一危襯
覈 り 覃...螳 蠍一朱 2001 12 14 ろ 5 30覿朱 れ 襴伎螳 給..
覓朱 覦煙 蟯 殊 る伎...

襾殊  伎 襦 襴伎  蟆曙磯ゼ 觜伎 襾殊 豌 覦煙 覦伎 ..

觜訣 襯 企慨蟆給..

SQL> shutdown
一危磯伎り 給.
一危磯伎り 襷危 伎給.
ORACLE 語ろ伎り 譬襭給.

yasicom% /export/home/oracle/8i/dbs/whole_backup.sql
yasicom% cat /export/home/oracle/8i/dbs/whole_backup.sql
cp $ORACLE_HOME/oradata/ORCL/*.dbf $ORACLE_HOME/backup
cp $ORACLE_HOME/oradata/ORCL/*.ctl $ORACLE_HOME/backup
cp $ORACLE_HOME/oradata/ORCL/*.log $ORACLE_HOME/backup
cp $ORACLE_HOME/oradata/ORCL/*.ora $ORACLE_HOME/backup


SQL> !date                                        <---------------- 一危覯伎 襦 ...
2001 12 17  れ 08 05覿 15豐

SQL> connect scott/tiger
郁屋給.
SQL> delete from emp;

14  給.

SQL> !date
2001 12 17  れ 08 06覿 16豐

SQL> connect sys/change_on_install as sysdba
郁屋給.
SQL> shutdown
一危磯伎り 給.
一危磯伎り 襷危 伎給.
ORACLE 語ろ伎り 譬襭給.
SQL> !cat $ORACLE_HOME/dbs/recovery.sql
cat: /export/home/oracle/8i/dbs/recovery.sql(襯)   給

SQL> !ls $ORACLE_HOME/dbs
backup_history    init.ora          initdw.ora        orapwORCL         shutdown
core              initORCL.ora      lkORCL            recover.sql       whole_backup.sql

SQL> !cat $ORACLE_HOME/dbs/recover.sql                      <---------------------------------- 覦煙 殊 殊 れ
cp $ORACLE_HOME/backup/*.ctl $ORACLE_HOME/oradata/ORCL/.
cp $ORACLE_HOME/backup/*.log $ORACLE_HOME/oradata/ORCL/.
cp $ORACLE_HOME/backup/*.ora $ORACLE_HOME/oradata/ORCL/.
cp $ORACLE_HOME/backup/*.dbf $ORACLE_HOME/oradata/ORCL/.

SQL> !$ORACLE_HOME/dbs/recover.sql

SQL> startup mount
ORACLE 語ろ伎り 給.

Total System Global Area   84218016 bytes
Fixed Size                    73888 bytes
Variable Size              55955456 bytes
Database Buffers           28016640 bytes
Redo Buffers                 172032 bytes
一危磯伎り 襷危碁給.
SQL> recover database until time '2001-12-17:08:05:15';
襷れ牡 覲糾規螳 襭給.
SQL> alter database open resetlogs;

一危覯伎り 覲蟆暑給.

SQL> connect scott/tiger
郁屋給.
SQL> set linesize 200
SQL> set pagesize 200
SQL> select * from emp;                                                            <-------------- 覲糾規螳 企..

     EMPNO ENAME      JOB              MGR HIREDATE        SAL       COMM     DEPTNO
---------- ---------- --------- ---------- -------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 80/12/17        800                    20
      7499 ALLEN      SALESMAN        7698 81/02/20       1600        300         30
      7521 WARD       SALESMAN        7698 81/02/22       1250        500         30
      7566 JONES      MANAGER         7839 81/04/02       2975                    20
      7654 MARTIN     SALESMAN        7698 81/09/28       1250       1400         30
      7698 BLAKE      MANAGER         7839 81/05/01       2850                    30
      7782 CLARK      MANAGER         7839 81/06/09       2450                    10
      7788 SCOTT      ANALYST         7566 87/04/19       3000                    20
      7839 KING       PRESIDENT            81/11/17       5000                    10
      7844 TURNER     SALESMAN        7698 81/09/08       1500          0         30
      7876 ADAMS      CLERK           7788 87/05/23       1100                    20
      7900 JAMES      CLERK           7698 81/12/03        950                    30
      7902 FORD       ANALYST         7566 81/12/03       3000                    20
      7934 MILLER     CLERK           7782 82/01/23       1300                    10

14 螳  給.


================
豬 蠍磯 覲糾規
================

豬蠍磯 覲糾規 ろ螳 蟾讌り碓  豺伎企 殊 り碓 ...
覲糾規 豺伎企 襦蠏 殊  豌 覲糾規襯 讌 覈詩....
企...豬蠍磯 覲糾規 覦覯 ...豺伎企 襦蠏 殊 譟伎 覿覿襷 伎 覲糾規襯   給...
....覦覯 螳...
螳蠍磯 覲糾規 覦覯 一危覯伎 襷危誤 覿覿蟾讌 螳給..
襷危 結覿 れ螻 螳給..

SQL> recover database until cancel;
襷れ牡 覲糾規螳 襭給.

SQL> alter database open resetlogs;

一危覯伎り 覲蟆暑給.

===============
覲蟆所鍵覦 覲糾規
===============

覲蟆所鍵覦 覲糾規 一危覯伎れ 殊企 豪 覲襯 蠏手碓襦 一危覯伎るゼ 覲糾規 覦覯..
 覦覯 豺伎企蠏瑚 譴螳 觜讌蟇磯 朱    給...
 覦覯 SCN覲企ゼ 伎蟇磯 豺伎企 襦蠏 殊 伎伎 一危覯伎るゼ 覲糾規..

SQL> desc v$log_history;
 企
 -----------------------------------------

 RECID
 STAMP
 THREAD#
 SEQUENCE#
 FIRST_CHANGE#
 FIRST_TIME
 NEXT_CHANGE#

SQL> recover database until change low_change                   <-------------- change 覯碁ゼ ロ...

 覓語レ ろ  蟲 豺伎企 襦蠏 殊 豺伎企 襴伎 譟伎 讌襯 朱 
蠍  る狩伎 豌 覯讌 豺伎企 襦蠏 殊  企 蟲 'auto'襯 ロ覃 朱
豺伎企 襦蠏 朱れ  覲糾規 ろ..
鏤
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

襭襭螳 襯 燕. 蠏碁Μ螻 襾語 螳 讌覿 覦 襯 燕 蟆企. 蠏 伎朱 覯 襯 企蟆 蟆企. 企蟆 覲 蟆企. 企 蠏碁 譟伎螳 朱 襷企. (覯る)