I had a performance problem in one of the routine backups, so I opened a Service Request (SR) at MOS (My Oracle Support). After a few hours from the moment I opened the SR, I got a request to upload the output of a few commands. Therefore, I used a SPOOL output to create it. For those unfamiliar with how to create a SPOOL output in the RMAN utility, follow below how you can accomplish this task:
[oracle@tech01 patch]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Thu Dec 1 09:56:21 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: BO (DBID=1159792519, not open) RMAN> spool log to /u01/app/patch/rman-output01.log RMAN> set echo on RMAN> show all; RMAN> report schema; RMAN> list incarnation; RMAN> list copy of database; RMAN> spool log off ; Spooling for log turned off Recovery Manager19.3.0.0.0 RMAN> exit exit
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)