oracle數(shù)據(jù)庫(kù)如何打開(kāi)歸檔？xp system/manager file=d:道處.dmp滿=y1。連接windows系統(tǒng)：open CMD window，Linux/Unix系統(tǒng)：open te

oracle數(shù)據(jù)庫(kù)如何打開(kāi)歸檔？

xp system/manager file=d:道處.dmp滿=y

1。連接windows系統(tǒng)：open CMD window，Linux/Unix系統(tǒng)：open terminal RMAN target/nocatalogsqlplus/nologconn/as SYSDBA

2。Open archive sqlplus>shutdown immediate（在啟動(dòng)存檔之前停止數(shù)據(jù)庫(kù)）sqlplus>startup mount（在裝載模式下啟動(dòng)數(shù)據(jù)庫(kù)）sqlplus>alter database Archivelog sqlplus>alter system set loguarchiveuudestu1=“/arch”（更改存檔日志的路徑，windows系統(tǒng)使用驅(qū)動(dòng)器號(hào)）sqlplus>alter database open（打開(kāi)數(shù)據(jù)庫(kù)）sqlplus>archive log list（檢查存檔是否已打開(kāi)）close archive alter database NOARCHIVELOG