使数据库为归档模式

发表日期：2008-2-9

　　1。若数据库为非归档模式，则数据不能保持它的完整。1。su - Oracle
1.1. modify the /opt/oracle/admin/dbora817/pfile/initdbora817.ora,make sure that
    log_archive_start = true
    log_archive_dest_1 = "location=/opt/oracle/admin/dbora817/arch"
    log_archive_format = arch_%t_%s.arc
   are not commented.

2. sqlplus '/ as sysdba'
3. SQL>shutdown
   SQL>startup mount
   SQL>alter database archivelog;
   SQL>alter database open;
4. verify:
   SQL>archive log list

Database log mode              Archive Mode
Automatic archival             ENABLED
Archive destination            /opt/oracle/admin/dbora817/arch
Oldest online log sequence     19
Next log sequence to archive   21
Current log sequence           21

上一篇：oracle热物理备份步骤人气:638
下一篇：Install Oracle9 on RedHat 人气:687

浏览全部Oracle教程的内容 Dreamweaver插件下载网页广告代码祝你圣诞节快乐 2009年新年快乐