Database Backup and Recovery (MOSC)

MOSC Banner

Restore backup data from tape

edited Jul 26, 2011 9:41PM in Database Backup and Recovery (MOSC) 12 commentsAnswered ✓
Hi,

Can you please help me to restore the tape backup to a different server (new server). This is urgent... Please

My DB verion: 9.2.0.8

OS: Windows 2003

Current Backup Script:

connect target /@<<<DB_ID>>>
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'cf_%F.RMAN';
RUN {
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=<<server>>.prod,NB_ORA_POLICY=prod-oracle-windows-<<server>>.prod-ALL,NB_ORA_SERV=<<backupserver>>.factset.com,NB_ORA_SCHED=Default-Application-Backup';
BACKUP INCREMENTAL LEVEL=0 FORMAT 'bk_u%u_s%s_p%p_t%t' DATABASE;
RELEASE CHANNEL ch00;
sql 'alter system archive log current';

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