Purpose:
Oracle Spfile Backup Validate
from Tape
$ rman target / catalog
rman/rman123@catdb
Recovery Manager: Release 10.2.0.4.0 -
Production on Mon Sep 6 12:39:12 2010
Copyright (c) 1982, 2007, Oracle. All
rights reserved.
connected to target database: SSADB
(DBID=3387211866)
connected to recovery catalog database
RMAN> list backup of spfile;
BS Key Type LV Size Device Type
Elapsed Time Completion Time
------- ---- -- ---------- -----------
------------ ---------------
152286
Full 23.00M SBT_TAPE 00:01:04 05-SEP-10
BP Key: 152288 Status:
AVAILABLE Compressed: NO Tag: TAG20100905T213
149
Handle:
c-3389811866-20100905-02 Media: 0011L4
SPFILE Included: Modification time:
05-SEP-10
RMAN> run {
2> allocate channel ch001 type
'SBT_TAPE';
3> SEND 'NB_ORA_CLIENT=ora-rs';
4> validate backupset 152286;
5> }
allocated channel: ch001
channel ch001: sid=1720
devtype=SBT_TAPE
channel ch001: Veritas NetBackup for
Oracle - Release 6.5 (2007072323)
sent command to channel: ch001
channel ch001: starting validation of
datafile backupset
channel ch001: reading from backup
piece c-3389811866-20100905-02
channel ch001: restored backup piece 1
piece handle=c-3389811866-20100905-02
tag=TAG20100905T213149
channel ch001: validation complete,
elapsed time: 00:02:05
released channel: ch001
Validate
Oracle Controlfile Backup from Tape
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
152272 Full 22.75M SBT_TAPE 00:01:01 05-SEP-10
BP Key: 152275 Status: AVAILABLE Compressed: NO Tag: TAG20100905T213
042
Handle: cntrl_5906_1_728947842 Media: 0011L4
Control File Included: Ckp SCN: 676569375 Ckp time: 05-SEP-10
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
152286 Full 23.00M SBT_TAPE 00:01:04 05-SEP-10
BP Key: 152288 Status: AVAILABLE Compressed: NO Tag: TAG20100905T213
149
Handle: c-3389811866-20100905-02 Media: 0011L4
Control File Included: Ckp SCN: 676569420 Ckp time: 05-SEP-10
RMAN> run {
2> allocate channel ch001 type
'SBT_TAPE';
3> SEND 'NB_ORA_CLIENT=ora-rs';
4> validate backupset 152286;
5> }
Validate Oracle Datafile Backup from
Tape
RMAN>list
backup of database completed between '04-SEP-10' and '06-SEP-10';
RMAN>list backup of database completed after '01-SEP-10';
RMAN>list backup of database completed after '01-SEP-10';
RMAN>list
backup of database;
BS Key Type LV
Size Device Type Elapsed Time Completion Time
------- ---- --
---------- ----------- ------------ ---------------
152119
Incr 0 22.43G
SBT_TAPE 00:17:10 05-SEP-10
BP
Key: 152129 Status: AVAILABLE Compressed: NO Tag: HOT_DB_BK_LEVEL
0
Handle:
bk_5900_1_728946270 Media:
List
of Datafiles in backup set 152119
File
LV Type Ckp SCN Ckp Time Name
----
-- ---- ---------- --------- ----
2
0 Incr 676568348 05-SEP-10 /ora_dat/ssadb/undotbs01.dbf
4
0 Incr 676568348 05-SEP-10 /ora_dat/ssadb/users01.dbf
5
0 Incr 676568348 05-SEP-10 /ora_dat/ssadb/system02.dbf
30
0 Incr 676568348 05-SEP-10 /ora_idx/ssadb/idx_SSAERP13.dbf
31
0 Incr 676568348 05-SEP-10 /ora_idx/ssadb/idx_SSAERP14.dbf
BS Key Type LV
Size Device Type Elapsed Time Completion Time
------- ---- --
---------- ----------- ------------ ---------------
152120
Incr
0 7.15G SBT_TAPE 00:10:59 05-SEP-10
BP
Key: 152130 Status: AVAILABLE Compressed: NO Tag: HOT_DB_BK_LEVEL
0
Handle:
bk_5901_1_728946836 Media:
List
of Datafiles in backup set 152120
File
LV Type Ckp SCN Ckp Time Name
----
-- ---- ---------- --------- ----
1
0 Incr 676568630 05-SEP-10 /ora_dat/ssadb/system01.dbf
3
0 Incr 676568630 05-SEP-10 /ora_dat/ssadb/sysaux01.dbf
32
0 Incr 676568630 05-SEP-10 /ora_idx/ssadb/idx_SSAERP15.dbf
RMAN> run {
2> allocate channel ch00 type
'SBT_TAPE';
3> send 'NB_ORA_CLIENT=ora-rs';
4> validate backupset 152120,151119;
5> release channel ch00;
6> }
allocated channel: ch00
channel ch00: sid=690 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for
Oracle - Release 6.5 (2007072323)
sent command to channel: ch00
channel ch00: starting validation of
datafile backupset
channel ch00: reading from backup piece
bk_5886_1_728858000
channel ch00: restored backup piece 1
piece handle=bk_5886_1_728858000
tag=HOT_DB_BK_LEVEL0
channel ch00: validation complete,
elapsed time: 00:08:48
channel ch00: starting validation of
datafile backupset
channel ch00: reading from backup piece
bk_5887_1_728858565
channel ch00: restored backup piece 1
piece handle=bk_5887_1_728858565
tag=HOT_DB_BK_LEVEL0
channel ch00: validation complete,
elapsed time: 00:02:15
released channel: ch00
Validate
Oracle Archive Log Files
RMAN> list backup of archivelog all
completed after '05-SEP-10';
List of Backup Sets
===================
BS Key Size Device Type Elapsed
Time Completion Time
------- ---------- -----------
------------ ---------------
152199 504.50M SBT_TAPE 00:01:09
05-SEP-10
BP Key: 152203 Status:
AVAILABLE Compressed: NO Tag: TAG20100905T212
702
Handle: al_5903_1_728947623
Media:
List of Archived Logs in backup set
152199
Thrd Seq Low SCN Low Time
Next SCN Next Time
---- ------- ---------- ---------
---------- ---------
1 20647 675468442 04-SEP-10
675618305 04-SEP-10
1 20648 675618305 04-SEP-10
675621933 04-SEP-10
1 20649 675621933 04-SEP-10
675787032 05-SEP-10
1 20650 675787032 05-SEP-10
675801972 05-SEP-10
1 20651 675801972 05-SEP-10
675950772 05-SEP-10
1 20652 675950772 05-SEP-10
675970688 05-SEP-10
1 20653 675970688 05-SEP-10
675990826 05-SEP-10
1 20654 675990826 05-SEP-10
676142884 05-SEP-10
1 20655 676142884 05-SEP-10
676161224 05-SEP-10
1 20656 676161224 05-SEP-10
676178891 05-SEP-10
1 20657 676178891 05-SEP-10
676195036 05-SEP-10
BS Key Size Device Type Elapsed
Time Completion Time
------- ---------- -----------
------------ ---------------
152200 476.00M SBT_TAPE 00:02:10
05-SEP-10
BP Key: 152204 Status:
AVAILABLE Compressed: NO Tag: TAG20100905T212
702
Handle: al_5904_1_728947623
Media:
List of Archived Logs in backup set
152200
Thrd Seq Low SCN Low Time
Next SCN Next Time
---- ------- ---------- ---------
---------- ---------
1 20658 676195036 05-SEP-10
676217270 05-SEP-10
1 20659 676217270 05-SEP-10
676234683 05-SEP-10
1 20660 676234683 05-SEP-10
676254444 05-SEP-10
1 20661 676254444 05-SEP-10
676274108 05-SEP-10
1 20662 676274108 05-SEP-10
676291037 05-SEP-10
1 20663 676291037 05-SEP-10
676305509 05-SEP-10
1 20664 676305509 05-SEP-10
676322927 05-SEP-10
1 20665 676322927 05-SEP-10
676351397 05-SEP-10
1 20666 676351397 05-SEP-10
676526354 05-SEP-10
1 20667 676526354 05-SEP-10
676543636 05-SEP-10
1 20668 676543636 05-SEP-10
676569175 05-SEP-10
1 20669 676569175 05-SEP-10
676569211 05-SEP-10
BS Key Size Device Type Elapsed
Time Completion Time
------- ---------- -----------
------------ ---------------
152499 687.25M SBT_TAPE 00:01:13
06-SEP-10
BP Key: 152503 Status:
AVAILABLE Compressed: NO Tag: TAG20100906T212
801
Handle: al_5917_1_729034081
Media:
List of Archived Logs in backup set
152499
Thrd Seq Low SCN Low Time
Next SCN Next Time
---- ------- ---------- ---------
---------- ---------
1 20670 676569211 05-SEP-10
676716175 05-SEP-10
1 20671 676716175 05-SEP-10
676724745 06-SEP-10
1 20672 676724745 06-SEP-10
676885284 06-SEP-10
1 20673 676885284 06-SEP-10
676905415 06-SEP-10
1 20674 676905415 06-SEP-10
676923094 06-SEP-10
1 20675 676923094 06-SEP-10
676942976 06-SEP-10
1 20676 676942976 06-SEP-10
677097830 06-SEP-10
1 20677 677097830 06-SEP-10
677247249 06-SEP-10
1 20678 677247249 06-SEP-10
677261164 06-SEP-10
1 20679 677261164 06-SEP-10
677277774 06-SEP-10
1 20680 677277774 06-SEP-10
677293510 06-SEP-10
1 20681 677293510 06-SEP-10
677310453 06-SEP-10
1 20682 677310453 06-SEP-10
677328878 06-SEP-10
1 20683 677328878 06-SEP-10
677347699 06-SEP-10
1 20684 677347699 06-SEP-10
677365452 06-SEP-10
BS Key Size Device Type Elapsed
Time Completion Time
------- ---------- -----------
------------ ---------------
152500
671.25M SBT_TAPE 00:02:13 06-SEP-10
BP Key: 152504 Status:
AVAILABLE Compressed: NO Tag: TAG20100906T212
801
Handle: al_5918_1_729034081
Media:
List of Archived Logs in backup set
152500
Thrd Seq Low SCN Low Time
Next SCN Next Time
---- ------- ---------- ---------
---------- ---------
1 20685 677365452 06-SEP-10
677394448 06-SEP-10
1 20686 677394448 06-SEP-10
677409834 06-SEP-10
1 20687 677409834 06-SEP-10
677426170 06-SEP-10
1 20688 677426170 06-SEP-10
677440722 06-SEP-10
1 20689 677440722 06-SEP-10
677457081 06-SEP-10
1 20690 677457081 06-SEP-10
677470170 06-SEP-10
1 20691 677470170 06-SEP-10
677483727 06-SEP-10
1 20692 677483727 06-SEP-10
677496501 06-SEP-10
1 20693 677496501 06-SEP-10
677510607 06-SEP-10
1 20694 677510607 06-SEP-10
677522135 06-SEP-10
1 20695 677522135 06-SEP-10
677534305 06-SEP-10
1 20696 677534305 06-SEP-10
677549321 06-SEP-10
1 20697 677549321 06-SEP-10
677703740 06-SEP-10
1 20698 677703740 06-SEP-10
677717755 06-SEP-10
1 20699 677717755 06-SEP-10
677739134 06-SEP-10
1 20700 677739134 06-SEP-10
677739175 06-SEP-10
RMAN> run {
2> allocate channel ch00 type
'SBT_TAPE';
3> send 'NB_ORA_CLIENT=ora-rs';
4> validate backupset 152500;
5> release channel ch00;
6> }
allocated channel: ch00
channel ch00: sid=690 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for
Oracle - Release 6.5 (2007072323)
sent command to channel: ch00
channel ch00: starting validation of
archive log backupset
channel ch00: reading from backup piece
al_5918_1_729034081
channel ch00: restored backup piece 1
piece handle=al_5918_1_729034081
tag=TAG20100906T212801
channel ch00: validation complete,
elapsed time: 00:06:56
released channel: ch00
No comments:
Post a Comment