Thursday, March 26, 2020

How to Test RMAN Tape Backup

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Mar 26 21:46:47 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN>
connected to target database: HYPP (DBID=2806684771)

RMAN>
connected to recovery catalog database

RMAN>
echo set on


RMAN> run {
2> allocate channel oem_sbt_backup type 'sbt_tape' format '%d_%U' parms "NBR_BACKUP_CHANNELS=4NB_ORA_CLASS=ora_octavo_hyppNB_ORA_CLIENT=octavo.ecp.privNB_ORA_SCHED=oracleNB_ORA_SERVER=flexo.ecp.priv";
3> backup as BACKUPSET current controlfile tag '03262020094644';
4> restore controlfile validate from tag '03262020094644';
5> release channel oem_sbt_backup;
6> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on oem_sbt_backup channel at 03/26/2020 21:47:19
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27209: syntax error in device PARMS - unknown keyword or missing =


RMAN> allocate channel for maintenance type 'sbt_tape'  parms "NBR_BACKUP_CHANNELS=4NB_ORA_CLASS=ora_octavo_hyppNB_ORA_CLIENT=octavo.ecp.privNB_ORA_SCHED=oracleNB_ORA_SERVER=flexo.ecp.priv";
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ORA_MAINT_SBT_TAPE_1 channel at 03/26/2020 21:47:19
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27209: syntax error in device PARMS - unknown keyword or missing =


RMAN> delete noprompt backuppiece tag '03262020094644';
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1764 device type=DISK
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 03/26/2020 21:47:46
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27209: syntax error in device PARMS - unknown keyword or missing =


RMAN> exit;

Recovery Manager complete.


##################################

 run
{
allocate channel t1 device type sbt;
send 'NB_ORA_SERV=agathor,NB_ORA_CLIENT=hermes.ecp.priv';
set archivelog destination to '/dbapps/oracle';
restore archivelog from logseq=48626 until logseq=48627 thread 1;
}

No comments:

Post a Comment