COLD BACKUP(三)

启用归档!

[@more@]

NAME                           LOG_MODE
------------------------------ ------------
HUIYI                          NOARCHIVELOG



NAME                           VALUE
------------------------------ --------------------------------------------------
log_archive_start              FALSE
log_archive_dest
log_archive_format             ARC%S.%T

log_arhive_start:    歸檔是否啟動
log_archive_dest:    歸檔的目的地(可以設置多個目的地)
log_archive_format: 歸檔文件名格式




System altered.



System altered.


alter system set log_archive_format='%s.trc'
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified




System altered.


Database closed.
Database dismounted.
ORACLE instance shut down.

ORACLE instance started.

Total System Global Area  147921840 bytes
Fixed Size                   453552 bytes
Variable Size             109051904 bytes
Database Buffers           37748736 bytes
Redo Buffers                 667648 bytes
Database mounted.


Database altered.



Database altered.



NAME                           LOG_MODE
------------------------------ ------------
HUIYI                          ARCHIVELOG

SYS@HUIYI>select name,value from v$parameter 
where name in('log_archive_dest','log_archive_format','log_archive_start');

NAME                           VALUE
------------------------------ --------------------------------------------------
log_archive_start              TRUE
log_archive_dest               D:backuparchive
log_archive_format             %s.trc




   DEST_ID DEST_NAME                                STATUS    DESTINATION
---------- ---------------------------------------- --------- ------------------------------
         1 LOG_ARCHIVE_DEST_1                       VALID     D:backuparchive
         2 LOG_ARCHIVE_DEST_2                       INACTIVE
         3 LOG_ARCHIVE_DEST_3                       INACTIVE
         4 LOG_ARCHIVE_DEST_4                       INACTIVE
         5 LOG_ARCHIVE_DEST_5                       INACTIVE
         6 LOG_ARCHIVE_DEST_6                       INACTIVE
         7 LOG_ARCHIVE_DEST_7                       INACTIVE
         8 LOG_ARCHIVE_DEST_8                       INACTIVE
         9 LOG_ARCHIVE_DEST_9                       INACTIVE
        10 LOG_ARCHIVE_DEST_10                      INACTIVE

10 rows selected.



Database log mode              Archive Mode(處於歸檔模式)
Automatic archival             Enabled(啟動自動歸檔)
Archive destination            D:backuparchive(歸檔路徑)
Oldest online log sequence     85(當前第一個在線日誌)
Next log sequence to archive   86(下一個將歸檔的序列號)
Current log sequence           86（當前的在線重做日誌文件序列號）



oracle   12227     1  0 17:03 ?        00:00:01 ora_pmon_huiyi
oracle   12229     1  0 17:03 ?        00:00:00 ora_dbw0_huiyi
oracle   12231     1  0 17:03 ?        00:00:01 ora_lgwr_huiyi
oracle   12233     1  0 17:03 ?        00:00:00 ora_ckpt_huiyi
oracle   12235     1  0 17:03 ?        00:00:01 ora_smon_huiyi
oracle   12237     1  0 17:03 ?        00:00:00 ora_reco_huiyi
oracle   12239     1  0 17:03 ?        00:00:01 ora_cjq0_huiyi
oracle   12243     1  0 17:03 ?        00:00:00 ora_s000_huiyi
oracle   12245     1  0 17:03 ?        00:00:00 ora_d000_huiyi
oracle   12247     1  0 17:03 ?        00:00:00 ora_arc0_huiyi
oracle   12249     1  0 17:03 ?        00:00:00 ora_arc1_huiyi
oracle   12271     1  2 17:04 ?        00:00:04 ora_qmn0_huiyi
507      12372 10589  0 17:07 pts/0    00:00:00 grep ora_

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8799875/viewspace-914231/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8799875/viewspace-914231/