Forum

Oracle Veritabanı Y...
 
Bildirimler
Hepsini Temizle

Oracle Veritabanı Yedekten Dönme Sorunu

8 Yazılar
4 Üyeler
0 Likes
2,014 Görüntüleme
(@DefneDeniz)
Gönderiler: 20
Eminent Member
Konu başlatıcı
 

Merhaba,

Linux üzerinde Oracle veritabanını açarken startup komutunu yazınca, şu şekilde hata veriyor:

SQL> startup;
ORACLE instance started.

Total System Global Area 3003121664 bytes
Fixed Size 2928920 bytes
Variable Size 771755752 bytes
Database Buffers 2214592512 bytes
Redo Buffers 13844480 bytes

ORA-00205: error in identifying control file, check alert log for more info

 

Veritabanı sağlıklı çalıştığı sırada Rman ile yedek almıştım.

Şimdi Control file'ı yedekten dönmeye çalışırken, şu komutu yazıyorum:

RMAN> restore controlfile from autobackup;

Starting restore at 12-JUL-18
using channel ORA_DISK_1

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20180712
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20180711
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20180710
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20180709
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20180708
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20180707
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20180706
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/12/2018 11:35:46
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

 

Bu şekilde hata veriyor.

Full yedek alınmıştı ve control file ile spfile autobackup şeklinde alınmıştı.

 

Şu an full yedekten de dönülmüyor, çünkü veritabanı mount modda açılmıyor.

 

Sorunun çözümü için ne yapmam gerekmektedir?

Yardımcı olursanız sevinirim.

Teşekkürler.

 

 
Gönderildi : 12/07/2018 16:43

(@vasviuysal)
Gönderiler: 7891
Üye
 

https://anargodjaev.wordpress.com/2016/02/11/rman-06172-no-autobackup-found-or-specified-handle-is-not-a-valid-copy-or-piece/

 

buradaki çözüm işinize yarar umarım

 

 

iyi çalışmalar

 

 

 
Gönderildi : 12/07/2018 16:57

(@ertanyildizdal)
Gönderiler: 285
Reputable Member
 

kesin görmüşsündür ama aşağıdaki dökümanı inceleyebilir misin?

https://community.oracle.com/thread/1126349?start=15&tstart=0

 

 

 
Gönderildi : 12/07/2018 17:15

(@DefneDeniz)
Gönderiler: 20
Eminent Member
Konu başlatıcı
 

Merhaba,

Yardımınız için çok teşekkürler.

Verdiğiniz linki inceledim.

Rman'de show all yazınca autobackup özelliği OFF olarak görünüyor.

Bunu değiştirmeyi denedim fakat veritabanı mount modda olmadığı için bunu değiştiremedim.

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

 

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 07/12/2018 14:14:08
ORA-01507: database not mounted

 
Gönderildi : 12/07/2018 17:16

(@bugraparlayan)
Gönderiler: 324
Üye
 

Selamlar,

Öncelikle control file dosyasına bir bakalım.

Oracle veri tabanında 2 adet control file tutuluyor. " sqlplus / as sysdba " yazarak sql penceresine düşün ve " show parameter control_files " paremetresini çalıştırın. Size control file yollarını söyleyecek.

Örnek çıktı.

SQL> /oracle/database/11.2.0.4/oradata/COZUMPARK/control01.ctl, /oracle/database/11.2.0.4/oradata/COZUMPARK/control02.ctl

Yeni bir terminal penceresi açın ve control file dosyasını açağadaki gibi kontrol edin. Dosyaların yazılabilir olması gerek eğer hata verirse buradan bir belirtin.

$ ll /oracle/database/11.2.0.4/oradata/COZUMPARK/control01.ctl

$ ll /oracle/database/11.2.0.4/oradata/COZUMPARK/fra/control02.ctl

 

Dosyalar düzgünse şunu bir deneyin.

Tekrar bir terminal açın ve " sqplus / as sysdba " diyin.

SQL> create pfile='/tmp/pfile.ora' from spfile;
File created.

yeni bir terminal penceresi açın burada spfile üzerinden oluşturduğumuz pfile 'ı düzenleyeceğiz.

$ vi /tmp/pfile.ora

Bu satırı bulun ve değiştirin

" *.control_files=/oracle/database/11.2.0.4/oradata/COZUMPARK/control01.ctl, /oracle/database/11.2.0.4/oradata/COZUMPARK/control02.ctl' "

yerine

" *.control_files=/oracle/database/11.2.0.4/oradata/COZUMPARK/control01.ctl" yazarak düzenleyip kayıt edin.

" sqplus / as sysdba " yazarak " shu immediate " komutu verin.

SQL> shu immediate

SQL> startup pfile=/tmp/pfile.ora

 

Çıktıyı sonra bize gönderin.

Hızlı yazdığım için satır satır bilare düzenlerim : ))

Kolay gelsin.

 

 

 

 

 

 

 

 

Oracle ACE Associate - Türkiye Hayat & Emeklilik

