- ÂÛ̳»ÕÕÂ:
- 0
|
´ó¼ÒºÃ£º
ÎÒµÄÊý¾Ý¿âÊÇnoarchivlog·Ç¹éµµÄ£Ê½¡£
ÎÒÔڹرÕÊý¾Ý¿âºó£¬±¸·ÝÁËusers01.dbf Êý¾ÝÎļþ¡£Ö®ºóÖØÐ´ò¿ªÊý¾Ý¿â£¬½¨Á¢Ò»¸ö±í
create table scott.ddd logging as select * from scott.dept;
È»ºóÔٴιرÕÊý¾Ý¿â£¬É¾³ýusers01.dbfÊý¾ÝÎļþ£¬ÔÙ¸´ÖÆÖ®Ç°´´½¨scott.ddd±íǰµÄÊý¾ÝÎļþusers01.dbf£¬È»ºó»Ö¸´¸ÃÊý¾ÝÎļþ£¬´ò¿ªÊý¾Ý¿âºó£¬µ± select * from scott.ddd; ʱÌáʾÊý¾Ý¿éË𻵡£ÎÒ´´½¨soott.ddd±íʱµÄÖØ×öÈÕÖ¾»¹´æÔڵģ¬Ã»ÓÐÇл»¹ýÖØ×öÈÕÖ¾£¬Ö´ÐÐrecover datafile 4;ʱҲûÌáʾ´íÎó£¬ÎªÊ²Ã´´ò¿ªÊý¾Ý¿âºó£¬ Ìáʾusers01.dbfÊý¾ÝÎļþµÄÊý¾Ý¿éËð»µÄØ£¿
µ«Èç¹ûÊÇÏÈ´´½¨scott.ddd±í£¬¹Ø±ÕÊý¾Ý¿âÔÙ±¸·Ýusers01.dbfÊý¾ÝÎļþ£¬È»ºó´ò¿ªÊý¾Ý¿â£¬ÔÚscott.ddd±íÖÐɾ³ýºÍ²åÈëÊý¾Ý£¬¹Ø±ÕÊý¾Ý¿â£¬ÔÙ¸´ÖÆ´´½¨±íʱµÄusers01.dbf±¸·ÝÊý¾ÝÎļþ£¬ÕâÑùÈ´¾Í¿ÉÒÔ»Ö¸´É¾³ý²åÈëµÄÊý¾Ý¡£
ÈçÏ£º
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> host cp /ora01/oracle/oradata/orcl/users01.dbf /ora01/oracle/oradata/orcl/users01.dbf.bak
SQL> startup;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218292 bytes
Variable Size 83888396 bytes
Database Buffers 75497472 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
SQL> create table scott.ddd logging as select * from scott.dept;
Table created.
SQL> select * from scott.ddd;
DEPTNO DNAME LOC
------------------ ------------------------------------------ ---------------------------------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> host rm /ora01/oracle/oradata/orcl/users01.dbf
SQL> startup;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218292 bytes
Variable Size 83888396 bytes
Database Buffers 75497472 bytes
Redo Buffers 7168000 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/ora01/oracle/oradata/orcl/users01.dbf'
SQL> host cp /ora01/oracle/oradata/orcl/users01.dbf.bak /ora01/oracle/oradata/orcl/users01.dbf
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: '/ora01/oracle/oradata/orcl/users01.dbf'
SQL> recover datafile 4;
Media recovery complete.
SQL> alter database open;
Database altered.
SQL> select * from scott.ddd;
select * from scott.ddd
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 4, block # 38
ORA-01110: data file 4: '/ora01/oracle/oradata/orcl/users01.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
-------------------------------------------------------------------
СµÜÊDzËÄñ£¬ÏëÇëÎʸ÷λÒÔÏÂÁ½¸öÎÊÌ⣺
1¡¢ÎªÊ²Ã´ÊÇÕâÑù£¬Èç¹ûÊÇ´´½¨±íǰ£¬±¸·ÝÊý¾ÝÎļþ£¬¾Í²»Äָܻ´¸Ã±í£¬ÌáʾÊý¾Ý¿éË𻵡£
Èç¹ûÊÇ´´½¨±íºó£¬ÔÙ±¸·ÝÊý¾ÝÎļþ£¬¾ÍÄָܻ´¸Ã±í¡£ÇëÎÊÕâÊÇʲôÔÒò£¿ÊDz»ÊÇÖØ×öÈÕÖ¾ÊDz»¼Ç¼´´½¨±íʱµÄÐÅÏ¢µÄ£¿
2¡¢ÇëÎÊÈçºÎÓô´½¨±íǰ±¸·ÝµÄÊý¾ÝÎļþ£¬½øÐлָ´±íµÄÊý¾ÝÄØ£¿£¨ÖØ×öÈÕ־δÇл»£©
----
ÒÔÉÏÎÊÌ⣬»¹Íû¸÷λ´óÏÀÄܰï½â´ðһϣ¬¸Ðл¡£
|
|