10.94.140.46 DB DROP

[]@ndc3vpaoemdb01:/home/oracle >
[]@ndc3vpaoemdb01:/home/oracle > ssh 10.94.140.46
Last unsuccessful login: Wed Apr 5 05:04:58 IST 2023 on ssh from 10.93.6.39
Last login: Fri Nov 29 06:30:41 IST 2024 on ssh from 10.94.141.87
###############################################################################
# #
# "This is an Vodafone Idea Ltd system and is meant for official use by #
# authorized users. #
# #
# Accessing and using this system constitutes consent to monitoring, interce #
# ption, retrieval,recording, reading, copying, searching or capturing and #
# disclosure of any information as to any information processed,stored or ma #
# nipulated within the system, including but not limited to information stor #
# ed locally on the hard drive or other media in use with this unit internal #
# ly or externally (e.g., floppy disks, tapes, CD-ROMs, PDA.s etc.) by the #
# company management or law enforcement agencies. #
# #
# Unauthorized or improper use of this system may lead to prosecution result #
# ing in disciplinary, criminal or civil penalties.Suspected access violatio #
# ns or breach of security policy should be reported to Account security #
# SPOC." #
# #
###############################################################################
You are logged :- oracle pts/0 Nov 29 23:53 (10.94.141.87) at Fri Nov 29 23:53:34
IST 2024
oratab file /etc/oratab found.
Alias for CXODBCG1 environment variables is set to CXODBCG1

Alias for ALT_DB_HOME environment variables is set to ALT_DB_HOME
Alias for +ASM environment variables is set to ASM
oracle 14549462 1 0 Sep 16 - 6:55

/grid_upgrade/oracle/Grid12CHome/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 15139170 1 0 Sep 16 - 12:37 ora_pmon_CXODBCG1
oracle 15728958 1 0 Sep 16 - 5:06 asm_pmon_+ASM
oracle 35783032 1 0 Sep 16 - 15:46
/oracle_upgrade/oracle/ora_base/Ora12CHome/bin/tnslsnr MARS_P -inherit
[]@cxopcog1:/home/oracle > ASM

ORACLE_SID is set to :- +ASM
ORACLE_HOME is set to :- /grid_upgrade/oracle/Grid12CHome
[+ASM]@cxopcog1:/home/oracle > uname -a
AIX cxopcog1 2 7 00CFCAD74C00
[+ASM]@cxopcog1:/home/oracle > sqlplus -V
SQL*Plus: Release 12.2.0.1.0 Production
[+ASM]@cxopcog1:/home/oracle > hostname

cxopcog1
[+ASM]@cxopcog1:/home/oracle > ifconfig -a
en0:
flags=1e084863,814c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BI
T,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 10.94.140.46 netmask 0xfffffc00 broadcast 10.94.143.255
tcp_sendspace 262144 tcp_recvspace 262144 rfc1323 1
lo0:
flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARG
ESEND,CHAIN>
inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
inet6 ::1%1/64
tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
[+ASM]@cxopcog1:/home/oracle > cat /etc/hosts
# @(#)47 1.2.1.1 src/bos/usr/sbin/netstart/hosts, cmdnet, bos720 7/14/11
20:16:59
# IBM_PROLOG_BEGIN_TAG
# This is an automatically generated prolog.
#
# bos720 src/bos/usr/sbin/netstart/hosts 1.2.1.1
#
# Licensed Materials - Property of IBM
#
# COPYRIGHT International Business Machines Corp. 1985,1989
# All Rights Reserved
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# IBM_PROLOG_END_TAG
#
# COMPONENT_NAME: TCPIP hosts
#
# FUNCTIONS: loopback
#
# ORIGINS: 26 27
#
# (C) COPYRIGHT International Business Machines Corp. 1985, 1989
# All Rights Reserved
# Licensed Materials - Property of IBM
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# /etc/hosts
#
# This file contains the hostnames and their address for hosts in the
# network. This file is used to resolve a hostname into an Internet
# address.
#
# At minimum, this file must contain the name and address for each
# device defined for TCP in your /etc/net file. It may also contain
# entries for well-known (reserved) names such as timeserver
# and printserver as well as any other host name and address.
#
# The format of this file is:
# Internet Address Hostname # Comments
# Internet Address can be either IPv4 or IPv6 address.
# Items are separated by any number of blanks and/or tabs. A '#'
# indicates the beginning of a comment; characters up to the end of the
# line are not interpreted by routines which search this file. Blank
# lines are allowed.
# Internet Address Hostname # Comments

