Database Backup and Recovery (MOSC)

MOSC Banner

RMAN tapes backup and recovery

edited Oct 21, 2010 4:13PM in Database Backup and Recovery (MOSC) 3 commentsAnswered
Dear Oracle Experts,

Please help me on my RMAN backup scripts below.

The level 0 will be run weekly and level 1 on daily.

1. How can I add a new backup location on a tape drive?
2. Can I keep tape-backup files longer than files on a server drive? 
3. Since I was working on my DB server remotely, how can I know backup files on tapes are still usable for recovery?
4. Can my backup files on tape be easily recovered onto my DB.

Thanks

Liz


## LEVEL 0##
run {
allocate channel EAG1 type disk;

BACKUP INCREMENTAL LEVEL 0
tag='MPSA2 LVL 0 dif DB BKUP'
format 'D:\dbbackup\RMAN\Level_0\MPSA2L0_t%t_s%s_p%p_c%c.bak'

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