Posts

Showing posts from January, 2022

RMAN-05655: specified REMOTE_RECOVERY_FILE_DEST parameter is NULL

 RMAN> DUPLICATE PLUGGABLE DATABASE pdb1 AS pdb1_in_cdb19 FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT ('ORCL', 'CDB19');2> 3>  Starting Duplicate PDB at 27-JAN-22 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=403 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate PDB command at 01/27/2022 15:47:52 RMAN-05501: aborting duplication of target database RMAN-05655: specified REMOTE_RECOVERY_FILE_DEST parameter is NULL REMOTE_RECOVERY_FILE_DEST specifies a directory from which to read archive log files during a pluggable database (PDB) refresh operation if the source is not available. Solution: In the auxiliary, I set REMOTE_RECOVERY_FILE_DEST from null to  SQL> show parameter ...

ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 bytes limit

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 26 18:50:15 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.   All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> ALTER DATABASE FLASHBACK OFF Above command was taking a long time, then I checked the alert log file and there was following error: """ ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 bytes limit 2022-01-26T18:32:55.460673+00:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_tt00_24306.trc: ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 bytes limit 2022-01-26T18:33:55.875760+00:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_tt00_24306.trc: ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 b...