|
SQL> shutdown immediate
數(shù)據(jù)庫已經(jīng)關(guān)閉。
已經(jīng)卸載數(shù)據(jù)庫。
ORACLE 例程已經(jīng)關(guān)閉。
SQL> startup mount
ORACLE 例程已經(jīng)啟動。
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
數(shù)據(jù)庫裝載完畢。
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: 數(shù)據(jù)庫未打開: 僅允許在固定表/視圖中查詢
SQL> alter database end backup;
數(shù)據(jù)庫已更改。
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 ;
數(shù)據(jù)庫已更改。
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;
系統(tǒng)已更改。
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這個是需要恢復(fù)用的redo
SQL> ----下面列出恢復(fù)需要的歸檔日志---
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: 無法結(jié)束聯(lián)機(jī)備份 - 沒有文件在備份中
|
