SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 28 12:02:22 2017 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options Instance Database Name Version Host Name Startup Time Status Status Logins Archiver ---------- ---------- ------------------------- -------------------- ---------- ---------- ---------- ---------- xxx 12.1.0.2.0 SourceServerName 15-JUL-17 OPEN ACTIVE ALLOWED STARTED FILE# Status CHANGE# TIME CON_ID ---------- ---------- ---------- --------------- ---------- 1 ACTIVE 6540639642 28-JUL-17 0 2 ACTIVE 6540639642 28-JUL-17 0 3 ACTIVE 6540639642 28-JUL-17 0 4 ACTIVE 6540639642 28-JUL-17 0 5 ACTIVE 6540639642 28-JUL-17 0 6 ACTIVE 6540639642 28-JUL-17 0 7 ACTIVE 6540639642 28-JUL-17 0 8 ACTIVE 6540639642 28-JUL-17 0 9 ACTIVE 6540639642 28-JUL-17 0 10 ACTIVE 6540639642 28-JUL-17 0 11 ACTIVE 6540639642 28-JUL-17 0 12 ACTIVE 6540639642 28-JUL-17 0 13 ACTIVE 6540639642 28-JUL-17 0 14 ACTIVE 6540639642 28-JUL-17 0 15 ACTIVE 6540639642 28-JUL-17 0 16 ACTIVE 6540639642 28-JUL-17 0 17 ACTIVE 6540639642 28-JUL-17 0 18 ACTIVE 6540639642 28-JUL-17 0 19 ACTIVE 6540639642 28-JUL-17 0 20 ACTIVE 6540639642 28-JUL-17 0 21 ACTIVE 6540639642 28-JUL-17 0 22 ACTIVE 6540639642 28-JUL-17 0 23 ACTIVE 6540639642 28-JUL-17 0 24 ACTIVE 6540639642 28-JUL-17 0 25 ACTIVE 6540639642 28-JUL-17 0 26 ACTIVE 6540639642 28-JUL-17 0 27 ACTIVE 6540639642 28-JUL-17 0 28 ACTIVE 6540639642 28-JUL-17 0 29 ACTIVE 6540639642 28-JUL-17 0 30 ACTIVE 6540639642 28-JUL-17 0 31 ACTIVE 6540639642 28-JUL-17 0 32 ACTIVE 6540639642 28-JUL-17 0 33 ACTIVE 6540639642 28-JUL-17 0 34 ACTIVE 6540639642 28-JUL-17 0 35 ACTIVE 6540639642 28-JUL-17 0 36 ACTIVE 6540639642 28-JUL-17 0 37 ACTIVE 6540639642 28-JUL-17 0 38 ACTIVE 6540639642 28-JUL-17 0 39 ACTIVE 6540639642 28-JUL-17 0 40 ACTIVE 6540639642 28-JUL-17 0 41 ACTIVE 6540639642 28-JUL-17 0 42 ACTIVE 6540639642 28-JUL-17 0 43 ACTIVE 6540639642 28-JUL-17 0 44 ACTIVE 6540639642 28-JUL-17 0 45 ACTIVE 6540639642 28-JUL-17 0 46 ACTIVE 6540639642 28-JUL-17 0 47 ACTIVE 6540639642 28-JUL-17 0 48 ACTIVE 6540639642 28-JUL-17 0 49 ACTIVE 6540639642 28-JUL-17 0 50 ACTIVE 6540639642 28-JUL-17 0 51 ACTIVE 6540639642 28-JUL-17 0 52 ACTIVE 6540639642 28-JUL-17 0 FILE# Status CHANGE# TIME CON_ID ---------- ---------- ---------- --------------- ---------- 53 ACTIVE 6540639642 28-JUL-17 0 54 ACTIVE 6540639642 28-JUL-17 0 55 ACTIVE 6540639642 28-JUL-17 0 56 ACTIVE 6540639642 28-JUL-17 0 57 ACTIVE 6540639642 28-JUL-17 0 58 ACTIVE 6540639642 28-JUL-17 0 59 ACTIVE 6540639642 28-JUL-17 0 60 ACTIVE 6540639642 28-JUL-17 0 61 ACTIVE 6540639642 28-JUL-17 0 62 ACTIVE 6540639642 28-JUL-17 0 63 ACTIVE 6540639642 28-JUL-17 0 64 ACTIVE 6540639642 28-JUL-17 0 65 ACTIVE 6540639642 28-JUL-17 0 66 ACTIVE 6540639642 28-JUL-17 0 67 ACTIVE 6540639642 28-JUL-17 0 68 ACTIVE 6540639642 28-JUL-17 0 69 ACTIVE 6540639642 28-JUL-17 0 70 ACTIVE 6540639642 28-JUL-17 0 71 ACTIVE 6540639642 28-JUL-17 0 72 ACTIVE 6540639642 28-JUL-17 0 73 ACTIVE 6540639642 28-JUL-17 0 74 ACTIVE 6540639642 28-JUL-17 0 75 ACTIVE 6540639642 28-JUL-17 0 76 ACTIVE 6540639642 28-JUL-17 0 77 ACTIVE 6540639642 28-JUL-17 0 78 ACTIVE 6540639642 28-JUL-17 0 79 ACTIVE 6540639642 28-JUL-17 0 80 ACTIVE 6540639642 28-JUL-17 0 81 ACTIVE 6540639642 28-JUL-17 0 82 ACTIVE 6540639642 28-JUL-17 0 83 ACTIVE 6540639642 28-JUL-17 0 84 ACTIVE 6540639642 28-JUL-17 0 85 ACTIVE 6540639642 28-JUL-17 0 86 ACTIVE 6540639642 28-JUL-17 0 87 ACTIVE 6540639642 28-JUL-17 0 88 ACTIVE 6540639642 28-JUL-17 0 89 ACTIVE 6540639642 28-JUL-17 0 90 ACTIVE 6540639642 28-JUL-17 0 91 ACTIVE 6540639642 28-JUL-17 0 92 ACTIVE 6540639642 28-JUL-17 0 93 ACTIVE 6540639642 28-JUL-17 0 94 ACTIVE 6540639642 28-JUL-17 0 95 ACTIVE 6540639642 28-JUL-17 0 96 ACTIVE 6540639642 28-JUL-17 0 97 ACTIVE 6540639642 28-JUL-17 0 98 ACTIVE 6540639642 28-JUL-17 0 99 ACTIVE 6540639642 28-JUL-17 0 100 ACTIVE 6540639642 28-JUL-17 0 101 ACTIVE 6540639642 28-JUL-17 0 102 ACTIVE 6540639642 28-JUL-17 0 103 ACTIVE 6540639642 28-JUL-17 0 104 ACTIVE 6540639642 28-JUL-17 0 FILE# Status CHANGE# TIME CON_ID ---------- ---------- ---------- --------------- ---------- 105 ACTIVE 6540639642 28-JUL-17 0 106 ACTIVE 6540639642 28-JUL-17 0 107 ACTIVE 6540639642 28-JUL-17 0 108 ACTIVE 6540639642 28-JUL-17 0 109 ACTIVE 6540639642 28-JUL-17 0 110 ACTIVE 6540639642 28-JUL-17 0 111 ACTIVE 6540639642 28-JUL-17 0 112 ACTIVE 6540639642 28-JUL-17 0 113 ACTIVE 6540639642 28-JUL-17 0 114 ACTIVE 6540639642 28-JUL-17 0 115 ACTIVE 6540639642 28-JUL-17 0 116 ACTIVE 6540639642 28-JUL-17 0 117 ACTIVE 6540639642 28-JUL-17 0 118 ACTIVE 6540639642 28-JUL-17 0 119 ACTIVE 6540639642 28-JUL-17 0 120 ACTIVE 6540639642 28-JUL-17 0 121 ACTIVE 6540639642 28-JUL-17 0 122 ACTIVE 6540639642 28-JUL-17 0 123 ACTIVE 6540639642 28-JUL-17 0 123 rows selected. SQL> alter database end backup; Database altered. SQL> set echo off FILE# Status CHANGE# TIME CON_ID ---------- ---------- ---------- --------------- ---------- 1 NOT ACTIVE 6540639642 28-JUL-17 0 2 NOT ACTIVE 6540639642 28-JUL-17 0 3 NOT ACTIVE 6540639642 28-JUL-17 0 4 NOT ACTIVE 6540639642 28-JUL-17 0 5 NOT ACTIVE 6540639642 28-JUL-17 0 6 NOT ACTIVE 6540639642 28-JUL-17 0 7 NOT ACTIVE 6540639642 28-JUL-17 0 8 NOT ACTIVE 6540639642 28-JUL-17 0 9 NOT ACTIVE 6540639642 28-JUL-17 0 10 NOT ACTIVE 6540639642 28-JUL-17 0 11 NOT ACTIVE 6540639642 28-JUL-17 0 12 NOT ACTIVE 6540639642 28-JUL-17 0 13 NOT ACTIVE 6540639642 28-JUL-17 0 14 NOT ACTIVE 6540639642 28-JUL-17 0 15 NOT ACTIVE 6540639642 28-JUL-17 0 16 NOT ACTIVE 6540639642 28-JUL-17 0 17 NOT ACTIVE 6540639642 28-JUL-17 0 18 NOT ACTIVE 6540639642 28-JUL-17 0 19 NOT ACTIVE 6540639642 28-JUL-17 0 20 NOT ACTIVE 6540639642 28-JUL-17 0 21 NOT ACTIVE 6540639642 28-JUL-17 0 22 NOT ACTIVE 6540639642 28-JUL-17 0 23 NOT ACTIVE 6540639642 28-JUL-17 0 24 NOT ACTIVE 6540639642 28-JUL-17 0 25 NOT ACTIVE 6540639642 28-JUL-17 0 26 NOT ACTIVE 6540639642 28-JUL-17 0 27 NOT ACTIVE 6540639642 28-JUL-17 0 28 NOT ACTIVE 6540639642 28-JUL-17 0 29 NOT ACTIVE 6540639642 28-JUL-17 0 30 NOT ACTIVE 6540639642 28-JUL-17 0 31 NOT ACTIVE 6540639642 28-JUL-17 0 32 NOT ACTIVE 6540639642 28-JUL-17 0 33 NOT ACTIVE 6540639642 28-JUL-17 0 34 NOT ACTIVE 6540639642 28-JUL-17 0 35 NOT ACTIVE 6540639642 28-JUL-17 0 36 NOT ACTIVE 6540639642 28-JUL-17 0 37 NOT ACTIVE 6540639642 28-JUL-17 0 38 NOT ACTIVE 6540639642 28-JUL-17 0 39 NOT ACTIVE 6540639642 28-JUL-17 0 40 NOT ACTIVE 6540639642 28-JUL-17 0 41 NOT ACTIVE 6540639642 28-JUL-17 0 42 NOT ACTIVE 6540639642 28-JUL-17 0 43 NOT ACTIVE 6540639642 28-JUL-17 0 44 NOT ACTIVE 6540639642 28-JUL-17 0 45 NOT ACTIVE 6540639642 28-JUL-17 0 46 NOT ACTIVE 6540639642 28-JUL-17 0 47 NOT ACTIVE 6540639642 28-JUL-17 0 48 NOT ACTIVE 6540639642 28-JUL-17 0 49 NOT ACTIVE 6540639642 28-JUL-17 0 50 NOT ACTIVE 6540639642 28-JUL-17 0 51 NOT ACTIVE 6540639642 28-JUL-17 0 52 NOT ACTIVE 6540639642 28-JUL-17 0 FILE# Status CHANGE# TIME CON_ID ---------- ---------- ---------- --------------- ---------- 53 NOT ACTIVE 6540639642 28-JUL-17 0 54 NOT ACTIVE 6540639642 28-JUL-17 0 55 NOT ACTIVE 6540639642 28-JUL-17 0 56 NOT ACTIVE 6540639642 28-JUL-17 0 57 NOT ACTIVE 6540639642 28-JUL-17 0 58 NOT ACTIVE 6540639642 28-JUL-17 0 59 NOT ACTIVE 6540639642 28-JUL-17 0 60 NOT ACTIVE 6540639642 28-JUL-17 0 61 NOT ACTIVE 6540639642 28-JUL-17 0 62 NOT ACTIVE 6540639642 28-JUL-17 0 63 NOT ACTIVE 6540639642 28-JUL-17 0 64 NOT ACTIVE 6540639642 28-JUL-17 0 65 NOT ACTIVE 6540639642 28-JUL-17 0 66 NOT ACTIVE 6540639642 28-JUL-17 0 67 NOT ACTIVE 6540639642 28-JUL-17 0 68 NOT ACTIVE 6540639642 28-JUL-17 0 69 NOT ACTIVE 6540639642 28-JUL-17 0 70 NOT ACTIVE 6540639642 28-JUL-17 0 71 NOT ACTIVE 6540639642 28-JUL-17 0 72 NOT ACTIVE 6540639642 28-JUL-17 0 73 NOT ACTIVE 6540639642 28-JUL-17 0 74 NOT ACTIVE 6540639642 28-JUL-17 0 75 NOT ACTIVE 6540639642 28-JUL-17 0 76 NOT ACTIVE 6540639642 28-JUL-17 0 77 NOT ACTIVE 6540639642 28-JUL-17 0 78 NOT ACTIVE 6540639642 28-JUL-17 0 79 NOT ACTIVE 6540639642 28-JUL-17 0 80 NOT ACTIVE 6540639642 28-JUL-17 0 81 NOT ACTIVE 6540639642 28-JUL-17 0 82 NOT ACTIVE 6540639642 28-JUL-17 0 83 NOT ACTIVE 6540639642 28-JUL-17 0 84 NOT ACTIVE 6540639642 28-JUL-17 0 85 NOT ACTIVE 6540639642 28-JUL-17 0 86 NOT ACTIVE 6540639642 28-JUL-17 0 87 NOT ACTIVE 6540639642 28-JUL-17 0 88 NOT ACTIVE 6540639642 28-JUL-17 0 89 NOT ACTIVE 6540639642 28-JUL-17 0 90 NOT ACTIVE 6540639642 28-JUL-17 0 91 NOT ACTIVE 6540639642 28-JUL-17 0 92 NOT ACTIVE 6540639642 28-JUL-17 0 93 NOT ACTIVE 6540639642 28-JUL-17 0 94 NOT ACTIVE 6540639642 28-JUL-17 0 95 NOT ACTIVE 6540639642 28-JUL-17 0 96 NOT ACTIVE 6540639642 28-JUL-17 0 97 NOT ACTIVE 6540639642 28-JUL-17 0 98 NOT ACTIVE 6540639642 28-JUL-17 0 99 NOT ACTIVE 6540639642 28-JUL-17 0 100 NOT ACTIVE 6540639642 28-JUL-17 0 101 NOT ACTIVE 6540639642 28-JUL-17 0 102 NOT ACTIVE 6540639642 28-JUL-17 0 103 NOT ACTIVE 6540639642 28-JUL-17 0 104 NOT ACTIVE 6540639642 28-JUL-17 0 FILE# Status CHANGE# TIME CON_ID ---------- ---------- ---------- --------------- ---------- 105 NOT ACTIVE 6540639642 28-JUL-17 0 106 NOT ACTIVE 6540639642 28-JUL-17 0 107 NOT ACTIVE 6540639642 28-JUL-17 0 108 NOT ACTIVE 6540639642 28-JUL-17 0 109 NOT ACTIVE 6540639642 28-JUL-17 0 110 NOT ACTIVE 6540639642 28-JUL-17 0 111 NOT ACTIVE 6540639642 28-JUL-17 0 112 NOT ACTIVE 6540639642 28-JUL-17 0 113 NOT ACTIVE 6540639642 28-JUL-17 0 114 NOT ACTIVE 6540639642 28-JUL-17 0 115 NOT ACTIVE 6540639642 28-JUL-17 0 116 NOT ACTIVE 6540639642 28-JUL-17 0 117 NOT ACTIVE 6540639642 28-JUL-17 0 118 NOT ACTIVE 6540639642 28-JUL-17 0 119 NOT ACTIVE 6540639642 28-JUL-17 0 120 NOT ACTIVE 6540639642 28-JUL-17 0 121 NOT ACTIVE 6540639642 28-JUL-17 0 122 NOT ACTIVE 6540639642 28-JUL-17 0 123 NOT ACTIVE 6540639642 28-JUL-17 0 123 rows selected. Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options