Reconfigure user/password for de Oracle Cloud Backup account
The symptoms maybe one of those
KBHS-00719, KBHS-00700One cause of the problem is the change of credentials or expired password, to reconfigure:
java -jar opc_install.jar -host https://<host-of-container> -opcId '<user>' -opcPass '<pswd>' -walletDir <wallet-location> <lib-location-optional>The lib location if you need to re-download de opc lib
Delete ALL archivelog no matter the status
delete force archivelog all;Parametros NLS configurados en la base de datos
SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET';SELECT * FROM NLS_DATABASE_PARAMETERSParametros NLS en la sesión
SELECT * FROM NLS_SESSION_PARAMETERSEliminar respaldos obsoletos basados en una ventana de tiempo de recuperación indicada
DELETE OBSOLETE RECOVERY WINDOW OF 30 DAYS;
Se conservan unicamente los respaldos que permitan la recuperación de hasta 30 días atras
Como ver el estado de operaciones de RMAN
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND TOTALWORK != 0 AND SOFAR <> TOTALWORK;Verificar que packs están activos
SHOW PARAMETER control_management_pack_access;
Activar/Desactivar Packs
ALTER SYSTEM SET control_management_pack_access = "DIAGNOSTIC+TUNING" SCOPE = BOTH;Valores permitidos
"NONE"
"DIAGNOSTIC"
"DIAGNOSTIC+TUNING"
Crear el directorio
CREATE OR REPLACE DIRECTORY nombre_del_directorio AS '/ruta/en/sistema operativo';La ruta encerrada en comillas simples, en Linux es CASE SENSITIVE
Permitir el acceso al directorio
GRANT READ, WRITE ON DIRECTORY nombre_del_directorio TO username;