Lab excercise: Test oracle backup of image copy (both backup/restore)
For the lab excercise if at all we needed to use sbt library, we will use oracle.disksbt library which is a dummy library provided by oracle.allocate channel t1 device type 'sbt_tape' parms 'SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/tmp)';
setup:
1) create a tablespace for the testing purpose...create tablespace backupofbackup02 datafile size 10m autoextend on next 10m;
select file_name from dba_data_files where lower(tablespace_name)='backupofbackup02';
alter user scott quota unlimited on backupofbackup02;
2) create a test table...
create table scott.test2 tablespace backupofbackup02 as
select mod(level,2) mdlvl,level lvl
from dual
connect by level < 1000;
3) Try access the table
select mdlvl,count(1)
from scott.test2
group by mdlvl;
select owner,table_name,tablespace_name
from dba_Tables
where owner='SCOTT'
and table_name='TEST2';
4) Put the tbspc in Ro mode and take a backup of the tablespace as backupset to local disk
alter tablespace BACKUPOFBACKUP02 read only;
select tablespace_name,status from dba_tablespaces where tablespace_name='BACKUPOFBACKUP02';
backup disk location: /oradata_2/oratest_21apr19
run
{
allocate channel d1 device type disk;
backup as copy tablespace BACKUPOFBACKUP02 format '/oradata_2/oratest_21apr19/backup_tbspc_%s_%t_%T';
}
5) Try backing up the copy of the tbspc to disk and sbt.
to backup backupset...
BACKUP BACKUPSET command
to backup copy backups...
backup copy of
BACKUP DATAFILECOPY FROM TAG
option disk:
list copy of tablespace BACKUPOFBACKUP02;
run
{
allocate channel d1 device type disk;
backup copy of tablespace BACKUPOFBACKUP02 format '/oradata_2/oratest_21apr19_dkch/backupdk_tbspc_%d_%s_%t_%T';
}
option tape:
run
{
allocate channel t1 device type 'sbt_tape' parms 'SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/oradata_2/oratest_21apr19_sbtch)';
backup copy of tablespace BACKUPOFBACKUP02 format 'backuptp_tbspc_%d_%s_%t_%T';
}
Notice here, we arent calling out any specific backup to be backedup, we are just calling the db object, which means by default the latest copy of tablespace will be up for backup. But by mentioing tag you can select old backup as well.
[read here: https://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmbackp.htm#CEGBCHJA]
6) Try to restore the tablespace from each of this backupset copies and try fetch the records from the test table.
option tape backup of image copy:
i) list backup of tablespace BACKUPOFBACKUP02 summary;
list backup of tablespace BACKUPOFBACKUP02;
list copy of tablespace BACKUPOFBACKUP02;
ii) manually delete the file from disk /oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
rm /oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
Try data selection to ensure the accidental damage is done... [if this retrives the rows, try disc from current session, flush the buffer cache and retry]
select mdlvl,count(1)
from scott.test2
group by mdlvl;
select error from v$datafile_header where file#=1015;
>> verify your getting "CANNOT OPEN FILE" message.
iii) To facilitate a tablespace restore on a nonarchivelog db, please keep the tablespace in offline state.Otherwise you may hit ORA-19573 & skipping datafile 1014; already restored to file errors.
alter tablespace BACKUPOFBACKUP02 offline;
iv) restore from the tape backupset:
run
{
allocate channel t1 device type 'sbt_tape' parms 'SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/oradata_2/oratest_21apr19_sbtch)';
restore tablespace BACKUPOFBACKUP02;
}
v) Bring the tablespace to online
alter tablespace BACKUPOFBACKUP02 online;
vi) Try data selection
select mdlvl,count(1)
from scott.test2
group by mdlvl;
option disk backupset (using tag to pick the disk backup):
i) Archive the previous results.
ii) manually delete the file from disk /oradata_1/oratest/datafile/o1_mf_backupof_gcrjv6tx_.dbf [the name of the file may change based on the previous restore since we are using OMF for this test]
rm /oradata_1/oratest/datafile/o1_mf_backupof_gcrjv6tx_.dbf
Try data selection to ensure the accidental damage is done... [if this retrives the rows, try disc from current session, flush the buffer cache and retry]
select mdlvl,count(1)
from scott.test2
group by mdlvl;
select error from v$datafile_header where file#=1014;
>> verify your getting "CANNOT OPEN FILE" message.
iii) To facilitate a tablespace restore on a nonarchivelog db, please keep the tablespace in offline state.Otherwise you may hit ORA-19573 & skipping datafile 1014; already restored to file errors.
alter tablespace BACKUPOFBACKUP02 offline;
iv) restore from the backupset copy on disk (#2) -- let us try a default restore using disk channel and observe what happens, then let us force it to a specific copy by renaming the other copy.
run
{
allocate channel d1 device type disk;
restore tablespace BACKUPOFBACKUP02 from tag TAG20190421T180721;
}
--- it properly picks the copy#1 first and incase the copy#1 isnt available it fails over to the next one which is copy#2 [you will notice messages like "failover to piece handle=" in rman restore when copy#1 is inaccessible].
v) Bring the tablespace to online
alter tablespace BACKUPOFBACKUP01 online;
vi) Try data selection
select mdlvl,count(1)
from scott.test2
group by mdlvl;
vii) Query and store the v$rman_status
select START_TIME,END_TIME,OPERATION,status,MBYTES_PROCESSED,INPUT_BYTES,OUTPUT_BYTES,OPTIMIZED,OUTPUT_DEVICE_TYPE
from v$rman_status
where END_TIME > sysdate -1/24 and operation!='LIST'
order by start_time;
repeat this excercise for...
option image copy:
run
{
allocate channel d1 device type disk;
restore tablespace BACKUPOFBACKUP02 from tag TAG20190421T180458;
}
Execution:
########### Step 1)
SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='BACKUPOFBACKUP02';
no rows selected
SQL> select tablespace_name,status from dba_tablespaces where upper(tablespace_name)='BACKUPOFBACKUP02';
no rows selected
SQL> create tablespace backupofbackup02 datafile size 10m autoextend on next 10m;
Tablespace created.
SQL> select file_name from dba_data_files where lower(tablespace_name)='backupofbackup02';
FILE_NAME
--------------------------------------------------------------------------------
/oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
SQL> alter user scott quota unlimited on backupofbackup02;
User altered.
########### Step 2)
SQL> create table scott.test2 tablespace backupofbackup02 asselect mod(level,2) mdlvl,level lvl
from dual
connect by level < 1000; 2 3 4
Table created.
########### Step 3)
SQL> select mdlvl,count(1)
from scott.test2
group by mdlvl; 2 3
MDLVL COUNT(1)
---------- ----------
1 500
0 499
SQL> select owner,table_name,tablespace_name
from dba_Tables
where owner='SCOTT'
and table_name='TEST2'; 2 3 4
OWNER TABLE_NAME TABLESPACE_NAME
---------- ------------ ------------------------------
SCOTT TEST2 BACKUPOFBACKUP02
########### Step 4)
RMAN> run
{
allocate channel d1 device type disk;
backup as copy tablespace BACKUPOFBACKUP02 format '/oradata_2/oratest_21apr19/backup_tbspc_%s_%t_%T';
}2> 3> 4> 5>
allocated channel: d1
channel d1: SID=271 device type=DISK
Starting backup at 21-APR-19
channel d1: starting datafile copy
input datafile file number=01015 name=/oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
output file name=/oradata_2/oratest_21apr19/backup_tbspc_104_1006193098_20190421 tag=TAG20190421T180458 RECID=2 STAMP=1006193100
channel d1: datafile copy complete, elapsed time: 00:00:04
Finished backup at 21-APR-19
Starting Control File and SPFILE Autobackup at 21-APR-19
piece handle=/oradata_1/fast_recovery_area/oratest/autobackup/2019_04_21/o1_mf_s_1006193102_gcrj2jj1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 21-APR-19
released channel: d1
RMAN> list copy of tablespace BACKUPOFBACKUP02;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
2 1015 A 21-APR-19 5741170 21-APR-19
Name: /oradata_2/oratest_21apr19/backup_tbspc_104_1006193098_20190421
Tag: TAG20190421T180458
RMAN>
########### Step 5)
>>>>>>>>>>>option disk:
RMAN> list backup of tablespace BACKUPOFBACKUP02 summary;
specification does not match any backup in the repository
RMAN> list copy of tablespace BACKUPOFBACKUP02;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
2 1015 A 21-APR-19 5741170 21-APR-19
Name: /oradata_2/oratest_21apr19/backup_tbspc_104_1006193098_20190421
Tag: TAG20190421T180458
RMAN> run
{
allocate channel d1 device type disk;
backup copy of tablespace BACKUPOFBACKUP02 format '/oradata_2/oratest_21apr19_dkch/backupdk_tbspc_%d_%s_%t_%T';
}2> 3> 4> 5>
allocated channel: d1
channel d1: SID=271 device type=DISK
Starting backup at 21-APR-19
channel d1: starting full datafile backup set
channel d1: including datafile copy of datafile 01015 in backup set
input file name=/oradata_2/oratest_21apr19/backup_tbspc_104_1006193098_20190421
channel d1: starting piece 1 at 21-APR-19
channel d1: finished piece 1 at 21-APR-19
piece handle=/oradata_2/oratest_21apr19_dkch/backupdk_tbspc_ORATEST_106_1006193241_20190421 tag=TAG20190421T180721 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 21-APR-19
Starting Control File and SPFILE Autobackup at 21-APR-19
piece handle=/oradata_1/fast_recovery_area/oratest/autobackup/2019_04_21/o1_mf_s_1006193243_gcrj6wjw_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 21-APR-19
released channel: d1
RMAN> list copy of tablespace BACKUPOFBACKUP02;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
2 1015 A 21-APR-19 5741170 21-APR-19
Name: /oradata_2/oratest_21apr19/backup_tbspc_104_1006193098_20190421
Tag: TAG20190421T180458
RMAN> list backup of tablespace BACKUPOFBACKUP02 summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
95 B F A DISK 21-APR-19 1 1 NO TAG20190421T180721
RMAN>
Note here: the tag changes unlinke backupset the tag isnt kept as same and copy count isnt incremented, since both the backups are of different type.
>>>>>>>>>>>option tape:
RMAN> run
{
allocate channel t1 device type 'sbt_tape' parms 'SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/oradata_2/oratest_21apr19_sbtch)';
backup copy of tablespace BACKUPOFBACKUP02 format 'backuptp_tbspc_%d_%s_%t_%T';
}2> 3> 4> 5>
allocated channel: t1
channel t1: SID=271 device type=SBT_TAPE
channel t1: WARNING: Oracle Test Disk API
Starting backup at 21-APR-19
channel t1: starting full datafile backup set
channel t1: including datafile copy of datafile 01015 in backup set
input file name=/oradata_2/oratest_21apr19/backup_tbspc_104_1006193098_20190421
channel t1: starting piece 1 at 21-APR-19
channel t1: finished piece 1 at 21-APR-19
piece handle=backuptp_tbspc_ORATEST_108_1006193400_20190421 tag=TAG20190421T180959 comment=API Version 2.0,MMS Version 8.1.3.0
channel t1: backup set complete, elapsed time: 00:00:01
Finished backup at 21-APR-19
Starting Control File and SPFILE Autobackup at 21-APR-19
piece handle=c-2907708373-20190421-02 comment=API Version 2.0,MMS Version 8.1.3.0
Finished Control File and SPFILE Autobackup at 21-APR-19
released channel: t1
RMAN>
RMAN> list copy of tablespace BACKUPOFBACKUP02;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
2 1015 A 21-APR-19 5741170 21-APR-19
Name: /oradata_2/oratest_21apr19/backup_tbspc_104_1006193098_20190421
Tag: TAG20190421T180458
RMAN> list backup of tablespace BACKUPOFBACKUP02 summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
95 B F A DISK 21-APR-19 1 1 NO TAG20190421T180721
97 B F A SBT_TAPE 21-APR-19 1 1 NO TAG20190421T180959
RMAN>
Note: Even after sending backupset to tape,we get to see one more tag and the copy# isnt incremented.
########### Step 6)
option tape backup of image copy:
RMAN> list backup of tablespace BACKUPOFBACKUP02 summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
95 B F A DISK 21-APR-19 1 1 NO TAG20190421T180721
97 B F A SBT_TAPE 21-APR-19 1 1 NO TAG20190421T180959
RMAN> list copy of tablespace BACKUPOFBACKUP02;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
2 1015 A 21-APR-19 5741170 21-APR-19
Name: /oradata_2/oratest_21apr19/backup_tbspc_104_1006193098_20190421
Tag: TAG20190421T180458
RMAN> list backup of tablespace BACKUPOFBACKUP02;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
95 Full 1.08M DISK 00:00:01 21-APR-19
BP Key: 97 Status: AVAILABLE Compressed: NO Tag: TAG20190421T180721
Piece Name: /oradata_2/oratest_21apr19_dkch/backupdk_tbspc_ORATEST_106_1006193241_20190421
List of Datafiles in backup set 95
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1015 Full 5741170 21-APR-19 /oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
97 Full 4.00M SBT_TAPE 00:00:00 21-APR-19
BP Key: 99 Status: AVAILABLE Compressed: NO Tag: TAG20190421T180959
Handle: backuptp_tbspc_ORATEST_108_1006193400_20190421 Media: n01tst_21apr19_sbtc,backuptp_tbspc_RMN0
List of Datafiles in backup set 97
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1015 Full 5741170 21-APR-19 /oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
RMAN>
[oracle@dbhost ~]$ ls -altr /oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
-rw-rw----. 1 oracle oracle 10493952 Apr 21 18:02 /oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
[oracle@dbhost ~]$ rm /oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
SQL> !ls -altr /oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
ls: cannot access /oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf: No such file or directory
SQL>
SQL> select mdlvl,count(1)
from scott.test2
group by mdlvl; 2 3
from scott.test2
*
ERROR at line 2:
ORA-01116: error in opening database file 1015
ORA-01110: data file 1015:
'/oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> select error from v$datafile_header where file#=1015;
ERROR
-----------------------------------------------------------------
CANNOT OPEN FILE
SQL>
SQL> alter tablespace BACKUPOFBACKUP02 offline;
Tablespace altered.
SQL> select status from dba_tablespaces where tablespace_name='BACKUPOFBACKUP02';
STATUS
---------
READ ONLY
SQL>
RMAN> run
{
allocate channel t1 device type 'sbt_tape' parms 'SBT_LIBRARY=oracle.disksbt, ENV=(BACKUP_DIR=/oradata_2/oratest_21apr19_sbtch)';
restore tablespace BACKUPOFBACKUP02;
}2> 3> 4> 5>
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=30 device type=SBT_TAPE
channel t1: WARNING: Oracle Test Disk API
Starting restore at 21-APR-19
channel t1: starting datafile backup set restore
channel t1: specifying datafile(s) to restore from backup set
channel t1: restoring datafile 01015 to /oradata_1/oratest/datafile/o1_mf_backupof_gcrhsodq_.dbf
channel t1: reading from backup piece backuptp_tbspc_ORATEST_108_1006193400_20190421
channel t1: piece handle=backuptp_tbspc_ORATEST_108_1006193400_20190421 tag=TAG20190421T180959
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:00:01
Finished restore at 21-APR-19
released channel: t1
RMAN>
SQL> select error from v$datafile_header where file#=1015;
ERROR
-----------------------------------------------------------------
OFFLINE NORMAL
SQL> alter tablespace BACKUPOFBACKUP02 online;
Tablespace altered.
SQL> select file_name from dba_data_files where lower(tablespace_name)='backupofbackup02';
FILE_NAME
--------------------------------------------------------------------------------
/oradata_1/oratest/datafile/o1_mf_backupof_gcrjv6tx_.dbf
SQL> select mdlvl,count(1)
from scott.test2
group by mdlvl; 2 3
MDLVL COUNT(1)
---------- ----------
1 500
0 499
SQL> select error from v$datafile_header where file#=1015;
ERROR
-----------------------------------------------------------------
SQL> select status from dba_tablespaces where tablespace_name='BACKUPOFBACKUP02';
STATUS
---------
READ ONLY
option disk backupset (using tag to pick the disk backup):
SQL> !ls -altr /oradata_1/oratest/datafile/o1_mf_backupof_gcrjv6tx_.dbf
-rw-rw----. 1 oracle oracle 10493952 Apr 21 18:18 /oradata_1/oratest/datafile/o1_mf_backupof_gcrjv6tx_.dbf
SQL> !rm /oradata_1/oratest/datafile/o1_mf_backupof_gcrjv6tx_.dbf
SQL> !ls -altr /oradata_1/oratest/datafile/o1_mf_backupof_gcrjv6tx_.dbf
ls: cannot access /oradata_1/oratest/datafile/o1_mf_backupof_gcrjv6tx_.dbf: No such file or directory
SQL> select error from v$datafile_header where file#=1015;
ERROR
-----------------------------------------------------------------
CANNOT OPEN FILE
SQL> select mdlvl,count(1)
from scott.test2
group by mdlvl; 2 3
select mdlvl,count(1)
*
ERROR at line 1:
ORA-01116: error in opening database file 1015
ORA-01110: data file 1015:
'/oradata_1/oratest/datafile/o1_mf_backupof_gcrjv6tx_.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
RMAN> run
{
allocate channel d1 device type disk;
restore tablespace BACKUPOFBACKUP02 from tag TAG20190421T180721;
}2> 3> 4> 5>
using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=14 device type=DISK
Starting restore at 21-APR-19
channel d1: starting datafile backup set restore
channel d1: specifying datafile(s) to restore from backup set
channel d1: restoring datafile 01015 to /oradata_1/oratest/datafile/o1_mf_backupof_gcrjv6tx_.dbf
channel d1: reading from backup piece /oradata_2/oratest_21apr19_dkch/backupdk_tbspc_ORATEST_106_1006193241_20190421
channel d1: piece handle=/oradata_2/oratest_21apr19_dkch/backupdk_tbspc_ORATEST_106_1006193241_20190421 tag=TAG20190421T180721
channel d1: restored backup piece 1
channel d1: restore complete, elapsed time: 00:00:07
Finished restore at 21-APR-19
released channel: d1
SQL> select error from v$datafile_header where file#=1015;
ERROR
-----------------------------------------------------------------
OFFLINE NORMAL
SQL> alter tablespace BACKUPOFBACKUP02 online;
Tablespace altered.
SQL> select error from v$datafile_header where file#=1015;
ERROR
-----------------------------------------------------------------
SQL> select mdlvl,count(1)
from scott.test2
group by mdlvl; 2 3
MDLVL COUNT(1)
---------- ----------
1 500
0 499
SQL> select file_name from dba_data_files where lower(tablespace_name)='backupofbackup02';
FILE_NAME
--------------------------------------------------------------------------------
/oradata_1/oratest/datafile/o1_mf_backupof_gcrkb76p_.dbf
SQL>
option image copy:
run
{
allocate channel d1 device type disk;
restore tablespace BACKUPOFBACKUP02 from tag TAG20190421T180458;
}
RMAN> run
{
allocate channel d1 device type disk;
restore tablespace BACKUPOFBACKUP02 from tag TAG20190421T180458;
}2> 3> 4> 5>
using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=268 device type=DISK
Starting restore at 21-APR-19
channel d1: restoring datafile 01015
input datafile copy RECID=2 STAMP=1006193100 file name=/oradata_2/oratest_21apr19/backup_tbspc_104_1006193098_20190421
destination for restore of datafile 01015: /oradata_1/oratest/datafile/o1_mf_backupof_gcrkb76p_.dbf
channel d1: copied datafile copy of datafile 01015
output file name=/oradata_1/oratest/datafile/o1_mf_backupof_gcrkks3n_.dbf RECID=0 STAMP=0
Finished restore at 21-APR-19
released channel: d1
RMAN> exit
SQL> select error from v$datafile_header where file#=1015;
ERROR
-----------------------------------------------------------------
OFFLINE NORMAL
SQL>
SQL> alter tablespace BACKUPOFBACKUP02 online;
Tablespace altered.
SQL> select error from v$datafile_header where file#=1015;
ERROR
-----------------------------------------------------------------
SQL> select mdlvl,count(1)
from scott.test2
group by mdlvl; 2 3
MDLVL COUNT(1)
---------- ----------
1 500
0 499
SQL>
SQL> select START_TIME,END_TIME,OPERATION,status,MBYTES_PROCESSED,INPUT_BYTES,OUTPUT_BYTES,OPTIMIZED,OUTPUT_DEVICE_TYPE
from v$rman_status
where END_TIME > sysdate -1/24 and operation!='LIST'
order by start_time; 2 3 4
START_TIME END_TIME OPERATION STATUS MBYTES_PROCESSED INPUT_BYTES OUTPUT_BYTES OPT OUTPUT_DEVICE_TYP
------------------- ------------------- --------------------------------- ----------------------- ---------------- ----------- ------------ --- -----------------
21/04/2019 18:04:05 21/04/2019 18:14:19 RMAN COMPLETED WITH ERRORS 148 151519232 152453120 NO
21/04/2019 18:04:57 21/04/2019 18:05:05 BACKUP COMPLETED 31 31981568 32063488 NO DISK <<< IMG copy backup to disk
21/04/2019 18:05:02 21/04/2019 18:05:05 CONTROL FILE AND SPFILE AUTOBACK COMPLETED 21 21495808 21577728 NO DISK
21/04/2019 18:07:21 21/04/2019 18:07:26 BACKUP COMPLETED 23 23068672 22708224 NO DISK <<< backupset of image copy to disk
21/04/2019 18:07:23 21/04/2019 18:07:26 CONTROL FILE AND SPFILE AUTOBACK COMPLETED 21 21495808 21577728 NO DISK
21/04/2019 18:09:59 21/04/2019 18:10:04 BACKUP COMPLETED 31 31981568 29360128 NO SBT_TAPE <<< backupset of iamge copy to tape
21/04/2019 18:10:01 21/04/2019 18:10:04 CONTROL FILE AND SPFILE AUTOBACK COMPLETED 21 21495808 25165824 NO SBT_TAPE
21/04/2019 18:17:38 21/04/2019 18:18:31 RMAN COMPLETED 10 0 10485760 NO
21/04/2019 18:18:13 21/04/2019 18:18:15 RESTORE COMPLETED 10 0 10485760 NO <<< restore from sbt
21/04/2019 18:24:33 21/04/2019 18:24:35 RMAN COMPLETED 0 0 0 NO
21/04/2019 18:24:38 21/04/2019 18:24:40 RMAN COMPLETED 0 0 0 NO
21/04/2019 18:24:45 21/04/2019 18:25:31 RMAN COMPLETED 0 0 0 NO
21/04/2019 18:25:41 21/04/2019 18:26:27 RMAN COMPLETED 10 1130496 10485760 NO
21/04/2019 18:26:14 21/04/2019 18:26:22 RESTORE COMPLETED 10 1130496 10485760 NO DISK <<< restore from disk backupset
21/04/2019 18:29:15 21/04/2019 18:30:26 RMAN COMPLETED 0 10485760 10485760 NO
21/04/2019 18:30:16 21/04/2019 18:30:18 RESTORE COMPLETED 0 10485760 10485760 NO DISK <<< restore from disk image copy
16 rows selected.
Summary: We could backup image copy as backupset to both disk and tape and also we are able to successfully perform restore as well.
Thank you for your visit, your comments are welcome.
No comments:
Post a Comment