Backup & Recovery :: Failed To Load Media Management Library
Jun 30, 2012
i just run the command
RMAN> crosscheck backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 06/30/2012 14:25:12
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
RMAN> configure default device type to disk;
old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # defa
[code]....
View 2 Replies
ADVERTISEMENT
May 11, 2012
I am trying to move my data files from one location to other as i ran out of space.
SQL> alter database rename file 'C:oracleproduct10.2.0oradataSPF433SPF433ADW_DATA.DBF' to 'D:OracleDatafilesSPF433SPF433ADW_DATA.DBF';
Database Altered
SQL> alter database rename file 'C:oracleproduct10.2.0oradataSPF433SPF433ADW_DATATEMP.DBF' to 'D:OracleDatafilesSPF433SPF433ADW_DATATEMP.DBF'
Database Altered
Now when i am trying to run Alter Database open I get ORA-01113: file 5 needs media recovery error
View 11 Replies
View Related
May 13, 2012
my restore scenario bellow.
I have hot full backup that processed by NetBackup Policy. the backup policy are;
1.Full backup database in Monday. Daily_Monday_RMAN <- 1 volume pool=1 media
2.Full backup database in Tuesday .Daily_Tuesday_RMAN <- 1 volume pool=1 media
3.Full backup database in Wednesday. Daily_Wednesday_RMAN <- 1 volume pool=1 media
4.Full backup database in Thursday. Daily_Thursday_RMAN <- 1 volume pool=1 media
5.Full backup database in Friday. Daily_Friday_RMAN <- 1 volume pool=1 media
6.Full backup database in Saturday. Daily_Saturday_RMAN <- 1 volume pool=1 media
How to restore database from one of medias?
View 5 Replies
View Related
Jan 26, 2012
I have a database for which I use RMAN for backup & recovery. The database is in archivelog mode. Online redo log files are multiplexed and I have more than one destinations for archive logs. If, due to a disk crash, all data files and redo log files are gone - and I have archive logs, one member of each redo log group and a full database backup available, I can recover till the last archived log. But I want to ask that what about the transactions which were not archived at the time of media failure? How can I recover committed transactions which were not archived at the time of crash, and I have a mirrored copy of log group which was current at the time of failure?
View 5 Replies
View Related
May 24, 2011
I take backup database with RMAN utility . Now without any third-party software I want to take backup database with RMAN utility and put on TAPE LIBRARY TS3100 . and I got error message.plz guide me how to configure TAPE library for RMAN
RMAN> run {
2> allocate channel stb1 device type stb format '/dev/IBMtape0/Full_dwhtest2_%T_%s';
3> backup ( database include current controlfile );
4> backup format '/dev/IBMtape0/Arc_dwhtest2_%T_%s' ( archivelog all);
5> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on stb1 channel at 05/22/2011 19:47:14
ORA-19554: error allocating device, device type: STB, device name:
ORA-27001: unsupported device type
View 7 Replies
View Related
Jul 28, 2011
We all know about the new feature introduced in Oracle 11g ie. "Deferred Segment Space management" in which there in no segment allocated to table which is empty, which means that only the data is going to be inserted in the table the first segment is going to be allocated.
I created a user assigned a default tablespace to it, created 3 tables, two of them having data and 1 empty table.
When I did export using the export utility, I found that the empty table was not included however the same situation contradicted when I did the export using "EXPDP".
I want to know is the something of tables missing in export happen in RMAN backup of the tablespace which I have assigned to that user.
View 6 Replies
View Related
Sep 28, 2011
I have a database in Archivelog mode and Flashback mode. I am trying to connect to RMAN. But am getting the error
SQL> select name,log_mode,flashback_on from v$database
2 /
NAME LOG_MODE FLA
--------- ------------ ---
ORCL ARCHIVELOG YES
SQL> show user
USER is "SYS"
SQL> host rman target /
[code]....
View 16 Replies
View Related
Feb 11, 2011
I have recently patched my catalog home to 9208 from 9204; the target database is still on 9204 but now I cannot connect to the catalog database.
oracle@mogw:TES1:/u01/app/oracle/admin/TES1/bdump
rman rcvcat rman/rman@RMANDB
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
[code]...
View 11 Replies
View Related
Jun 25, 2013
While connecting to target database from stand database. I am getting below error.
calhost dbs]$ sqlplus system/oracle@proddb
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:10 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[standdb@localhost dbs]$ rman target system/oracle@proddb auxiliary system/oracle@standdb
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:22 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
View 7 Replies
View Related
Apr 11, 2012
We are getting below error while doing backup of the database through RMAN.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch02 channel at 04/11/2012 00:23:24
ORA-19502: write error on file "/backup/PDWH/RMAN/PDWH_data_820_1_780279469.rmn", block number 961920 (block size=8192)
ORA-27072: File I/O error
Linux Error: 25: Inappropriate ioctl for device Additional information: 4 Additional information: 961920 Additional information: 802816
Even i checked the space & it was good enough to hold the backup.
View 10 Replies
View Related
May 18, 2011
i am creating a library management system using struts 2.i have a form that display a table having column(bookname, author, publisher,..etc) and it contains an operation "edit book" with each row. now i m stuck with an update query(or any other query) by which i can edit an entire row (or any column) onclicking the edit button.i'm using oracle 10g database.
View 2 Replies
View Related
Oct 3, 2012
Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:Users>rman
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Oct 3 16:24:38 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect target sys/@proddb
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04002: ocipi failed, ORA--1
when i try to connect with the prod database by logging in the server,then it raise the above error.
i want to aware you with what i have done before it--
(1) this database is running on the port 1526 not on 1521, because of some reason new listner have to made.
(2) i can easily access this database without any error from my local machine, then it doesnot raise-ORA-12154: TNS:could not resolve the connect identifier specified
now i am going to take backup from RMAN at my local machine of same database , then
C:UsersNeetesh>rman target /@proddb
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Oct 3 16:29:47 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12154: TNS:could not resolve the connect identifier specified
C:UsersNeetesh>
View 11 Replies
View Related
Jul 23, 2012
We having OSB 10.4 on Solaris 10 with SL 24 TL Auto loader ( Tapes doesn't having Bar-code ), while firing file system backup (Sol 10 is the client OS) , it is hanging . and i have logged in to TL console then it shows loading and unloading. while OSB catalog backup is getting fired on the associated media family.
View 2 Replies
View Related
Nov 29, 2012
One of database, while taking backup using RMAN, it failed with the following error:
RMAN-03009: failure of backup command on DISK4 channel at 11/28/2012 09:47:29
ORA-19566: exceeded limit of 0 corrupt blocks for file <faile_name>
I used DBV to identify the number of blocks corrupted.
I referred the Metalink iD 457422.1 & 336133.1. But it did not work since the corrupted blocks have got object in it.
I could able to find the object as well. it is one of the table in the datafile.
I used 'ALTER TABLE ... MOVE..' command to see if that works. But again getting the same error while taking the backup and corrupted blocks still exists.
DB Version : 10.2.0.5
OS Version : RHEL 5.6
View 5 Replies
View Related
Nov 15, 2011
while executing a clone script i got the below error : -
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/15/2011 20:07:34
RMAN-12010: automatic channel allocation initialization failed
RMAN-06758: DB_UNIQUE_NAME is not unique in the recovery catalog
Here i understand that RMAN couldn't find which SPFILE to use to restore the target DB.
How do i check for the DB_UNIQUE_NAME in recovery catalog?
The proposed solution that i found was Use the FOR DB_UNIQUE_NAME option to specify the name of the instance whose parameter file you want to restore. how to implement this in my clone script?
View 7 Replies
View Related
Oct 23, 2013
When I try to start lampp, I am getting the below error.
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/no-debug-non-zts-20090626/oci8.so' - libclntsh.so.10.1: cannot open shared object file: No such file or directory in Unknown on line 0
But I have libclntsh.so.11.1 in my system. Why it is searching for libclntsh.so.10.1?
View 3 Replies
View Related
Jun 27, 2013
I am using 64bit RHL machine which is with oracle 11g. i was having one problem earlier
ORA-01116: error in opening database file 6ORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/tbs_data.dat'ORA-27041: unable to open fileLinux Error: 2: No such file or directory So what i did was SQL> select tablespace_name from dba_data_files where file_id = 6;SQL> alter tablespace sa offline immediate; RMAN> restore datafile 6;RMAN> recover datafile 6;
This gave me error.
RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002:
failure of recover command at 06/27/2013 13:31:44RMAN-06053: unable to perform media recovery because of missing log SQL> alter tablespace sa online;alter tablespace sa online*ERROR at line 1:ORA-01113: file 6 needs media recoveryORA-01110: data file 6: '/u01/app/oracle/product/11.2.0/db_1/dbs/tbs_data.dat'
what is the reason for this. There is no data in database.
View 6 Replies
View Related
Oct 27, 2012
I just installed Oracle XE on my local computer Windows 7. When I run STARTUP command I get this error:
SQL> startup;
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1384760 bytes
Variable Size 226496200 bytes
Database Buffers 301989888 bytes
Redo Buffers 5791744 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:ORACLEXEAPPORACLEORADATAXESYSTEM.DBF'
I try to fix it by recover but unsuccessfully:
SQL> recover datafile 'D:ORACLEXEAPPORACLEORADATAXESYSTEM.DBF'
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
View 5 Replies
View Related
Dec 1, 2011
I have created dataguard between two instances hosted in two different servers. I have done switchover from primary to standby & then again standby to primary with DGMGRL utility.
1- When I done switchover to primary & trying to open standby database in readonly mode it was giving below error-
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
Why this error was coming ?
2- As I was not able to open standby database in read only mode, I have executed below command-
alter database recover managed standby database disconnect from session;
which return an error as-
ORA-01153: an incompatible media recovery is active
After this I have executed-
alter database recover managed standby database cancel;
which executed successfully.
& then after standby database open in read only mode.
Why above error was coming ?
3- After this I had tried to check the checkpoint_change# & controlfile_change# from primary database and result shows both number were different.
Why they are not matching ?
View 6 Replies
View Related
Sep 19, 2012
I noticed that my standby server was behind the prduction one.In the error log I noticed: ORA-00600: internal error code, arguments: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
then
MRP0: Background Media Recovery terminated with error 448
Recovered data files to a consistent state at change 286116915
This error happens in sequence: Recovery of Online Redo Log: Thread 1 Group 4 Seq 8830 Reading mem 0I found this archive log in standby and it is same size as in the production one.
View 9 Replies
View Related
Jul 6, 2010
I've experienced an error while installing the Application Management Pack 3 on Linux Machine (OS: Oracle Enterprise Linux 5.3 32-bit) with EM Grid Control 10g Release 5. I want to install the Grid Control Plug-in Oracle E-Business Suite Management Pack 3 to manage our EBS Oracle Apps R12, but it was failed due to error. Below was the logs for error:
Log: /u01/app/oraInventory/logs/installActions2010-07-06_03-00-11PM.log
RepManager was not able to run successfully.
/applications/em/em/WEB-INF/lib/myjar.jar:/u01/app/oracle/OracleHomes/oms10g/sysman/jlib/emCfg.jar:/u01/a
pp/oracle/OracleHomes/oms10g/jlib/ojmisc.jar:/u01/app/oracle/OracleHomes/oms10g/sysman/jlib/emUpgrade.jar
:/u01/app/oracle/OracleHomes/oms10g/sysman/jlib/emagentSDK.jar oracle.apps.oms_extn.util.EBSOUIUtil RepMa
[code].....
View 1 Replies
View Related
Oct 25, 2012
I am using 11.2.0.1.0 on RHEL 5.4ASM is properly working on my machine. database is running from ASM. I want to configure additional oracleasm devices.command fails saying:
$ oracleasm createdisk ASMDISK08 /dev/xvd8
Writing disk header: done
Instantiating disk: failed
Clearing disk header: done
I am creating asm diskgroup on loopback devicesHere are the configured loopback devices.
[root@host1 ~]# ls -l /dev/loop[1-9]
brw-rw-rw- 1 oracle oinstall 7, 1 Oct 25 14:42 /dev/loop1
brw-rw-rw- 1 oracle oinstall 7, 2 Oct 25 14:42 /dev/loop2
brw-rw-rw- 1 oracle oinstall 7, 3 Oct 25 14:42 /dev/loop3
brw-rw-rw- 1 oracle oinstall 7, 4 Oct 25 14:42 /dev/loop4
[code]...
I am unable to understand where is the problem.
View 11 Replies
View Related
Mar 27, 2013
My cluster have two node.Data diskgroup uses normal redundancy.Priamry disks are located in one storage.Fail group disks are located in another storage.When we close the failgroup disks' storage the 2nd instance restart.After automatically restarted everything goes well.I want to know why does the 2nd instance restart?Is it normal?
View 2 Replies
View Related
Sep 4, 2012
I am getting error while Full database logical export backup
Physical RAM 8GB
SGA 5632MB
Database info
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
Error details
ORA-31694: master table "SYSTEM"."ORCL" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-00604: error occurred at recursive SQL level 3
ORA-21780: Maximum number of object durations exceeded.
ORA-06512: at "SYS.DBMS_METADATA", line 1548
ORA-06512: at "SYS.DBMS_METADATA", line 1585
[code]....
View 6 Replies
View Related
Dec 14, 2012
i'm trying to install Oracle Apex Listener but when i try to open the apex.war file is giving me an error:
$ java -jar apex.war
Failed to load Main-class manifest attribute from apex
i see in another topic that if i create a txt file inserting the MainClass: Main-Class that my error will disappear.
i'm using VM with OEL 5
View 4 Replies
View Related
Feb 10, 2011
We are trying to restore a database on the different server using RAM incremental level 0 and 1 backups. We have weekly Incremental level 0 backups along with incremental backups on daily basis. During recovery of Incremental level 0 backup, RMAN is expecting/looking for Incremental Level 0 backup of prior week as well. Is this the usual process for RMAN to look for prior level 0 backup though we need to restore from the current level 0 backup and roll forward by a week with subsequent Level 1 backup.?
We intend to restore from the Level 0 of 1/16 and roll forward with daily incrementals till 1/22. RMAN is expecting level 0 backupsets from 1/9 backup as well and keep failing since those backups are not available. quick inputs since we are in middle of recovery and trying to resolve if this is even doable.
View 11 Replies
View Related
Sep 24, 2010
ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload
ORA-31640: unable to open dump file "D:oradataPSPRODDBdata_pump_dirpowerschool-fri.dmp" for read
ORA-19505: failed to identify file "D:oradataPSPRODDBdata_pump_dirpowerschool-fri.dmp"
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 2192117862)
View 10 Replies
View Related
Aug 27, 2012
I have recently upgraded our test APEX environment from 3.2.1 to 4.1.1.00.23. Everything went smoothly - I have only one small but annoying problem. In both administration and administration services some background graphics are not displayed. This issue occurs only under Mozilla Firefox (in MS IE it OK). The application frontend is OK in both browsers.
Under Firefox, I inspected the sourcecode in Firebug and the relative links to images. e.g.
background: url("../apex/builder/bg-region-darkblue-r.gif") no-repeat scroll
show message "Failed to load the given URL".
somehow related to the fact that our application is accessed via apache proxy. Because when I open the administration and/or administration services page in FF directly on the server, it displays correctly (incl. images).
But the network (Apache proxy) configuration is exactly the same as in the previous version of APEX where we had no problem. Something must have changed in the sourcecode of the new version.
View 3 Replies
View Related
Oct 20, 2011
Here is the details
[oracle@localhost dbs]$ export ORACLE_SID=stby
[oracle@localhost dbs]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 20 09:47:34 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> !
[oracle@localhost dbs]$ pwd
/oraeng/app/oracle/product/10.2.0/dbs
[oracle@localhost dbs]$ exit
exit
[code].....
View 1 Replies
View Related
Oct 18, 2011
I have problem on using "delete obsolete" in RMAN.
First, let describe my backup configuration.
1. Full backup every Monday (17-Oct, 10-Oct, 3-Oct, 26-Sep)
2. Incremental backup for other days
3. Enable autobackup of control file
4. Backup archive log every day
5. RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS
6. Execute "Delete obsolete" every day
7. control file is used instead of catalog
The results observed:
1. Backup of control files older than 30 days will be deleted
2. Backup of archive log files older than 30 days will be deleted.
3. Backup of datafiles older than ~14 days but before 30 days are also DELETED.
In my example, the backup of datafiles created at 26-Sep is deleted at 16-Oct.
I tried "restore database validate until time "sysdate-22"" at 17-Oct. And RMAN reported "datafile xx will be created automatically during restore operation". It seems that RMAN failed to do restoration up to 22 days ago. The retention policy I set seems not effective on datafile backups.
I checked view v$backup_set and the "Keep" is "No" and "Keep until" is empty.
The only thing I can think of, is the settings of "CONTROL_FILE_RECORD_KEEP_TIME". It is marked "7" in the Oracle, which is less than the retention. But I suppose this only causes the backup not deleted, but NOT be deleted earlier.
View 6 Replies
View Related
