ORA-16086: Redo data cannot be written to the standby redo log

2024-11-22T07:09:14.930561+00:00 Errors in file /data/oracle/MYDB/admin/diag/rdbms/MYDB/MYDB7/trace/MYDB7_lgwr_178713.trc: ORA-16086: Redo data cannot be written to the standby redo log LGWR (PID:178713): Error 16086 for LNO:2 to 'MYDB_sb' LGWR (PID:178713): Failed to archive LNO:2 T-1.S-1765560, error=16086 2024-11-22T07:09:14.945680+00:00 Thread 1 advanced to log sequence 1765560 (LGWR switch), current SCN: 13393654452914 Current log# 2 seq# 1765560 mem# 0: +DATA/MYDB/onlinelog/group_2.471.1046140279 Current log# 2 seq# 1765560 mem# 1: +REC/MYDB/onlinelog/group_2.19611.1046140279 2024-11-22T07:09:16.758563+00:00 ARC1 (PID:184077): Archived Log entry 7135590 added for T-1.S-1765559 ID 0x794f6c68 LAD:1 2024-11-22T07:09:26.011951+00:00

RMAN-06172: no AUTOBACKUP found or the specified handle is not a valid copy or piece

     

RMAN> restore controlfile from '/home/oracle/current.257.1073287779_20240609_0030';     Starting restore at 12-JUN-24  using target database control file instead of recovery catalog  allocated channel: ORA_DISK_1  channel ORA_DISK_1: SID=2049 device type=DISK     RMAN-00571: ============================================== =============  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============  RMAN-00571: ============================================== =============  RMAN-03002: failure of restore command at 06/12/2024 08:38:03  RMAN-06172: no AUTOBACKUP found or the specified handle is not a valid copy or piece

ORA-01103: database name ... in control file is not ...

SQL> srtup pfile=init.ora  ORACLE instance started.     Total System Global Area 3226043912 bytes  Fixed Size                  9172488 bytes  Variable Size            2080374784 bytes  Database Buffers         1006632960 bytes  Redo Buffers              129863680 bytes  ORA-01103: database name 'NEWDB' in control file is not 'SALMAN'

RMAN-06617: UNTIL TIME is ahead of last NEXT TIME in archived logs

RMAN-00571: ===========================================================  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============  RMAN-00571: ===========================================================  RMAN-03002: failure of Duplicate Db command at 06/26/2024 05:32:00  RMAN-05501: aborting duplication of target database  RMAN-06617: UNTIL TIME (20-JUN-24) is ahead of last NEXT TIME in archived logs (20-JUN-24)

ORA-29339: tablespace block size 4096 does not match configured block sizes

SQL> create tablespace testtbs blocksize 4k datafile '+DATA' size 2m;  create tablespace testtbs blocksize 4k datafile '+DATA' size 2m  *  ERROR at line 1:  ORA-29339: tablespace block size 4096 does not match configured block sizes

ORA-03214: File size specified is smaller than minimum required

SQL> alter database datafile '+DATA/MYDB/19AF24AD633634AEE0632502F50A727A/DATAFILE/testtbs.5971.1170569741' resize 6m;  alter database datafile '+DATA/MYDB/19AF24AD633634AEE0632502F50A727A/DATAFILE/testtbs.5971.1170569741' resize 6m  *  ERROR at line 1:  ORA-03214: File size specified is smaller than minimum required

RMAN-06617: UNTIL TIME (20-JUN-24) is ahead of last NEXT TIME in archived logs...

RMAN-00571: ===========================================================  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============  RMAN-00571: ===========================================================  RMAN-03002: failure of Duplicate Db command at 06/26/2024 05:32:00  RMAN-05501: aborting duplication of target database  RMAN-06617: UNTIL TIME (20-JUN-24) is ahead of last NEXT TIME in archived logs (20-JUN-24)

ORA-00821: Specified value of sga_target 5120M is too small, needs to be at least 12352M

There could be situations where you are trying to start your database instance, however, it returns an error message instead of starting up. Such errors are mostly related to init parameters and must be fixed before retrying to start the instance. Issue could be related to an invalid value of a parameter or syntax error in the parameter file. In the following I will explain one of the errors that are related to an invalid value of parameter SGA_TARGET.