****************************************************************
Probleminiz Çözüldüğünde Sonucu Burada Paylaşırsanız.
Sizde Aynı Problemi Yaşayanlar İçin Yardım Etmiş Olursunuz.
Eğer sorununuz çözüldü ise lütfen "çözüldü" olarak işaretlerseniz diğer üyeler için çok büyük kolaylık sağlayacaktır.
*****************************************************************

 
Gönderildi : 12/07/2018 18:04

(@DefneDeniz)
Gönderiler: 20
Eminent Member
Konu başlatıcı
 

Merhaba yanıtlar için çok teşekkürler.

Öncelikle control file'leri kontrol ettim okunabilir haldeler.

-rw-r----- 1 oracle oinstall 18005722 Jul 10 09:17 /u01/app/oracle/oradata/emrepcdb/control01.ctl

pfile içerisini şu şekilde düzenledim:

*.control_files='/u01/app/oracle/oradata/emrepcdb/control01.ctl'

Daha sonra shu immediate yazınca şu hatayı verdi.

SQL> shu immediate
ORA-01507: database not mounted

ORACLE instance shut down.

Son olarak, startup çıktısı:

SQL> startup pfile=/tmp/pfile.ora
ORACLE instance started.

Total System Global Area 3003121664 bytes
Fixed Size 2928920 bytes
Variable Size 771755752 bytes
Database Buffers 2214592512 bytes
Redo Buffers 13844480 bytes
ORA-00205: error in identifying control file, check alert log for more info

Teşekkürler.

 
Gönderildi : 12/07/2018 20:01

(@bugraparlayan)
Gönderiler: 324
Üye
 

Selamlar,

Database Alert log çıktısnı paylaşırmısınız.

Teşekkürler,

Oracle ACE Associate - Türkiye Hayat & Emeklilik

****************************************************************
Probleminiz Çözüldüğünde Sonucu Burada Paylaşırsanız.
Sizde Aynı Problemi Yaşayanlar İçin Yardım Etmiş Olursunuz.
Eğer sorununuz çözüldü ise lütfen "çözüldü" olarak işaretlerseniz diğer üyeler için çok büyük kolaylık sağlayacaktır.
*****************************************************************

 
Gönderildi : 13/07/2018 12:09

(@DefneDeniz)
Gönderiler: 20
Eminent Member
Konu başlatıcı
 

Merhaba,

