Re: RAC restore on single node

Posted by Roshan on May 31, 2017; 11:55am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RAC-restore-on-single-node-tp2737p2741.html

Extract from alert log when I issue startup nomount

[ora12c@rh-archicom-01 trace]$ tail -f alert_cbs2.log
  undo_retention           = 9000
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=cbsXDB)"
  audit_file_dest          = "/archicom/ora12c/admin/cbs/adump"
  audit_trail              = "DB"
  db_name                  = "cbs"
  open_cursors             = 5000
  pga_aggregate_target     = 0
  diagnostic_dest          = "/archicom/ora12c"
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Wed May 31 16:08:16 2017
WARNING: failed to retrieve DB spfile location (unable to communicate with CRSD/OHASD)
Starting ORACLE instance (normal) (OS id: 11324)
Wed May 31 16:08:16 2017
CLI notifier numLatches:29 maxDescs:3414
Wed May 31 16:08:16 2017
**********************************************************************
Wed May 31 16:08:16 2017
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Wed May 31 16:08:16 2017
 Per process system memlock (soft) limit = 64K
Wed May 31 16:08:16 2017
 Expected per process system memlock (soft) limit to lock
 SHARED GLOBAL AREA (SGA) into memory: 13G
Wed May 31 16:08:16 2017
 Available system pagesizes:
  4K, 2048K
Wed May 31 16:08:16 2017
 Supported system pagesize(s):
Wed May 31 16:08:16 2017
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
Wed May 31 16:08:16 2017
        4K       Configured         3276808         3276808        NONE
Wed May 31 16:08:16 2017
 Reason for not supporting certain system pagesizes:
Wed May 31 16:08:16 2017
  2048K - Dynamic allocate and free memory regions
Wed May 31 16:08:16 2017
RECOMMENDATION:
Wed May 31 16:08:16 2017
 1. Increase per process memlock (soft) limit to at least 13GB
 to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
Wed May 31 16:08:16 2017
**********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 16
Number of processor cores in the system is 16
Number of processor sockets in the system is 2
2017-05-31 16:08:16.776
[unknown process(11324)]CRS-2317:Cannot get local GPnP security keys (wallet).
2017-05-31 16:08:16.776
[unknown process(11324)]CRS-2316:Cannot initialize GPnP, CLSGPNP_ERR (Generic GPnP error).
kggpnpInit: failed to init gpnp
  WARNING: No cluster interconnect has been specified. Depending on
           the communication driver configured Oracle cluster traffic
           may be directed to the public interface of this machine.
           Oracle recommends that RAC clustered databases be configured
           with a private interconnect for enhanced security and
           performance.
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =341
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
NUMA system with 2 nodes detected
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options.
ORACLE_HOME = /archicom/ora12c/product/12.1.0
System name:    Linux
Node name:      rh-archicom-01.mtg.local
Release:        3.10.0-327.el7.x86_64
Version:        #1 SMP Thu Oct 29 17:29:29 EDT 2015
Machine:        x86_64
Using parameter settings in server-side pfile /archicom/ora12c/product/12.1.0/dbs/initcbs2.ora
System parameters with non-default values:
  processes                = 2048
  sessions                 = 3104
  event                    = "28401 TRACE NAME CONTEXT FOREVER, LEVEL 1"
  sga_max_size             = 12800M
  sga_target               = 0
  memory_target            = 12800M
  memory_max_target        = 12800M
  control_files            = "/archicom/ora12c/oradata/control01.ctl"
  control_files            = "/home/ora12c/control02.ctl"
  control_file_record_keep_time= 30
  db_block_size            = 16384
  compatible               = "12.1.0.2.0"
  log_archive_format       = "%t_%s_%r.arc"
  db_files                 = 1024
  cluster_database         = FALSE
  db_recovery_file_dest    = "/archicom/ora12c/oradata"
  db_recovery_file_dest_size= 200G
  undo_tablespace          = "UNDOTBS1"
  undo_retention           = 9000
  remote_login_passwordfile= "EXCLUSIVE"
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=cbsXDB)"
  audit_file_dest          = "/archicom/ora12c/admin/cbs/adump"
  audit_trail              = "DB"
  db_name                  = "cbs"
  open_cursors             = 5000
  pga_aggregate_target     = 0
  diagnostic_dest          = "/archicom/ora12c"
NOTE: remote asm mode is local (mode 0x1; from cluster type)