ASM failed to start up with below messages in ASM alert log:
Tue Oct 02 10:54:12 2018 ERROR: Network OS Ping failed to inst 1 on IP (169.254.255.151), Tue Oct 02 10:54:55 2018 Instance Critical Process (pid: 11, ospid: 8470, LMON) died unexpectedly PMON (ospid: 8443): terminating the instance due to error 481
Read more of this content when you subscribe today.
AWS DMS ( Data Migration Service ) task has been running for many hours, then failed with error “Table error” for Load State.
1)Check target database, 99% records have been migrated from Oracle source database to PostgreSQL RDS.
Read more of this content when you subscribe today.
On primary database side, ORA errors in alert log:
Sat Sep 22 03:56:48 2018 Errors in file /u01/app/oracle/diag/rdbms/ractest/RACTEST1/trace/RACTEST1_arc4_20835.trc: ORA-07286: sksagdi: cannot obtain device information. Sat Sep 22 03:56:48 2018 ARC4: FAL archive failed with error 7286. See trace for details Sat Sep 22 03:56:48 2018 Errors in file /u01/app/oracle/diag/rdbms/ractest/RACTEST1/trace/RACTEST1_arc4_20835.trc: ORA-16055: FAL request rejected ARCH: FAL archive failed. Archiver continuing
On standby database side :
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 536870912 bytes disk space from 214748364800 limit
ORA-19815: WARNING: db_recovery_file_dest_size of 214748364800 bytes
is 100.00% used, and has 0 remaining bytes available.
Sat Sep 22 04:24:24 2018
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Standby database archive log retention policy is not configured properly.
RMAN> show all; ... .. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; ..
Change the archive log retention policy on standby side.
RMAN>CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
This post step by step explains how to migrate on-premise Oracle database 12c data to AWS PostgreSQL RDS by using AWS DMS ( Database Migration Service). Assume the schema has been migrated by using the AWS Schema Conversion Tool (AWS SCT).
Read more of this content when you subscribe today.
List operations remaining time > 10 minutes :
SQL>select
username,sid, opname, target, sofar, totalwork, units,
to_char(start_time,'YYYYMMDD-HH24:MI:SS') StartTime,
time_remaining, message
from
V$SESSION_LONGOPS
where
time_remaining>600;
USERNAME SID OPNAME TARGET SOFAR TOTALWORK UNITS STARTTIME TIME_REMAINING MESSAGE
------------ ------ ---------- ---------- ------- ---------- ------- ----------------- -------------- ---------------------------------------------------------
TETSUSER 5704 Table Scan TETSUSER.TEST 22414 39677 Blocks 20180920-10:55:49 3676 Table Scan: JAMES.TEST: 22414 out of 39677 Blocks done
Make DBA Life Easy 