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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)