| Problem with RMAN via the EM console [message #249707] |
Thu, 05 July 2007 10:48  |
enrdes
Messages: 4
Registered: July 2007
|
Junior Member |
|
|
Hi, I am trying to recover 2 datafiles via EM console: maintenance tab -> perform recovery. I am on Win XPSP2 with 10gR2.
My DB is in Archive Log mode so I should be able to recover from my archive logs and redo logs located in the flashback area, and correctly pointed by the initialization parameters.
At the end of the steps, I can see on the console screen the output of RMAN, but there are not enough indications to understand where to dig further:
**************************************************************************
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 5 00:16:08 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
connected to target database: ORCL4 (DBID=547098002)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> run {
2> restore datafile 4,5;
3> }
Starting restore at 05-JUL-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=153 devtype=DISK
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/05/2007 00:16:12
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
RMAN> exit;
Recovery Manager complete.
***************************************************************
As mentioned my archive logs are in the flash recovery area and not on tape so I am not sure why RMAN seems to attempt to recover from tape as well after the attempt from disk is failing. My knowledge of RMAN though is zero and really don't know where the problem can be.
This is the output of RMAN> show all;
*************************************************************
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # defa
ult
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 1 G;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 1 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S
NCFORCL4.ORA'; # default
*******************************************************
Reason I am trying to recover these 2 datafiles is because due to an error they have been filled up, I am not even allowed to allocate additional space for them and they just show in the "recover" status instead of "online".
Thanks in advance for your help.
|
|
|
|
|
|
| Re: Problem with RMAN via the EM console [message #249731 is a reply to message #249707] |
Thu, 05 July 2007 12:26  |
enrdes
Messages: 4
Registered: July 2007
|
Junior Member |
|
|
Hi Michel thanks.
I never configured tapes and don't use them as this is all happening on my laptop for practice. I have archived logs, and I can see them in the flash recovery area. When I click on maintenance tab in the EM console and then on Perform Recovery, I don't seem to find options to either recover or restore - I just follow the guided steps, and when submit, I expect the files to begin recovery, instead I receive that error.
What I would like to accomplish is recovering the 2 data files as they were yesterday or a couple of days back. I think I have all archive logs from at least one week back, so I should be able to do it ... can you please give me some indications (with or without the use of EM console)?
Thanks a lot!
|
|
|
|
| Re: Problem with RMAN via the EM console [message #249743 is a reply to message #249709] |
Thu, 05 July 2007 13:50 |
enrdes
Messages: 4
Registered: July 2007
|
Junior Member |
|
|
Michel, here I am trying to restore from a back up dated june 27 named : 'BACKUP_ORCL4_00004_062707111919'. This is on my hard disk, and EM is able to see it and place as an option during the steps.
But at the end when submitting, I am getting the same error:
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 5 14:26:03 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
connected to target database: ORCL4 (DBID=547098002)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> run {
2> restore datafile 4,5 from tag 'BACKUP_ORCL4_00004_062707111919';
3> }
Starting restore at 05-JUL-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=150 devtype=DISK
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/05/2007 14:26:07
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
RMAN> exit;
Recovery Manager complete.
|
|
|
|
| Re: Problem with RMAN via the EM console [message #249751 is a reply to message #249743] |
Thu, 05 July 2007 14:42 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # defa
ult
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 1 G;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 1 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S
NCFORCL4.ORA'; # default
|
CHANGE ALL SBT_TAPE ENTRIES WITH DISK
change sbt_tape to disk type.
[Updated on: Thu, 05 July 2007 14:42] Report message to a moderator |
|
|
|
 Re: Problem with RMAN via the EM console [message #249760 is a reply to message #249751] |
Thu, 05 July 2007 15:11 |
enrdes
Messages: 4
Registered: July 2007
|
Junior Member |
|
|
michel, dreamz, thank you - the problem is finally fixed and I was able to recover my DB to 24 hours back.
I modified RMAN as follows:
• RMAN TARGET /
• RMAN> CONFIGURE DEVICE TYPE 'SBT_TAPE' CLEAR;
• RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear;
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
