丢失undo文件，丢失部分归档日志的…

丢失undo，丢失部分归档日志，是完全可以进行不完全恢复的。我的测试如下：

SQL> select file_name,file_id,tablespace_name,status from dba_data_files;

FILE_NAME                                                    FILE_ID TABLESPACE_NAME            STATUS
----------------------------------------------- ------- -------------------- ---------
/u01/app/oracle/oradata/yssingle/system01.dbf        1        SYSTEM                        AVAILABLE
/u01/app/oracle/oradata/yssingle/undotbs01.dbf    2        UNDOTBS1                    AVAILABLE
......

8 rows selected

SQL> select * from v$log;

    GROUP#    THREAD#    SEQUENCE#        BYTES    MEMBERS ARCHIVED STATUS            FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
            1            1            49    209715200            1 YES        ACTIVE                    868530 2011-2-18 上
            2            1            50    209715200            1 NO        CURRENT                869023 2011-2-18 上
            3            1            48    209715200            1 YES        INACTIVE                757330 2011-1-13 上

做个RMAN全备份
[oracle@yssingle1 rmanbak]$ ./rman_backup.sh
[oracle@yssingle1 rmanbak]$ ll /archive/
total 0

SQL> alter system archive log current;

System altered

SQL> alter system archive log current;

System altered

SQL> alter system archive log current;

System altered

SQL> select * from v$log;

    GROUP#    THREAD#    SEQUENCE#        BYTES    MEMBERS ARCHIVED STATUS            FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
            1            1            55    209715200            1 NO        CURRENT                869244 2011-2-18 上
            2            1            53    209715200            1 YES        INACTIVE            869235 2011-2-18 上
            3            1            54    209715200            1 YES        INACTIVE            869240 2011-2-18 上

SQL>

虚拟机断电后重启，模拟断电后丢失undo文件、归档日志
[oracle@yssingle1 ~]$ cd /u01/app/oracle/oradata/yssingle/

[oracle@yssingle1 yssingle]$ mv undotbs01.dbf undotbs01.dbf.bak ――模拟断电后丢失undo文件[oracle@yssingle1 yssingle]$ ll
total 1721184
-rw-r-----    1 oracle oinstall    7553024 Feb 18 10:39 control01.ctl
......
-rw-r-----    1 oracle oinstall 104865792 Feb 18 10:39 test01.dbf
-rw-r-----    1 oracle oinstall 209723392 Feb 18 10:39 undotbs01.dbf.bak
......

[oracle@yssingle1 rmanbak]$ ll /archive/
total 44
-rw-r-----    1 oracle oinstall 35840 Feb 18 10:37 1_52_723812272.dbf
-rw-r-----    1 oracle oinstall    2048 Feb 18 10:37 1_53_723812272.dbf
-rw-r-----    1 oracle oinstall    1536 Feb 18 10:37 1_54_723812272.dbf

[oracle@yssingle1 archive]$ mv 1_52_723812272.dbf 1_52_723812272.dbf.bak ――模拟丢失归档日志[oracle@yssingle1 archive]$ ll /archive/
total 44
-rw-r-----    1 oracle oinstall 35840 Feb 18 10:37 1_52_723812272.dbf.bak
-rw-r-----    1 oracle oinstall    2048 Feb 18 10:37 1_53_723812272.dbf
-rw-r-----    1 oracle oinstall    1536 Feb 18 10:37 1_54_723812272.dbf


SQL> startup
ORACLE instance started.

Total System Global Area    209715200 bytes
Fixed Size                        1260936 bytes
Variable Size                192938616 bytes
Database Buffers                12582912 bytes
Redo Buffers                    2932736 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/u01/app/oracle/oradata/yssingle/undotbs01.dbf'
SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

RMAN> restore archivelog sequence 51; ――恢复归档日志51

Starting restore at 18-FEB-11
using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=51
channel ORA_DISK_1: reading from backup piece /rmanbak/arc_t20110218_s43_p1.bak
channel ORA_DISK_1: restored backup piece 1
piece handle=/rmanbak/arc_t20110218_s43_p1.bak tag=TAG20110218T103312
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 18-FEB-11

RMAN> exit


Recovery Manager complete.
[oracle@yssingle1 bdump]$ ll /archive
total 60
-rw-r-----    1 oracle oinstall 15360 Feb 18 11:14 1_51_723812272.dbf
-rw-r-----    1 oracle oinstall 35840 Feb 18 10:37 1_52_723812272.dbf.bak
-rw-r-----    1 oracle oinstall    2048 Feb 18 10:37 1_53_723812272.dbf
-rw-r-----    1 oracle oinstall    1536 Feb 18 10:37 1_54_723812272.dbf

[oracle@yssingle1 yssingle]$ rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Fri Feb 18 11:07:37 2011

Copyright (c) 1982, 2005, Oracle.    All rights reserved.

connected to target database: YSSINGLE (DBID=1772505200, not open)

RMAN> restore database;
Starting restore at 18-FEB-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=44 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/yssingle/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/yssingle/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/yssingle/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/yssingle/users01.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/yssingle/goldengate01.dbf
restoring datafile 00006 to /u01/app/oracle/oradata/yssingle/test01.dbf
restoring datafile 00007 to /u01/app/oracle/oradata/yssingle/director01.dbf
restoring datafile 00008 to /u01/app/oracle/oradata/yssingle/veridata01.dbf
channel ORA_DISK_1: reading from backup piece /rmanbak/full_t20110218_s41_p.bak
channel ORA_DISK_1: restored backup piece 1
piece handle=/rmanbak/full_t20110218_s41_p.bak tag=TAG20110218T103233
channel ORA_DISK_1: restore complete, elapsed time: 00:00:56
Finished restore at 18-FEB-11
RMAN> recover database until sequence 52;
Starting recover at 18-FEB-11
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 51 is already on disk as file /archive/1_51_723812272.dbf
archive log filename=/archive/1_51_723812272.dbf thread=1 sequence=51
media recovery complete, elapsed time: 00:00:00
Finished recover at 18-FEB-11
RMAN> sql "ALTER DATABASE OPEN";

sql statement: ALTER DATABASE OPEN
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 02/18/2011 11:16:58
RMAN-11003: failure during parse/execution of SQL statement: ALTER DATABASE OPENORA-01589: must use RESETLOGS or NORESETLOGS option for database open

RMAN> ^[[A
user interrupt received


RMAN> sql "ALTER DATABASE OPEN RESETLOGS";sql statement: ALTER DATABASE OPEN RESETLOGS

RMAN> exit


Recovery Manager complete.

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area    209715200 bytes
Fixed Size                        1260936 bytes
Variable Size                192938616 bytes
Database Buffers                12582912 bytes
Redo Buffers                    2932736 bytes
Database mounted.
Database opened.
SQL> exit
重启数据库正常。