Hello,
I'm performing RMAN recovery of some tables that we lost in a test schema. Below is the script, which has about a list of 1300 tables (but have cut short the script here, for ease of reading).
run
{
set auxiliary instance parameter file to '/u26/app/oracle/product/12.2.0/db_1/dbs/initrecover.ora';
RECOVER TABLE
O428UAT."ACTIONPERMS",
O428UAT."ACTIONPLANS",
...............................................
...............................................
until time "to_date('21-MAY-2020 05:00:00','DD-MON-YYYY HH24:MI:SS')"
AUXILIARY DESTINATION '/u06/oracle/temp/oracle/recv_schema';
}
The aux destination is 15 TB and only 4.4TB is used. The entire test DB is about 9TB.
I would think it has enough space, but the job failed multiple times.
I have 2 issues, from the RMAN log below.
Removing automatic instance
shutting down automatic instance
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/21/2020 16:48:00
RMAN-06136: ORACLE error from auxiliary database: ORA-01000: maximum open cursors exceeded
RMAN-06136: ORACLE error from auxiliary database: ORA-01000: maximum open cursors exceeded
RMAN-05059: Table O428UAT.CS_ENTITY_REC_TREE_GTT resides in tablespace SYSTEM
RMAN-05003: Tablespace Point-in-Time Recovery is not allowed for tablespace SYSTEM
RMAN-05122: there is insufficient disk space to perform this table recovery
1. RMAN-06136: ORACLE error from auxiliary database: ORA-01000: maximum open cursors exceeded -- I found a Document which said we can define a pfile override, which I did.
set auxiliary instance parameter file to '/u26/app/oracle/product/12.2.0/db_1/dbs/initrecover.ora';
The init file contents are as below:
*.open_cursors=1000
*.processes=1200
Do I need one cursor/process per table? Do I need to change the above to 2000 each or probably 3000?
2. RMAN-05122: there is insufficient disk space to perform this table recovery -- Why am I getting this, when I have 11 TB of space and hardly a third of it is used, but it is still failing. Is there a limit on what rman can use or a default, which I can override? I cannot find absolutely anything on this error anywhere.
s608109ch3nsint.stars-net.com:/ifs/CH3_NFS/u06
15T 4.4T 11T 30% /u06
Thanks,
Venkatesh