Home » RDBMS Server » Backup & Recovery » Problem with RMAN via the EM console
Problem with RMAN via the EM console [message #249707] Thu, 05 July 2007 10:48 Go to next message
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 #249709 is a reply to message #249707] Thu, 05 July 2007 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
restore datafile 4,5;

You tried to RESTORE the files not to RECOVER them so RMAN needs the location where they were backed up that is tape.

Regards
Michel
Re: Problem with RMAN via the EM console [message #249731 is a reply to message #249707] Thu, 05 July 2007 12:26 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

icon10.gif  Re: Problem with RMAN via the EM console [message #249760 is a reply to message #249751] Thu, 05 July 2007 15:11 Go to previous message
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.
Previous Topic: error in flashing back database,
Next Topic: rman and security
Goto Forum:
  


Current Time: Sat Dec 10 07:12:20 CST 2016

Total time taken to generate the page: 0.21860 seconds