Hi All,
OS: OEL 5.4
DB: 11gR2 RAC 3 nodes
I have installed RAC to practice. I have created ASM diskgroup FRA to store backups and archive logs. I turned on archive yesterday and as I didn't allocate much space, I am getting below error for any user operations.
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.
now when I try to delete it from RMAN I get error. What is the best way to delete archive logs and get system up and running.
RMAN> crosscheck archivelog all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 07/01/2016 07:42:36
RMAN-12010: automatic channel allocation initialization failed
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
RMAN> delete noprompt expired archivelog all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 07/01/2016 07:42:53
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Thanks