SQL> ALTER SYSTEM ARCHIVE LOG current; System altered. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 34 Next log sequence to archive 36 Current log sequence 36 SQL> ALTER SYSTEM ARCHIVE LOG current; System altered. SQL> RMAN> list backup of archivelog sequence 36; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958357 9.00K SBT_TAPE 00:00:00 2019-10-18_22-41-45 BP Key: 50958358 Status: AVAILABLE Compressed: YES Tag: TAG20191018T224145 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_36_CTKEY_50958350_BACKUP Media: List of Archived Logs in backup set 50958357 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 36 1127680 2019-10-18_22-41-24 1127704 2019-10-18_22-41-33 RMAN> list backup of archivelog sequence 37; specification does not match any backup in the repository RMAN> [oracle@exac1vm01-ORAD18]$ for i in {1..100000} > do > echo "Insert Data $i - `date +%d-%m-%Y-%H%M%S`" > sqlplus -s / as sysdba< set heading on feedback on; > insert into testIns(c1, c2, c3) values ($i, sysdate, 'Loop'); > commit; > EOF > done Insert Data 1 - 18-10-2019-224237 1 row created. Commit complete. Insert Data 2 - 18-10-2019-224237 1 row created. ... ... Insert Data 89 - 18-10-2019-224247 1 row created. Commit complete. Insert Data 90 - 18-10-2019-224247 1 row created. Commit complete. ... [oracle@exac1vm01-ORAD18]$ [oracle@exac1vm01-ORAD18]$ [oracle@exac1vm01-ORAD18]$ ps -ef |grep pmon_ORAD18 oracle 31646 1 0 22:27 ? 00:00:00 ora_pmon_ORAD18 oracle 37116 396809 0 22:29 pts/2 00:00:00 grep pmon_ORAD18 [oracle@exac1vm01-ORAD18]$ ps -ef |grep smon_ORAD18 oracle 31731 1 0 22:27 ? 00:00:00 ora_smon_ORAD18 oracle 37213 396809 0 22:29 pts/2 00:00:00 grep smon_ORAD18 [oracle@exac1vm01-ORAD18]$ ps -ef |grep lgwr_ORAD18 oracle 31724 1 0 22:27 ? 00:00:00 ora_lgwr_ORAD18 oracle 37245 396809 0 22:29 pts/2 00:00:00 grep lgwr_ORAD18 [oracle@exac1vm01-ORAD18]$ ps -ef |grep dbw0_ORAD18 oracle 31722 1 0 22:27 ? 00:00:00 ora_dbw0_ORAD18 oracle 40104 396809 0 22:29 pts/2 00:00:00 grep dbw0_ORAD18 [oracle@exac1vm01-ORAD18]$ ps -ef |grep arc* |grep ORAD18 oracle 31805 1 0 22:27 ? 00:00:00 ora_mark_ORAD18 oracle 32021 1 0 22:27 ? 00:00:00 ora_arc0_ORAD18 oracle 32042 1 0 22:27 ? 00:00:00 ora_arc1_ORAD18 oracle 32050 1 0 22:27 ? 00:00:00 ora_arc2_ORAD18 oracle 32057 1 0 22:27 ? 00:00:00 ora_arc3_ORAD18 [oracle@exac1vm01-ORAD18]$ [oracle@exac1vm01-ORAD18]$ [oracle@exac1vm01-ORAD18]$ [oracle@exac1vm01-ORAD18]$ date Fri Oct 18 22:30:32 CEST 2019 [oracle@exac1vm01-ORAD18]$ kill -9 31646 31731 31724 31722 32021 32042 32050 32057 [oracle@exac1vm01-ORAD18]$ ... ... Insert Data 955 - 18-10-2019-224429 1 row created. Commit complete. Insert Data 956 - 18-10-2019-224429 1 row created. Commit complete. Insert Data 957 - 18-10-2019-224429 1 row created. commit * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 77603 Session ID: 27 Serial number: 7933 Insert Data 958 - 18-10-2019-224441 ... ASMCMD> cd +DATAC1/ORAD18/ ASMCMD> ls -l Type Redund Striped Time Sys Name Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y PARAMETERFILE/ Y TEMPFILE/ ASMCMD> rm -rf CONTROLFILE/ ASMCMD> rm -rf DATAFILE/ ASMCMD> rm -rf ONLINELOG/ ASMCMD> rm -rf TEMPFILE/ ASMCMD> cd +RECOC1/ORAD18/ ASMCMD> ls -l Type Redund Striped Time Sys Name Y ARCHIVELOG/ Y AUTOBACKUP/ Y CONTROLFILE/ Y ONLINELOG/ ASMCMD> rm -rf ARCHIVELOG/ ASMCMD> rm -rf AUTOBACKUP/ ASMCMD> rm -rf CONTROLFILE/ ASMCMD> rm -rf ONLINELOG/ ASMCMD> [oracle@exac1vm01-ORAD18]$ rman target / catalog vpcusr/welcome1@zeros1ig-scan:1521/zeros1:dedicated Recovery Manager: Release 18.0.0.0.0 - Production on Fri Oct 18 22:50:52 2019 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. connected to target database (not started) connected to recovery catalog database RMAN> startup nomount; Oracle instance started Total System Global Area 2147480376 bytes Fixed Size 8659768 bytes Variable Size 671088640 bytes Database Buffers 1459617792 bytes Redo Buffers 8114176 bytes RMAN> list backup of controlfile completed after "sysdate - 40/1440"; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957674 Full 50.00M SBT_TAPE 00:00:01 2019-10-18_22-11-52 BP Key: 50957675 Status: AVAILABLE Compressed: NO Tag: TAG20191018T221151 Handle: c-2464352672-20191018-04 Media: Recovery Appliance (ZDLRAK) Control File Included: Ckp SCN: 820662 Ckp time: 2019-10-18_22-11-51 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957752 Full 50.00M SBT_TAPE 00:00:00 2019-10-18_22-12-03 BP Key: 50957753 Status: AVAILABLE Compressed: NO Tag: TAG20191018T221203 Handle: c-2464352672-20191018-05 Media: Recovery Appliance (ZDLRAK) Control File Included: Ckp SCN: 820763 Ckp time: 2022-10-18_22-12-03 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957831 Full 50.00M SBT_TAPE 00:00:00 2019-10-18_22-12-23 BP Key: 50957832 Status: AVAILABLE Compressed: NO Tag: TAG20191018T221223 Handle: c-2464352672-20191018-06 Media: Recovery Appliance (ZDLRAK) Control File Included: Ckp SCN: 820893 Ckp time: 2019-10-18_22-12-23 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957913 Full 50.00M SBT_TAPE 00:00:01 2019-10-18_22-12-45 BP Key: 50957914 Status: AVAILABLE Compressed: NO Tag: TAG20191018T221244 Handle: c-2464352672-20191018-07 Media: Recovery Appliance (ZDLRAK) Control File Included: Ckp SCN: 821010 Ckp time: 2019-10-18_22-12-44 RMAN> RMAN> restore controlfile from tag = TAG20191018T221244; Starting restore at 2019-10-18_22-52-40 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=30 device type=DISK allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=414 device type=SBT_TAPE channel ORA_SBT_TAPE_1: RA Library (ZDLRAK) SID=95340023A28A7E7DE0538C43B20A715C channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: restoring control file channel ORA_SBT_TAPE_1: reading from backup piece c-2464352672-20191018-07 channel ORA_SBT_TAPE_1: piece handle=c-2464352672-20191018-07 tag=TAG20191018T221244 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:04 output file name=+DATAC1/ORAD18/CONTROLFILE/current.896.1022010765 output file name=+RECOC1/ORAD18/CONTROLFILE/current.965.1022010765 Finished restore at 2019-10-18_22-52-47 RMAN> RMAN> list backup of database completed after "sysdate - 45/1440"; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957689 Incr 1 40.00K SBT_TAPE 00:00:00 2019-10-18_22-11-49 BP Key: 50957690 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957678I Media: List of Datafiles in backup set 50957689 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 1 Incr 820644 2019-10-18_22-11-49 NO +DATAC1/ORAD18/DATAFILE/users.894.1022003695 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957699 Incr 0 40.00K SBT_TAPE 00:00:00 2019-10-18_22-11-49 BP Key: 50957700 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957678_4 Media: List of Datafiles in backup set 50957699 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 0 Incr 820644 2019-10-18_22-11-49 NO +DATAC1/ORAD18/DATAFILE/users.894.1022003695 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957714 Incr 1 160.00K SBT_TAPE 00:00:00 2019-10-18_22-11-47 BP Key: 50957715 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957704I Media: List of Datafiles in backup set 50957714 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 1 Incr 820638 2019-10-18_22-11-47 NO +DATAC1/ORAD18/DATAFILE/system.920.1022003683 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957718 Incr 0 249.41M SBT_TAPE 00:00:00 2019-10-18_22-11-47 BP Key: 50957719 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957704_1 Media: List of Datafiles in backup set 50957718 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 0 Incr 820638 2019-10-18_22-11-47 NO +DATAC1/ORAD18/DATAFILE/system.920.1022003683 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957743 Incr 1 216.00K SBT_TAPE 00:00:01 2019-10-18_22-11-46 BP Key: 50957744 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957728I Media: List of Datafiles in backup set 50957743 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 1 Incr 820636 2019-10-18_22-11-46 NO +DATAC1/ORAD18/DATAFILE/undotbs1.901.1022003687 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957747 Incr 0 256.00K SBT_TAPE 00:00:01 2019-10-18_22-11-46 BP Key: 50957748 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957728_3 Media: List of Datafiles in backup set 50957747 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 0 Incr 820636 2019-10-18_22-11-46 NO +DATAC1/ORAD18/DATAFILE/undotbs1.901.1022003687 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957780 Incr 1 648.00K SBT_TAPE 00:00:00 2019-10-18_22-11-48 BP Key: 50957781 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957771I Media: List of Datafiles in backup set 50957780 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 2 1 Incr 820642 2019-10-18_22-11-48 NO +DATAC1/ORAD18/DATAFILE/sysaux.918.1022003687 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957784 Incr 0 92.07M SBT_TAPE 00:00:00 2019-10-18_22-11-48 BP Key: 50957785 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957771_2 Media: List of Datafiles in backup set 50957784 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 2 0 Incr 820642 2019-10-18_22-11-48 NO +DATAC1/ORAD18/DATAFILE/sysaux.918.1022003687 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957918 Incr 1 40.00K SBT_TAPE 00:00:00 2019-10-18_22-12-41 BP Key: 50957919 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957917I Media: List of Datafiles in backup set 50957918 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 2 1 Incr 820990 2019-10-18_22-12-41 NO +DATAC1/ORAD18/DATAFILE/sysaux.918.1022003687 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957922 Incr 0 92.07M SBT_TAPE 00:00:00 2019-10-18_22-12-41 BP Key: 50957923 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957917_2 Media: List of Datafiles in backup set 50957922 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 2 0 Incr 820990 2019-10-18_22-12-41 NO +DATAC1/ORAD18/DATAFILE/sysaux.918.1022003687 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957956 Incr 1 40.00K SBT_TAPE 00:00:00 2019-10-18_22-12-42 BP Key: 50957957 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957954I Media: List of Datafiles in backup set 50957956 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 1 Incr 820992 2019-10-18_22-12-42 NO +DATAC1/ORAD18/DATAFILE/users.894.1022003695 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957960 Incr 1 40.00K SBT_TAPE 00:00:00 2019-10-18_22-12-39 BP Key: 50957961 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957955I Media: List of Datafiles in backup set 50957960 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 1 Incr 820985 2019-10-18_22-12-39 NO +DATAC1/ORAD18/DATAFILE/undotbs1.901.1022003687 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957964 Incr 0 40.00K SBT_TAPE 00:00:00 2019-10-18_22-12-42 BP Key: 50957965 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957954_4 Media: List of Datafiles in backup set 50957964 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 4 0 Incr 820992 2019-10-18_22-12-42 NO +DATAC1/ORAD18/DATAFILE/users.894.1022003695 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957968 Incr 0 256.00K SBT_TAPE 00:00:00 2019-10-18_22-12-39 BP Key: 50957969 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957955_3 Media: List of Datafiles in backup set 50957968 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 3 0 Incr 820985 2019-10-18_22-12-39 NO +DATAC1/ORAD18/DATAFILE/undotbs1.901.1022003687 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957973 Incr 1 40.00K SBT_TAPE 00:00:00 2019-10-18_22-12-40 BP Key: 50957974 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957972I Media: List of Datafiles in backup set 50957973 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 1 Incr 820987 2019-10-18_22-12-40 NO +DATAC1/ORAD18/DATAFILE/system.920.1022003683 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 50957977 Incr 0 249.41M SBT_TAPE 00:00:00 2019-10-18_22-12-40 BP Key: 50957978 Status: AVAILABLE Compressed: YES Tag: BKP-LEVEL0 Handle: VB$_1965521110_50957972_1 Media: List of Datafiles in backup set 50957977 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- ------------------- ----------- ------ ---- 1 0 Incr 820987 2019-10-18_22-12-40 NO +DATAC1/ORAD18/DATAFILE/system.920.1022003683 RMAN> RMAN> list backup of archivelog all completed after "sysdate - 40/1440"; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958022 44.00K SBT_TAPE 00:00:00 2019-10-18_22-15-17 BP Key: 50958023 Status: AVAILABLE Compressed: YES Tag: TAG20191018T221517 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_24_CTKEY_50958015_BACKUP Media: List of Archived Logs in backup set 50958022 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 24 821214 2019-10-18_22-13-48 821385 2019-10-18_22-15-06 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958057 2.78M SBT_TAPE 00:00:00 2019-10-18_22-19-30 BP Key: 50958058 Status: AVAILABLE Compressed: YES Tag: TAG20191018T221930 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_25_CTKEY_50958054_BACKUP Media: List of Archived Logs in backup set 50958057 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 25 821385 2019-10-18_22-15-06 922323 2019-10-18_22-19-21 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958067 1.16M SBT_TAPE 00:00:00 2019-10-18_22-21-31 BP Key: 50958068 Status: AVAILABLE Compressed: YES Tag: TAG20191018T222131 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_26_CTKEY_50958065_BACKUP Media: List of Archived Logs in backup set 50958067 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 26 922323 2019-10-18_22-19-21 923134 2019-10-18_22-21-07 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958072 1.11M SBT_TAPE 00:00:00 2019-10-18_22-21-58 BP Key: 50958073 Status: AVAILABLE Compressed: YES Tag: TAG20191018T222158 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_27_CTKEY_50958064_BACKUP Media: List of Archived Logs in backup set 50958072 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 27 923134 2019-10-18_22-21-07 923641 2019-10-18_22-21-37 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958109 34.50K SBT_TAPE 00:00:01 2019-10-18_22-23-29 BP Key: 50958110 Status: AVAILABLE Compressed: YES Tag: TAG20191018T222328 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_28_CTKEY_50958070_BACKUP Media: List of Archived Logs in backup set 50958109 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 28 923641 2019-10-18_22-21-37 923862 2019-10-18_22-23-20 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958143 70.00K SBT_TAPE 00:00:00 2019-10-18_22-26-04 BP Key: 50958144 Status: AVAILABLE Compressed: YES Tag: TAG20191018T222604 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_29_CTKEY_50958141_BACKUP Media: List of Archived Logs in backup set 50958143 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 29 923862 2019-10-18_22-23-20 1024171 2019-10-18_22-25-52 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958153 1.14M SBT_TAPE 00:00:00 2019-10-18_22-27-58 BP Key: 50958154 Status: AVAILABLE Compressed: YES Tag: TAG20191018T222758 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_30_CTKEY_50958150_BACKUP Media: List of Archived Logs in backup set 50958153 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 30 1024171 2019-10-18_22-25-52 1025023 2019-10-18_22-27-40 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958158 1.12M SBT_TAPE 00:00:00 2019-10-18_22-28-21 BP Key: 50958159 Status: AVAILABLE Compressed: YES Tag: TAG20191018T222821 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_31_CTKEY_50958151_BACKUP Media: List of Archived Logs in backup set 50958158 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 31 1025023 2019-10-18_22-27-40 1025761 2019-10-18_22-28-20 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958259 72.50K SBT_TAPE 00:00:00 2019-10-18_22-35-41 BP Key: 50958260 Status: AVAILABLE Compressed: YES Tag: TAG20191018T223541 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_32_CTKEY_50958251_BACKUP Media: List of Archived Logs in backup set 50958259 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 32 1025761 2019-10-18_22-28-20 1126106 2019-10-18_22-35-34 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958294 1.13M SBT_TAPE 00:00:00 2019-10-18_22-37-35 BP Key: 50958295 Status: AVAILABLE Compressed: YES Tag: TAG20191018T223735 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_33_CTKEY_50958250_BACKUP Media: List of Archived Logs in backup set 50958294 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 33 1126106 2019-10-18_22-35-34 1127033 2019-10-18_22-37-17 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958347 39.50K SBT_TAPE 00:00:00 2019-10-18_22-38-53 BP Key: 50958348 Status: AVAILABLE Compressed: YES Tag: TAG20191018T223853 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_34_CTKEY_50958284_BACKUP Media: List of Archived Logs in backup set 50958347 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 34 1127033 2019-10-18_22-37-17 1127239 2019-10-18_22-38-26 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958353 115.00K SBT_TAPE 00:00:00 2019-10-18_22-41-43 BP Key: 50958354 Status: AVAILABLE Compressed: YES Tag: TAG20191018T224143 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_35_CTKEY_50958297_BACKUP Media: List of Archived Logs in backup set 50958353 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 35 1127239 2019-10-18_22-38-26 1127680 2019-10-18_22-41-24 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958357 9.00K SBT_TAPE 00:00:00 2019-10-18_22-41-45 BP Key: 50958358 Status: AVAILABLE Compressed: YES Tag: TAG20191018T224145 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_36_CTKEY_50958350_BACKUP Media: List of Archived Logs in backup set 50958357 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 36 1127680 2019-10-18_22-41-24 1127704 2019-10-18_22-41-33 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 50958380 995.00K SBT_TAPE 00:00:00 2019-10-18_22-44-55 BP Key: 50958381 Status: AVAILABLE Compressed: YES Tag: TAG20191018T224455 Handle: $RSCN_1_RTIM_1022003674_THRD_1_SEQ_37_CTKEY_50958351_BACKUP Media: List of Archived Logs in backup set 50958380 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 37 1127704 2019-10-18_22-41-33 1129802 2019-10-18_22-44-29 RMAN> RMAN> alter database mount; released channel: ORA_DISK_1 released channel: ORA_SBT_TAPE_1 Statement processed RMAN> RMAN> run{ 2> set until scn 1129802; 3> restore database; 4> recover database; 5> } executing command: SET until clause Starting restore at 2019-10-18_22-56-20 Starting implicit crosscheck backup at 2019-10-18_22-56-20 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=34 device type=DISK Crosschecked 1 objects Finished implicit crosscheck backup at 2019-10-18_22-56-23 Starting implicit crosscheck copy at 2019-10-18_22-56-23 using channel ORA_DISK_1 Finished implicit crosscheck copy at 2019-10-18_22-56-23 searching for all files in the recovery area cataloging files... no files cataloged using channel ORA_DISK_1 allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=412 device type=SBT_TAPE channel ORA_SBT_TAPE_1: RA Library (ZDLRAK) SID=95340D7DD1F8A19AE0538C43B20AF039 channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_1: restoring datafile 00002 to +DATAC1/ORAD18/DATAFILE/sysaux.918.1022003687 channel ORA_SBT_TAPE_1: reading from backup piece VB$_1965521110_50957917_2 channel ORA_SBT_TAPE_1: piece handle=VB$_1965521110_50957917_2 tag=BKP-LEVEL0 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:15 channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_1: restoring datafile 00003 to +DATAC1/ORAD18/DATAFILE/undotbs1.901.1022003687 channel ORA_SBT_TAPE_1: reading from backup piece VB$_1965521110_50957955_3 channel ORA_SBT_TAPE_1: piece handle=VB$_1965521110_50957955_3 tag=BKP-LEVEL0 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:15 channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATAC1/ORAD18/DATAFILE/users.894.1022003695 channel ORA_SBT_TAPE_1: reading from backup piece VB$_1965521110_50957954_4 channel ORA_SBT_TAPE_1: piece handle=VB$_1965521110_50957954_4 tag=BKP-LEVEL0 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:15 channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_1: restoring datafile 00001 to +DATAC1/ORAD18/DATAFILE/system.920.1022003683 channel ORA_SBT_TAPE_1: reading from backup piece VB$_1965521110_50957972_1 channel ORA_SBT_TAPE_1: piece handle=VB$_1965521110_50957972_1 tag=BKP-LEVEL0 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:16 Finished restore at 2019-10-18_22-57-32 Starting recover at 2019-10-18_22-57-33 using channel ORA_DISK_1 using channel ORA_SBT_TAPE_1 starting media recovery channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=23 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_23_CTKEY_50957791_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_23_CTKEY_50957791_BACKUP tag=TAG20191018T221354 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:03 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_23.966.1022011061 thread=1 sequence=23 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_23.966.1022011061 RECID=14 STAMP=1022011060 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=24 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_24_CTKEY_50958015_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_24_CTKEY_50958015_BACKUP tag=TAG20191018T221517 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_24.966.1022011063 thread=1 sequence=24 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_24.966.1022011063 RECID=15 STAMP=1022011063 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=25 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_25_CTKEY_50958054_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_25_CTKEY_50958054_BACKUP tag=TAG20191018T221930 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_25.966.1022011065 thread=1 sequence=25 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_25.966.1022011065 RECID=16 STAMP=1022011065 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=26 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_26_CTKEY_50958065_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_26_CTKEY_50958065_BACKUP tag=TAG20191018T222131 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_26.966.1022011067 thread=1 sequence=26 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_26.966.1022011067 RECID=17 STAMP=1022011067 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=27 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_27_CTKEY_50958064_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_27_CTKEY_50958064_BACKUP tag=TAG20191018T222158 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_27.966.1022011069 thread=1 sequence=27 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_27.966.1022011069 RECID=18 STAMP=1022011068 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=28 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_28_CTKEY_50958070_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_28_CTKEY_50958070_BACKUP tag=TAG20191018T222328 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:02 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_28.966.1022011071 thread=1 sequence=28 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_28.966.1022011071 RECID=19 STAMP=1022011070 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=29 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_29_CTKEY_50958141_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_29_CTKEY_50958141_BACKUP tag=TAG20191018T222604 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_29.966.1022011073 thread=1 sequence=29 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_29.966.1022011073 RECID=20 STAMP=1022011071 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=30 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_30_CTKEY_50958150_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_30_CTKEY_50958150_BACKUP tag=TAG20191018T222758 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_30.966.1022011075 thread=1 sequence=30 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_30.966.1022011075 RECID=21 STAMP=1022011073 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=31 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_31_CTKEY_50958151_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_31_CTKEY_50958151_BACKUP tag=TAG20191018T222821 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:02 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_31.966.1022011077 thread=1 sequence=31 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_31.966.1022011077 RECID=22 STAMP=1022011075 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=32 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_32_CTKEY_50958251_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_32_CTKEY_50958251_BACKUP tag=TAG20191018T223541 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_32.966.1022011079 thread=1 sequence=32 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_32.966.1022011079 RECID=23 STAMP=1022011076 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=33 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_33_CTKEY_50958250_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_33_CTKEY_50958250_BACKUP tag=TAG20191018T223735 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_33.966.1022011081 thread=1 sequence=33 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_33.966.1022011081 RECID=24 STAMP=1022011078 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=34 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_34_CTKEY_50958284_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_34_CTKEY_50958284_BACKUP tag=TAG20191018T223853 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_34.966.1022011083 thread=1 sequence=34 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_34.966.1022011083 RECID=25 STAMP=1022011079 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=35 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_35_CTKEY_50958297_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_35_CTKEY_50958297_BACKUP tag=TAG20191018T224143 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_35.966.1022011085 thread=1 sequence=35 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_35.966.1022011085 RECID=26 STAMP=1022011081 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=36 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_36_CTKEY_50958350_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_36_CTKEY_50958350_BACKUP tag=TAG20191018T224145 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_36.966.1022011087 thread=1 sequence=36 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_36.966.1022011087 RECID=27 STAMP=1022011083 channel ORA_SBT_TAPE_1: starting archived log restore to default destination channel ORA_SBT_TAPE_1: restoring archived log archived log thread=1 sequence=37 channel ORA_SBT_TAPE_1: reading from backup piece $RSCN_1_RTIM_1022003674_THRD_1_SEQ_37_CTKEY_50958351_BACKUP channel ORA_SBT_TAPE_1: piece handle=$RSCN_1_RTIM_1022003674_THRD_1_SEQ_37_CTKEY_50958351_BACKUP tag=TAG20191018T224455 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_37.966.1022011089 thread=1 sequence=37 channel default: deleting archived log(s) archived log file name=+RECOC1/ORAD18/ARCHIVELOG/2019_10_18/thread_1_seq_37.966.1022011089 RECID=28 STAMP=1022011084 media recovery complete, elapsed time: 00:00:00 Finished recover at 2019-10-18_22-58-05 RMAN> exit Recovery Manager complete. [oracle@exac1vm01-ORAD18]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 - Production on Fri Oct 18 22:58:50 2019 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0 SQL> select max(c1) from testins; MAX(C1) ---------- 956 SQL> SQL> show parameter dest_2; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_online_log_dest_2 string log_archive_dest_2 string SERVICE="zeros1ig-scan.simo.fz net.org:1521/zeros1:dedicated" ASYNC NOAFFIRM delay=0 option al compression=disable max_fai lure=1 max_connections=1 reope n=10 DB_UNIQUE_NAME=zeros1 net _timeout=8 group=1 priority=1 VALID_FOR=(ONLINE_LOGFILE,ALL_ ROLES) log_archive_dest_20 string NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_21 string log_archive_dest_22 string log_archive_dest_23 string log_archive_dest_24 string log_archive_dest_25 string log_archive_dest_26 string log_archive_dest_27 string log_archive_dest_28 string log_archive_dest_29 string SQL>