# 192.9.200.1 net0sample # ethernet name/address
# 128.100.0.1 token0sample # token ring name/address
# 10.2.0.2 x25sample # x.25 name/address
# 2000:1:1:1:209:6bff:feee:2b7f ipv6sample # ipv6 name/address
127.0.0.1 loopback localhost # loopback (lo0) name/address
10.94.140.46 cxopcog1
10.87.138.142 INMUMNTP01.vodafone.in
10.87.32.58 INKARNTP02.vodafone.in
10.87.205.60 Nim_master
10.87.148.72 nbumaster2
10.87.148.237 nbumedia3
10.87.148.238 nbumedia4
10.87.149.218 nbumedia5
10.87.148.73 bcvsrv2
10.87.148.74 bcvsrv3
10.87.148.75 bcvsrv4
10.87.148.119 UPSSZ3BCV
10.87.165.65 cPOSZ4BCV
10.87.245.23 AIX712
10.87.205.55 Nim41A_master
10.87.205.56 Nim51_master
10.87.226.92 NDCS5N1-New
10.87.228.32 Nim41B_master
10.87.226.49 oemcloudha
10.87.226.94 OEMEXA
10.87.148.73 bcvsrv2
10.87.148.74 bcvsrv3
10.87.148.75 bcvsrv4
10.87.149.29 bcvsrv5
10.87.148.119 UPSSZ3BCV
10.87.164.91 UPSSZ4BCV
10.87.148.64 cPOSZ2BCV
10.87.164.253 cPOSZ3BCV
10.87.165.65 cPOSZ4BCV
10.87.165.91 cposBCV
10.87.148.237 nbumedia3
10.87.148.238 nbumedia4
10.87.148.236 nbumaster2-standby
10.87.148.72 nbumaster2
10.87.149.218 nbumedia5
10.87.150.212 71tl3sp5
10.87.150.60 INDIACUG
#10.87.150.213 CXOPCOG1
10.87.149.201 teradeta
********************************
10.94.141.35 netizzapd02
10.94.140.207 netizzapd03
10.87.228.35 POCBufferDB2
10.94.1.162 ITAMbcn.vodafone.co.in
10.94.0.70 NDC3LAIPNIM01
10.94.0.65 NDC3LAIPMAST01
10.94.0.66 NDC3LAIPMEDIA01
10.94.136.67 ndc3r3l2nbmed02
10.94.0.89 NETBOPS1
10.94.32.11 NDC3LAITNIM01
10.94.108.24 NDC3CWNPTEMP01.internal.vodafone.com
10.94.108.25 NDC3CWNPTEMS01.internal.vodafone.com
10.94.0.71 NDC3LAIPOEM01
10.87.132.51 Nim132_Master
10.94.108.25 NDC3CWNPTEMS01.inroot.in
10.94.108.24 NDC3CWNPTEMP01.inroot.in
10.94.104.166 NDC3CLNPTEMR01
10.94.104.167 NDC3CLNPTEMR02
10.94.104.168 NDC3CLNPTEMR03
10.94.104.169 NDC3CLNPTEMR04
10.94.104.170 NDC3CLNPTEMR05
10.94.104.171 NDC3CLNPTEMR06
10.94.104.172 NDC3CLNPTEMR07
10.94.104.173 NDC3CLNPTEMR08
10.94.104.174 NDC3CLNPTEMR09
10.94.140.116 ndc3vpaispbcv
10.94.160.74 NDC3VLNPTEMRAP01
10.87.210.59 nzmako
10.94.49.55 nzanalytics
10.87.224.122 nzedw
################################## Added on Request of Backup Team

