0 Flares Twitter 0 Facebook 0 Filament.io 0 Flares ×

What’s up Guys

As you know, I need to improve my english and need to practice. So, I decided to try write my articles in english too. If you meet any error, I’m sorry.

That said, I hope to that articles help you to solved some issues and doubts.

The more older articles is here:

 

Vamos brincar de backup e restore – Parte 1

Vamos brincar de backup e restore – Parte 2

This article, in portuguese:

Vamos brincar de backup e restore – Parte 3

 

Today, we will restore using Restore points.

Enjoy it.

1) Let’s create a test table.

SQL> show con_name
CON_NAME
——————————
CDB$ROOT

SQL> alter session set nls_date_format=’DD/MM/YYYY HH24:Mi:SS’;
Session altered.

SQL> create table teste10 as select * from dba_objects;
Table created.

SQL> select count(1) from teste10;
COUNT(1)
———-
72696

SQL> alter session set container=thorpdb3;
Session altered.

SQL> create table teste11 as select * from dba_objects;
Table created.

SQL> select count(1) from teste11;
COUNT(1)
———-
72694

SQL> select sysdate from dual;
SYSDATE
——————-
29/01/2018 14:05:10

2) Now, let’s create a Restore Point in CDB.

SQL> alter session set container=cdb$root;
Session altered.

SQL> show con_name;
CON_NAME
——————————
CDB$ROOT

SQL> CREATE RESTORE POINT thor_restore;
Restore point created.

set linesize 121
col name format a15
col time format a32
SELECT name, scn, time, database_incarnation#, guarantee_flashback_database, storage_size
FROM gv$restore_point;

NAME SCN TIME DATABASE_INCARNATION# GUA STORAGE_SIZE
————— ———- ——————————– ——————— — ————
THOR_RESTORE 2549765 29/01/18 14:06:07,000000000 3 NO 0

3) Let’s remove the test table in CDB and insert more data into the test table in PDB.

SQL> drop table test10;

SQL> alter session set container=thorpdb3;
Session altered.

SQL> insert into teste11 select * from dba_objects;
72695 rows created.

SQL> commit;
Commit complete.

SQL> select count(1) from teste11;
COUNT(1)
———-
145389

4) Finally, let’s restore database for Restore Point.

run
{
shutdown immediate;
startup mount;
set until restore point thor_restore;
restore database;
recover database;
alter database open resetlogs;
}

Read the log’s:
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area 1241513984 bytes

Fixed Size 8792248 bytes
Variable Size 452986696 bytes
Database Buffers 771751936 bytes
Redo Buffers 7983104 bytes

executing command: SET until clause

Starting restore at 29-JAN-18
flashing back control file to SCN 2549766
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=42 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=48 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=49 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=50 device type=DISK

