DBA Knowledge Base

Move Oracle controlfile from filesystem to ASM December 17, 2022 - (0)
1. Find out controlfile locations: Please note another copy of controlfile is already on ASM, +FRA diskgroup. We are moving the first one. SQL> show parameter control_files NAME TYPE VALUE ———————————— ———– —————————— control_files string /u01/app/oracle/oradata/PRSH01 /control01.ctl, +FRA/PRSH01/co ntrol02.ctl 2. Place database into nomount mode using RMAN and copy controlfile to new location: $ rman […]
Comparing speed between 2 cores vs 1 multi-threaded core December 14, 2022 - (0)
Move Oracle datafiles from filesystem to ASM using RMAN December 5, 2022 - (0)
DBCA Fails With INS-00001 and DBT-00007 November 28, 2022 - (0)
Postfix: flush emails from the mail queue August 6, 2022 - (0)

Mobile Site | Full Site