526互联

2、[FATAL] Error while cataloging RMAN Backups

发布时间 2023-08-23 16:34:29作者: 站着说话不腰疼

[FATAL] Error while cataloging RMAN Backups

1、利用oracle小工具

sysresv

IPC Resources for ORACLE_SID "ifrsdev" :
Maximum shared memory segment size (shmmax): 4398046511104 bytes
Total system shared memory (shmall): 4398046511104 bytes
Total system shared memory count (shmmni): 4096
*********************** Dumping ipcs output ********************

------ Message Queues --------
key msqid owner perms used-bytes messages

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x073d1965 0 postgres 600 56 6
0x00000000 4882433 oracle 600 8900608 1
0x00000000 4915202 oracle 600 1560281088 1
0x00000000 4947971 oracle 600 7876608 1
0x067c3cb4 4980740 oracle 600 12288 1

------ Semaphore Arrays --------
key semid owner perms nsems

*********************** End of ipcs command dump **************

***************** Dumping Resource Limits(s/h) *****************
core file size 0 KB/UNLIMITED
data seg size UNLIMITED/UNLIMITED
scheduling priority 0 KB/0 KB
file size UNLIMITED/UNLIMITED
pending signals 78 KB/78 KB
max locked memory 128 GB/128 GB
max memory size UNLIMITED/UNLIMITED
open files 64 KB/64 KB
POSIX message queues 800 KB/800 KB
real-time priority 0 KB/0 KB
stack size 32 MB/32 MB
cpu time UNLIMITED/UNLIMITED
max user processes 16 KB/16 KB
virtual memory UNLIMITED/UNLIMITED
file locks UNLIMITED/UNLIMITED

***************** End of Resource Limits Dump ******************
Maximum map count configured per process: 65530
Total /dev/shm size: 21474709504 bytes, used: 126976 bytes
Shared Memory:
ID KEY
4915202 0x00000000
4947971 0x00000000
4882433 0x00000000
4980740 0x067c3cb4
Semaphores:
ID KEY
No semaphore resources used
Oracle Instance not alive for sid "ifrsdev"

ipcrm -m 4915202
ipcrm -m 4947971
ipcrm -m 4882433
ipcrm -m 4980740