Oracle 11g 備份和恢復 基本概念快速入門

--檢視並使資料庫進入歸檔模式

sys@TESTDB11>archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     95

Current log sequence           97

--1.關庫

sys@TESTDB11>shutdown immediate;

Database dismounted.

ORACLE instance shut down.

--2.啟動到MOUNT狀態

sys@TESTDB11>startup mount;

ORACLE instance started.

Total System Global Area  855982080 bytes

Fixed Size                  2230792 bytes

Variable Size             641730040 bytes

Database Buffers          209715200 bytes

Redo Buffers                2306048 bytes

Database mounted.

--3.改變歸檔模式

--3.1 進入歸檔模式

sys@TESTDB11>alter database archivelog;

--3.2 進入非歸檔模式

sys@TESTDB11>alter database noarchivelog;

Database altered.

--4. 開啟資料庫

sys@TESTDB11>alter database open;

Database altered.

--5. 再次歸檔模式

sys@TESTDB11>archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     95

Next log sequence to archive   97

Current log sequence           97