中财网废后难宠全文txt下载:每日oracle---查看哪个文件需要恢复，恢复时需要的redo和archive文件
来源：百度文库 编辑：中财网 时间：2024/04/29 16:30:39
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: 无法结束联机备份 - 没有文件在备份中