RMAN-05609: Must specify a username for target connection when using active duplicate

While I was trying to duplicate my database I got this error: orcl_pri> rman target / auxiliary [email protected]_dr Recovery Manager: Release 12.1.0.2.0 – Production on Mon Apr 15 13:50:51 2019 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=XXXXXXXXXX) auxiliary database Password: connected to auxiliary database: ORCL…

Read More

Oracle, RMAN, ,

In how much time will RMAN or Datapump finish the job?

This is how you can see it: RMAN SQL>alter session set nls_date_format=’dd/mm/yy hh24:mi:ss’; SQL>select sid, totalwork, sofar,(sofar/totalwork) * 100 per_done,start_time, sysdate + time_remaining/3600/24 end_at from v$session_longops where totalwork > sofar and lower(opname) not like ‘%aggregate%’ and lower(opname) like ‘rman%’; SID START_TIME        TOTALWORK SOFAR   PER_DONE END_AT —– —————– ———- ———- ———- —————– —————– 491 18/08/10 20:13:45…

Read More

Import&Export, RMAN, , , ,