############################
10.94.0.65 NDC3LAIPMAST01
10.94.0.66 NDC3LAIPMEDIA01
10.94.136.67 ndc3r3l2nbmed02
10.94.140.99 ndc3r3l2nbbcv03
10.94.140.116 ndc3vpaispbcv
10.94.140.184 delbcv
10.94.140.106 bcvsrv9
10.94.0.68 NDC3LAIPBCV01
10.94.31.245 ndc33plnbcvdb09
10.94.141.112 ndc3vpaimisbcv2
10.94.136.67 ndc3r3l2nbmed02
10.94.136.64 ndc3r3l2nbbcv02
10.94.141.54 ndc3vpaiicrbcv
10.94.141.75 ndc3vpaicpsbcv1
10.94.0.87 NDC3LAIPMVADB
10.94.48.32 NDC3LAIPEKYC01
###################################################################################
##############
10.94.136.11 ndc3vpaiappnim
10.94.140.11 ndc3vpaidbnim
10.94.134.11 ndc3vqtestnim
10.94.32.47 vilictprd8d
10.94.0.89 NETBOPS1
10.94.32.47 vilictprd8d
10.94.0.89 NETBOPS1
::1 loopback localhost # IPv6 loopback (lo0) name/address
[+ASM]@cxopcog1:/home/oracle > no -a
arpqsize = 1024
arpt_killc = 20
arptab_bsiz = 7
arptab_nb = 149
bcastping = 0
bsd_loglevel = 3
cached_routes = 0
clean_partial_conns = 1
delayack = 0
delayackports = {}
dgd_flush_cached_route = 0
dgd_packets_lost = 3
dgd_ping_time = 5
dgd_retry_time = 5
directed_broadcast = 0
dmxperf = 0
fasttimo = 200
hstcp = 0
icmp6_errmsg_rate = 10
icmpaddressmask = 0
icmptimestamp = 1
ie5_old_multicast_mapping = 0
ifsize = 256
ifstats32 = 0
igmpv2_deliver = 0
init_high_wat = 0
ip6_defttl = 64
ip6_prune = 1
ip6forwarding = 0
ip6srcrouteforward = 0
ip_ifdelete_no_retrans = 0
ip_ifdelete_notify = 0
ip_nfrag = 200
ipforwarding = 0
ipfragttl = 2
ipignoreredirects = 1
ipoutqueues = 0
ipqmaxlen = 100
ipsendredirects = 0
ipsrcrouteforward = 0
ipsrcrouterecv = 0
ipsrcroutesend = 0
limited_ss = 0
llsleep_timeout = 3
lo_perf = 1
lowthresh = 90
main_if6 = 0
main_site6 = 0
maxnip6q = 20
maxttl = 255
medthresh = 95
mpr_policy = 1
multi_homed = 1
nbc_limit = 12582912
nbc_max_cache = 131072
nbc_min_cache = 1
nbc_ofile_hashsz = 12841
nbc_pseg = 0
nbc_pseg_limit = 25165824
ndd_event_name = {all}
ndd_event_tracing = 0
ndogthreads = 0
ndp_mmaxtries = 3
ndp_umaxtries = 3
ndpqsize = 50
ndpt_down = 3
ndpt_keep = 120
ndpt_probe = 5
ndpt_reachable = 30
ndpt_retrans = 1
net_buf_size = {all}
net_buf_type = {all}
net_malloc_frag_mask = {0}
netm_page_promote = 1
nonlocsrcroute = 0
nstrpush = 8
passive_dgd = 0
pmtu_default_age = 10
pmtu_expire = 10
pmtu_rediscover_interval = 30
psebufcalls = 20
psecache = 1
psetimers = 20
rfc1122addrchk = 0
rfc1323 = 1
rfc2414 = 1
route_expire = 1
routerevalidate = 0
rtentry_lock_complex = 1
rto_high = 64
rto_length = 13
rto_limit = 7
rto_low = 1
rtpool_size = 25
sack = 0
sb_max = 1048576
send_file_duration = 300
site6_index = 0
sockthresh = 60
sodebug = 0
sodebug_env = 0
somaxconn = 1024
soreuseport_lb = 0
strctlsz = 1024
strmsgsz = 0
strthresh = 85
strturncnt = 15
subnetsarelocal = 1
tcp_bad_port_limit = 0
tcp_cwnd_modified = 0
tcp_ecn = 0
tcp_ephemeral_high = 65535
tcp_ephemeral_low = 32768
tcp_fastlo = 0
tcp_fastlo_crosswpar = 0
tcp_finwait2 = 1200
tcp_icmpsecure = 0
tcp_init_window = 0
tcp_inpcb_hashtab_siz = 24499
tcp_keepcnt = 8
tcp_keepidle = 14400
tcp_keepinit = 150
tcp_keepintvl = 150
tcp_limited_transmit = 1
tcp_low_rto = 0
tcp_maxburst = 0
tcp_maxqueuelen = 0
tcp_mssdflt = 1448
tcp_nagle_limit = 65535
tcp_nagleoverride = 0
tcp_ndebug = 100
tcp_newreno = 1
tcp_nodelayack = 0
tcp_pmtu_discover = 0
tcp_recvspace = 262144
tcp_sendspace = 262144
tcp_syn_rto = 0
tcp_tcpsecure = 7
tcp_timewait = 1
tcp_ttl = 60
tcprexmtthresh = 3
tcptr_enable = 0
thewall = 50331648
timer_wheel_tick = 0
tn_filter = 1
udp_bad_port_limit = 0
udp_ephemeral_high = 65535
udp_ephemeral_low = 32768
udp_inpcb_hashtab_siz = 24499
udp_pmtu_discover = 0
udp_recv_perf = 0
udp_recvspace = 42080
udp_send_perf = 0
udp_sendspace = 9216
udp_ttl = 30
udpcksum = 1
use_sndbufpool = 1
[+ASM]@cxopcog1:/home/oracle > netstat -in
Name Mtu Network Address Ipkts Ierrs Opkts
Oerrs Coll
en0 1500 link#2 fa.be.54.7f.35.20 1377683159 0 785947214
0 0
en0 1500 10.94.140 10.94.140.46 1377683159 0 785947214
0 0
lo0 16896 link#1 1008552657 0 1008552657
0 0
lo0 16896 127 127.0.0.1 1008552657 0 1008552657
0 0
lo0 16896 ::1%1 1008552657 0 1008552657
0 0
[+ASM]@cxopcog1:/home/oracle >
[+ASM]@cxopcog1:/home/oracle > ps -ef|grep -i pmon
oracle 37093758 38076904 0 23:54:10 pts/0 0:00 grep -i pmon
[+ASM]@cxopcog1:/home/oracle > ps -ef|grep -i tns
oracle 14549462 1 0 Sep 16 - 6:55
/grid_upgrade/oracle/Grid12CHome/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 35783032 1 0 Sep 16 - 15:46
/oracle_upgrade/oracle/ora_base/Ora12CHome/bin/tnslsnr MARS_P -inherit
oracle 37093760 38076904 0 23:54:10 pts/0 0:00 grep -i tns
[+ASM]@cxopcog1:/home/oracle > ps -ef|grep -i agent
root 6422798 7012704 0 Sep 16 - 0:00 /opt/ds_agent/ds_agent -b -i -
w /var/opt/ds_agent -e /opt/ds_agent/ext
root 8388898 6422798 2 Sep 16 - 53435:51 /opt/ds_agent/ds_agent -b -
i -w /var/opt/ds_agent -e /opt/ds_agent/ext
root 10158404 1 0 Sep 16 - 8:52
/opt/IBM/ITM/aix526/ul/bin/kulagent
root 11731226 11862388 0 Sep 16 - 1062:49 /opt/ds_agent/ds_am -g
../diag -v 5 -d /var/opt/ds_agent/am -P 4
root 11862388 1 0 Sep 16 - 0:00 /opt/ds_agent/ds_am -g ../diag
-v 5 -d /var/opt/ds_agent/am -P 4
oracle 12059002 1 0 Sep 16 - 14:31
/agent13c/agent13base/agent_13.2.0.0.0/perl/bin/perl
/agent13c/agent13base/agent_13.2.0.0.0/bin/emwd.pl agent
/agent13c/agent13c/sysman/log/emagent.nohup
root 12321116 1 0 Sep 16 - 6362:30
/opt/IBM/ITM/aix526/ux/bin/kuxagent
oracle 12976550 12059002 2 Sep 16 - 5107:27
/agent13c/agent13base/agent_13.2.0.0.0/oracle_common/jdk/bin/java -Xmx160M -server
-Djava.security.egd=file:///dev/./urandom -
Dsun.lang.ClassLoader.allowArraySyntax=true -Xgcpolicy:gencon -
Dwatchdog.pid=12059002 -cp
/agent13c/agent13base/agent_13.2.0.0.0/jdbc/lib/ojdbc7.jar:/agent13c/agent13base/
agent_13.2.0.0.0/ucp/lib/ucp.jar:/agent13c/agent13base/agent_13.2.0.0.0/
oracle_common/modules/jsch-0.1.53.jar:/agent13c/agent13base/agent_13.2.0.0.0/
oracle_common/modules/com.oracle.http_client.http_client_12.1.3.jar:/agent13c/
agent13base/agent_13.2.0.0.0/oracle_common/modules/oracle.xdk_12.1.3/
xmlparserv2.jar:/agent13c/agent13base/agent_13.2.0.0.0/oracle_common/modules/
oracle.dms_12.1.3/dms.jar:/agent13c/agent13base/agent_13.2.0.0.0/oracle_common/
modules/oracle.odl_12.1.3/ojdl.jar:/agent13c/agent13base/agent_13.2.0.0.0/
oracle_common/modules/oracle.odl_12.1.3/ojdl2.jar:/agent13c/agent13base/
agent_13.2.0.0.0/lib/optic.jar:/agent13c/agent13base/agent_13.2.0.0.0/sysman/jlib/
log4j-core.jar:/agent13c/agent13base/agent_13.2.0.0.0/jlib/gcagent_core.jar:/
agent13c/agent13base/agent_13.2.0.0.0/sysman/jlib/emagentSDK-intg.jar:/agent13c/
agent13base/agent_13.2.0.0.0/sysman/jlib/emagentSDK.jar
oracle.sysman.gcagent.tmmain.TMMain
oracle 15204752 1 0 Sep 16 - 222:54
/grid_upgrade/oracle/Grid12CHome/bin/cssdagent
oracle 15466982 1 0 Sep 16 - 2054:05
/grid_upgrade/oracle/Grid12CHome/bin/oraagent.bin
oracle 37093762 38076904 0 23:54:10 pts/0 0:00 grep -i agent
root 56885682 1 0 May 09 - 382:22
/opt/IBM/ITM/aix526/lo/bin/kloagent cxopcog1_lfa-logstash
root 66978190 1 0 Apr 09 - 445:22
/opt/IBM/ITM/aix526/lo/bin/kloagent cxopcog1_aix-errpt
[+ASM]@cxopcog1:/home/oracle > ps -ef|grep -i oem
oracle 37093764 38076904 0 23:54:10 pts/0 0:00 grep -i oem
[+ASM]@cxopcog1:/home/oracle > ps -ef|grep -i d.bin
oracle 11010488 1 0 Sep 16 - 310:10
/grid_upgrade/oracle/Grid12CHome/bin/ohasd.bin reboot
oracle 13566286 1 0 Sep 16 - 137:36
/grid_upgrade/oracle/Grid12CHome/bin/ocssd.bin
oracle 14483952 1 0 Sep 16 - 134:36
/grid_upgrade/oracle/Grid12CHome/bin/evmd.bin
oracle 40894862 38076904 0 23:54:10 pts/0 0:00 grep -i d.bin
[+ASM]@cxopcog1:/home/oracle > ps -ef |grep -i mgr
oracle 65339860 38076904 0 23:54:10 pts/0 0:00 grep -i mgr
[+ASM]@cxopcog1:/home/oracle >
[+ASM]@cxopcog1:/home/oracle > crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_CXODBCG1_ARCH.dg
ONLINE ONLINE cxopcog1 STABLE
ora.DG_CXODBCG1_DATA.dg
ora.DG_CXODBCG1_REDOCTL01.dg
ora.LISTENER.lsnr
ora.asm
ONLINE ONLINE cxopcog1 Started,STABLE
ora.ons
OFFLINE OFFLINE cxopcog1 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE cxopcog1 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE cxopcog1 STABLE
--------------------------------------------------------------------------------
[+ASM]@cxopcog1:/home/oracle > lsnrctl status LISTENER
LSNRCTL for IBM/AIX RISC System/6000: Version 12.2.0.1.0 - Production on 29-NOV-

