SQL*Plus:Release 11.2.0.4.0 Production on Tue Sep 27 11:11:47 2016
Copyright(c) 1982, 2013, Oracle. All rightsreserved.
SQL>
ORACLEinstance started.
FixedSize 2269032 bytes
DatabaseBuffers 1.7918E+10 bytes
Databasemounted.
SQL>
alterdatabase open
ERRORat line 1:
ProcessID: 3065
Solution:
Step-1: First look at [alert.log] file the find the actual error
<msgtime='2016-09-27T11:12:09.555+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.xx.12'module='[email protected] (TNS V1-V3)'
<txt>ARCH: Error 19809 Creatingarchive log file to'/fra/TECHDB/archivelog/2016_09_27/o1_mf_1_16404_%u_.arc'
</msg>
<msgtime='2016-09-27T11:12:09.555+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.xx.12'module='
<txt>ARC1: Error 19809 Creatingarchive log file to'/fra/TECHDB/archivelog/2016_09_27/o1_mf_1_16405_%u_.arc'
</msg>
<msgtime='2016-09-27T11:12:09.614+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.xx.12'module='
<txt>ARCH: Archival stopped, erroroccurred. Will continue retrying
</msg>
<msgtime='2016-09-27T11:12:09.614+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.xx.12'module='
<txt>ORACLE Instance techdb - ArchivalError
</msg>
<msgtime='2016-09-27T11:12:09.620+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.xx.12'module='[email protected] (TNS V1-V3)'
<txt>Errors in file/u01/app/oracle/diag/rdbms/techdb/techdb/trace/techdb_ora_3065.trc:
ORA-16038:log 3 sequence# 16404 cannot be archived
ORA-00312:online log 3 thread 1: '/techtestdb/techdb/redo03.log'
</msg>
<msgtime='2016-09-27T11:12:09.620+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.x.12'module='
<txt>ORA-16038: log 2 sequence# 16405cannot be archived
ORA-00312:online log 2 thread 1: '/techtestdb/techdb/redo02.log'
</msg>
<msgtime='2016-09-27T11:12:09.688+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.xx.12'module='[email protected] (TNS V1-V3)'
<txt>USER (ospid: 3065): terminatingthe instance due to error 16038
</msg>
<msgtime='2016-09-27T11:12:09.710+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.xx.12'module='
<txt>System state dump requested by(instance=1, osid=3065), summary=[abnormal instance termination].
</msg>
<msgtime='2016-09-27T11:12:09.729+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.xx.12'module='
<txt>SystemState dumped to trace file/u01/app/oracle/diag/rdbms/techdb/techdb/trace/techdb_diag_3031_20160927111209.trc
</msg>
<msgtime='2016-09-27T11:12:09.870+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.xx.12'module='
<txt>Dumping diagnostic data indirectory=[cdmp_20160927111209], requested by (instance=1, osid=3065),summary=[abnormal instance termination].
</msg>
<msgtime='2016-09-27T11:12:09.951+06:00' org_id='oracle' comp_id='rdbms'
host_id='techtest.nblbd.com' host_addr='xxx.xx.xx.12'module='[email protected] (TNS V1-V3)'
<txt>Instance terminated by USER, pid =3065
</msg>
Step-2: After look the alert log file, We have found two point on it and that are-
1.Error to create archive log
>>Step-3: First try to delete the archive log toovercome error
RecoveryManager: Release 11.2.0.4.0 - Production on Tue Sep 27 11:15:23 2016
Copyright(c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connectedto target database (not started)
RMAN>delete noprompt archivelog all;
usingtarget database control file instead of recovery catalog
RMAN-00571:
RMAN-00569: ERROR MESSAGE STACK FOLLOWS
RMAN-00571:
RMAN-03002:failure of delete command at 09/27/2016 11:15:29
RMAN-06403:could not obtain a fully authorized session
ORA-27101:shared memory realm does not exist
It is not possible to delete archive log as database is not open and limit exceeded for the recovery file.
>>Step-4: Increase the size of DB_RECOVERY_FILE_DEST_SIZE
4.1: current value
----------------------------------------------- ------------------------------
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE =55g;
System altered.
>>Step-5: Database Open
[oracle@techtest~]$ sqlplus / as sysdba
SQL*Plus:Release 11.2.0.4.0 Production on Tue Sep 27 11:18:30 2016
Copyright(c) 1982, 2013, Oracle. All rightsreserved.
OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Withthe Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>select open_mode from v$database;
OPEN_MODE
MOUNTED
SQL>
ORA-01081:cannot start already-running ORACLE - shut it down first
SQL>alter database open;
Databasealtered.
SQL>exit
This error can occur due to different problems. Therefore check alert log file.
Hello, I will mention my problem.And we will try solve this problem together. i have oracle 11 gR2 standalone database in Oracle linux OS. After I haverebooted the OS i can' t access my database .
Oracle database is starting in mount mode but it cant start open mode.
The following error message below in this mode:
I checked my alertlog Through OS text editor program. Online redo log files and their mirrors in differ paths. The Database is in archive mode and online log file 3 canâ t archieved.
For solve this problem we will use PITR( Point in timerecovery) method via RMAN. I m not useCatalog database.
rman target /
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ---------------------------
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20120501T001147
Piece Name:+XFRA/xdb/autobackup/2012_05_01/s_782093507.299.782093509
SPFILE db_unique_name:XDB
Control File Included: CkpSCN:1222523 Ckp time: 01-MAY-12
I signed that SCN is 1222523 when backup have been taken. I willuse this scn number.
I will Run command in RMANtool. You can execute more lines at onetime between Run {} command .
If you want set untiltime <date> inside of until scn . I prefer Scn number.
RMAN> run {
3> restore database;
5> }
channel ORA_DISK_1: restoring datafile 00001 to u01/app/oracle/oradata/XDB/datafile/system01. dbf
channel ORA_DISK_1: restoring datafile 00002 to/u01/app/oracle/oradata/XDB/datafile/sysaux01. dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/XDB/datafile/undotbs01 .dbf
channel ORA_DISK_1: restoring datafile 00004 to/u01/app/oracle/oradata/XDB/datafile/users01.d bf
channel ORA_DISK_1: reading from backup piece+XFRA/xdb/backupset/2012_02_04/nnndn0_tag2012020 4t232950_0.275.774401393
channel ORA_DISK_1: piece handle=+XFRA/xdb/backupset/2012_02_04/nnndn0_tag20120204t232950_0.27 5.774401393 tag=TAG20120204T232950
channel ORA_DISK_1: restore complete, elapsed time: 00:03:04
using channel ORA_DISK_1
archived log for thread 1 with sequence 1 is already on disk asfile +XFRA/xdb/archivelog/2012 _02_04/thread_1_seq_1.277.774402255
archived log for thread 1 with sequence 2 is already on disk asfile +XFRA/xdb/archivelog/2012 _02_04/thread_1_seq_2.278.774402273
archived log for thread 1 with sequence 3 is already on disk asfile +XFRA/xdb/archivelog/2012 _02_04/thread_1_seq_3.279.774402285
archived log for thread 1 with sequence 4 is already on disk asfile +XFRA/xdb/archivelog/2012 _02_05/thread_1_seq_4.281.774485121
archived log for thread 1 with sequence 5 is already on disk asfile +XFRA/xdb/archivelog/2012 _02_11/thread_1_seq_5.282.774986479
archived log for thread 1 with sequence 6 is already on disk asfile +XFRA/xdb/archivelog/2012 _02_11/thread_1_seq_6.283.774986847
archived log for thread 1 with sequence 7 is already on disk asfile +XFRA/xdb/archivelog/2012 _02_19/thread_1_seq_7.284.775694209
archived log for thread 1 with sequence 8 is already on disk asfile +XFRA/xdb/archivelog/2012 _02_27/thread_1_seq_8.288.776307623
archived log for thread 1 with sequence 9 is already on disk asfile +XFRA/xdb/archivelog/2012 _03_12/thread_1_seq_9.289.777764633
archived log for thread 1 with sequence 10 is already on disk asfile +XFRA/xdb/archivelog/201 2_03_12/thread_1_seq_10.290.777766019
archived log for thread 1 with sequence 11 is already on disk asfile +XFRA/xdb/archivelog/201 2_03_17/thread_1_seq_11.291.778189273
archived log for thread 1 with sequence 12 is already on disk asfile +XFRA/xdb/archivelog/201 2_03_17/thread_1_seq_12.292.778194849
archived log for thread 1 with sequence 13 is already on disk asfile +XFRA/xdb/archivelog/201 2_03_17/thread_1_seq_13.293.778195573
archived log for thread 1 with sequence 14 is already on disk asfile +XFRA/xdb/archivelog/201 2_03_17/thread_1_seq_14.294.778196007
archived log for thread 1 with sequence 15 is already on disk asfile +XFRA/xdb/archivelog/201 2_03_24/thread_1_seq_15.295.778788259
archived log for thread 1 with sequence 16 is already on disk asfile +XFRA/xdb/archivelog/201 2_03_25/thread_1_seq_16.296.778810005
archived log for thread 1 with sequence 17 is already on disk asfile +XFRA/xdb/archivelog/201 2_04_05/thread_1_seq_17.297.779829497
archived log for thread 1 with sequence 18 is already on disk asfile +XFRA/xdb/archivelog/201 2_04_08/thread_1_seq_18.298.780101645
archived log for thread 1 with sequence 19 is already on disk asfile +XFRA/xdb/archivelog/201 2_04_09/thread_1_seq_19.257.780105631
archived log for thread 1 with sequence 20 is already on disk asfile +XFRA/xdb/archivelog/201 2_04_30/thread_1_seq_20.256.782004437
archived log filename=+XFRA/xdb/archivelog/2012_02_04/thread_1_seq_1.277.774402255 thread=1s equence=1
Ora-03113 End-of-file On Communication Channel While Starting The Database
archived log filename=+XFRA/xdb/archivelog/2012_02_04/thread_1_seq_2.278.774402273 thread=1s equence=2
archived log file name=+XFRA/xdb/archivelog/2012_02_04/thread_1_seq_3.279.774402285thread=1 s equence=3
archived log filename=+XFRA/xdb/archivelog/2012_02_05/thread_1_seq_4.281.774485121 thread=1s equence=4
archived log filename=+XFRA/xdb/archivelog/2012_02_11/thread_1_seq_5.282.774986479 thread=1sequence=5
archived log filename=+XFRA/xdb/archivelog/2012_02_11/thread_1_seq_6.283.774986847 thread=1sequence=6
archived log filename=+XFRA/xdb/archivelog/2012_02_19/thread_1_seq_7.284.775694209 thread=1sequence=7
archived log filename=+XFRA/xdb/archivelog/2012_02_27/thread_1_seq_8.288.776307623 thread=1sequence=8
archived log filename=+XFRA/xdb/archivelog/2012_03_12/thread_1_seq_9.289.777764633 thread=1sequence=9
archived log filename=+XFRA/xdb/archivelog/2012_03_12/thread_1_seq_10.290.777766019 thread=1sequence=10
archived log file name=+XFRA/xdb/archivelog/2012_03_17/thread_1_seq_11.291.778189273thread=1 sequence=11
archived log filename=+XFRA/xdb/archivelog/2012_03_17/thread_1_seq_12.292.778194849 thread=1sequence=12
archived log filename=+XFRA/xdb/archivelog/2012_03_17/thread_1_seq_13.293.778195573 thread=1sequence=13
archived log filename=+XFRA/xdb/archivelog/2012_03_17/thread_1_seq_14.294.778196007 thread=1sequence=14
archived log filename=+XFRA/xdb/archivelog/2012_03_24/thread_1_seq_15.295.778788259 thread=1sequence=15
archived log file name=+XFRA/xdb/archivelog/2012_03_25/thread_1_seq_16.296.778810005thread=1 sequence=16
archived log filename=+XFRA/xdb/archivelog/2012_04_05/thread_1_seq_17.297.779829497 thread=1sequence=17
archived log filename=+XFRA/xdb/archivelog/2012_04_08/thread_1_seq_18.298.780101645 thread=1sequence=18
archived log filename=+XFRA/xdb/archivelog/2012_04_09/thread_1_seq_19.257.780105631 thread=1sequence=19
archived log filename=+XFRA/xdb/archivelog/2012_04_30/thread_1_seq_20.256.782004437 thread=1sequence=20
Finished recover at 13-JUN-12
As without problem finishedrecover process We are opening databaseopen with resetlogs Because using resetlogs parameter, log number reset and starting 1 number.
RMAN> alter database open resetlogs;
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |