oracle / ansible-database-migration-tool Goto Github PK

During the migration actions on the target's side have failed. Analysis in the target's alert log shows up:

(...) clonedb = TRUE service_names = "ORCL.602344925.oraclecloud.internal" clonedb_dir = "/u02/app/oracle/oradata/ORCL" (...) Errors in file /u01/app/oracle/diag/rdbms/orcl_syd1s3/ORCL/trace/ORCL_ora_3361.trc: ORA-17514: Access to clonedb bitmap file failed (...)

TASK [target_restore_role : Download TDE file from OSS (non ExaCS)] *****************************************************************************************
[WARNING]: Consider using the get_url or uri module rather than running 'curl'. If you need to use command because get_url or uri is insufficient you can
add 'warn: false' to this command task or set 'command_warnings=False' in ansible.cfg to get rid of this message.

changed: [172.17.30.130]

TASK [target_restore_role : Unpack the source wallet on target TDE location (non ExaCS)] ********************************************************************
fatal: [172.17.30.130]: FAILED! => {"changed": false, "msg": "Failed to find handler for "/opt/oracle/dcs/commonstore/wallets/tde/SNDBX12C_iad169/_tde.tgz". Make sure the required command to extract the file is installed. Command "/bin/gtar" could not handle archive. Command "/bin/unzip" could not handle archive."}

PLAY RECAP **************************************************************************************************************************************************
172.17.30.130 : ok=19 changed=1 unreachable=0 failed=1 skipped=14 rescued=0 ignored=0

Both directory exist.

[oracle@sandbox12c bin]$ ls -lrt unzip
-rwxr-xr-x 2 root root 185576 Jun 9 2019 unzip
[oracle@sandbox12c bin]$ ls -lrt gtar
lrwxrwxrwx 1 root root 3 Jan 30 2020 gtar -> tar
[oracle@sandbox12c bin]$ exit

Restore on the target has failed and I have noticed archive logs missing in the alert log:

(...) Errors in file /u01/app/oracle/diag/rdbms/orcl_syd1s3/ORCL/incident/incdir_41987/ORCL_ora_57047_i41987.trc: ORA-00308: cannot open archived log '/u03/ora_backup/flash_recovery_area/ORCL/archivelog/2020_06_09/o1_mf_1_75_hfyfy85o_.arc' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory (...)

It looks like entries in controlfile restored from OCI-C where ASM was not implemented. This archive log files should be treated with RMAN crosscheck command and delete obsolete/expired.