2024 23:54:26
Copyright (c) 1991, 2017, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 12.2.0.1.0
- Production
Start Date 16-SEP-2023 03:47:10
Uptime 440 days 20 hr. 7 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/grid_upgrade/oracle/Grid12CHome/network/admin/listener.ora
Listener Log File
/grid_upgrade/oracle/diag/tnslsnr/cxopcog1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cxopcog1)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DG_CXODBCG1_ARCH" has 1 instance(s).
Service "+ASM_DG_CXODBCG1_DATA" has 1 instance(s).
Service "+ASM_DG_CXODBCG1_REDOCTL01" has 1 instance(s).
The command completed successfully
[+ASM]@cxopcog1:/home/oracle > lsnrctl stop LISTENER

2024 23:54:31
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
[+ASM]@cxopcog1:/home/oracle > df -gt
Filesystem GB blocks Used Free %Used Mounted on
/dev/hd4 11.00 6.27 4.73 58% /
/dev/hd2 15.50 6.82 8.68 45% /usr
/dev/hd9var 10.00 2.03 7.97 21% /var
/dev/hd3 14.50 0.16 14.34 2% /tmp
/dev/hd1 7.50 4.74 2.76 64% /home
/dev/hd11admin 0.50 0.00 0.50 1% /admin
/proc - - - - /proc
/dev/hd10opt 4.50 2.76 1.74 62% /opt
/dev/livedump 0.50 0.00 0.50 1% /var/adm/ras/livedump
/dev/data02 540.00 293.91 246.09 55% /data02
/dev/data03 540.00 163.13 376.87 31% /data03
/dev/Grid_12g 100.00 37.97 62.03 38% /grid_12c
/dev/usropenv 15.00 3.32 11.68 23% /usr/openv
/dev/oracle 100.00 39.78 60.22 40% /oracle
/dev/archive 200.00 24.31 175.69 13% /archive
/dev/agent12c 10.00 0.04 9.96 1% /agent12c
/dev/agent13c 10.00 2.99 7.01 30% /agent13c
/dev/oracleadmdmp 90.00 29.90 60.10 34% /oracleadmindump
/dev/orcl_upgrd_lv 150.00 31.09 118.91 21% /oracle_upgrade
/dev/grid_upgrd_lv 150.00 20.64 129.36 14% /grid_upgrade
/dev/rman_bkp_lv 100.00 24.44 75.56 25% /RMAN_backup
/dev/Grid19C_LV 140.00 0.02 139.98 1% /grid_19c
/dev/19C_binary_LV 140.00 0.02 139.98 1% /oracle_19c
[+ASM]@cxopcog1:/home/oracle > cd /archive
[+ASM]@cxopcog1:/archive > mkdir DB_DROP_2024
[+ASM]@cxopcog1:/archive > cd DB_DROP_2024
[+ASM]@cxopcog1:/archive/DB_DROP_2024 > pwd
/archive/DB_DROP_2024
[+ASM]@cxopcog1:/archive/DB_DROP_2024 > cd
[+ASM]@cxopcog1:/home/oracle > cd scripts
[+ASM]@cxopcog1:/home/oracle/scripts >
[+ASM]@cxopcog1:/home/oracle/scripts > sqlplus / as sysasm
SQL*Plus: Release 12.2.0.1.0 Production on Fri Nov 29 23:55:00 2024

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> @asm_dg
GROUP_NUMBER NAME STATE TYPE TOTAL_MB

