Topic: Backup & Recovery >> not able restore and recover datbase files with RMAN
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: not able restore and recover datbase files with RMAN |
| yogi |
Posted: May 06, 2008 04:57:36 AM |
Total Post: 3
Joined: Apr, 2008
|
hi all,
day before yesterday i configuared RMAN in one of test database,
configured all parameter, default device type to disk later i changed to default device type to SBT_TAPE, back device type to disk .iam not able to perform restore n recovery operation. here is the script which is giving me the error
[oracle@nisi-dba-122 ~]$ rman target sys/sys@sir catalog rman/rman@catdb
Recovery Manager: Release 10.2.0.3.0 - Production on Tue May 6 02:08:16 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SIR (DBID=1074185434)
connected to recovery catalog database
RMAN> backup database;
Starting backup at 06-MAY-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/d04/stony/system.dbf
input datafile fno=00004 name=/d04/stony/sysaux.dbf
input datafile fno=00003 name=/d04/stony/undo.dbf
input datafile fno=00005 name=/d04/stony/tools.dbf
input datafile fno=00002 name=/d04/stony/usr04.dbf
channel ORA_DISK_1: starting piece 1 at 06-MAY-08
channel ORA_DISK_1: finished piece 1 at 06-MAY-08
piece handle=/d04/stony/recover/SIR_DB_39jflhts_105_1 tag=TAG20080506T020900 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
Finished backup at 06-MAY-08
Starting Control File and SPFILE Autobackup at 06-MAY-08
piece handle=/d04/stony/control/c-1074185434-20080506-03 comment=NONE
Finished Control File and SPFILE Autobackup at 06-MAY-08
RMAN> restore database;
Starting restore at 06-MAY-08
using channel ORA_DISK_1
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/06/2008 02:10:08
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 9
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO NONE;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/d04/stony/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '/d04/stony/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
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 2;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/d04/stony/recover/%d_DB_%u_%s_%p';
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 '/d04/stony/RMAN';
how to activate restore n recover command |
|
|
 Mohammed Taj |
| Posted: May 06, 2008 08:35:43 AM |  |
|
Total Post: 634
Joined: Jul, 2007
|
Manually allocate channel to DISK before restore command.
{
run
allocate channel c1 device type DISK;
restore database;
}
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Mohammed Taj | 634 |
| Murtuja Khokhar | 586 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 385 |
| Ramesh Jois | 226 |
| neeraj sharma | 189 |
| snehalatha p | 166 |
| Gitesh Trivedi | 150 |
| Gopu Gopi | 138 |
| Kushal ratnaker | 136 |
|
|
