[oracle@node1 BACKUP]$ export NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'
[oracle@node1 BACKUP]$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Fri Sep 9 01:49:46 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1449691228)
RMAN> list backup ;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1 Incr 0 1.02M DISK 00:00:01 Sep 08 2016 08:22:01
BP Key: 1 Status: AVAILABLE Compressed: YES Tag: TAG20160908T082159
Piece Name: /data01/BACKUP/orcl_LVL0_02rf9b18_1_1.bak
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
2 0 Incr 1931739 Sep 08 2016 08:14:38 +DATA/ORCL/DATAFILE/sumit.272.921987559
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2 Incr 0 1.09M DISK 00:00:07 Sep 08 2016 08:22:09
BP Key: 2 Status: AVAILABLE Compressed: YES Tag: TAG20160908T082159
Piece Name: /data01/BACKUP/orcl_LVL0_07rf9b1a_1_1.bak
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
6 0 Incr 1931739 Sep 08 2016 08:14:38 +DATA/ORCL/DATAFILE/users.259.921910449
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
3 Incr 0 80.00K DISK 00:00:00 Sep 08 2016 08:22:06
BP Key: 3 Status: AVAILABLE Compressed: YES Tag: TAG20160908T082159
Piece Name: /data01/BACKUP/orcl_LVL0_08rf9b1e_1_1.bak
SPFILE Included: Modification time: Sep 08 2016 08:10:24
SPFILE db_unique_name: ORCL
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
4 Incr 0 16.77M DISK 00:00:12 Sep 08 2016 08:22:13
BP Key: 4 Status: AVAILABLE Compressed: YES Tag: TAG20160908T082159
Piece Name: /data01/BACKUP/orcl_LVL0_05rf9b19_1_1.bak
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
4 0 Incr 1931739 Sep 08 2016 08:14:38 +DATA/ORCL/DATAFILE/undotbs1.260.921910449
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
5 Incr 0 21.41M DISK 00:00:28 Sep 08 2016 08:22:27
BP Key: 5 Status: AVAILABLE Compressed: YES Tag: TAG20160908T082159
Piece Name: /data01/BACKUP/orcl_LVL0_01rf9b17_1_1.bak
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
5 0 Incr 1931739 Sep 08 2016 08:14:38 +DATA/ORCL/DATAFILE/example.270.921910549
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
6 Incr 0 1.03M DISK 00:00:32 Sep 08 2016 08:22:33
BP Key: 6 Status: AVAILABLE Compressed: YES Tag: TAG20160908T082159
Piece Name: /data01/BACKUP/orcl_LVL0_06rf9b19_1_1.bak
Control File Included: Ckp SCN: 1931739 Ckp time: Sep 08 2016 08:14:38
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
7 Incr 0 99.54M DISK 00:00:39 Sep 08 2016 08:22:39
BP Key: 7 Status: AVAILABLE Compressed: YES Tag: TAG20160908T082159
Piece Name: /data01/BACKUP/orcl_LVL0_04rf9b18_1_1.bak
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
3 0 Incr 1931739 Sep 08 2016 08:14:38 +DATA/ORCL/DATAFILE/sysaux.257.921910247
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
8 Incr 0 204.73M DISK 00:00:54 Sep 08 2016 08:22:54
BP Key: 8 Status: AVAILABLE Compressed: YES Tag: TAG20160908T082159
Piece Name: /data01/BACKUP/orcl_LVL0_03rf9b18_1_1.bak
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 0 Incr 1931739 Sep 08 2016 08:14:38 +DATA/ORCL/DATAFILE/system.258.921910333
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
9 Incr 0 1.02M DISK 00:00:00 Sep 08 2016 12:07:06
BP Key: 9 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120704
Piece Name: /data01/BACKUP/orcl_LVL0_0brf9o7a_1_1.bak
List of Datafiles in backup set 9
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
2 0 Incr 1942586 Sep 08 2016 12:07:06 +DATA/ORCL/DATAFILE/sumit.272.921987559
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
10 Incr 0 80.00K DISK 00:00:04 Sep 08 2016 12:07:25
BP Key: 10 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120704
Piece Name: /data01/BACKUP/orcl_LVL0_0hrf9o7p_1_1.bak
SPFILE Included: Modification time: Sep 08 2016 12:06:36
SPFILE db_unique_name: ORCL
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
11 Incr 0 1.40M DISK 00:00:22 Sep 08 2016 12:07:28
BP Key: 11 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120704
Piece Name: /data01/BACKUP/orcl_LVL0_0erf9o7a_1_1.bak
List of Datafiles in backup set 11
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
4 0 Incr 1942590 Sep 08 2016 12:07:07 +DATA/ORCL/DATAFILE/undotbs1.260.921910449
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
12 Incr 0 21.41M DISK 00:00:25 Sep 08 2016 12:07:30
BP Key: 12 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120704
Piece Name: /data01/BACKUP/orcl_LVL0_0arf9o79_1_1.bak
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
5 0 Incr 1942587 Sep 08 2016 12:07:06 +DATA/ORCL/DATAFILE/example.270.921910549
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13 Incr 0 1.09M DISK 00:00:25 Sep 08 2016 12:07:40
BP Key: 13 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120704
Piece Name: /data01/BACKUP/orcl_LVL0_0grf9o7j_1_1.bak
List of Datafiles in backup set 13
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
6 0 Incr 1942599 Sep 08 2016 12:07:30 +DATA/ORCL/DATAFILE/users.259.921910449
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
14 Incr 0 1.03M DISK 00:00:37 Sep 08 2016 12:07:48
BP Key: 14 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120704
Piece Name: /data01/BACKUP/orcl_LVL0_0frf9o7f_1_1.bak
Control File Included: Ckp SCN: 1942593 Ckp time: Sep 08 2016 12:07:15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
15 Incr 0 99.77M DISK 00:00:44 Sep 08 2016 12:07:50
BP Key: 15 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120704
Piece Name: /data01/BACKUP/orcl_LVL0_0drf9o7a_1_1.bak
List of Datafiles in backup set 15
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
3 0 Incr 1942589 Sep 08 2016 12:07:06 +DATA/ORCL/DATAFILE/sysaux.257.921910247
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
16 Incr 0 204.66M DISK 00:00:55 Sep 08 2016 12:08:01
BP Key: 16 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120704
Piece Name: /data01/BACKUP/orcl_LVL0_0crf9o7a_1_1.bak
List of Datafiles in backup set 16
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 0 Incr 1942588 Sep 08 2016 12:07:06 +DATA/ORCL/DATAFILE/system.258.921910333
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
17 8.94M DISK 00:00:01 Sep 08 2016 12:08:14
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20160908T120812
Piece Name: /data01/BACKUP/orcl_arch_0irf9o9d_1_1.bak
List of Archived Logs in backup set 17
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 8 1930443 Sep 08 2016 08:08:06 1942733 Sep 08 2016 12:08:08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
18 Incr 0 1.02M DISK 00:00:01 Sep 08 2016 12:09:44
BP Key: 18 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120942
Piece Name: /data01/BACKUP/orcl_LVL0_0lrf9oc7_1_1.bak
List of Datafiles in backup set 18
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
2 0 Incr 1943154 Sep 08 2016 12:09:43 +DATA/ORCL/DATAFILE/sumit.272.921987559
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
19 Incr 0 80.00K DISK 00:00:00 Sep 08 2016 12:09:55
BP Key: 19 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120942
Piece Name: /data01/BACKUP/orcl_LVL0_0rrf9ocj_1_1.bak
SPFILE Included: Modification time: Sep 08 2016 12:09:49
SPFILE db_unique_name: ORCL
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
20 Incr 0 1.41M DISK 00:00:16 Sep 08 2016 12:10:00
BP Key: 20 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120942
Piece Name: /data01/BACKUP/orcl_LVL0_0orf9oc8_1_1.bak
List of Datafiles in backup set 20
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
4 0 Incr 1943158 Sep 08 2016 12:09:45 +DATA/ORCL/DATAFILE/undotbs1.260.921910449
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
21 Incr 0 21.41M DISK 00:00:35 Sep 08 2016 12:10:18
BP Key: 21 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120942
Piece Name: /data01/BACKUP/orcl_LVL0_0krf9oc7_1_1.bak
List of Datafiles in backup set 21
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
5 0 Incr 1943153 Sep 08 2016 12:09:43 +DATA/ORCL/DATAFILE/example.270.921910549
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
22 Incr 0 1.03M DISK 00:00:37 Sep 08 2016 12:10:21
BP Key: 22 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120942
Piece Name: /data01/BACKUP/orcl_LVL0_0prf9oc8_1_1.bak
Control File Included: Ckp SCN: 1943156 Ckp time: Sep 08 2016 12:09:44
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
23 Incr 0 99.80M DISK 00:00:45 Sep 08 2016 12:10:28
BP Key: 23 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120942
Piece Name: /data01/BACKUP/orcl_LVL0_0nrf9oc7_1_1.bak
List of Datafiles in backup set 23
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
3 0 Incr 1943156 Sep 08 2016 12:09:44 +DATA/ORCL/DATAFILE/sysaux.257.921910247
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
24 Incr 0 1.09M DISK 00:00:45 Sep 08 2016 12:10:29
BP Key: 24 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120942
Piece Name: /data01/BACKUP/orcl_LVL0_0qrf9oc8_1_1.bak
List of Datafiles in backup set 24
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
6 0 Incr 1943169 Sep 08 2016 12:09:56 +DATA/ORCL/DATAFILE/users.259.921910449
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
25 Incr 0 204.66M DISK 00:00:51 Sep 08 2016 12:10:34
BP Key: 25 Status: AVAILABLE Compressed: YES Tag: TAG20160908T120942
Piece Name: /data01/BACKUP/orcl_LVL0_0mrf9oc7_1_1.bak
List of Datafiles in backup set 25
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 0 Incr 1943155 Sep 08 2016 12:09:43 +DATA/ORCL/DATAFILE/system.258.921910333
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
26 136.50K DISK 00:00:01 Sep 08 2016 12:10:46
BP Key: 26 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_0trf9oe5_1_1.bak
List of Archived Logs in backup set 26
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 9 1942733 Sep 08 2016 12:08:08 1943057 Sep 08 2016 12:09:28
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
27 9.50K DISK 00:00:00 Sep 08 2016 12:10:46
BP Key: 27 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_0urf9oe6_1_1.bak
List of Archived Logs in backup set 27
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 13 1943066 Sep 08 2016 12:09:34 1943226 Sep 08 2016 12:10:44
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
28 8.94M DISK 00:00:01 Sep 08 2016 12:10:46
BP Key: 28 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_0srf9oe5_1_1.bak
List of Archived Logs in backup set 28
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 8 1930443 Sep 08 2016 08:08:06 1942733 Sep 08 2016 12:08:08
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
29 3.50K DISK 00:00:00 Sep 08 2016 12:10:46
BP Key: 29 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_0vrf9oe6_1_1.bak
List of Archived Logs in backup set 29
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 10 1943057 Sep 08 2016 12:09:28 1943060 Sep 08 2016 12:09:30
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
30 3.00K DISK 00:00:00 Sep 08 2016 12:10:46
BP Key: 30 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_10rf9oe6_1_1.bak
List of Archived Logs in backup set 30
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 11 1943060 Sep 08 2016 12:09:30 1943063 Sep 08 2016 12:09:33
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
31 2.50K DISK 00:00:00 Sep 08 2016 12:10:46
BP Key: 31 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_11rf9oe6_1_1.bak
List of Archived Logs in backup set 31
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 12 1943063 Sep 08 2016 12:09:33 1943066 Sep 08 2016 12:09:34
RMAN> list backup of archivelog all ;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
17 8.94M DISK 00:00:01 Sep 08 2016 12:08:14
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20160908T120812
Piece Name: /data01/BACKUP/orcl_arch_0irf9o9d_1_1.bak
List of Archived Logs in backup set 17
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 8 1930443 Sep 08 2016 08:08:06 1942733 Sep 08 2016 12:08:08
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
26 136.50K DISK 00:00:01 Sep 08 2016 12:10:46
BP Key: 26 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_0trf9oe5_1_1.bak
List of Archived Logs in backup set 26
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 9 1942733 Sep 08 2016 12:08:08 1943057 Sep 08 2016 12:09:28
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
27 9.50K DISK 00:00:00 Sep 08 2016 12:10:46
BP Key: 27 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_0urf9oe6_1_1.bak
List of Archived Logs in backup set 27
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 13 1943066 Sep 08 2016 12:09:34 1943226 Sep 08 2016 12:10:44
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
28 8.94M DISK 00:00:01 Sep 08 2016 12:10:46
BP Key: 28 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_0srf9oe5_1_1.bak
List of Archived Logs in backup set 28
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 8 1930443 Sep 08 2016 08:08:06 1942733 Sep 08 2016 12:08:08
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
29 3.50K DISK 00:00:00 Sep 08 2016 12:10:46
BP Key: 29 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_0vrf9oe6_1_1.bak
List of Archived Logs in backup set 29
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 10 1943057 Sep 08 2016 12:09:28 1943060 Sep 08 2016 12:09:30
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
30 3.00K DISK 00:00:00 Sep 08 2016 12:10:46
BP Key: 30 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_10rf9oe6_1_1.bak
List of Archived Logs in backup set 30
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 11 1943060 Sep 08 2016 12:09:30 1943063 Sep 08 2016 12:09:33
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
31 2.50K DISK 00:00:00 Sep 08 2016 12:10:46
BP Key: 31 Status: AVAILABLE Compressed: NO Tag: TAG20160908T121045
Piece Name: /data01/BACKUP/orcl_arch_11rf9oe6_1_1.bak
List of Archived Logs in backup set 31
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 12 1943063 Sep 08 2016 12:09:33 1943066 Sep 08 2016 12:09:34
[oracle@node1 BACKUP]$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 8 08:43:06 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1449691228, not open)
RMAN> report schema ;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 790 SYSTEM *** +DATA/ORCL/DATAFILE/system.258.921910333
2 1024 SUMIT *** +DATA/ORCL/DATAFILE/sumit.272.921987559
3 610 SYSAUX *** +DATA/ORCL/DATAFILE/sysaux.257.921910247
4 80 UNDOTBS1 *** +DATA/ORCL/DATAFILE/undotbs1.260.921910449
5 1243 EXAMPLE *** +DATA/ORCL/DATAFILE/example.270.921910549
6 5 USERS *** +DATA/ORCL/DATAFILE/users.259.921910449
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 60 TEMP 32767 +DATA/ORCL/TEMPFILE/temp.269.921910529
2. Add TNS entry for UAT in ORCL and ORCL entry in UAT .
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
UAT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = uat)
)
)
3) Copy Password File from ORCL to UAT and rename it to orapw$ORACLE_SID
4.) Add static entry of UAT is listener file ( grid )
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = uat)
(ORACLE_HOME = /data01/app/oracle/product/11g/db_1)
(SID_NAME = uat)
)
)
[grid@node2 admin]$ lsnrctl reload
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 08-SEP-2016 09:15:09
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node2.localdomain)(PORT=1521)))
The command completed successfully
[grid@node2 admin]$ lsnrctl services
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 08-SEP-2016 09:15:16
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node2.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "uat" has 1 instance(s).
Instance "uat", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
5.)Verify TNS Connectivity to UAT from PROD
[oracle@node1 dbs]$ sqlplus sys/xxxxx@uat as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 8 09:52:19 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
6.) start UAT on node2
[oracle@node2 dbs]$
mkdir -p /data01/app/oracle/admin/uat/adump
mkdir -p /data01/app/oracle/admin/orcl/adump
SQL> cat inituat.ora
db_name='uat'
[oracle@node2 dbs]$ export ORACLE_SID=uat
[oracle@node2 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 8 10:12:07 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount ;
ORACLE instance started.
Total System Global Area 218103808 bytes
Fixed Size 2922712 bytes
Variable Size 159385384 bytes
Database Buffers 50331648 bytes
Redo Buffers 5464064 bytes
SQL> show parameter db_name ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string uat
7) Connect RMAN to Target (orcl) and Auxiliary (uat) using TNS
[oracle@node2 dbs]$ rman auxiliary / | tee rman_duplicate_achive.log
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 8 12:24:07 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: UAT (not mounted)
RMAN>
echo set on
RMAN> @rman_duplicate.cmd
RMAN> run {
duplicate database to uat
spfile
parameter_value_convert ('ORCL','UAT')
set control_files='+UAT_DATA'
set db_file_name_convert='+DATA','+UAT_DATA'
set log_file_name_convert='+DATA','+UAT_DATA'
set db_name='uat'
BACKUP LOCATION '/data01/BACKUP_NODE2/' ;
}
Starting Duplicate Db at 08-SEP-2016 12:24:32
contents of Memory Script:
{
restore clone spfile to '/data01/app/oracle/product/11g/db_1/dbs/spfileuat.ora' from
'/data01/BACKUP_NODE2/orcl_LVL0_0rrf9ocj_1_1.bak';
sql clone "alter system set spfile= ''/data01/app/oracle/product/11g/db_1/dbs/spfileuat.ora''";
}
executing Memory Script
Starting restore at 08-SEP-2016 12:24:32
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=22 device type=DISK
channel ORA_AUX_DISK_1: restoring spfile from AUTOBACKUP /data01/BACKUP_NODE2/orcl_LVL0_0rrf9ocj_1_1.bak
channel ORA_AUX_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 08-SEP-2016 12:24:33
sql statement: alter system set spfile= ''/data01/app/oracle/product/11g/db_1/dbs/spfileuat.ora''
contents of Memory Script:
{
sql clone "alter system set db_name =
''UAT'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set control_files =
''+UAT_DATA'' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''+DATA'', ''+UAT_DATA'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''+DATA'', ''+UAT_DATA'' comment=
'''' scope=spfile";
sql clone "alter system set db_name =
''uat'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''UAT'' comment= ''duplicate'' scope=spfile
sql statement: alter system set control_files = ''+UAT_DATA'' comment= '''' scope=spfile
sql statement: alter system set db_file_name_convert = ''+DATA'', ''+UAT_DATA'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''+DATA'', ''+UAT_DATA'' comment= '''' scope=spfile
sql statement: alter system set db_name = ''uat'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 515899392 bytes
Fixed Size 2926224 bytes
Variable Size 436210032 bytes
Database Buffers 71303168 bytes
Redo Buffers 5459968 bytes
contents of Memory Script:
{
sql clone "alter system set control_files =
''+UAT_DATA/UAT/CONTROLFILE/current.256.922019095'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''UAT'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile from '/data01/BACKUP_NODE2/orcl_LVL0_0prf9oc8_1_1.bak';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set control_files = ''+UAT_DATA/UAT/CONTROLFILE/current.256.922019095'' comment= ''Set by RMAN'' scope=spfile
sql statement: alter system set db_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''UAT'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 515899392 bytes
Fixed Size 2926224 bytes
Variable Size 436210032 bytes
Database Buffers 71303168 bytes
Redo Buffers 5459968 bytes
Starting restore at 08-SEP-2016 12:25:21
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=28 device type=DISK
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
output file name=+UAT_DATA/UAT/CONTROLFILE/current.256.922019095
Finished restore at 08-SEP-2016 12:25:24
database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=28 device type=DISK
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
contents of Memory Script:
{
set until scn 1943226;
set newname for datafile 1 to
"+UAT_DATA";
set newname for datafile 2 to
"+UAT_DATA";
set newname for datafile 3 to
"+UAT_DATA";
set newname for datafile 4 to
"+UAT_DATA";
set newname for datafile 5 to
"+UAT_DATA";
set newname for datafile 6 to
"+UAT_DATA";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 08-SEP-2016 12:25:30
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +UAT_DATA
channel ORA_AUX_DISK_1: reading from backup piece /data01/BACKUP_NODE2/orcl_LVL0_0mrf9oc7_1_1.bak
channel ORA_AUX_DISK_1: piece handle=/data01/BACKUP_NODE2/orcl_LVL0_0mrf9oc7_1_1.bak tag=TAG20160908T120942
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00002 to +UAT_DATA
channel ORA_AUX_DISK_1: reading from backup piece /data01/BACKUP_NODE2/orcl_LVL0_0lrf9oc7_1_1.bak
channel ORA_AUX_DISK_1: piece handle=/data01/BACKUP_NODE2/orcl_LVL0_0lrf9oc7_1_1.bak tag=TAG20160908T120942
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to +UAT_DATA
channel ORA_AUX_DISK_1: reading from backup piece /data01/BACKUP_NODE2/orcl_LVL0_0orf9oc8_1_1.bak
channel ORA_AUX_DISK_1: piece handle=/data01/BACKUP_NODE2/orcl_LVL0_0orf9oc8_1_1.bak tag=TAG20160908T120942
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to +UAT_DATA
channel ORA_AUX_DISK_1: reading from backup piece /data01/BACKUP_NODE2/orcl_LVL0_0krf9oc7_1_1.bak
channel ORA_AUX_DISK_1: piece handle=/data01/BACKUP_NODE2/orcl_LVL0_0krf9oc7_1_1.bak tag=TAG20160908T120942
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00006 to +UAT_DATA
channel ORA_AUX_DISK_1: reading from backup piece /data01/BACKUP_NODE2/orcl_LVL0_0qrf9oc8_1_1.bak
channel ORA_AUX_DISK_1: piece handle=/data01/BACKUP_NODE2/orcl_LVL0_0qrf9oc8_1_1.bak tag=TAG20160908T120942
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to +UAT_DATA
channel ORA_AUX_DISK_1: reading from backup piece /data01/BACKUP_NODE2/orcl_LVL0_0nrf9oc7_1_1.bak
channel ORA_AUX_DISK_1: piece handle=/data01/BACKUP_NODE2/orcl_LVL0_0nrf9oc7_1_1.bak tag=TAG20160908T120942
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 08-SEP-2016 12:28:25
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=8 STAMP=922019305 file name=+UAT_DATA/UAT/DATAFILE/system.263.922019131
datafile 2 switched to datafile copy
input datafile copy RECID=9 STAMP=922019306 file name=+UAT_DATA/UAT/DATAFILE/sumit.262.922019197
datafile 3 switched to datafile copy
input datafile copy RECID=10 STAMP=922019306 file name=+UAT_DATA/UAT/DATAFILE/sysaux.257.922019261
datafile 4 switched to datafile copy
input datafile copy RECID=11 STAMP=922019306 file name=+UAT_DATA/UAT/DATAFILE/undotbs1.259.922019221
datafile 5 switched to datafile copy
input datafile copy RECID=12 STAMP=922019306 file name=+UAT_DATA/UAT/DATAFILE/example.261.922019225
datafile 6 switched to datafile copy
input datafile copy RECID=13 STAMP=922019306 file name=+UAT_DATA/UAT/DATAFILE/users.258.922019259
contents of Memory Script:
{
set until scn 1943226;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 08-SEP-2016 12:28:26
using channel ORA_AUX_DISK_1
starting media recovery
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=13
channel ORA_AUX_DISK_1: reading from backup piece /data01/BACKUP_NODE2/orcl_arch_0urf9oe6_1_1.bak
channel ORA_AUX_DISK_1: piece handle=/data01/BACKUP_NODE2/orcl_arch_0urf9oe6_1_1.bak tag=TAG20160908T121045
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
archived log file name=+FRA/UAT/ARCHIVELOG/2016_09_08/thread_1_seq_13.256.922019317 thread=1 sequence=13
channel clone_default: deleting archived log(s)
archived log file name=+FRA/UAT/ARCHIVELOG/2016_09_08/thread_1_seq_13.256.922019317 RECID=1 STAMP=922019317
media recovery complete, elapsed time: 00:00:01
Finished recover at 08-SEP-2016 12:28:39
Oracle instance started
Total System Global Area 515899392 bytes
Fixed Size 2926224 bytes
Variable Size 436210032 bytes
Database Buffers 71303168 bytes
Redo Buffers 5459968 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''UAT'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
}
executing Memory Script
sql statement: alter system set db_name = ''UAT'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started
Total System Global Area 515899392 bytes
Fixed Size 2926224 bytes
Variable Size 436210032 bytes
Database Buffers 71303168 bytes
Redo Buffers 5459968 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "UAT" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '+UAT_DATA', '+UAT_DATA' ) SIZE 50 M REUSE,
GROUP 2 ( '+UAT_DATA', '+UAT_DATA' ) SIZE 50 M REUSE,
GROUP 3 ( '+UAT_DATA', '+UAT_DATA' ) SIZE 50 M REUSE
DATAFILE
'+UAT_DATA/UAT/DATAFILE/system.263.922019131'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
set newname for tempfile 1 to
"+UAT_DATA";
switch clone tempfile all;
catalog clone datafilecopy "+UAT_DATA/UAT/DATAFILE/sumit.262.922019197",
"+UAT_DATA/UAT/DATAFILE/sysaux.257.922019261",
"+UAT_DATA/UAT/DATAFILE/undotbs1.259.922019221",
"+UAT_DATA/UAT/DATAFILE/example.261.922019225",
"+UAT_DATA/UAT/DATAFILE/users.258.922019259";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to +UAT_DATA in control file
cataloged datafile copy
datafile copy file name=+UAT_DATA/UAT/DATAFILE/sumit.262.922019197 RECID=1 STAMP=922019343
cataloged datafile copy
datafile copy file name=+UAT_DATA/UAT/DATAFILE/sysaux.257.922019261 RECID=2 STAMP=922019343
cataloged datafile copy
datafile copy file name=+UAT_DATA/UAT/DATAFILE/undotbs1.259.922019221 RECID=3 STAMP=922019343
cataloged datafile copy
datafile copy file name=+UAT_DATA/UAT/DATAFILE/example.261.922019225 RECID=4 STAMP=922019343
cataloged datafile copy
datafile copy file name=+UAT_DATA/UAT/DATAFILE/users.258.922019259 RECID=5 STAMP=922019343
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=922019343 file name=+UAT_DATA/UAT/DATAFILE/sumit.262.922019197
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=922019343 file name=+UAT_DATA/UAT/DATAFILE/sysaux.257.922019261
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=922019343 file name=+UAT_DATA/UAT/DATAFILE/undotbs1.259.922019221
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=922019343 file name=+UAT_DATA/UAT/DATAFILE/example.261.922019225
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=922019343 file name=+UAT_DATA/UAT/DATAFILE/users.258.922019259
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 08-SEP-2016 12:29:49
Jadwal Sabung Ayam Online SV388 11 Februari 2019 - Senin, 11 Februari 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.
ReplyDeleteSitus Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.
Untuk Info Lebih Lanjut Bisa Hub kami Di :
wechat : bolavita
line : cs_bolavita
whatsapp : +628122222995
BBM: BOLAVITA