FREE_MB OFFLINE_DISKS
------------ ------------------------------ ----------- ------ ----------
---------- -------------
1 DG_CXODBCG1_DATA MOUNTED EXTERN 267924
122320 0
2 DG_CXODBCG1_REDOCTL01 MOUNTED EXTERN 49152
48075 0
48075 0
48089 0
5 DG_CXODBCG1_ARCH MOUNTED EXTERN 204800
204747 0
SQL> @asm_disk
GROUP_NUMBER DISK_NUMBER NAME MOUNT_S HEADER_STATU MODE_ST

STATE TOTAL_MB FREE_MB PATH OS_MB
------------ ----------- --------------------------- ------- ------------ -------
-------- ---------- ---------- ---------------------------------------- ----------
0 0 CLOSED CANDIDATE ONLINE
NORMAL 0 0 /dev/cxopcog1_cxodbcg1_ASM_02 267926
1 0 DG_CXODBCG1_DATA_0000 CACHED MEMBER ONLINE
NORMAL 267924 122320 /dev/cxopcog1_cxodbcg1_ASM_01 267926
2 0 DG_CXODBCG1_REDOCTL01_0000 CACHED MEMBER ONLINE
NORMAL 49152 48075 /dev/cxopcog1_cxodbcg1_ASM_redoctl01 49152
5 0 DG_CXODBCG1_ARCH_0000 CACHED MEMBER ONLINE
NORMAL 204800 204747 /dev/cxopcog1_cxodbcg1_ASM_hdisk16 204800
6 rows selected.
SQL> show parameter spfile;
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
spfile string /grid_12c/app/product/grid_hom
e/dbs/spfile+ASM.ora
SQL>
SQL> create pfile='/archive/DROP_DB_2024/initasm_1.ora' from spfile;
create pfile='/archive/DROP_DB_2024/initasm_1.ora' from spfile
*
ERROR at line 1:
ORA-07391: sftopn: fopen error, unable to open text file.
SQL> create pfile='/archive/DB_DROP_2024/initasm_1.ora' from spfile;

File created.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
[+ASM]@cxopcog1:/home/oracle/scripts > ps -ef | grep pmon
[+ASM]@cxopcog1:/home/oracle/scripts > CXODBCG1
ORACLE_SID is set to :- CXODBCG1
ORACLE_HOME is set to :- /oracle_upgrade/oracle/ora_base/Ora12CHome
[CXODBCG1]@cxopcog1:/home/oracle/scripts > lsnrctl status MARS_P

2024 23:56:21
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.94.140.46)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias MARS_P
Version TNSLSNR for IBM/AIX RISC System/6000: Version 12.2.0.1.0
- Production
Start Date 16-SEP-2023 04:36:29
Uptime 440 days 19 hr. 19 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/oracle_upgrade/oracle/ora_base/Ora12CHome/network/admin/listener.ora
Listener Log File
/oracle_upgrade/oracle/diag/tnslsnr/cxopcog1/mars_p/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.94.140.46)(PORT=1526)))
Services Summary...
Service "CXODBCG1" has 2 instance(s).
Instance "CXODBCG1", status UNKNOWN, has 1 handler(s) for this service...
Instance "CXODBCG1", status READY, has 1 handler(s) for this service...
Service "CXODBCG1XDB" has 1 instance(s).
Instance "CXODBCG1", status READY, has 1 handler(s) for this service...
[CXODBCG1]@cxopcog1:/home/oracle/scripts > lsnrctl stop MARS_P

2024 23:56:34
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.94.140.46)(PORT=1526)))
[CXODBCG1]@cxopcog1:/home/oracle/scripts > sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Nov 29 23:56:42 2024
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> @name
SP2-0310: unable to open file "name.sql"
SQL> @au
Enter value for username:
INST_ID DB User Logon Time Status SESS Program OS