skipping datafile 5; already restored to file +DATA/THOR/4700A987085B3DFAE05387E5E50A8C7B/DATAFILE/system.273.965234681
skipping datafile 6; already restored to file +DATA/THOR/4700A987085B3DFAE05387E5E50A8C7B/DATAFILE/sysaux.272.965234681
skipping datafile 8; already restored to file +DATA/THOR/4700A987085B3DFAE05387E5E50A8C7B/DATAFILE/undotbs1.274.965234681
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA/THOR/DATAFILE/system.257.965234485
channel ORA_DISK_1: reading from backup piece +DATA/THOR/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.530.966438637
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00010 to +DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/DATAFILE/sysaux.279.965235083
channel ORA_DISK_2: reading from backup piece +DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.532.966438637
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00014 to +DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/DATAFILE/sysaux.284.965235107
channel ORA_DISK_3: reading from backup piece +DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.533.966438637
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00003 to +DATA/THOR/DATAFILE/sysaux.258.965234539
channel ORA_DISK_4: reading from backup piece +DATA/THOR/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.531.966438637
^[[Bchannel ORA_DISK_2: piece handle=+DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.532.966438637 tag=TAG20180126T151035
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:02:26
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00022 to +DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/DATAFILE/sysaux.299.965485011
channel ORA_DISK_2: reading from backup piece +DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.535.966438809
channel ORA_DISK_3: piece handle=+DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.533.966438637 tag=TAG20180126T151035
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:02:26
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00026 to +DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/DATAFILE/sysaux.305.965485357
channel ORA_DISK_3: reading from backup piece +DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.536.966438809
channel ORA_DISK_4: piece handle=+DATA/THOR/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.531.966438637 tag=TAG20180126T151035
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:02:26
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00009 to +DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/DATAFILE/system.278.965235083
channel ORA_DISK_4: reading from backup piece +DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.538.966438937
channel ORA_DISK_1: piece handle=+DATA/THOR/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.530.966438637 tag=TAG20180126T151035
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:30
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00013 to +DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/DATAFILE/system.283.965235107
channel ORA_DISK_1: reading from backup piece +DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.542.966438975
channel ORA_DISK_1: piece handle=+DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.542.966438975 tag=TAG20180126T151035
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00021 to +DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/DATAFILE/system.298.965485011
channel ORA_DISK_1: reading from backup piece +DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.539.966438973
channel ORA_DISK_4: piece handle=+DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.538.966438937 tag=TAG20180126T151035
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:00:48
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00025 to +DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/DATAFILE/system.304.965485357
channel ORA_DISK_4: reading from backup piece +DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.540.966438973
channel ORA_DISK_1: piece handle=+DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.539.966438973 tag=TAG20180126T151035
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00011 to +DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/DATAFILE/undotbs1.277.965235083
channel ORA_DISK_1: reading from backup piece +DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.545.966439031
channel ORA_DISK_4: piece handle=+DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.540.966438973 tag=TAG20180126T151035
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:00:46
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00015 to +DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/DATAFILE/undotbs1.282.965235107
channel ORA_DISK_4: reading from backup piece +DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.546.966439033
channel ORA_DISK_1: piece handle=+DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.545.966439031 tag=TAG20180126T151035
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00023 to +DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/DATAFILE/undotbs1.297.965485011
channel ORA_DISK_1: reading from backup piece +DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.548.966439033
channel ORA_DISK_4: piece handle=+DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.546.966439033 tag=TAG20180126T151035
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:00:02
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00027 to +DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/DATAFILE/undotbs1.303.965485357
channel ORA_DISK_4: reading from backup piece +DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.549.966439035
channel ORA_DISK_1: piece handle=+DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.548.966439033 tag=TAG20180126T151035
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to +DATA/THOR/DATAFILE/undotbs1.259.965234575
channel ORA_DISK_1: reading from backup piece +DATA/THOR/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.550.966439035
channel ORA_DISK_4: piece handle=+DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.549.966439035 tag=TAG20180126T151035
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:00:00
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00007 to +DATA/THOR/DATAFILE/users.260.965234577
channel ORA_DISK_4: reading from backup piece +DATA/THOR/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.552.966439039
channel ORA_DISK_4: piece handle=+DATA/THOR/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.552.966439039 tag=TAG20180126T151035
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:00:02
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00012 to +DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/DATAFILE/users.281.965235105
channel ORA_DISK_4: reading from backup piece +DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.553.966439039
channel ORA_DISK_1: piece handle=+DATA/THOR/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.550.966439035 tag=TAG20180126T151035
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00016 to +DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/DATAFILE/users.286.965235119
channel ORA_DISK_1: reading from backup piece +DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.554.966439041
channel ORA_DISK_4: piece handle=+DATA/THOR/6299C00259AD7C3AE0530238A8C0E90F/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.553.966439039 tag=TAG20180126T151035
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:00:01
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00024 to +DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/DATAFILE/users.296.965485011
channel ORA_DISK_4: reading from backup piece +DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.556.966439041
channel ORA_DISK_1: piece handle=+DATA/THOR/6299C19B88C07EB1E0530238A8C0186C/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.554.966439041 tag=TAG20180126T151035
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:00
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00028 to +DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/DATAFILE/users.302.965485357
channel ORA_DISK_1: reading from backup piece +DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.557.966439041
channel ORA_DISK_4: piece handle=+DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.556.966439041 tag=TAG20180126T151035
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:00:01
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00019 to +DATA/THOR/6299EDF975680482E0530238A8C00AF8/DATAFILE/undotbs1.289.965235853
channel ORA_DISK_4: reading from backup piece +DATA/THOR/6299EDF975680482E0530238A8C00AF8/BACKUPSET/2018_01_29/nnndf0_tag20180129t102356_0.583.966680637
channel ORA_DISK_1: piece handle=+DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.557.966439041 tag=TAG20180126T151035
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:00
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00020 to +DATA/THOR/6299EDF975680482E0530238A8C00AF8/DATAFILE/users.288.965235853
channel ORA_DISK_1: reading from backup piece +DATA/THOR/6299EDF975680482E0530238A8C00AF8/BACKUPSET/2018_01_29/nnndf0_tag20180129t102356_0.584.966680637
channel ORA_DISK_1: piece handle=+DATA/THOR/6299EDF975680482E0530238A8C00AF8/BACKUPSET/2018_01_29/nnndf0_tag20180129t102356_0.584.966680637 tag=TAG20180129T102356
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00017 to +DATA/THOR/6299EDF975680482E0530238A8C00AF8/DATAFILE/system.290.965235853
channel ORA_DISK_1: reading from backup piece +DATA/THOR/6299EDF975680482E0530238A8C00AF8/BACKUPSET/2018_01_29/nnndf0_tag20180129t102356_0.582.966680637
channel ORA_DISK_4: piece handle=+DATA/THOR/6299EDF975680482E0530238A8C00AF8/BACKUPSET/2018_01_29/nnndf0_tag20180129t102356_0.583.966680637 tag=TAG20180129T102356
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:00:01
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00018 to +DATA/THOR/6299EDF975680482E0530238A8C00AF8/DATAFILE/sysaux.291.965235853
channel ORA_DISK_4: reading from backup piece +DATA/THOR/6299EDF975680482E0530238A8C00AF8/BACKUPSET/2018_01_29/nnndf0_tag20180129t102356_0.581.966680637
channel ORA_DISK_2: piece handle=+DATA/THOR/62D3EADA70FC2F9FE0530238A8C0F70D/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.535.966438809 tag=TAG20180126T151035
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:02:21
channel ORA_DISK_3: piece handle=+DATA/THOR/62D405A2F8C03AB1E0530238A8C04E05/BACKUPSET/2018_01_26/nnndf0_tag20180126t151035_0.536.966438809 tag=TAG20180126T151035
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:02:21
channel ORA_DISK_1: piece handle=+DATA/THOR/6299EDF975680482E0530238A8C00AF8/BACKUPSET/2018_01_29/nnndf0_tag20180129t102356_0.582.966680637 tag=TAG20180129T102356
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:46
channel ORA_DISK_4: piece handle=+DATA/THOR/6299EDF975680482E0530238A8C00AF8/BACKUPSET/2018_01_29/nnndf0_tag20180129t102356_0.581.966680637 tag=TAG20180129T102356
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:01:15
Finished restore at 29-JAN-18

Starting recover at 29-JAN-18
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

starting media recovery

archived log for thread 1 with sequence 54 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_54.560.966439051
archived log for thread 1 with sequence 55 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_55.562.966439053
archived log for thread 1 with sequence 56 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_56.459.966441189
archived log for thread 1 with sequence 57 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_57.454.966441189
archived log for thread 1 with sequence 58 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_58.467.966441189
archived log for thread 1 with sequence 1 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_1.309.966441199
archived log for thread 1 with sequence 2 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_2.310.966441203
archived log for thread 1 with sequence 3 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_3.448.966441209
archived log for thread 1 with sequence 4 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_4.445.966680051
archived log for thread 1 with sequence 5 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_5.442.966680055
archived log for thread 1 with sequence 6 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_6.437.966680059
archived log for thread 1 with sequence 7 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_7.431.966680223
archived log for thread 1 with sequence 8 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_8.410.966680241
archived log for thread 1 with sequence 9 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_9.392.966680553
archived log for thread 1 with sequence 10 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_10.388.966680553
archived log for thread 1 with sequence 11 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_11.570.966680603
archived log for thread 1 with sequence 12 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_12.574.966680629
archived log for thread 1 with sequence 13 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_13.576.966680633
archived log for thread 1 with sequence 14 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_14.586.966680693
archived log for thread 1 with sequence 15 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_15.590.966681465
archived log for thread 1 with sequence 16 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_16.592.966681741
archived log for thread 1 with sequence 17 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_17.594.966681741
archived log for thread 1 with sequence 18 is already on disk as file +DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_18.606.966694265
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_54.560.966439051 thread=1 sequence=54
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_55.562.966439053 thread=1 sequence=55
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_56.459.966441189 thread=1 sequence=56
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_57.454.966441189 thread=1 sequence=57
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_58.467.966441189 thread=1 sequence=58
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_1.309.966441199 thread=1 sequence=1
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_2.310.966441203 thread=1 sequence=2
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_26/thread_1_seq_3.448.966441209 thread=1 sequence=3
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_4.445.966680051 thread=1 sequence=4
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_5.442.966680055 thread=1 sequence=5
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_6.437.966680059 thread=1 sequence=6
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_7.431.966680223 thread=1 sequence=7
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_8.410.966680241 thread=1 sequence=8
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_9.392.966680553 thread=1 sequence=9
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_10.388.966680553 thread=1 sequence=10
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_11.570.966680603 thread=1 sequence=11
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_12.574.966680629 thread=1 sequence=12
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_13.576.966680633 thread=1 sequence=13
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_14.586.966680693 thread=1 sequence=14
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_15.590.966681465 thread=1 sequence=15
archived log file name=+DATA/THOR/ARCHIVELOG/2018_01_29/thread_1_seq_16.592.966681741 thread=1 sequence=16
media recovery complete, elapsed time: 00:00:05
Finished recover at 29-JAN-18

Statement processed

5) After the restore, let’s try select the data on the test table.

Important: Remember that we excluded the test table in the CDB and inserted more data in the test table in the PDB (there were 72694 records and after the insert the table was 145389 records).

SQL> show con_name;
CON_NAME
——————————
CDB$ROOT

SQL> select count(1) from teste10;
COUNT(1)
———-
72696

SQL> alter session set container=thorpdb3;
Session altered.

SQL> select count(1) from teste11;
COUNT(1)
———-
72694

SQL> alter session set nls_date_format=’DD/MM/YYYY HH24:Mi:SS’;
Session altered.

SQL> select sysdate from dual;
SYSDATE
——————-
29/01/2018 14:36:34

That’s it folks. I hope you like the article.

See you on next post.

Mario

Leave a Reply

Your email address will not be published. Required fields are marked *