I faced with that error message during restore our 10.2.0.5 db on AIX 6.1
My restore database command is simple as follow:
RUN
{
allocate channel restore01 type ‘SB_TAPE’ ;
allocate channel restore02 type ‘SBT_TAPE’ ;
RESTORE DATABASE ;
RELEASE channel restore01;
RELEASE channel restore02;
}
We can restore db without any error message, than We started to recover process.
My recover database command is simple as follow:
RUN
{
allocate channel restore01 type ‘SBT_TAPE’ ;
allocate channel restore02 type ‘SBT_TAPE’ ;
RECOVER DATABASE ;
RELEASE channel restore01;
RELEASE channel restore02;
}
During recover process Rman session end with:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/31/2016 16:00:00
RMAN-06561: available space must be larger than 1421913 kb
After investigate error message, I found this:
Cause: The recovery failed because it requires more disk space. One of the following could have caused this error: 1) The MAXSIZE option is used but is not large enough to restore files. 2) Files should be restored to recovery area, but available disk space is not large enough to restore files.
Action: One of the following: 1) Increase the MAXSIZE parameter and retry the command. 2) Free up disk space in the recovery area.
I also find this information:
Workaround
The workaround is not to set db_recovery_file_dest and
db_recovery_file_dest_size parameters in the init.ora of auxiliary instance
during duplicate.
We set&increased db_recovery_file_dest and db_recovery_file_dest_size but error still persist.
So how I solved issue. Here is the command
RECOVER DATABASE delete archivelog maxsize 150000M;
{
allocate channel restore01 type ‘SBT_TAPE’ ;
allocate channel restore02 type ‘SBT_TAPE’ ;
RECOVER DATABASE delete archivelog maxsize 150000M;;
RELEASE channel restore01;
RELEASE channel restore02;
}
Reference:
Bug 8631293 – RMAN DUPLICATE throws RMAN-6561 after setting recovery area parameter (Doc ID 8631293.8)
Bir Cevap Yazın