Reading mysqldump output file compressed with gzip on linux

I usually need to do it when I'm creating a slave. I need to be able to read a mysql dump file generated by mysqldump command and after, compressed with gzip command. For example: mysqldump --single-transaction --events --quick --compress --routines --master-data=2 --databases sonda xi --add-drop-database | gzip > /backup/teste_backup.sql.gz When I am creating a slave, … Continue reading Reading mysqldump output file compressed with gzip on linux

RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

This can happen during a duplicate database, for example: (dg1)(oracle@jupiter):admin> rman target sys/danilo123@jupiter auxiliary sys/danilo123@jupiterstb Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jul 10 18:10:58 2021 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: JUPITER (DBID=4201888259) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== … Continue reading RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Oracle script – Number of redo log groups by thread# and type

Just sharing other script in my blog. This script shows the number of redo log groups (online log and standby log) by thread# and type. --Written by: astoradba.wordpress.com select m.type,g.thread#,count(DISTINCT g.group#) NUMBER_OF_GROUPS from v$log g inner join v$logfile m on m.group#=g.group# group by m.type,g.thread# union all select m.type,g.thread#,count(DISTINCT g.group#) NUMBER_OF_GROUPS from v$standby_log g inner join … Continue reading Oracle script – Number of redo log groups by thread# and type

ORA-01111,ORA-01110,ORA-01157 in the physical standby database

This erro usually happen when the parameter standby_file_management is defined as manual. Documentation.When automatic standby file management is enabled, operating system file additions and deletions on the primary database are replicated on the standby database. STANDBY_FILE_MANAGEMENT is only applicable to physical standby databases.MANUAL - Disables automatic standby file managementAUTO - Enables automatic standby file managementSetting STANDBY_FILE_MANAGEMENT to AUTO causes Oracle to … Continue reading ORA-01111,ORA-01110,ORA-01157 in the physical standby database

ORA-10458,ORA-01152 and ORA-01110 after recover standby database from service

RMAN> recover standby database from service service_name_here; Starting recover at 05-MAR-21 using target database control file instead of recovery catalog Oracle instance started Total System Global Area 1291842528 bytes Fixed Size 8647648 bytes Variable Size 503316480 bytes Database Buffers 771751936 bytes Redo Buffers 8126464 bytes contents of Memory Script: { restore standby controlfile from service … Continue reading ORA-10458,ORA-01152 and ORA-01110 after recover standby database from service

ACFS – CRS-2552: There are no available instances of resource

First, if your environment are using serverpool, check the serverpool configuration as well. My environment does not use serverpool. root@rac2:~# srvctl config filesystem -d /dev/asm/u02-26 Volume device: /dev/asm/u02-26 Diskgroup name: data Volume name: u02 Canonical volume device: /dev/asm/u02-26 Accelerator volume devices: Mountpoint path: /u02/ Mount point owner: oracle Mount point group: oinstall Mount permissions: owner:oracle:rwx,pgrp:oinstall:rwx,other::r-x … Continue reading ACFS – CRS-2552: There are no available instances of resource

RMAN-10015 during rename file using RMAN

oracle@rac1:~$ tail -f rmanlogmothist.log set newname for datafile 3 to '+DGDATAMOTHIST/mothist/datafile/sysaux01.dbf'; set newname for datafile 4 to '+DGDATAMOTHIST/mothist/datafile/undotbs101.dbf'; set newname for datafile 5 to '+DGDATAMOTHIST/mothist/datafile/undotbs201.dbf'; set newname for datafile 7 to '+DGDATAMOTHIST/mothist/datafile/users01.dbf'; set newname for datafile 8 to '+DGDATAMOTHIST/mothist/datafile/size_monitor01.dbf'; set newname for tempfile 1 to '+DGDATAMOTHIST/mothist/datafile/temp01.dbf';... several renames ... sql "alter database rename file '+FRA/MOOTDB/ONLINELOG/group_1.297.1067716013' … Continue reading RMAN-10015 during rename file using RMAN

Script to list jobs created with DBMS_JOB

Hi, Just sharing another script. This script show all jobs created with dbms_job (not dbms_scheduler). Also, this script was made to be used with sqlplus, which the output is more organized. If you are using other tool such SQL Developer, just issue: select * from dba_jobs; with some condition, it's enough. There are four lines … Continue reading Script to list jobs created with DBMS_JOB

SQL – How natural join works?

Here is an example. We have the following tables: Structure of the tables provided by Oracle in Human Resource Schema (HR). You can test it by yourself using LiveSQL. There you have access to HR schema. Just use hr. before the table names in the examples bellow. Let's focus just in JOB_HISTORY AND EMPLOYEES tables. … Continue reading SQL – How natural join works?

How to disable MGMTDB and Cluster Health Monitor (CHM)?

I usually disable it in my labs to save resources from VM. I do not recommend to do it in a production environment. Is it Supported to disable the Cluster Health Monitor Resource (ora.crf)? (Doc ID 2650051.1) APPLIES TO:Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterThe Cluster Health Monitor node resource, ora.crf, is … Continue reading How to disable MGMTDB and Cluster Health Monitor (CHM)?

Oracle – Backup do banco mesmo com blocos corrompidos.

Encontrei um cliente com uma rotina de backup "burrinha". A retenção era de um backup e para fazer o próximo backup a rotina apagava o ultimo backup disponível (iniciava o script com o comando delete backup completed before trunc(sysdate - 1)).. o motivo dessa rotina "burrinha" era espaço em disco.. o que aconteceu é que … Continue reading Oracle – Backup do banco mesmo com blocos corrompidos.

Restore followed by ORA-19504 ORA-17502 ORA-15001 ORA-15040

oracle@rac2:~$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Wed Dec 30 17:25:25 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: MOOTDB (not mounted) RMAN> RMAN> restore controlfile from '/backup/control01.bkp'; Starting restore at 30-DEC-20 using target database control file instead of recovery catalog allocated channel: … Continue reading Restore followed by ORA-19504 ORA-17502 ORA-15001 ORA-15040