Database Backup and Recovery (MOSC)

MOSC Banner

Listing backups

Hi Experts,

Log for Full backup taken with Data Protector tool has shown below. DBA dont have access to tape media.
From putty, Can we run prepare a script and check what all backups are available in media.
 


Log:
====
[Normal] From: ob2rman@erpproddb1.ttd.com ""  Time: 11/24/23 04:56:07
	Starting Oracle Recovery Manager.
 
 
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Nov 24 04:56:07 2023
Version 19.17.0.0.0
 
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
 
RMAN> CONNECT TARGET *
2> HOST 'exit';
3> run {
4> allocate channel 'dev_0' type 'sbt_tape'
5> parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
6> 
7> allocate channel 'dev_1' type 'sbt_tape'
8> parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';


48> 
49> send device type 'sbt_tape' 'OB2BARHOSTNAME=erpprod-scan.ttd.com';
50> send channel 'dev_0' 'OB2BARTYPE=Oracle8';
51> send channel 'dev_0' 'OB2APPNAME=prodcdb2';
52>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center