ÇözümPark'a hoş geldiniz. Oturum Aç | Üye Ol
 
Ana Sayfa Makale Video Forum Resimler Dosyalar Etkinlik Hizmetlerimiz Biz Kimiz

Oracle Veritabanı Yedekten Dönme Sorunu

Son Mesajınız 07-13-2018, 10:50 Defne Deniz tarafından gönderildi. 7 yanıt.
Mesajları Sırala: Önceki Sonraki
  •  07-12-2018, 13:43 533376

    Oracle Veritabanı Yedekten Dönme Sorunu

    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.

     

  •  07-12-2018, 13:57 533378 Cevap 533376

    Cevap : Oracle Veritabanı Yedekten Dönme Sorunu

  •  07-12-2018, 14:15 533380 Cevap 533376

    Cevap : Oracle Veritabanı Yedekten Dönme Sorunu

    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

     

     

  •  07-12-2018, 14:16 533381 Cevap 533378

    Cevap : Oracle Veritabanı Yedekten Dönme Sorunu

    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

  •  07-12-2018, 15:04 533384 Cevap 533381

    Cevap : Oracle Veritabanı Yedekten Dönme Sorunu

    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 Fusion Middleware Expert
    Oracle OCP
    MICROSOFT MCSE
    BEŞİKTAŞ JK : )
  •  07-12-2018, 17:01 533396 Cevap 533384

    Cevap : Oracle Veritabanı Yedekten Dönme Sorunu

    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.

  •  07-13-2018, 9:09 533411 Cevap 533396

    Cevap : Oracle Veritabanı Yedekten Dönme Sorunu

    Selamlar,

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

    Teşekkürler,


    Oracle Fusion Middleware Expert
    Oracle OCP
    MICROSOFT MCSE
    BEŞİKTAŞ JK : )
  •  07-13-2018, 10:50 533418 Cevap 533411

    Cevap : Oracle Veritabanı Yedekten Dönme Sorunu

    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.

RSS haberlerini XML olarak görüntüle