User Terminal Machine Name EVENT MINS
SQL_ID
---------- -------------- -------------- ---------- ------------ ---------------
---------- ------------ --------------- ------------------------------ ----------
-------------
1 SYS 23:56 Nov/29 Active 1410,2709 SQLPLUS@CXOPCOG
oracle pts/0 Cxopcog1 SQL*Net message to 0
fz9y0ru0nsszw
1 SYS 04:30 Sep/16 Active 385,29872 ORACLE@CXOPCOG1
oracle UNKNOWN Cxopcog1 OFS idle 634766
2 rows selected.
SQL>
set pagesize 0
set lines 300
col name for a40
col value for a90
select name,value from v$parameter where name not like '\_%' escape '\' union
(select name,value from v$parameter where substr(name, 0,1) ='_');
create table PARAMETER_NOV__2024 as (select name,value from v$parameter where name
not like '\_%' escape '\' ) union (select name,value from v$parameter where
substr(name, 0,1) ='_');SQL> SQL> SQL> SQL> SQL> DBFIPS_140
FALSE
O7_DICTIONARY_ACCESSIBILITY FALSE
_system_trig_enabled TRUE
_upgrade_capture_noops FALSE
_upgrade_optim FALSE
active_instance_count
allow_global_dblinks FALSE
allow_group_access_to_sga FALSE
approx_for_aggregation FALSE
approx_for_count_distinct FALSE
approx_for_percentile none
aq_tm_processes 1
archive_lag_target 0
asm_diskgroups
asm_diskstring
asm_io_processes 20
asm_power_limit 1
asm_preferred_read_failure_groups
audit_file_dest /oracle/app/DIAG/adump
audit_sys_operations TRUE
audit_syslog_level
audit_trail DB
autotask_max_active_pdbs 2
awr_pdb_autoflush_enabled FALSE
awr_snapshot_time_offset 0
background_core_dump partial
background_dump_dest
/oracle_upgrade/oracle/ora_base/Ora12CHome/rdbms/log
backup_tape_io_slaves FALSE
bitmap_merge_area_size 1048576
blank_trimming FALSE
buffer_pool_keep
buffer_pool_recycle
cdb_cluster FALSE
cdb_cluster_name CXODBCG1
cell_offload_compaction ADAPTIVE
cell_offload_decryption TRUE
cell_offload_parameters
cell_offload_plan_display AUTO
cell_offload_processing TRUE
cell_offloadgroup_name
circuits
client_result_cache_lag 3000
client_result_cache_size 0
clonedb FALSE
clonedb_dir
cluster_database FALSE
cluster_database_instances 1
cluster_interconnects
commit_logging
commit_point_strength 1
commit_wait
commit_write
common_user_prefix C##
compatible 11.2.0.0.0
connection_brokers ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
containers_parallel_degree 65535
control_file_record_keep_time 7
control_files
+DG_CXODBCG1_REDOCTL01/CXODBCG1/CONTROLFILE/current.256.963087899,
+DG_CXODBCG1_REDOCTL02/
CXODBCG1/CONTROLFILE/current.256.963087899
control_management_pack_access DIAGNOSTIC+TUNING
core_dump_dest
/oracle/app/DIAG/diag/rdbms/cxodbcg1/CXODBCG1/cdump
cpu_count 48
create_bitmap_area_size 8388608
create_stored_outlines
cursor_bind_capture_destination memory+disk
cursor_invalidation IMMEDIATE
cursor_sharing EXACT
cursor_space_for_time FALSE
data_guard_sync_latency 0
data_transfer_cache_size 0
db_16k_cache_size 0
db_2k_cache_size 0
db_32k_cache_size 0
db_4k_cache_size 0
db_8k_cache_size 0
db_big_table_cache_percent_target 0
db_block_buffers 0
db_block_checking FALSE
db_block_checksum TYPICAL
db_block_size 8192
db_cache_advice ON
db_cache_size 0
db_create_file_dest
db_create_online_log_dest_1 +DG_CXODBCG1_REDOCTL01
db_create_online_log_dest_4
db_create_online_log_dest_5
db_domain
db_file_multiblock_read_count 128
db_file_name_convert
db_files 1000
db_flash_cache_file
db_flash_cache_size 0
db_flashback_retention_target 1440
db_index_compression_inheritance NONE
db_keep_cache_size 0
db_lost_write_protect NONE
db_name CXODBCG1
db_performance_profile
db_recovery_file_dest /archive/CXODBCG1/FRA
db_recovery_file_dest_size 107374182400
db_recycle_cache_size 0
db_securefile PERMITTED
db_ultra_safe OFF
db_unique_name CXODBCG1
db_unrecoverable_scn_tracking TRUE
db_writer_processes 6
dbwr_io_slaves 0
ddl_lock_timeout 0
default_sharing metadata
deferred_segment_creation TRUE
dg_broker_config_file1
/oracle_upgrade/oracle/ora_base/Ora12CHome/dbs/dr1CXODBCG1.dat
dg_broker_config_file2
/oracle_upgrade/oracle/ora_base/Ora12CHome/dbs/dr2CXODBCG1.dat
dg_broker_start FALSE
diagnostic_dest /oracle/app/DIAG/
disable_pdb_feature 0
disk_asynch_io TRUE
dispatchers (PROTOCOL=TCP) (SERVICE=CXODBCG1XDB)
distributed_lock_timeout 60
dml_locks 6756
dnfs_batch_size 4096
dst_upgrade_insert_conv TRUE
enable_automatic_maintenance_pdb TRUE
enable_ddl_logging FALSE
enable_dnfs_dispatcher FALSE
enable_goldengate_replication FALSE
enable_pluggable_database FALSE
enabled_PDBs_on_standby *
encrypt_new_tablespaces CLOUD_ONLY
event
exafusion_enabled 1
external_keystore_credential_location
fal_client
fal_server
fast_start_io_target 0
fast_start_mttr_target 300
fast_start_parallel_rollback LOW
file_mapping FALSE
fileio_network_adapters
filesystemio_options asynch
fixed_date
gcs_server_processes 0
global_names FALSE
global_txn_processes 1
hash_area_size 131072
heat_map OFF
hi_shared_memory_address 0
hs_autoregister TRUE
ifile
inmemory_adg_enabled TRUE
inmemory_clause_default
inmemory_expressions_usage ENABLE
inmemory_force DEFAULT
inmemory_max_populate_servers 0
inmemory_query ENABLE
inmemory_size 0
inmemory_trickle_repopulate_servers_perc 1
ent
inmemory_virtual_columns MANUAL
instance_abort_delay_time 0
instance_groups
instance_mode READ-WRITE
instance_name CXODBCG1
instance_number 0
instance_type RDBMS
instant_restore FALSE
java_jit_enabled TRUE
java_max_sessionspace_size 0
java_pool_size 0
java_restrict none
java_soft_sessionspace_limit 0
job_queue_processes 10
large_pool_size 0
ldap_directory_access NONE
ldap_directory_sysauth no
license_max_sessions 0
license_max_users 0
license_sessions_warning 0
listener_networks
local_listener (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=10.94.140.46)(PORT=1526)))
lock_name_space
lock_sga FALSE
log_archive_config
log_archive_dest
log_archive_dest_1 LOCATION=/archive/CXODBCG1/ARCH
log_archive_dest_10
log_archive_dest_11
log_archive_dest_12
log_archive_dest_13
log_archive_dest_14
log_archive_dest_15
log_archive_dest_16
log_archive_dest_17
log_archive_dest_18
log_archive_dest_19
log_archive_dest_2
log_archive_dest_20
log_archive_dest_21
log_archive_dest_22
log_archive_dest_23
log_archive_dest_24
log_archive_dest_25
log_archive_dest_26
log_archive_dest_27
log_archive_dest_28
log_archive_dest_29
log_archive_dest_3
log_archive_dest_30
log_archive_dest_31
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_state_1 enable
log_archive_duplex_dest
log_archive_format %t_%s_%r.arc
log_archive_max_processes 4
log_archive_min_succeed_dest 1
log_archive_start FALSE
log_archive_trace 0
log_buffer 100982784
log_checkpoint_interval 0
log_checkpoint_timeout 1800
log_checkpoints_to_alert FALSE
log_file_name_convert
long_module_action FALSE
max_datapump_jobs_per_pdb 100
max_dispatchers
max_dump_file_size unlimited
max_idle_time 0
max_iops 0
max_mbps 0
max_pdbs 4098
max_shared_servers
max_string_size STANDARD
memory_max_target 0
memory_target 0
nls_calendar
nls_comp BINARY
nls_currency
nls_date_format
nls_date_language
nls_dual_currency
nls_iso_currency
nls_language AMERICAN
nls_length_semantics BYTE
nls_nchar_conv_excp FALSE
nls_numeric_characters
nls_sort
nls_territory AMERICA
nls_time_format
nls_time_tz_format
nls_timestamp_format
nls_timestamp_tz_format
noncdb_compatible FALSE
object_cache_max_size_percent 10
object_cache_optimal_size 10240000
ofs_threads 4
olap_page_pool_size 0
one_step_plugin_for_pdb_with_tde FALSE
open_cursors 300
open_links 4
open_links_per_instance 4
optimizer_adaptive_plans TRUE
optimizer_adaptive_reporting_only FALSE
optimizer_adaptive_statistics FALSE
optimizer_capture_sql_plan_baselines FALSE
optimizer_dynamic_sampling 2
optimizer_features_enable 12.2.0.1
optimizer_index_caching 0
optimizer_index_cost_adj 100
optimizer_inmemory_aware TRUE
optimizer_mode ALL_ROWS
optimizer_secure_view_merging TRUE
optimizer_use_invisible_indexes FALSE
optimizer_use_pending_statistics FALSE
optimizer_use_sql_plan_baselines TRUE
os_authent_prefix ops$
os_roles FALSE
outbound_dblink_protocols ALL
parallel_adaptive_multi_user FALSE
parallel_degree_limit CPU
parallel_degree_policy MANUAL
parallel_execution_message_size 16384
parallel_force_local TRUE
parallel_instance_group
parallel_max_servers 820
parallel_min_percent 0
parallel_min_servers 192
parallel_min_time_threshold AUTO
parallel_servers_target 768
parallel_threads_per_cpu 2
pdb_file_name_convert
pdb_lockdown
pdb_os_credential
permit_92_wrap_format TRUE
pga_aggregate_limit 38654705664
pga_aggregate_target 19327352832
plscope_settings IDENTIFIERS:NONE
plsql_ccflags
plsql_code_type INTERPRETED
plsql_debug FALSE
plsql_optimize_level 2
plsql_v2_compatibility FALSE
plsql_warnings DISABLE:ALL
pre_page_sga TRUE
processes 1000
processor_group_name
query_rewrite_enabled TRUE
query_rewrite_integrity enforced
rdbms_server_dn
read_only_open_delayed FALSE
recovery_parallelism 0
recyclebin on
redo_transport_user
remote_dependencies_mode TIMESTAMP
remote_listener
remote_login_passwordfile EXCLUSIVE
remote_os_authent FALSE
remote_os_roles FALSE
remote_recovery_file_dest
replication_dependency_tracking TRUE
resource_limit FALSE
resource_manage_goldengate FALSE
resource_manager_cpu_allocation 48
resource_manager_plan
result_cache_max_result 5
result_cache_max_size 289931264
result_cache_mode MANUAL
result_cache_remote_expiration 0
resumable_timeout 0
rollback_segments
sec_case_sensitive_logon TRUE
sec_max_failed_login_attempts 3
sec_protocol_error_further_action (DROP,3)
sec_protocol_error_trace_action LOG
sec_return_server_release_banner FALSE
serial_reuse disable
service_names CXODBCG1
session_cached_cursors 50
session_max_open_files 10
sessions 1536
sga_max_size 57982058496
sga_min_size 0
sga_target 57982058496
shadow_core_dump partial
shared_memory_address 0
shared_pool_reserved_size 301989888
shared_pool_size 0
shared_server_sessions
shared_servers 1
shrd_dupl_table_refresh_rate 60
skip_unusable_indexes TRUE
smtp_out_server
sort_area_retained_size 0
sort_area_size 65536
spatial_vector_acceleration FALSE
spfile
/oracle_upgrade/oracle/ora_base/Ora12CHome/dbs/spfileCXODBCG1.ora
sql92_security TRUE
sql_trace FALSE
sqltune_category DEFAULT
standby_archive_dest ?#/dbs/arch
standby_db_preserve_states NONE
standby_file_management MANUAL
standby_pdb_source_file_dblink
standby_pdb_source_file_directory
star_transformation_enabled FALSE
statistics_level TYPICAL
streams_pool_size 0
tape_asynch_io TRUE
target_pdbs 0
temp_undo_enabled FALSE
thread 0
threaded_execution FALSE
timed_os_statistics 0
timed_statistics TRUE
trace_enabled TRUE
tracefile_identifier
transactions 1689
transactions_per_rollback_segment 5
undo_management AUTO
undo_retention 900
undo_tablespace UNDOTBS1
unified_audit_sga_queue_size 1048576
uniform_log_timestamp_format TRUE
use_dedicated_broker FALSE
use_large_pages TRUE
use_sigio TRUE
user_dump_dest
/oracle_upgrade/oracle/ora_base/Ora12CHome/rdbms/log
utl_file_dir
workarea_size_policy AUTO
xml_db_events enable
423 rows selected.
SQL>
Table created.
SQL> show parameter spfile

