Automatic Storage Management (ASM)

How to Resolve ASMCMD-9463: operation failed due to lack of write permissions

by Ed Chen
April 22, 2022May 18, 2022

ASMCMD-9463 Tried to copy a data file out of ASM, but it failed with ASMCMD-9463. [grid@primary01 grid]$ asmcmd cp +DATA/ORCLCDB/ORCLPDB/example_01.dbf /backup/example_01.dbf ASMCMD-9463: operation failed due… Read More »

How to Move Wallet_Root out of ASM

by Ed Chen
March 24, 2022February 22, 2023

Move Wallet out of ASM In case that you found it's difficult to manage the wallet in ASM, I provide a way to move it… Read More »

How to Move Wallet_Root into ASM

by Ed Chen
March 23, 2022December 27, 2022
2 Comments

WALLET_ROOT In How to enable Oracle TDE 19c in RAC DB, we put the wallet in every server of a RAC database. Since the wallet… Read More »

How to Resolve RMAN-06023: no backup or copy of datafile found to restore

by Ed Chen
February 25, 2022February 27, 2022
2 Comments

RMAN-06026 and RMAN-06023 Found errors RMAN-06026 and RMAN-06023 after several hours of database restore. RMAN> restore database; ... RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK… Read More »

How to Resolve ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

by Ed Chen
October 4, 2021March 6, 2023
2 Comments

ORA-00245 Tried to create a standby controlfile from a RAC database, but it failed with ORA-00245 or ORA-245. [oracle@primary01 ~]$ sqlplus / as sysdba ...… Read More »

How to Resolve ORA-32002: cannot create SPFILE already being used by the instance

by Ed Chen
August 16, 2021October 23, 2021

ORA-32002 Tried to restore the server parameter (SPFILE) to the default location from a parameter file (PFILE), but it failed with ORA-32002 like this. SQL>… Read More »

How to Resolve ASMCMD-9453: failed to register password file as a CRS resource

by Ed Chen
December 6, 2020October 24, 2021

ASMCMD-9453 In the process of creating an empty RAC database, I tried to copy a password file into ASM by pwcopy command in ASMCMD, then… Read More »

How to Build Asymmetric Standby Database for Data Guard

by Ed Chen
July 14, 2019February 13, 2023
4 Comments

Asymmetric Data Guard Usually we build data guard environments with the symmetric architecture design on primary and standby servers, that is, single-instance to single-instance or… Read More »

How to Restore 10g RAC Database from a Backup Set

by Ed Chen
June 26, 2019December 10, 2022
2 Comments

For 12c RAC database restoration, you may check: How to Restore 12c RAC Database from a Backup Set. Suppose we have recovered 10g CRS and… Read More »

How to Change SPFILE Location in Oracle

by Ed Chen
February 23, 2019February 25, 2023
2 Comments

ALTER SYSTEM SET SPFILE Before reading, you have to know that there's no ALTER SYSTEM SET SPFILE statement in Oracle, because we can never write… Read More »