IVR Testing

 what will happen if our Archive Log destination is full on standby side ? If your Archive Log destination is full on standby side, your MRP process will not run, it means there will be a gap in between your Primar database and Standby database . to avoid this situation what we can do you can add a space to the Archive Log destination so that a new Archives will get generated,  second thing is you can also delete the old Archive Logs so that those Archive Log which has been applied those are of no use as of now so you can delete those old Archive Logs from the standby side

 ### To display the main Container name. SQL> show con_name; CON_NAME ------------------------------ CDB$ROOT SQL> ### To display the All the Container names which is under CDB ROOT Folder. SQL> show pdbs;     CON_ID      CON_NAME      OPEN MODE  RESTRICTED ----------      ------------------------------ ---------- ----------          2      PDB$SEED                      READ ONLY       NO          3      PDBPRIM                        READ WRITE      NO          4      PDBPRIM2                      READ WRITE      NO SQL> ### To open Pluggable Database folder ( SUB Container na...