Delete Archivelog Using RMAN in Oracle
SQL>
startup
ORACLE instance started.
Total System Global Area 1636814848 bytes
Fixed Size 2176248 bytes
Variable Size 1140853512 bytes
Database Buffers 486539264 bytes
Redo Buffers 7245824 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 1380
Session ID: 191 Serial number: 3
ORACLE instance started.
Total System Global Area 1636814848 bytes
Fixed Size 2176248 bytes
Variable Size 1140853512 bytes
Database Buffers 486539264 bytes
Redo Buffers 7245824 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 1380
Session ID: 191 Serial number: 3
Check in
Alert Log file …….
NOTE: initiating MARK
startup
Starting background process
MARK
Mon Jan 06 16:41:54 2014
MARK started with pid=19, OS
id=2952
NOTE: MARK has subscribed
Mon Jan 06 16:41:54 2014
starting up 1 dispatcher(s)
for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared
server(s) ...
ORACLE_BASE from environment
= E:\app\Administrator
Mon Jan 06 16:41:56 2014
ALTER DATABASE MOUNT /* db
agent *//* {0:1:28} */
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was
mounted
NOTE: dependency between
database ASM and diskgroup resource ora.DATA.dg is established
Successful mount of redo
thread 1, with mount id 3855157908
Database mounted in
Exclusive Mode
Lost write protection
disabled
Completed: ALTER DATABASE
MOUNT /* db agent *//* {0:1:28} */
ALTER DATABASE OPEN /* db
agent *//* {0:1:28} */
LGWR: STARTING ARCH
PROCESSES
Mon Jan 06 16:42:02 2014
ARC0 started with pid=26, OS
id=8080
ARC0: Archival started
ARC0: Becoming the 'no FAL'
ARCH
ARC0: Becoming the 'no SRL'
ARCH
LGWR: STARTING ARCH
PROCESSES COMPLETE
ARCH: Error 19504 Creating
archive log file to 'E:\ARCHIVE\ARC0000003106_0832442370.0001'
ARC0: Error 19504 Creating
archive log file to 'E:\ARCHIVE\ARC0000003107_0832442370.0001'
Errors in file
E:\APP\ADMINISTRATOR\diag\rdbms\asm\asm\trace\asm_ora_1500.trc:
ORA-16038: log 1 sequence#
3106 cannot be archived
ORA-19504: failed to create
file ""
ORA-00312: online log 1
thread 1: '+DATA/asm/onlinelog/group_1.261.832442371'
USER (ospid: 1500):
terminating the instance due to error 16038
Mon Jan 06 16:42:04 2014
System state dump requested
by (instance=1, osid=1500), summary=[abnormal instance termination].
System State dumped to trace
file E:\APP\ADMINISTRATOR\diag\rdbms\asm\asm\trace\asm_diag_1608.trc
Dumping diagnostic data in
directory=[cdmp_20140106164204], requested by (instance=1, osid=1500),
summary=[abnormal instance termination].
Mon Jan 06 16:42:11 2014
Instance terminated by USER,
pid = 1500
SQL>Shutdown Immediate;
SQL>
startup mount
Then follow
the below steps….
SQL> HOST
E:\app\Administrator\product\11.2.0\dbhome_1\BIN>rman
target /
Recovery Manager: Release
11.2.0.3.0 - Production on Mon Jan 6 17:36:48 2014
Copyright (c) 1982, 2011,
Oracle and/or its affiliates. All rights
reserved.
connected to target
database: ASM (DBID=1255844286)
RMAN>
Archivelog List Commands
RMAN>list archivelog all;
RMAN>list copy of archivelog until time ‘SYSDATE-10′;
RMAN>list copy of archivelog from time ‘SYSDATE-10′
RMAN>list copy of archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′;
RMAN>list copy of archivelog from sequence 1000;
RMAN>list copy of archivelog until sequence 1500;
RMAN>list copy of archivelog from sequence 1000 until sequence 1500;
RMAN>list copy of archivelog until time ‘SYSDATE-10′;
RMAN>list copy of archivelog from time ‘SYSDATE-10′
RMAN>list copy of archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′;
RMAN>list copy of archivelog from sequence 1000;
RMAN>list copy of archivelog until sequence 1500;
RMAN>list copy of archivelog from sequence 1000 until sequence 1500;
Archivelog Delete Commands
RMAN>delete archivelog until time ‘SYSDATE-10′;
RMAN>delete archivelog from time ‘SYSDATE-10′
RMAN>delete archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′;
RMAN>delete archivelog from sequence 1000;
RMAN>delete archivelog until sequence 1500;
RMAN>delete archivelog from sequence 1000 until sequence 1500;
Note : Also, you can use noprompt statement for do not yes-no question.
RMAN>delete noprompt archivelog until time ‘SYSDATE-10′;
RMAN> quit
Recovery Manager complete.
E:\app\Administrator\product\11.2.0\dbhome_1\BIN>sqlplus
SQL*Plus: Release 11.2.0.3.0
Production on Mon Jan 6 17:39:15 2014
Copyright (c) 1982, 2011,
Oracle. All rights reserved.
Enter user-name: sys as
sysdba
Enter password:
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning,
Automatic Storage Management, OLAP, Data Mining
and Real Application Testing
options
SQL>alter database open;
Now Issue
is solved…..
Please share your valuable feedback.
