Oracle不可恢复的nologging数据库对象 - 数据库编程

nel ORA_DISK_1: piece handle=/u01/app/FRA/ORA11GR2/backupset/2013_03_16/o1_mf_nnndf_TAG20130316T104134_8n7pyymv_.bkp tag=TAG20130316T104134

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:08

Finished restore at 16-MAR-13

RMAN> recover tablespace users;

Starting recover at 16-MAR-13

using channel ORA_DISK_1

starting media recovery

media recovery complete, elapsed time: 00:00:01

Finished recover at 16-MAR-13

RMAN> alter database open;

database opened

RMAN>

6) 验证NOLOGGING的不可恢复性

SCOTT@ORA11GR2>select count(*) from t_objects;

select count(*) from t_objects

ERROR at line 1:

ORA-01578: ORACLE data block corrupted (file # 4, block # 675)

ORA-01110: data file 4: '/u01/app/oracle/oradata/ORA11GR2/users01.dbf'

ORA-26040: Data block was loaded using the NOLOGGING option

SCOTT@ORA11GR2>

7) 小结

Oracle不可恢复的nologging数据库对象(二)