Problem : -
Database SID=orcl
1.
SQL> startup
ORACLE instance started.
Total System Global Area 6530596864 bytes
Fixed Size 2219048 bytes
Variable Size 3556770776 bytes
Database Buffers 2952790016 bytes
Redo Buffers 18817024 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 753668
Session ID: 96 Serial number: 3
ORACLE instance started.
Total System Global Area 6530596864 bytes
Fixed Size 2219048 bytes
Variable Size 3556770776 bytes
Database Buffers 2952790016 bytes
Redo Buffers 18817024 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 753668
Session ID: 96 Serial number: 3
2.
alert_orcl.log
Tue Aug 12 17:52:37 2014
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /d01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora
System parameters with non-default values:
processes = 150
sessions = 248
memory_target = 6256M
control_files = "/d01/app/oracle/oradata/orcl/control01.ctl"
control_files = "/d01/app/oracle/flash_recovery_area/orcl/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_format = "%t_%s_%r.dbf"
db_recovery_file_dest = "/d01/app/oracle/flash_recovery_area"
db_recovery_file_dest_size= 3852M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
audit_file_dest = "/d01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "/d01/app/oracle"
Tue Aug 12 17:52:37 2014
PMON started with pid=2, OS id=860670
Tue Aug 12 17:52:38 2014
VKTM started with pid=3, OS id=700672 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue Aug 12 17:52:38 2014
GEN0 started with pid=4, OS id=491846
Tue Aug 12 17:52:38 2014
DIAG started with pid=5, OS id=647324
Tue Aug 12 17:52:38 2014
DBRM started with pid=6, OS id=557196
Tue Aug 12 17:52:38 2014
PSP0 started with pid=7, OS id=553438
Tue Aug 12 17:52:38 2014
DIA0 started with pid=8, OS id=434638
Tue Aug 12 17:52:38 2014
MMAN started with pid=9, OS id=696514
Tue Aug 12 17:52:38 2014
DBW0 started with pid=10, OS id=385046
Tue Aug 12 17:52:38 2014
LGWR started with pid=11, OS id=311750
Tue Aug 12 17:52:39 2014
CKPT started with pid=12, OS id=180302
Tue Aug 12 17:52:39 2014
SMON started with pid=13, OS id=422120
Tue Aug 12 17:52:39 2014
RECO started with pid=14, OS id=590094
Tue Aug 12 17:52:39 2014
MMON started with pid=15, OS id=843842
Tue Aug 12 17:52:39 2014
MMNL started with pid=16, OS id=667850
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /d01/app/oracle
Tue Aug 12 17:52:39 2014
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 1383189735
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Tue Aug 12 17:52:44 2014
ALTER DATABASE OPEN
LGWR: STARTING ARCH PROCESSES
Tue Aug 12 17:52:44 2014
ARC0 started with pid=20, OS id=643416
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Errors in file /d01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_377118.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4039114752 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Errors in file /d01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_377118.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 34288640 bytes disk space from 4039114752 limit
ARCH: Error 19809 Creating archive log file to '/d01/app/oracle/flash_recovery_area/ORCL/archivelog/2014_08_12/o1_mf_1_126_%u_.arc'
Tue Aug 12 17:52:45 2014
ARC1 started with pid=21, OS id=451010
Errors in file /d01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_377118.trc:
ORA-16038: log 3 sequence# 126 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/d01/app/oracle/oradata/orcl/redo03.log'
USER (ospid: 377118): terminating the instance due to error 16038
Instance terminated by USER, pid = 377118
Solution : -
1. $ export ORACLE_SID=orcl
2. $ sqlplus / as sysdba
3. SQL> startup mount
ORACLE instance started.
Total System Global Area 6530596864 bytes
Fixed Size 2219048 bytes
Variable Size 3556770776 bytes
Database Buffers 2952790016 bytes
Redo Buffers 18817024 bytes
Database mounted.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size big integer 3072M
4. SQL> alter system set db_recovery_file_dest_size=5050M;
System altered.
5. SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
6. SQL> startup
ORACLE instance started.
Total System Global Area 6530596864 bytes
Fixed Size 2219048 bytes
Variable Size 3556770776 bytes
Database Buffers 2952790016 bytes
Redo Buffers 18817024 bytes
Database mounted.
Database opened.
7. have coffee.
No comments:
Post a Comment