SQL> shutdown immediate
數據庫已經(jīng)關(guān)閉。
已經(jīng)卸載數據庫。
ORACLE 例程已經(jīng)關(guān)閉。
SQL> startup mount
ORACLE 例程已經(jīng)啟動(dòng)。
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
名稱(chēng) 是否為空? 類(lèi)型
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------
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: 數據庫未打開(kāi): 僅允許在固定表/視圖中查詢(xún)
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
名稱(chēng) 是否為空? 類(lèi)型
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------
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這個(gè)是需要恢復用的redo
SQL> ----下面列出恢復需要的歸檔日志---
SQL> desc V$recover_log
ERROR:
ORA-04043: 對象 V$recover_log 不存在
SQL> desc v$recovery_log
名稱(chēng) 是否為空? 類(lèi)型
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------
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: 無(wú)法結束聯(lián)機備份 - 沒(méi)有文件在備份中
聯(lián)系客服