spfile string /oracle_upgrade/oracle/ora_bas
e/Ora12CHome/dbs/spfileCXODBCG
1.ora
SQL> create pfile='/archive/DB_DROP_2024/initCXODBCG1_BKP.ora' from spfile;
File created.
SQL> show parameter control

control_file_record_keep_time integer 7
control_files string +DG_CXODBCG1_REDOCTL01/CXODBCG
1/CONTROLFILE/current.256.9630
87899, +DG_CXODBCG1_REDOCTL02/
CXODBCG1/CONTROLFILE/current.2
56.963087899
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> alter database backup controlfile to trace as
'/archive/DB_DROP_2024/CXODBCG1_2024.ctl';
Database altered.
SQL>
show parameter back
show parameter DISPATCHERS
show parameter SHARED_SERVERS
select * from v$diag_info;SQL> background_core_dump string

partial
background_dump_dest string /oracle_upgrade/oracle/ora_bas
e/Ora12CHome/rdbms/log
backup_tape_io_slaves boolean FALSE
db_flashback_retention_target integer 1440
fast_start_parallel_rollback string LOW
rollback_segments string
transactions_per_rollback_segment integer 5
SQL> dispatchers string (PROTOCOL=TCP)
(SERVICE=CXODBC
G1XDB)
max_dispatchers integer
SQL> max_shared_servers integer
shared_servers integer 1
SQL> SQL>
1 Diag Enabled TRUE
0
1 ADR Base /oracle/app/DIAG
0
1 ADR Home
/oracle/app/DIAG/diag/rdbms/cxodbcg1/CXODBCG1
0
1 Diag Trace
/oracle/app/DIAG/diag/rdbms/cxodbcg1/CXODBCG1/trace
0
1 Diag Alert
/oracle/app/DIAG/diag/rdbms/cxodbcg1/CXODBCG1/alert
0
1 Diag Incident
/oracle/app/DIAG/diag/rdbms/cxodbcg1/CXODBCG1/incident
0
1 Diag Cdump
/oracle/app/DIAG/diag/rdbms/cxodbcg1/CXODBCG1/cdump
0
1 Health Monitor
/oracle/app/DIAG/diag/rdbms/cxodbcg1/CXODBCG1/hm
0
1 Default Trace File
/oracle/app/DIAG/diag/rdbms/cxodbcg1/CXODBCG1/trace/CXODBCG1_ora_35783044.trc
0
1 Active Problem Count 0
0
1 Active Incident Count 0
0
11 rows selected.
SQL> spool CXODBCG1.txt
select name,open_mode from v$database;
select count(*) from dba_objects where status<>'VALID';
select owner,OBJECT_TYPE,count(*) from dba_objects where status<>'VALID' group by

