注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

我的博客

 
 
 

日志

 
 
关于我

风流茶说合,酒是色媒人,古往今来,浪涛依旧,我辈今朝,叱咤风云,

网易考拉推荐

oracle归档日志满了后的处理  

2009-03-09 09:52:50|  分类: orcle |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
  

第 1 行出现错误:

ORA-16038: 日志 3 序列号 142 无法归档

ORA-19809: 超出了恢复文件数的限制

ORA-00312: 联机日志 3 线程 1: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\EHR\REDO03.LOG'

SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1        143 NO INACTIVE

         3        142 NO INACTIVE

         2        144 NO CURRENT

SQL> recover database until cancel ;

完成介质恢复。

SQL> alter database open reset logs;

alter database open reset logs

                    *

第 1 行出现错误:

ORA-02288: 无效的 OPEN 模式

SQL> alter database open resetlogs;

数据库已更改。

SQL> backup database;

SP2-0734: 未知的命令开头 "backup dat..." - 忽略了剩余的行。

SQL> SELECT log_mode from v$database;

LOG_MODE

------------

ARCHIVELOG

SQL> clear archivelogs

SP2-0735: 未知的 CLEAR 选项开头 "archivelog..."

SQL> clear archivelogs;

SP2-0735: 未知的 CLEAR 选项开头 "archivelog..."

SQL> SELECT log_mode from v$database;

LOG_MODE

------------

ARCHIVELOG

SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1          2 NO CURRENT

         2          1 YES INACTIVE

         3          0 YES UNUSED

SQL> alter database clear logfile group 3

2 ;

数据库已更改。

SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1          2 NO CURRENT

         2          1 YES INACTIVE

         3          0 YES UNUSED

SQL> alter database clear unarchived logfile group 3;

数据库已更改。

SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1          2 NO CURRENT

         2          1 YES INACTIVE

         3          0 YES UNUSED

SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1          2 NO CURRENT

         2          1 YES INACTIVE

         3          0 YES UNUSED

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

CONTROLFILE                   0                         0               0

ONLINELOG                     0                         0               0

ARCHIVELOG                99.96                       .07             489

BACKUPPIECE                   0                         0               0

IMAGECOPY                     0                         0               0

FLASHBACKLOG                  0                         0               0

已选择6行。

SQL> alter database clear unarchived logfile group 1;

alter database clear unarchived logfile group 1

*

第 1 行出现错误:

ORA-01624: 日志 1 是紧急恢复实例 ehr (线程 1) 所必需的

ORA-00312: 联机日志 1 线程 1: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\EHR\REDO01.LOG'

SQL> alter database clear unarchived logfile group 2;

数据库已更改。

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

CONTROLFILE                   0                         0               0

ONLINELOG                     0                         0               0

ARCHIVELOG                99.96                       .07             489

BACKUPPIECE                   0                         0               0

IMAGECOPY                     0                         0               0

FLASHBACKLOG                  0                         0               0

已选择6行。

SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1          2 NO CURRENT

         2          0 YES UNUSED

         3          0 YES UNUSED

SQL> startup immediate

SP2-0714: 无效的        STARTUP 选项组合

SQL> shutdown immediate

数据库已经关闭。

已经卸载数据库。

ORACLE 例程已经关闭。

SQL> startup

ORACLE 例程已经启动。

Total System Global Area 2550136832 bytes

Fixed Size                  2006416 bytes

Variable Size            1174405744 bytes

Database Buffers         1358954496 bytes

Redo Buffers               14770176 bytes

数据库装载完毕。

数据库已经打开。

SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1          2 NO CURRENT

         2          0 YES UNUSED

         3          0 YES UNUSED

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

CONTROLFILE                   0                         0               0

ONLINELOG                     0                         0               0

ARCHIVELOG                99.96                       .07             489

BACKUPPIECE                   0                         0               0

IMAGECOPY                     0                         0               0

FLASHBACKLOG                  0                         0               0

已选择6行。

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

CONTROLFILE                   0                         0               0

ONLINELOG                     0                         0               0

ARCHIVELOG                12.52                         0              62

BACKUPPIECE                   0                         0               0

IMAGECOPY                     0                         0               0

FLASHBACKLOG                  0                         0               0

已选择6行。

SQL> alter system switch logfile;

系统已更改。

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

CONTROLFILE                   0                         0               0

ONLINELOG                     0                         0               0

ARCHIVELOG                12.66                         0              63

BACKUPPIECE                   0                         0               0

IMAGECOPY                     0                         0               0

FLASHBACKLOG                  0                         0               0

已选择6行。

SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1          2 YES ACTIVE

         2          3 NO CURRENT

         3          0 YES UNUSED

SQL> alter system switch logfile;

系统已更改。

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

CONTROLFILE                   0                         0               0

ONLINELOG                     0                         0               0

ARCHIVELOG                12.66                         0              64

BACKUPPIECE                   0                         0               0

IMAGECOPY                     0                         0               0

FLASHBACKLOG                  0                         0               0

已选择6行。

SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1          2 YES ACTIVE

         2          3 YES ACTIVE

         3          4 NO CURRENT

SQL> alter system switch logfile;

系统已更改。

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

CONTROLFILE                   0                         0               0

ONLINELOG                     0                         0               0

ARCHIVELOG                12.66                         0              65

BACKUPPIECE                   0                         0               0

IMAGECOPY                     0                         0               0

FLASHBACKLOG                  0                         0               0

已选择6行。

SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1          5 NO CURRENT

         2          3 YES ACTIVE

         3          4 YES ACTIVE

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

------------ ------------------ ------------------------- ---------------

CONTROLFILE                   0                         0               0

ONLINELOG                     0                         0               0

ARCHIVELOG                12.66                         0              65

BACKUPPIECE                   0                         0               0

IMAGECOPY                     0                         0               0

FLASHBACKLOG                  0                         0               0

已选择6行。

SQL> select * from v$recovery_file_dest;

NAME

--------------------------------------------------------------------------------

SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES

----------- ---------- ----------------- ---------------

E:\oracle\product\10.2.0/flash_recovery_area

2.1475E+10 2718720000                 0      1.8447E+19

SQL> SHOW parameter db_recovery_file_dest ;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest                string      E:\oracle\product\10.2.0/flash

                                                 _recovery_area

db_recovery_file_dest_size           big integer 20G

SQL> ALTER SYSTEM SET db_recovery_file_dest_size=40g SCOPE=BOTH;

系统已更改。

SQL> SHOW parameter db_recovery_file_dest ;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest                string      E:\oracle\product\10.2.0/flash

                                                 _recovery_area

db_recovery_file_dest_size           big integer 40G

SQL

  评论这张
 
阅读(1547)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017