prior to instance startup operation.
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 3
Thu Jul 12 12:02:33 2018
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Jul 12 12:02:35 2018
Stopping background process VKTM
Thu Jul 12 12:02:35 2018
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Jul 12 12:02:44 2018
Instance shutdown complete
Thu Jul 12 13:34:13 2018
Starting ORACLE instance (normal) (OS id: 18359)
Thu Jul 12 13:34:13 2018
CLI notifier numLatches:7 maxDescs:519
Thu Jul 12 13:34:13 2018
*******************************************************************
Thu Jul 12 13:34:13 2018
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Thu Jul 12 13:34:13 2018
Per process system memlock (soft) limit = 64K
Thu Jul 12 13:34:13 2018
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 2866M
Thu Jul 12 13:34:13 2018
Available system pagesizes:
4K, 2048K
Thu Jul 12 13:34:13 2018
Supported system pagesize(s):
Thu Jul 12 13:34:13 2018
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
Thu Jul 12 13:34:13 2018
4K Configured 4 733188 NONE
Thu Jul 12 13:34:13 2018
2048K 0 1433 0 NONE
Thu Jul 12 13:34:13 2018
RECOMMENDATION:
Thu Jul 12 13:34:13 2018
1. For optimal performance, configure system with expected number
of pages for every supported system pagesize prior to the next
instance restart operation.
Thu Jul 12 13:34:13 2018
2. Increase per process memlock (soft) limit to at least 2866MB
to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
Thu Jul 12 13:34:13 2018
****************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 2
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/12.1.0.2/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1
System name: Linux
Node name: ---hostname---
Release: 4.1.12-37.4.1.el6uek.x86_64
Version: #2 SMP Tue May 17 07:23:38 PDT 2016
Machine: x86_64
Using parameter settings in server-side spfile /u01/app/oracle/product/12.1.0.2/db_1/dbs/spfileemrepcdb.ora
System parameters with non-default values:
processes = 300
shared_pool_size = 576M
sga_target = 2864M
control_files = "/u01/app/oracle/oradata/emrepcdb/control01.ctl"
control_files = "/u01/app/oracle/oradata/emrepcdb/control02.ctl"
db_block_size = 8192
compatible = "12.1.0.2.0"
cluster_database = FALSE
undo_tablespace = "UNDOTBS1"
db_securefile = "PERMITTED"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=emrepcdbXDB)"
session_cached_cursors = 200
parallel_min_servers = 0
parallel_max_servers = 8
audit_file_dest = "/u01/app/oracle/admin/emrepcdb/adump"
audit_trail = "DB"
db_name = "emrepcdb"
open_cursors = 300
pga_aggregate_target = 1000000000
optimizer_adaptive_features= FALSE
diagnostic_dest = "/u01/app/oracle"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Starting background process PMON
Thu Jul 12 13:34:13 2018
PMON started with pid=2, OS id=29389
Starting background process PSP0
Thu Jul 12 13:34:13 2018
PSP0 started with pid=3, OS id=29391
Starting background process VKTM
Thu Jul 12 13:34:14 2018
VKTM started with pid=4, OS id=29393 at elevated (RT) priority
Thu Jul 12 13:34:14 2018
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process GEN0
Thu Jul 12 13:34:14 2018
GEN0 started with pid=5, OS id=29397
Starting background process MMAN
Thu Jul 12 13:34:14 2018
MMAN started with pid=6, OS id=29399
Starting background process DIAG
Starting background process DBRM
Thu Jul 12 13:34:14 2018
DIAG started with pid=8, OS id=29403
Thu Jul 12 13:34:14 2018
DBRM started with pid=9, OS id=29405
Starting background process VKRM
Thu Jul 12 13:34:14 2018
VKRM started with pid=10, OS id=29407
Starting background process DIA0
Thu Jul 12 13:34:14 2018
DIA0 started with pid=11, OS id=29409
Starting background process DBW0
Starting background process LGWR
Thu Jul 12 13:34:14 2018
DBW0 started with pid=12, OS id=29411
Starting background process CKPT
Thu Jul 12 13:34:14 2018
LGWR started with pid=13, OS id=29413
Thu Jul 12 13:34:14 2018
CKPT started with pid=14, OS id=29415
Starting background process SMON
Thu Jul 12 13:34:14 2018
SMON started with pid=16, OS id=29419
Starting background process RECO
Thu Jul 12 13:34:14 2018
RECO started with pid=18, OS id=29424
Starting background process LREG
Thu Jul 12 13:34:14 2018
LREG started with pid=19, OS id=29426
Starting background process PXMN
Thu Jul 12 13:34:14 2018
PXMN started with pid=20, OS id=29428
Starting background process MMON
Thu Jul 12 13:34:14 2018
MMON started with pid=21, OS id=29430
Starting background process MMNL
Thu Jul 12 13:34:14 2018
MMNL started with pid=22, OS id=29432
Thu Jul 12 13:34:14 2018
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Thu Jul 12 13:34:14 2018
ALTER DATABASE MOUNT
Thu Jul 12 13:34:14 2018
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/emrepcdb/control02.ctl'
ORA-27048: skgfifi: file header information is invalid
Additional information: 10
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/emrepcdb/control01.ctl'
ORA-27048: skgfifi: file header information is invalid
Additional information: 10
ORA-205 signalled during: ALTER DATABASE MOUNT...
Thu Jul 12 13:34:17 2018
Using default pga_aggregate_limit of 2048 MB
Thu Jul 12 14:33:07 2018
ERROR: Shared memory area is accessible to instance startup process
prior to instance startup operation.
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
Thu Jul 12 14:33:16 2018
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Jul 12 14:33:18 2018
Stopping background process VKTM
Thu Jul 12 14:33:18 2018
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Jul 12 14:33:28 2018
Instance shutdown complete
Thu Jul 12 14:33:36 2018
Starting ORACLE instance (normal) (OS id: 4267)
Thu Jul 12 14:33:36 2018
CLI notifier numLatches:7 maxDescs:519
Thu Jul 12 14:33:36 2018
****************************************************************
Thu Jul 12 14:33:36 2018
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Thu Jul 12 14:33:36 2018
Per process system memlock (soft) limit = 64K
Thu Jul 12 14:33:36 2018
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 2866M
Thu Jul 12 14:33:36 2018
Available system pagesizes:
4K, 2048K
Thu Jul 12 14:33:36 2018
Supported system pagesize(s):
Thu Jul 12 14:33:36 2018
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
Thu Jul 12 14:33:36 2018
4K Configured 4 733188 NONE
Thu Jul 12 14:33:36 2018
2048K 0 1433 0 NONE
Thu Jul 12 14:33:36 2018
RECOMMENDATION:
Thu Jul 12 14:33:36 2018
1. For optimal performance, configure system with expected number
of pages for every supported system pagesize prior to the next
instance restart operation.
Thu Jul 12 14:33:36 2018
2. Increase per process memlock (soft) limit to at least 2866MB
to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
Thu Jul 12 14:33:36 2018
****************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 2
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/12.1.0.2/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1
System name: Linux
Node name: ---hostname---
Release: 4.1.12-37.4.1.el6uek.x86_64
Version: #2 SMP Tue May 17 07:23:38 PDT 2016
Machine: x86_64
Using parameter settings in server-side spfile /u01/app/oracle/product/12.1.0.2/db_1/dbs/spfileemrepcdb.ora
System parameters with non-default values:
processes = 300
shared_pool_size = 576M
sga_target = 2864M
control_files = "/u01/app/oracle/oradata/emrepcdb/control01.ctl"
control_files = "/u01/app/oracle/oradata/emrepcdb/control02.ctl"
db_block_size = 8192
compatible = "12.1.0.2.0"
cluster_database = FALSE
undo_tablespace = "UNDOTBS1"
db_securefile = "PERMITTED"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=emrepcdbXDB)"
session_cached_cursors = 200
parallel_min_servers = 0
parallel_max_servers = 8
audit_file_dest = "/u01/app/oracle/admin/emrepcdb/adump"
audit_trail = "DB"
db_name = "emrepcdb"
open_cursors = 300
pga_aggregate_target = 1000000000
optimizer_adaptive_features= FALSE
diagnostic_dest = "/u01/app/oracle"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Starting background process PMON
Thu Jul 12 14:33:36 2018
PMON started with pid=2, OS id=4279
Starting background process PSP0
Thu Jul 12 14:33:36 2018
PSP0 started with pid=3, OS id=4281
Starting background process VKTM
Thu Jul 12 14:33:37 2018
VKTM started with pid=4, OS id=4283 at elevated (RT) priority
Thu Jul 12 14:33:37 2018
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process GEN0
Thu Jul 12 14:33:37 2018
GEN0 started with pid=5, OS id=4287
Starting background process MMAN
Thu Jul 12 14:33:37 2018
MMAN started with pid=6, OS id=4289
Starting background process DIAG
Thu Jul 12 14:33:37 2018
DIAG started with pid=8, OS id=4293
Starting background process DBRM
Thu Jul 12 14:33:37 2018
DBRM started with pid=9, OS id=4295
Starting background process VKRM
Thu Jul 12 14:33:37 2018
VKRM started with pid=10, OS id=4297
Starting background process DIA0
Thu Jul 12 14:33:37 2018
DIA0 started with pid=11, OS id=4299
Starting background process DBW0
Thu Jul 12 14:33:37 2018
DBW0 started with pid=12, OS id=4301
Starting background process LGWR
Thu Jul 12 14:33:37 2018
LGWR started with pid=13, OS id=4303
Starting background process CKPT
Thu Jul 12 14:33:37 2018
CKPT started with pid=14, OS id=4305
Starting background process SMON
Thu Jul 12 14:33:37 2018
SMON started with pid=16, OS id=4309
Starting background process RECO
Thu Jul 12 14:33:37 2018
RECO started with pid=18, OS id=4313
Starting background process LREG
Thu Jul 12 14:33:37 2018
LREG started with pid=19, OS id=4315
Starting background process PXMN
Thu Jul 12 14:33:37 2018
PXMN started with pid=20, OS id=4317
Starting background process MMON
Thu Jul 12 14:33:37 2018
MMON started with pid=21, OS id=4319
Starting background process MMNL
Thu Jul 12 14:33:37 2018
MMNL started with pid=22, OS id=4321
Thu Jul 12 14:33:37 2018
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Thu Jul 12 14:33:37 2018
ALTER DATABASE MOUNT
Thu Jul 12 14:33:37 2018
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/emrepcdb/control02.ctl'
ORA-27048: skgfifi: file header information is invalid
Additional information: 10
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/emrepcdb/control01.ctl'
ORA-27048: skgfifi: file header information is invalid
Additional information: 10
ORA-205 signalled during: ALTER DATABASE MOUNT...
Thu Jul 12 14:33:40 2018
Using default pga_aggregate_limit of 2048 MB
Thu Jul 12 14:51:02 2018
ERROR: Shared memory area is accessible to instance startup process
prior to instance startup operation.
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
Thu Jul 12 14:51:12 2018
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Jul 12 14:51:14 2018
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Jul 12 14:51:14 2018
Stopping background process VKTM
Thu Jul 12 14:51:23 2018
Instance shutdown complete
Thu Jul 12 14:51:31 2018
Starting ORACLE instance (normal) (OS id: 6750)
Thu Jul 12 14:51:31 2018
CLI notifier numLatches:7 maxDescs:519
Thu Jul 12 14:51:31 2018
****************************************************************
Thu Jul 12 14:51:31 2018
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Thu Jul 12 14:51:31 2018
Per process system memlock (soft) limit = 64K
Thu Jul 12 14:51:31 2018
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 2866M
Thu Jul 12 14:51:31 2018
Available system pagesizes:
4K, 2048K
Thu Jul 12 14:51:31 2018
Supported system pagesize(s):
Thu Jul 12 14:51:31 2018
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
Thu Jul 12 14:51:31 2018
4K Configured 4 733188 NONE
Thu Jul 12 14:51:31 2018
2048K 0 1433 0 NONE
Thu Jul 12 14:51:31 2018
RECOMMENDATION:
Thu Jul 12 14:51:31 2018
1. For optimal performance, configure system with expected number
of pages for every supported system pagesize prior to the next
instance restart operation.
Thu Jul 12 14:51:31 2018
2. Increase per process memlock (soft) limit to at least 2866MB
to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
Thu Jul 12 14:51:31 2018
****************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 2
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/12.1.0.2/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1
System name: Linux
Node name: ---hostname---
Release: 4.1.12-37.4.1.el6uek.x86_64
Version: #2 SMP Tue May 17 07:23:38 PDT 2016
Machine: x86_64
Using parameter settings in server-side spfile /u01/app/oracle/product/12.1.0.2/db_1/dbs/spfileemrepcdb.ora
System parameters with non-default values:
processes = 300
shared_pool_size = 576M
sga_target = 2864M
control_files = "/u01/app/oracle/oradata/emrepcdb/control01.ctl"
control_files = "/u01/app/oracle/oradata/emrepcdb/control02.ctl"
db_block_size = 8192
compatible = "12.1.0.2.0"
cluster_database = FALSE
undo_tablespace = "UNDOTBS1"
db_securefile = "PERMITTED"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=emrepcdbXDB)"
session_cached_cursors = 200
parallel_min_servers = 0
parallel_max_servers = 8
audit_file_dest = "/u01/app/oracle/admin/emrepcdb/adump"
audit_trail = "DB"
db_name = "emrepcdb"
open_cursors = 300
pga_aggregate_target = 1000000000
optimizer_adaptive_features= FALSE
diagnostic_dest = "/u01/app/oracle"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Starting background process PMON
Thu Jul 12 14:51:32 2018
PMON started with pid=2, OS id=6755
Starting background process PSP0
Thu Jul 12 14:51:32 2018
PSP0 started with pid=3, OS id=6757
Starting background process VKTM
Thu Jul 12 14:51:33 2018
VKTM started with pid=4, OS id=6759 at elevated (RT) priority
Thu Jul 12 14:51:33 2018
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process GEN0
Thu Jul 12 14:51:33 2018
GEN0 started with pid=5, OS id=6763
Starting background process MMAN
Thu Jul 12 14:51:33 2018
MMAN started with pid=6, OS id=6765
Starting background process DIAG
Thu Jul 12 14:51:33 2018
DIAG started with pid=8, OS id=6769
Starting background process DBRM
Thu Jul 12 14:51:33 2018
DBRM started with pid=9, OS id=6771
Starting background process VKRM
Thu Jul 12 14:51:33 2018
VKRM started with pid=10, OS id=6773
Starting background process DIA0
Thu Jul 12 14:51:33 2018
DIA0 started with pid=11, OS id=6775
Starting background process DBW0
Thu Jul 12 14:51:33 2018
DBW0 started with pid=12, OS id=6777
Starting background process LGWR
Thu Jul 12 14:51:33 2018
LGWR started with pid=13, OS id=6779
Starting background process CKPT
Thu Jul 12 14:51:33 2018
CKPT started with pid=14, OS id=6781
Starting background process SMON
Thu Jul 12 14:51:33 2018
SMON started with pid=16, OS id=6785
Starting background process RECO
Thu Jul 12 14:51:33 2018
RECO started with pid=18, OS id=6789
Starting background process LREG
Thu Jul 12 14:51:33 2018
LREG started with pid=19, OS id=6792
Starting background process PXMN
Thu Jul 12 14:51:33 2018
PXMN started with pid=20, OS id=6794
Starting background process MMON
Thu Jul 12 14:51:33 2018
MMON started with pid=21, OS id=6796
Starting background process MMNL
Thu Jul 12 14:51:33 2018
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jul 12 14:51:33 2018
MMNL started with pid=22, OS id=6798
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Thu Jul 12 14:51:33 2018
ALTER DATABASE MOUNT
Thu Jul 12 14:51:33 2018
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/emrepcdb/control02.ctl'
ORA-27048: skgfifi: file header information is invalid
Additional information: 10
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/emrepcdb/control01.ctl'
ORA-27048: skgfifi: file header information is invalid
Additional information: 10
ORA-205 signalled during: ALTER DATABASE MOUNT...
Thu Jul 12 14:51:36 2018
Using default pga_aggregate_limit of 2048 MB
Thu Jul 12 16:54:00 2018
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
Thu Jul 12 16:54:02 2018
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Jul 12 16:54:04 2018
Stopping background process VKTM
Thu Jul 12 16:54:04 2018
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Jul 12 16:54:14 2018
Instance shutdown complete
Thu Jul 12 16:54:57 2018
Starting ORACLE instance (normal) (OS id: 21793)
Thu Jul 12 16:54:57 2018
CLI notifier numLatches:7 maxDescs:519
Thu Jul 12 16:54:57 2018
****************************************************************
Thu Jul 12 16:54:57 2018
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Thu Jul 12 16:54:57 2018
Per process system memlock (soft) limit = 64K
Thu Jul 12 16:54:57 2018
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 2866M
Thu Jul 12 16:54:57 2018
Available system pagesizes:
4K, 2048K
Thu Jul 12 16:54:57 2018
Supported system pagesize(s):
Thu Jul 12 16:54:57 2018
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
Thu Jul 12 16:54:57 2018
4K Configured 4 733188 NONE
Thu Jul 12 16:54:57 2018
2048K 0 1433 0 NONE
Thu Jul 12 16:54:57 2018
RECOMMENDATION:
Thu Jul 12 16:54:57 2018
1. For optimal performance, configure system with expected number
of pages for every supported system pagesize prior to the next
instance restart operation.
Thu Jul 12 16:54:57 2018
2. Increase per process memlock (soft) limit to at least 2866MB
to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
Thu Jul 12 16:54:57 2018
****************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 2
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/12.1.0.2/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1
System name: Linux
Node name: ---hostname---
Release: 4.1.12-37.4.1.el6uek.x86_64
Version: #2 SMP Tue May 17 07:23:38 PDT 2016
Machine: x86_64
Using parameter settings in client-side pfile /tmp/pfile.ora on machine ---hostname---
System parameters with non-default values:
processes = 300
shared_pool_size = 576M
sga_target = 2864M
control_files = "/u01/app/oracle/oradata/emrepcdb/control01.ctl"
db_block_size = 8192
compatible = "12.1.0.2.0"
cluster_database = FALSE
undo_tablespace = "UNDOTBS1"
db_securefile = "PERMITTED"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=emrepcdbXDB)"
session_cached_cursors = 200
parallel_min_servers = 0
parallel_max_servers = 8
audit_file_dest = "/u01/app/oracle/admin/emrepcdb/adump"
audit_trail = "DB"
db_name = "emrepcdb"
open_cursors = 300
pga_aggregate_target = 1000000000
optimizer_adaptive_features= FALSE
diagnostic_dest = "/u01/app/oracle"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Starting background process PMON
Thu Jul 12 16:54:58 2018
PMON started with pid=2, OS id=21875
Starting background process PSP0
Thu Jul 12 16:54:58 2018
PSP0 started with pid=3, OS id=21877
Starting background process VKTM
Thu Jul 12 16:54:59 2018
VKTM started with pid=4, OS id=21879 at elevated (RT) priority
Thu Jul 12 16:54:59 2018
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process GEN0
Thu Jul 12 16:54:59 2018
GEN0 started with pid=5, OS id=21883
Starting background process MMAN
Thu Jul 12 16:54:59 2018
MMAN started with pid=6, OS id=21885
Starting background process DIAG
Thu Jul 12 16:54:59 2018
DIAG started with pid=8, OS id=21889
Starting background process DBRM
Thu Jul 12 16:54:59 2018
DBRM started with pid=9, OS id=21891
Starting background process VKRM
Thu Jul 12 16:54:59 2018
VKRM started with pid=10, OS id=21893
Starting background process DIA0
Starting background process DBW0
Thu Jul 12 16:55:00 2018
DIA0 started with pid=11, OS id=21895
Starting background process LGWR
Thu Jul 12 16:55:00 2018
DBW0 started with pid=12, OS id=21897
Thu Jul 12 16:55:00 2018
LGWR started with pid=13, OS id=21899
Starting background process CKPT
Thu Jul 12 16:55:00 2018
CKPT started with pid=14, OS id=21901
Starting background process SMON
Thu Jul 12 16:55:00 2018
SMON started with pid=16, OS id=21906
Starting background process RECO
Thu Jul 12 16:55:00 2018
RECO started with pid=18, OS id=21910
Starting background process LREG
Thu Jul 12 16:55:00 2018
LREG started with pid=19, OS id=21912
Starting background process PXMN
Thu Jul 12 16:55:00 2018
PXMN started with pid=20, OS id=21914
Starting background process MMON
Thu Jul 12 16:55:00 2018
MMON started with pid=21, OS id=21916
Starting background process MMNL
Thu Jul 12 16:55:00 2018
MMNL started with pid=22, OS id=21918
Thu Jul 12 16:55:00 2018
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Thu Jul 12 16:55:00 2018
ALTER DATABASE MOUNT
Thu Jul 12 16:55:00 2018
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/emrepcdb/control01.ctl'
ORA-27048: skgfifi: file header information is invalid
Additional information: 10
ORA-205 signalled during: ALTER DATABASE MOUNT...
Thu Jul 12 16:55:03 2018
Using default pga_aggregate_limit of 2048 MB
Thu Jul 12 16:56:00 2018
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
Thu Jul 12 16:56:02 2018
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Thu Jul 12 16:56:04 2018
Stopping background process VKTM
Thu Jul 12 16:56:13 2018
Instance shutdown complete
Thu Jul 12 17:00:00 2018
Starting ORACLE instance (normal) (OS id: 22501)
Thu Jul 12 17:00:00 2018
CLI notifier numLatches:7 maxDescs:519
Thu Jul 12 17:00:00 2018
****************************************************************
Thu Jul 12 17:00:00 2018
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Thu Jul 12 17:00:00 2018
Per process system memlock (soft) limit = 64K
Thu Jul 12 17:00:00 2018
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 2866M
Thu Jul 12 17:00:00 2018
Available system pagesizes:
4K, 2048K
Thu Jul 12 17:00:00 2018
Supported system pagesize(s):
Thu Jul 12 17:00:00 2018
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
Thu Jul 12 17:00:00 2018
4K Configured 4 733188 NONE
Thu Jul 12 17:00:00 2018
2048K 0 1433 0 NONE
Thu Jul 12 17:00:00 2018
RECOMMENDATION:
Thu Jul 12 17:00:00 2018
1. For optimal performance, configure system with expected number
of pages for every supported system pagesize prior to the next
instance restart operation.
Thu Jul 12 17:00:00 2018
2. Increase per process memlock (soft) limit to at least 2866MB
to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
Thu Jul 12 17:00:00 2018
****************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 2
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/12.1.0.2/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1
System name: Linux
Node name: ---hostname---
Release: 4.1.12-37.4.1.el6uek.x86_64
Version: #2 SMP Tue May 17 07:23:38 PDT 2016
Machine: x86_64
Using parameter settings in client-side pfile /tmp/pfile.ora on machine ---hostname---
System parameters with non-default values:
processes = 300
shared_pool_size = 576M
sga_target = 2864M
control_files = "/u01/app/oracle/oradata/emrepcdb/control01.ctl"
db_block_size = 8192
compatible = "12.1.0.2.0"
cluster_database = FALSE
undo_tablespace = "UNDOTBS1"
db_securefile = "PERMITTED"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=emrepcdbXDB)"
session_cached_cursors = 200
parallel_min_servers = 0
parallel_max_servers = 8
audit_file_dest = "/u01/app/oracle/admin/emrepcdb/adump"
audit_trail = "DB"
db_name = "emrepcdb"
open_cursors = 300
pga_aggregate_target = 1000000000
optimizer_adaptive_features= FALSE
diagnostic_dest = "/u01/app/oracle"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Starting background process PMON
Thu Jul 12 17:00:00 2018
PMON started with pid=2, OS id=22512
Starting background process PSP0
Thu Jul 12 17:00:00 2018
PSP0 started with pid=3, OS id=22514
Starting background process VKTM
Thu Jul 12 17:00:01 2018
VKTM started with pid=4, OS id=22520 at elevated (RT) priority
Thu Jul 12 17:00:01 2018
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process GEN0
Thu Jul 12 17:00:01 2018
GEN0 started with pid=5, OS id=22524
Starting background process MMAN
Thu Jul 12 17:00:01 2018
MMAN started with pid=6, OS id=22526
Starting background process DIAG
Thu Jul 12 17:00:01 2018
DIAG started with pid=8, OS id=22530
Starting background process DBRM
Thu Jul 12 17:00:01 2018
DBRM started with pid=9, OS id=22532
Starting background process VKRM
Thu Jul 12 17:00:01 2018
VKRM started with pid=10, OS id=22534
Starting background process DIA0
Thu Jul 12 17:00:01 2018
DIA0 started with pid=11, OS id=22536
Starting background process DBW0
Thu Jul 12 17:00:01 2018
DBW0 started with pid=12, OS id=22538
Starting background process LGWR
Thu Jul 12 17:00:01 2018
LGWR started with pid=13, OS id=22540
Starting background process CKPT
Thu Jul 12 17:00:02 2018
CKPT started with pid=14, OS id=22542
Starting background process SMON
Thu Jul 12 17:00:02 2018
SMON started with pid=16, OS id=22546
Starting background process RECO
Thu Jul 12 17:00:02 2018
RECO started with pid=18, OS id=22550
Starting background process LREG
Thu Jul 12 17:00:02 2018
LREG started with pid=19, OS id=22552
Starting background process PXMN
Thu Jul 12 17:00:02 2018
PXMN started with pid=20, OS id=22554
Starting background process MMON
Thu Jul 12 17:00:02 2018
MMON started with pid=21, OS id=22556
Starting background process MMNL
Thu Jul 12 17:00:02 2018
MMNL started with pid=22, OS id=22558
Thu Jul 12 17:00:02 2018
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Thu Jul 12 17:00:02 2018
ALTER DATABASE MOUNT
Thu Jul 12 17:00:02 2018
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/emrepcdb/control01.ctl'
ORA-27048: skgfifi: file header information is invalid
Additional information: 10
ORA-205 signalled during: ALTER DATABASE MOUNT...
Thu Jul 12 17:00:05 2018
Using default pga_aggregate_limit of 2048 MB
Fri Jul 13 09:21:24 2018
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
Fri Jul 13 09:21:26 2018
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Fri Jul 13 09:21:28 2018
Stopping background process VKTM
Fri Jul 13 09:21:38 2018
Instance shutdown complete
Fri Jul 13 09:22:08 2018
Starting ORACLE instance (normal) (OS id: 16510)
Fri Jul 13 09:22:08 2018
CLI notifier numLatches:7 maxDescs:519
Fri Jul 13 09:22:08 2018
****************************************************************
Fri Jul 13 09:22:08 2018
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Fri Jul 13 09:22:08 2018
Per process system memlock (soft) limit = 64K
Fri Jul 13 09:22:08 2018
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 2866M
Fri Jul 13 09:22:08 2018
Available system pagesizes:
4K, 2048K
Fri Jul 13 09:22:08 2018
Supported system pagesize(s):
Fri Jul 13 09:22:08 2018
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
Fri Jul 13 09:22:08 2018
4K Configured 4 733188 NONE
Fri Jul 13 09:22:08 2018
2048K 0 1433 0 NONE
Fri Jul 13 09:22:08 2018
RECOMMENDATION:
Fri Jul 13 09:22:08 2018
1. For optimal performance, configure system with expected number
of pages for every supported system pagesize prior to the next
instance restart operation.
Fri Jul 13 09:22:08 2018
2. Increase per process memlock (soft) limit to at least 2866MB
to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
Fri Jul 13 09:22:08 2018
*******************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 2
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/12.1.0.2/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1
System name: Linux
Node name: ---hostname---
Release: 4.1.12-37.4.1.el6uek.x86_64
Version: #2 SMP Tue May 17 07:23:38 PDT 2016
Machine: x86_64
Using parameter settings in client-side pfile /tmp/pfile.ora on machine ---hostname---
System parameters with non-default values:
processes = 300
shared_pool_size = 576M
sga_target = 2864M
control_files = "/u01/app/oracle/oradata/emrepcdb/control01.ctl"
db_block_size = 8192
compatible = "12.1.0.2.0"
cluster_database = FALSE
undo_tablespace = "UNDOTBS1"
db_securefile = "PERMITTED"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=emrepcdbXDB)"
session_cached_cursors = 200
parallel_min_servers = 0
parallel_max_servers = 8
audit_file_dest = "/u01/app/oracle/admin/emrepcdb/adump"
audit_trail = "DB"
db_name = "emrepcdb"
open_cursors = 300
pga_aggregate_target = 1000000000
optimizer_adaptive_features= FALSE
diagnostic_dest = "/u01/app/oracle"
enable_pluggable_database= TRUE
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Starting background process PMON
Fri Jul 13 09:22:08 2018
PMON started with pid=2, OS id=16593
Starting background process PSP0
Starting background process VKTM
Fri Jul 13 09:22:08 2018
PSP0 started with pid=3, OS id=16595
Fri Jul 13 09:22:09 2018
VKTM started with pid=4, OS id=16597 at elevated (RT) priority
Starting background process GEN0
Fri Jul 13 09:22:09 2018
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Fri Jul 13 09:22:09 2018
GEN0 started with pid=5, OS id=16601
Starting background process MMAN
Fri Jul 13 09:22:09 2018
MMAN started with pid=6, OS id=16603
Starting background process DIAG
Fri Jul 13 09:22:09 2018
DIAG started with pid=8, OS id=16607
Starting background process DBRM
Fri Jul 13 09:22:09 2018
DBRM started with pid=9, OS id=16609
Starting background process VKRM
Fri Jul 13 09:22:09 2018
VKRM started with pid=10, OS id=16611
Starting background process DIA0
Fri Jul 13 09:22:09 2018
DIA0 started with pid=11, OS id=16613
Starting background process DBW0
Fri Jul 13 09:22:09 2018
DBW0 started with pid=12, OS id=16615
Starting background process LGWR
Fri Jul 13 09:22:09 2018
LGWR started with pid=13, OS id=16617
Starting background process CKPT
Fri Jul 13 09:22:09 2018
CKPT started with pid=14, OS id=16619
Starting background process SMON
Fri Jul 13 09:22:09 2018
SMON started with pid=16, OS id=16623
Starting background process RECO
Fri Jul 13 09:22:09 2018
RECO started with pid=18, OS id=16627
Starting background process LREG
Fri Jul 13 09:22:09 2018
LREG started with pid=19, OS id=16629
Starting background process PXMN
Fri Jul 13 09:22:09 2018
PXMN started with pid=20, OS id=16631
Starting background process MMON
Fri Jul 13 09:22:09 2018
MMON started with pid=21, OS id=16633
Starting background process MMNL
Fri Jul 13 09:22:09 2018
MMNL started with pid=22, OS id=16635
Fri Jul 13 09:22:09 2018
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Fri Jul 13 09:22:09 2018
ALTER DATABASE MOUNT
Fri Jul 13 09:22:09 2018
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/emrepcdb/control01.ctl'
ORA-27048: skgfifi: file header information is invalid
Additional information: 10
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Jul 13 09:22:12 2018
Using default pga_aggregate_limit of 2048 MB

 

 

Teşekkürler.

 
Gönderildi : 13/07/2018 13:50

Paylaş: