日志满是oracle,oracle日志满了，咋办...记录

最新推荐文章于 2022-09-26 21:34:59 发布
最新推荐文章于 2022-09-26 21:34:59 发布
阅读量257 收藏
点赞数
文章标签： 日志满是oracle

[oracle@oracle111 db_1]$ echo $ORACLE_SID

cms

[oracle@oracle111 db_1]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 13 15:51:08

2012

Copyright (c) 1982, 2005, Oracle. All rights

reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit

Production

With the Partitioning, OLAP and Data Mining options

SQL> select * from v$logfile;

GROUP#

STATUS TYPE

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

MEMBER

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

IS_

---

3 STALE ONLINE

/oracle/app/oradata/cms/redo03.log

NO

2 ONLINE

/oracle/app/oradata/cms/redo02.log

NO

GROUP#

STATUS TYPE

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

MEMBER

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

IS_

---

1 ONLINE

/oracle/app/oradata/cms/redo01.log

NO

SQL> archive log list;

Database log

mode Archive Mode

Automatic

archival Enabled

Archive

destination USE_DB_RECOVERY_FILE_DEST

Oldest online log

sequence 16

Next log sequence to archive 16

Current log

sequence 19

SQL> shutdown immediate;

ORA-03113: end-of-file on communication channel

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release

10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

[oracle@oracle111 db_1]$ rman

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jul 13

15:56:32 2012

Copyright (c) 1982, 2005, Oracle. All rights

reserved.

RMAN> crosscheck archivelog all;

RMAN-00571:

===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

===============

RMAN-00571:

===========================================================

RMAN-03002: failure of crosscheck command at 07/13/2012

15:56:47

RMAN-12010: automatic channel allocation initialization

failed

RMAN-06171: not connected to target database

RMAN>

eixt

RMAN-00571:

===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

===============

RMAN-00571:

===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01009: syntax error: found "identifier": expecting one of:

"allocate, alter, backup, beginline, blockrecover, catalog, change,

connect, copy, convert, create, crosscheck, configure, duplicate,

