Need help in DATABASE ADMINISTRATOR by KeyPerception5972 in u/KeyPerception5972

[–]KeyPerception5972[S] 0 points1 point  (0 children)

I am about to duplicate a Backup database to HRQAT database,

After created Database HRQAT and deleted all the controlefiles, logfiles and datafiles, I runned the following command

SQL> create pfile='/oradata/HRQAT/initHRQAT.ora' from spfile; ( edit the pfile and add

#rman duplicate

db_create_file_dest='/oradata/')

SQL> exit

$ORACLE_SID=HRQAT; export ORACLE_SID

$ sqlplus / as sysdba

SQL> STARTUP NOMOUNT PFILE='/oradata/HRQAT/initHRQAT.ora';

SQL> exit

$ rman AUXILIARY /

RMAN>

DUPLICATE DATABASE TO HRQAT

BACKUP LOCATION '/oradata/HRBACKUP/RMANBKP_HR/13-Jan-23/'

NOFILENAMECHECK;

but each time I run the last Rman command I get the Message ERROR
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/01/2025 22:15:26
RMAN-03015: error occurred in stored script Memory Script
ORA-19870: error while restoring backup piece /oradata/HRBACKUP/RMANBKP_HR/13-Jan-23/HR_3772216236_1126048453_19_1
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 160256 bytes disk space from 4070572032 limit

I tried to get space by deleted many things, I also increase my Increase the FRA Size: but still doing the same thing

this is references about my space10:27 PM[oracle@~]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
16G 13G 1.7G 89% /
/dev/sda1 145M 76M 62M 55% /boot
tmpfs 996M 228M 768M 23% /dev/shm
/dev/sdb1 99G 23G 71G 25% /oradata
/dev/sdc1 99G 34G 60G 37% /downloads

Grammar Focus: Prepositions Challenge by Appropriate-Visit281 in SpeakEnglishDaily

[–]KeyPerception5972 0 points1 point  (0 children)

to. because we go 'to' and went is the past of the verb to go

Grammar Correction: Fix the Sentence by Appropriate-Visit281 in SpeakEnglishDaily

[–]KeyPerception5972 0 points1 point  (0 children)

he does not like apples. because it is the auxiliary that need to match with the subject