owner,OBJECT_TYPE order by 1;
select status,count(*) from dba_indexes group by status;
select status,count(*) from dba_ind_partitions group by status;
select count(*) from dba_objects where status='INVALID';
create table sys.CXODBCG1_1 as select * from dba_objects where status='INVALID';
select OWNER,INDEX_NAME,TABLE_OWNER,TABLE_NAME from dba_indexes where

status='UNUSABLE';
select INDEX_OWNER,INDEX_NAME,PARTITION_NAME from dba_ind_partitions where

STATUS='UNUSABLE';SQL> SQL> CXODBCG1 READ WRITE
1 row selected.
SQL> SQL> 1
1 row selected.
SQL> SQL> DBSFWUSER

PACKAGE BODY 1
1 row selected.
SQL> SQL> VALID 2749

N/A 125
2 rows selected.
SQL> SQL> USABLE 792

1 row selected.
SQL> SQL> 1
1 row selected.
SQL> SQL>
Table created.
SQL> SQL>
no rows selected
SQL> SQL>
no rows selected
SQL>
SQL>
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> alter system checkpoint;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> show pdbs

SQL>
SQL>
SQL>
SQL>
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production
[CXODBCG1]@cxopcog1:/home/oracle/scripts > ps -ef | grep pmon
oracle 62718386 38076904 0 00:00:41 pts/0 0:00 grep pmon
[CXODBCG1]@cxopcog1:/home/oracle/scripts > gg
ksh: gg: not found.
[CXODBCG1]@cxopcog1:/home/oracle/scripts > exit
Connection to 10.94.140.46 closed.

10.94.140.46 DB DROP

Uploaded by

Copyright:

Available Formats

10.94.140.46 DB DROP

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

10.94.140.46 DB DROP

Uploaded by

Copyright:

Available Formats

[]@ndc3vpaoemdb01:/home/oracle >

oratab file /etc/oratab found.

Alias for CXODBCG1 environment variables is set to CXODBCG1

oracle 14549462 1 0 Sep 16 - 6:55

[]@cxopcog1:/home/oracle > ASM

SQL*Plus: Release 12.2.0.1.0 Production

[+ASM]@cxopcog1:/home/oracle > hostname

# Internet Address Hostname # Comments

################################## Added on Request of Backup Team

LSNRCTL for IBM/AIX RISC System/6000: Version 12.2.0.1.0 - Production on 29-NOV-

Copyright (c) 1991, 2017, Oracle. All rights reserved.

LSNRCTL for IBM/AIX RISC System/6000: Version 12.2.0.1.0 - Production on 29-NOV-

Copyright (c) 1991, 2017, Oracle. All rights reserved.

SQL*Plus: Release 12.2.0.1.0 Production on Fri Nov 29 23:55:00 2024

Copyright (c) 1982, 2017, Oracle. All rights reserved.

GROUP_NUMBER NAME STATE TYPE TOTAL_MB

GROUP_NUMBER DISK_NUMBER NAME MOUNT_S HEADER_STATU MODE_ST

SQL> show parameter spfile;

NAME TYPE VALUE

SQL> create pfile='/archive/DB_DROP_2024/initasm_1.ora' from spfile;

LSNRCTL for IBM/AIX RISC System/6000: Version 12.2.0.1.0 - Production on 29-NOV-

Copyright (c) 1991, 2017, Oracle. All rights reserved.

LSNRCTL for IBM/AIX RISC System/6000: Version 12.2.0.1.0 - Production on 29-NOV-

Copyright (c) 1991, 2017, Oracle. All rights reserved.

SQL*Plus: Release 12.2.0.1.0 Production on Fri Nov 29 23:56:42 2024

Copyright (c) 1982, 2017, Oracle. All rights reserved.

INST_ID DB User Logon Time Status SESS Program OS

423 rows selected.

SQL> show parameter spfile

SQL> show parameter control

select * from v$diag_info;SQL> background_core_dump string

SQL> spool CXODBCG1.txt

select name,open_mode from v$database;

select count(*) from dba_objects where status<>'VALID';

select owner,OBJECT_TYPE,count(*) from dba_objects where status<>'VALID' group by

select status,count(*) from dba_indexes group by status;

select status,count(*) from dba_ind_partitions group by status;

select count(*) from dba_objects where status='INVALID';

create table sys.CXODBCG1_1 as select * from dba_objects where status='INVALID';

select OWNER,INDEX_NAME,TABLE_OWNER,TABLE_NAME from dba_indexes where

select INDEX_OWNER,INDEX_NAME,PARTITION_NAME from dba_ind_partitions where

SQL> SQL> DBSFWUSER

SQL> SQL> VALID 2749

SQL> SQL> USABLE 792

SQL> alter system checkpoint;

SQL> show pdbs

You might also like