debug, delete, drop, exit, endinline, flashback, host, {, library,

list, mount, open, print, quit, recover, register, release,

replace, report, renormalize, reset, restore, resync, rman, run,

rpctest, set, setlimit, sql, switch, spool, startup, shutdown,

send, show, test, transport, upgrade, unregister, validate"

RMAN-01008: the bad identifier was: eixt

RMAN-01007: at line 1 column 1 file: standard input

RMAN> exit

Recovery Manager complete.

[oracle@oracle111 db_1]$ rman target

Argument Value Description

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

target quoted-string connect-string for target

database

catalog quoted-string connect-string for recovery

catalog

nocatalog none if specified, then no recovery catalog

cmdfile quoted-string name of input command file

log quoted-string name of output message log

file

trace quoted-string name of output debugging message

log file

append none if specified, log is opened in append mode

debug optional-args activate debugging

msgno none show RMAN-nnnn prefix for all messages

send quoted-string send a command to the media

manager

pipe string building block for pipe names

timeout integer number of seconds to wait for pipe input

checksyntax none check the command file for syntax errors

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

Both single and double quotes (' or ") are accepted for a

quoted-string.

Quotes are not required unless the string contains embedded

white-space.

RMAN-00571:

===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

===============

RMAN-00571:

===========================================================

RMAN-00552: syntax error in command line arguments

RMAN-01009: syntax error: found "end-of-file": expecting one of:

"double-quoted-string, equal, identifier,

single-quoted-string"

RMAN-01007: at line 0 column 0 file: command line arguments

[oracle@oracle111 db_1]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jul 13

15:57:20 2012

Copyright (c) 1982, 2005, Oracle. All rights

reserved.

connected to target database: CMS (DBID=441461913)

RMAN> crosscheck archivelog all;

using target database control file instead of recovery

catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=317 devtype=DISK

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_254_7ytw1sn4_.arc

recid=4 stamp=787252025

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_254_7ytsz5m2_.arc

recid=3 stamp=787249894

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_255_7ytw1ss7_.arc

recid=5 stamp=787252025

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_1_7ytz67yp_.arc

recid=7 stamp=787255240

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_2_7yvh0o8p_.arc

recid=8 stamp=787271446

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_30/o1_mf_1_3_7ywf6w9n_.arc

recid=9 stamp=787302366

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_01/o1_mf_1_4_7yz1bypy_.arc

recid=10 stamp=787474912

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_01/o1_mf_1_5_7z0pkzwc_.arc

recid=11 stamp=787529408

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_02/o1_mf_1_6_7z29g3nx_.arc

recid=12 stamp=787581509

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_03/o1_mf_1_7_7z4j89fl_.arc

recid=13 stamp=787654025

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_03/o1_mf_1_8_7z4rxwcl_.arc

recid=14 stamp=787662909

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_03/o1_mf_1_9_7z5yrjdh_.arc

recid=15 stamp=787701649

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_04/o1_mf_1_10_7z88m6yb_.arc

recid=16 stamp=787777255

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_05/o1_mf_1_11_7z9mvrjg_.arc

recid=17 stamp=787821561

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_05/o1_mf_1_12_7zc7h9c4_.arc

recid=18 stamp=787874410

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_06/o1_mf_1_13_7zd89gs1_.arc

recid=19 stamp=787908015

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_06/o1_mf_1_14_7zfvvn26_.arc

recid=20 stamp=787960820

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_07/o1_mf_1_15_7zgz02ot_.arc

recid=21 stamp=787996803

Crosschecked 18 objects

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=317 devtype=DISK

specification does not match any archive log in the recovery

catalog

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=317 devtype=DISK

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_254_7ytw1sn4_.arc

recid=4 stamp=787252025

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_254_7ytsz5m2_.arc

recid=3 stamp=787249894

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_255_7ytw1ss7_.arc

recid=5 stamp=787252025

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_1_7ytz67yp_.arc

recid=7 stamp=787255240

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_2_7yvh0o8p_.arc

recid=8 stamp=787271446

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_30/o1_mf_1_3_7ywf6w9n_.arc

recid=9 stamp=787302366

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_01/o1_mf_1_4_7yz1bypy_.arc

recid=10 stamp=787474912

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_01/o1_mf_1_5_7z0pkzwc_.arc

recid=11 stamp=787529408

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_02/o1_mf_1_6_7z29g3nx_.arc

recid=12 stamp=787581509

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_03/o1_mf_1_7_7z4j89fl_.arc

recid=13 stamp=787654025

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_03/o1_mf_1_8_7z4rxwcl_.arc

recid=14 stamp=787662909

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_03/o1_mf_1_9_7z5yrjdh_.arc

recid=15 stamp=787701649

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_04/o1_mf_1_10_7z88m6yb_.arc

recid=16 stamp=787777255

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_05/o1_mf_1_11_7z9mvrjg_.arc

recid=17 stamp=787821561

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_05/o1_mf_1_12_7zc7h9c4_.arc

recid=18 stamp=787874410

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_06/o1_mf_1_13_7zd89gs1_.arc

recid=19 stamp=787908015

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_06/o1_mf_1_14_7zfvvn26_.arc

recid=20 stamp=787960820

validation succeeded for archived log

archive log

filename=/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_07/o1_mf_1_15_7zgz02ot_.arc

recid=21 stamp=787996803

Crosschecked 18 objects

RMAN> delete archivelog until time 'sysdate-3'

2> ;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=317 devtype=DISK

List of Archived Log Copies

Key Thrd

Seq S Low Time Name

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

4 1 254 A 29-JUN-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_254_7ytw1sn4_.arc

3 1 254 A 29-JUN-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_254_7ytsz5m2_.arc

5 1 255 A 29-JUN-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_255_7ytw1ss7_.arc

7 1 1 A 29-JUN-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_1_7ytz67yp_.arc

8 1 2 A 29-JUN-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_29/o1_mf_1_2_7yvh0o8p_.arc

9 1 3 A 29-JUN-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_06_30/o1_mf_1_3_7ywf6w9n_.arc

10 1 4 A 30-JUN-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_01/o1_mf_1_4_7yz1bypy_.arc

11 1 5 A 01-JUL-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_01/o1_mf_1_5_7z0pkzwc_.arc

12 1 6 A 01-JUL-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_02/o1_mf_1_6_7z29g3nx_.arc

13 1 7 A 02-JUL-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_03/o1_mf_1_7_7z4j89fl_.arc

14 1 8 A 03-JUL-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_03/o1_mf_1_8_7z4rxwcl_.arc

15 1 9 A 03-JUL-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_03/o1_mf_1_9_7z5yrjdh_.arc

16 1 10 A 03-JUL-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_04/o1_mf_1_10_7z88m6yb_.arc

17 1 11 A 04-JUL-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_05/o1_mf_1_11_7z9mvrjg_.arc

18 1 12 A 05-JUL-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_05/o1_mf_1_12_7zc7h9c4_.arc

19 1 13 A 05-JUL-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_06/o1_mf_1_13_7zd89gs1_.arc

20 1 14 A 06-JUL-12

/oracle/app/flash_recovery_area/CMS/archivelog/2012_07_06/o1_mf_1_14_7zfvvn26_.arc

21

weixin_39978257
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
日志满了 数据库下线oracle,oracle 日志满、数据库空间不足的处理
weixin_26833939的博客
04-03 119
客户反映宽带认证服务器，认证日志、认证详单没有且部分宽带用户有掉线现象--处理过程1.查看磁盘空间使用情况df -h发现有一磁盘使用100%2.经过分析发现数据库日志异常大,清理相关日志--10G/u01/app/oracle/diag/tnslsnr/RADIUS1/listener/alert--400M/u01/app/oracle/diag/tnslsnr/RADIUS1/listener...
Oracle归档日志删除
二逩
06-17 1771
Oracle归档日志删除 我们都都知道在controlfile中记录着每一个archivelog的相关信息，当然们在OS下把这些物理文件delete掉后，在我们的 controlfile中仍然记录着这些archivelog的信息，在oracle的OEM管理器中有可视化的日志展现出，当我们手工清除 archive目录下的文件后，这些记录并没有被我们从controlfile中清除掉，也就是or
使用 RMAN 无法连接到 target database
最新发布
youmeyoume2165的博客
09-26 1828
在DataGurd创建物理standby数据库时，使用 RMAN 无法连接 target database，提示报错：
RMAN 异机复制数据库
38°C的专栏
05-14 725
<br />实验平台： REDHAT linux 4.7 + oracle 10g<br /><br />目标库信息：<br />ORACLE_BASE: /u01/app/oracle<br />ORACLE_HOME: /u01/app/oracle/product/10.2.0/db_1<br />ORACLE_SID：orcl<br />IP: 192.168.1.20<br /><br />辅助库信息：<br />ORACLE_BASE: /u01/app/oracle<br />ORACLE_H
RMAN-01009: syntax error: found "dot" 解决办法
rudy gao
06-03 5234
RMAN-01009: syntax error: found "dot" 解决方法 　　今天调试一个RMAN 的备份脚本，这个脚本以前也用过很多次，并没有什么问题，今天执行时，就是过不去。 　　操作系统：Redhat 5.8 　　数据库：11.2.0.3 　　错误如下： 　　RMAN-00571:===================================
解决Oracle数据库归档日志占满磁盘空间问题
09-09
Oracle数据库的归档日志（Archived Logs）是数据库运行过程中不可或缺的一部分，它们记录了数据库事务的更改历史，用于在发生故障时进行恢复。然而，当归档日志占满磁盘空间时，可能导致数据库性能下降甚至无法正常...
com.oracle.ojdbc7jar包下载.zip
07-15
- 注意异常处理，确保在出现错误时能正确关闭资源并记录日志。 总之，ojdbc7-12.1.0.2.jar是Java开发者在Oracle数据库项目中的必备工具，它提供了连接和操作Oracle数据库的能力，使得Java应用程序能灵活地处理...
blog.zip_jfinal_jfinal 日志配置_oracle
09-23
本文将深入探讨如何在JFinal项目中进行日志配置，并结合Oracle数据库进行简单实现。 首先，让我们来了解JFinal的日志配置。JFinal默认集成了Log4j作为日志系统，但同时也支持其他日志框架如Logback和Java内置的日志...
oracle数据库归档日志满问题解决方案.docx
12-30
Oracle数据库归档日志满问题解决方案 Oracle数据库的归档日志满问题是一个常见的问题，当归档日志满时，数据库将无法写入新的日志，从而影响数据库的正常运行。下面是一个解决方案，旨在帮助用户解决 Oracle ...
Oracle.ManagedDataAccess.zip
04-10
7. **错误处理和诊断**：提供了详细的异常信息和日志记录，方便调试和问题排查。 8. **XML支持**：支持XML类型的字段操作，可以方便地处理包含XML数据的数据库列。 9. **安全性**：支持最新的安全特性，如加密连接...
oracle rman备份时间,Oracle 11g RMAN备份-一致备份
weixin_30232185的博客
04-02 456
--调整为非归档模式sys@TESTDB11>shutdownimmediate;Database closed.Database dismounted.ORACLE instance shut down.--启动到mount状态sys@TESTDB11>startupmount;ORACLE instance started.Total SystemGlobalArea8559820...
玩转恢复目录数据库（一)
congyuji4066的博客
09-04 166
关于oracle的恢复目录的概念和规划，以后再逐步总结。如何创建数据库的恢复目录？应该分为两种情况，一种是数据库同时目标数据库，又是目录数据库；另一种是目标数据库和目录数据库分离。 《一》目标和目录数据库为同一台数据库的创建思...
日志满是oracle,oracle归档日志满了，导致oracle用户不能登录
weixin_34002071的博客
04-03 1524
原因：归档日志文件爆满什么是Oracle归档模式？Oracle数据库有联机重做日志，这个日志是记录对数据库所做的修改，比如插入，删除，更新数据等，对这些操 作都会记录在联机重做日志里。一般数据库至少要有2个联机重做日志组。当一个联机重做日志组被写满的时候，就会发生日志切换，这时联机重做日志组2成为当 前使用的日志，当联机重做日志组2写满的时候，又会发生日志切换，去写联机重做日志组1，就这样反复进行...
oracle redo空间满了,如何解决Oracle数据库归档日志占满磁盘空间
weixin_35849182的博客
04-09 771
1、数据库不能启动SQL> startupORACLE 例程已经启动。Total System Global Area 289406976 bytesFixed Size 1248576 bytesVariable Size 83886784 bytesDatabase Buffers 197132288 byte...
“syntax error: unexpected end of file”解决方案
热门推荐
你不勇敢 没人替你坚强
05-24 4万+
Linux环境，Jenkins执行shell脚本报错： line 51: syntax error: unexpected end of file Build step 'Execute shell' marked build as failure 检查了下自己写的脚本文件，并没有第51行，反复执行多次，仍然提示这个错误。 在网上搜了一圈，两种解决方案： 1、检查脚本格式 使用vim...
RMAN登陆及连接target数据库的步骤方法
iteye_19543的博客
04-10 1727
[img]http://dl2.iteye.com/upload/attachment/0095/9467/df364d56-51d5-3c91-96e0-df17abeb7c3e.jpg[/img] RMAN登陆及连接target数据库的步骤方法 一、 方法一： a) [Oracle@odd-oelr4u8 ~]$ rman target s...
su oracle c 脚本,做个ORACLE维护归档脚本出错 su - oracle -c '出错
weixin_35909607的博客
04-04 390
使用双引号是不行的，HP UNIX下用的是单引号，RMAN里单独执行这段脚本是没错的run{allocate channel c1 type DISK connect 'sys/sys@kmer1';allocate channel c2 type DISK connect 'sys/sys@kmer2';delete noprompt archivelog until time 'sysdate...
oracle日志空间满了解决方案,oracle归档日志满了的处理方法
weixin_42275078的博客
04-03 1214
db_recovery_file_dest_size参考文档:http://www.eygle.com/archives/2005/03/oracle10gecieif.html1.错误提示:ORA-19815:WARNING:db_recovery_file_dest_sizeof2147483648bytesis87.41%used,andhas270457856r...
Oracle日志分析工具LogMiner入门与实例
Oracle日志分析工具LogMiner是Oracle数据库管理中一项强大的功能，它允许用户在不重启实例的情况下，无需物理访问数据库就能深入分析数据库的更改历史，这对于数据回滚、性能调优以及审计跟踪等工作至关重要。...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值