日志满是oracle,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