oracle的archive文件怎么打开,每日oracle---查看哪个文件需要恢复，恢复时需要的redo和archive文件...

SQL> shutdown immediate

数据库已经关闭。

已经卸载数据库。

ORACLE 例程已经关闭。

SQL> startup mount

ORACLE 例程已经启动。

Total System Global Area 135338868 bytes

Fixed Size                   453492 bytes

Variable Size             109051904 bytes

Database Buffers           25165824 bytes

Redo Buffers                 667648 bytes

数据库装载完毕。

SQL> desc v$recover_file

名称                                                                                                                                                                          是否为空? 类型

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------

FILE#                                                                                                                                                                                  NUMBER

ONLINE                                                                                                                                                                                 VARCHAR2(7)

ONLINE_STATUS                                                                                                                                                                          VARCHAR2(7)

ERROR                                                                                                                                                                                  VARCHAR2(18)

CHANGE#                                                                                                                                                                                NUMBER

TIME                                                                                                                                                                                   DATE

SQL> select * from v$recover_file;

FILE# ONLINE ONLINE_ ERROR                                                                CHANGE# TIME

---------- ------- ------- ----------------------------------------------------------------- ---------- ----------

11 ONLINE ONLINE FILE NOT FOUND                                                             0

SQL> select * from v$backup;

FILE# STATUS                CHANGE# TIME

---------- ------------------ ---------- ----------

1 NOT ACTIVE                  0

2 NOT ACTIVE                  0

3 NOT ACTIVE                  0

4 NOT ACTIVE                  0

5 NOT ACTIVE                  0

6 NOT ACTIVE                  0

7 NOT ACTIVE                  0

8 NOT ACTIVE                  0

9 NOT ACTIVE            1088581 22-5月 -08

10 NOT ACTIVE                  0

11 FILE NOT FOUND              0

已选择11行。

SQL> select file_name,tablespace_name from dba_data_files;

select file_name,tablespace_name from dba_data_files

*

ERROR 位于第 1 行:

ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询

SQL> alter database end backup;

数据库已更改。

SQL> select * from v$backup;

FILE# STATUS                CHANGE# TIME

---------- ------------------ ---------- ----------

1 NOT ACTIVE                  0

2 NOT ACTIVE                  0

3 NOT ACTIVE                  0

4 NOT ACTIVE                  0

5 NOT ACTIVE                  0

6 NOT ACTIVE                  0

7 NOT ACTIVE                  0

8 NOT ACTIVE                  0

9 NOT ACTIVE            1088581 22-5月 -08

10 NOT ACTIVE                  0

11 FILE NOT FOUND              0

已选择11行。

SQL> ----将文件放回原处---

SQL> alter database open

2 ;

数据库已更改。

SQL> select * from v$backup;

FILE# STATUS                CHANGE# TIME

---------- ------------------ ---------- ----------

1 NOT ACTIVE                  0

2 NOT ACTIVE                  0

3 NOT ACTIVE                  0

4 NOT ACTIVE                  0

5 NOT ACTIVE                  0

6 NOT ACTIVE                  0

7 NOT ACTIVE                  0

8 NOT ACTIVE                  0

9 NOT ACTIVE            1088581 22-5月 -08

10 NOT ACTIVE                  0

11 NOT ACTIVE                  0

已选择11行。

SQL> desc v$loghist

名称                                                                                                                                                                          是否为空? 类型

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------

THREAD#                                                                                                                                                                                NUMBER

SEQUENCE#                                                                                                                                                                              NUMBER

FIRST_CHANGE#                                                                                                                                                                          NUMBER

FIRST_TIME                                                                                                                                                                             DATE

SWITCH_CHANGE#                                                                                                                                                                         NUMBER

SQL> desc v$archive_log

ERROR:

ORA-04043: 对象 v$archive_log 不存在

SQL> select sequence# from v$archive_log where 1088581 between FIRST_CHANGE#   and SWITCH_CHANGE#         ;

select sequence# from v$archive_log where 1088581 between FIRST_CHANGE#   and SWITCH_CHANGE#

*

ERROR 位于第 1 行:

ORA-00942: 表或视图不存在

SQL> select sequence# from v$loghist where 1088581 between FIRST_CHANGE#   and SWITCH_CHANGE#

2 ;

SEQUENCE#

----------

5

SQL> select * from v$logfile;

GROUP# STATUS TYPE

---------- ------- -------

MEMBER

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

3 STALE   ONLINE

D:\ORACLE\DEMO\REDO03.LOG

2         ONLINE

D:\ORACLE\DEMO\REDO02.LOG

1 STALE   ONLINE

D:\ORACLE\DEMO\REDO01.LOG

SQL> alter system switch logfile;

系统已更改。

SQL> select * from v$logfile;

GROUP# STATUS TYPE

---------- ------- -------

MEMBER

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

3         ONLINE

D:\ORACLE\DEMO\REDO03.LOG

2         ONLINE

D:\ORACLE\DEMO\REDO02.LOG

1 STALE   ONLINE

D:\ORACLE\DEMO\REDO01.LOG

SQL> select * from v$log;

GROUP#    THREAD# SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME

---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------

1          1          5 104857600          1 YES INACTIVE               1066224 22-5月 -08

2          1          6 104857600          1 YES ACTIVE                 1108702 22-5月 -08

3          1          7 104857600          1 NO CURRENT                1113417 22-5月 -08

SQL> ----D:\ORACLE\DEMO\REDO01.LOG这个是需要恢复用的redo

SQL> ----下面列出恢复需要的归档日志---

SQL> desc V$recover_log

ERROR:

ORA-04043: 对象 V$recover_log 不存在

SQL> desc v$recovery_log

名称                                                                                                                                                                          是否为空? 类型

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------

THREAD#                                                                                                                                                                                NUMBER

SEQUENCE#                                                                                                                                                                              NUMBER

TIME                                                                                                                                                                                   DATE

ARCHIVE_NAME                                                                                                                                                                           VARCHAR2(513)

SQL> select * from v$recovery_log;

未选定行

SQL> select * from v$recovery_log;

未选定行

SQL> alter tablespace users end backup;

alter tablespace users end backup

*

ERROR 位于第 1 行:

ORA-01142: 无法结束联机备份 - 没有文件在备份中