Oracle drop logfile group error!

I got the following error while executing the statement:SQL> alter database drop logfile group 3;alter database drop logfile group 3*ERROR at line 1:ORA-00350: log 3 of thread 1 needs to be archivedORA-00312: online log 3 thread 1: 'F:\ORA9I\ORADATA\TESTDB\REDO03.LOG'Can anybody tell me the reaso ...

MySQL ERROR 1529 (HY000): Failed to drop LOGFILE GROUP

mysql> select version(); +----------------------------------+ | version() | +----------------------------------+ | 5.1.35-ndb-7.0.7-cluster-gpl-log | +----------------------------------+ I can't drop a logfile group. This is error message; mysql> DROP LOGFILE GROUP lg_1 ENGINE NDBCLUSTER; ERRO ...

Oracle ORA-01291: missing logfile, but not actually

OS - win 2000 SP4Database - Oracle 10.2I am trying to run the logminer utility in Oracle 10g,but dbms_logmnr.start_logmnr stops with error ORA-01291: missing logfile if STARTIME is used. I used the same steps in 9i, which executed without error. Below is the code which are executed in order.SQL> ...

Oracle Logical Standby Dataguard experience. Robust? Reliable?

DBAs,Need sharing from all of your experience using logical standby Dataguard in 10gR2 or 11gR1. Do you feel that this logical standby technology requires high operational overhead (e.g. lots of problems, bugs, not so robust, error prone, etc). Transaction load is rather high for my environment.I on ...

Oracle ORA-01156 recovery in progress may need access to files

I am facing ORA-01156 ERROR error while renaming datafile.it says:ORA-01156: recovery in progress may need access to files My steps:- alter database datafile 'xxx' offline;- move/copy datafile- alter database rename file 'xxx' to 'xxx'; !!!!!!!---ora-01156 ERROR- recover datafile 'xxx' (new location ...

Oracle ORA-01274 on Physical Standby database.

I have configured a physical standby database with **LGWR ASYNC ** transport services, which works fine. When I create a set of datafiles, and users on the primary site, and then do a log switch, the alert log at standby site is being written with the error: **ORA-01274**.I have attributed this to s ...

Oracle ORA-01274 on Physical standby ---- REMOVED A FEW TERMS NO REPLY NEEDED.

I have configured a physical standby database with ARCH transport services, which works fine. When I create a set of datafiles, and users on the primary site, and then do a log switch, the alert log at standby site is being written with the error: **ORA-01274**.I have attributed this to some configu ...

Oracle 9i database software upgrade issue with standby (Dataguard) database

All,I have encountered a problem in upgrading the Oracle software on 2 of our databases in-house. The databases in question here are using Dataguard, so one is set to primary and one is set to standby. The version that they are/were starting at is 9.2.0.7. I was able to install and complete the 9.2. ...

Oracle Drop LogFile

I have Oracle 9, and I have a LogFile corrupt, message:ORA-00354 corrupt redo log block header, so I would like to drop this LogFile but i have next error: ORA-00350 log string of thread string needs to be archived, and I can not drop it, Could you let me know what i can do? ...

Oracle Steps to breakup a Primary to Physical Standby dataguard/replication

I have a setup consisting of a primary d/b and a physical standby d/b.I now want to break up this dataguard environment in such a way that the both these databases become totally independant of each other. I don't want to drop or damage the primary d/b in any way.Can someone suggest where I can find ...

Oracle drop datafile in dataguard

HelloOracle 10.2.0.1I have dataguard configuration with standby file management auto.When I add a datafile, it is automatically added to standby database.However,when I drop a datafile, it is dropped from primary database but it is not dropped from the standby database..What is the reason for this? ...

Oracle ORA-01078,LRM-00123 in dataguard configuration

i'm in middle of dataguard configuration...in the doc which i'm using they have mentioned to edit the primary ora file and make some necessary changes,i did those changes,but at the time of spfile creation it is throwing an error like ora-01078,lrm-00123,i'm attaching both the content below,i need u ...

Oracle Multiple Standby Dataguard Configuration

Sorry if this has been posted before, but I could not find the answer.I have a Primary site (PRIM) and one Standby site(STBY1). The standby receives archive log changes from the primary. Also using dataguard to manage the Standby. I would like to create another standby (STBY2) and use the current st ...

Oracle ORA-600 ORA-08102 - Drop user name cascade;

Is there anyone that could help me ? I have installed Oracle Xe on Windows XP SP2 and when I try to drop a user using sqlplus, I receive the message:ORA-00604 - SQL recursive error level 1ORA-08102 : index key not found , obj# 110, file 1, block 43558 (2).I really don´t know what to do any more... ...

Oracle ORA-03113 while creating standby db

i created standby db when i trying to recover the dB then i'm getting error ORA-03113.SQL> startup nomount;ORACLE instance started.Total System Global Area 1058505840 bytesFixed Size 730224 bytesVariable Size 889192448 bytesDatabase Buffers 167772160 bytesRedo Buffers 811008 bytesSQL> alter da ...

Oracle standby-dataguard

people talk about the standby database and the dataguard.what is the actual difference between the standby database and the datagaurd.Does both of them indicate the same or there is any difference between them in their name and in their functionality. ...

Oracle ORA-1403 on Logical Standby (looks like invalid ROWID)

We have implemented 10.2.0.4 Data Guard (Logical Standby) on Windows Server 2003 R2 and after a deployment to production where we added a new column to a table (with a default of 'N') then updated 15 rows in the table to 'Y' the SQL Apply Failed with ORA-1403 No data found. The table in question is ...

Oracle switchover logical standby dataguard

we are using oracle9i on enterprise linux 3 . our primary and logical database are not located remotely but are two different servers.now i need to know the steps that i need to perform in order to switch my primary database to standby database and vice versa . i tried few things but was unsuccessfu ...

Oracle ora-01203 error in Standby database

I have Standby Db running on windows, oracle version 9208. I have above said error when i did import the tablespace to my primary database. Is there any way i can attach this tablespace to standby (i thought automatically it can do) or I have to recreate the Standby from scratch i mean from the resc ...

Oracle Moving a tablespace on a standby dataguard database

I have moved a tablespace to another filesystem on my primary database and now need to move the corresponding tablespace on my standby. Is there anyway of doing this? I don't particulary want to rebuild it as its big...I'm using version 10.1.0.5.0 ...

Oracle Backup Physical Standby (Dataguard) using RMAN : Issues

I am running a RMAN backup on standby server using the command below. The RMAN backup is actually connecting to the primary database on another server, I found this very confusing and to reassure, i shutdown the primary database and ran the backup again. It fails with not able to conenct to target d ...

Oracle standby dataguard

iget the following Alert in the my enterprise manager (em) window The Data Guard status of standby1 is Error ORA-12154: TNS:could not resolve the connect identifier specified.whats wrong with my data guard configuration? ...

Oracle In my standby dataguard configuration

I observed one strange thing in my database is that my archives are getting shipped regularly to DR site but in night time only it starts to getting applied. Some time, it starts to apply but its very slow. I confirmed with network team and they said that there is no problem in connectivity.Could an ...

Oracle dropping log file in standby database

Please,I need a help for the following issue:I'm making a technical documentation on various event that occur on dataguard configuraation, right now I drop a redo log group file on primary database, and when I try to drop the equivalent log group file on standby database I got the following error:SQ ...

Oracle Active dataguard + ORA-07445: exception encountered: core dump [kmmlrl()

I have this problem in dataguard. I setup dataguard success archivelog apply from primary dataguard system to standby dataguard system.but when i change active dataguard by step sql> startup mount;sql> alter database open read only;in alert log oracle show this error in below and database shut ...

Oracle ora-01561 when trying to drop an offline tablespace in 8i

i 'm using oracle 8i ,9i and 10g. On oracle 8i i have a tablespace 'users' that has no data . The select * from dba_segments where tablespace_name ='users' returns no rows. i made the tablespace offline and the following command fails with ora-01561. drop tablespace users including contents; is ther ...

Oracle ORA-600 in standby alert log

We have recently migrated our database from Solaris to Linux (RHEL5) and since this migration we are seeing weird errors related to archive log shipping to the remote standby site and a corresponding ORA-600 in the standby site.What's interesting is everything gets resolved by itself, it always seem ...

Oracle ORA-279 signalled during recovery of standby database

I am preparing standby database after taking hot backup and copying those datafiles to standby,taken controlfile standby controlfile backup from primarymounted the standby database using standby controlfile usingstartup nomount pfile='/u01/stand.ora'alter database mount standby database;Now I have s ...

Gaps in Oracle Dataguard Standby

The system is a Logical Standby Dataguard.With the following query it is possible to see that there are gaps:SQL> set numformat 99999999999SQL> set linesize 2000SQL> set pagesize 20000SQL> select thread# trd, sequence#,2 first_change#, next_change#,3 dict_begin beg, dict_end end,4 to_cha ...

Oracle standby db log status CLEARING_CURRENT

I have a physical standby server with 2 log groups. One has a status of CLEARING, and the other has a status of CLEARING_CURRENT. I think there was a disk-write error that initiated theses statuses. That situation has been remedied.My question is, how do I get the logs to clear? Other information: T ...

Oracle prob. with DataGuard

i have created standby db in oracle 9i it is working fine but i have some doubt reg. redolog files.i have configured log_archive_dest_2='service=<servicename> that means arch process will resposible for log transfre and disk write prameter is by default noaffirm(i realy dont understand the mea ...

Oracle SDU Dataguard configuration

Please, Looking for some clarification implementing SDU parameter file.I'm configuring Dataguard using Oracle 10g,Release 2 on WindowsIn order to best use data size sent amoung primary,standby and clients application oracle recommends to configure SDU parameter for the highest size.Network configura ...

Oracle ORA-00205: error of identification of the control archive

They help me please! Soon apos the installation of the OracleXE in Windows XP, I was to try to open the page of the bank and it did not open. Later I was in the command line (sqlplus) to logar as they system and it gave this message to me: ora-01033 oracle initialization or shutdown in process alrea ...

ORA-00349: failure obtaining block size for '+Z' in Oracle XE

I am attempting to move the online redo log files to a new flash recovery area location created on network drive "Z" ( Oracle Database 10g Express Edition Release 10.2.0.1.0). When I run @?/sqlplus/admin/movelogs; in SQL*Plus as a local sysdba, I get the following errors: ERROR at line 1: ORA-00349: ...

Oracle Standby db in R/W mode with RMAN

I have a test environment that I have a physical non-managed standby database created in a virtual machine. I would like to use a physical standby database for read/write testing and reporting. I've been implementing the Data Guard Scenarios and tried to see if I can revert the activated database ba ...

Oracle Standby Media Recovery Process fails !!!

On the Primary DB 10.2.0.3 i did a Database Point in time recovery and then opened it in reset logs. I do have a standby (dataguard) in online apply mode and its not applying the new series of logs after the restlogs in primaryWhen restarted the Standby database, the alert.log of standby shows the M ...

Oracle recover standby database

Our primary linux 10g db is in standard edition and we would like to manually create a standby databaseAfter copying the control and datafiles from primary to standby database, started the standby instance ..SQL> startup nomount pfile=/path/to/pfile/initSID.standbySQL> alter database mount sta ...

Oracle Logical Standby Scenario..!!

We are having dataguard setup with Primary, Physical standby and Logical Standby databases located on three different machines..Oracle Version : 10.2.0.1OS : RHEL 4 on (x86 32-Bit)Following are our initialization parameters for all the three instances.. Primary Database Parameters--*.db_unique_name= ...

Oracle Problem drop inactive redo log group

At first I had created the database with the default redo log file sizes. Then I added larger redo log groups with the objective of removing the default ones that were created using DBCA. This is a two node RAC. SQL> r1 select group#,thread#,bytes,members,status from gv$log2* order by group#GROUP ...

Oracle ORA-01219: database not open: queries allowed on fixed tables/views only

I am working in Oracle database 10G. My database was working fine till last night but today when i started my SQLPLUS session, it was showing me following error, ORA-01219: database not open: queries allowed on fixed tables/views only So i did the following steps from command prompt, sqlplus /nologc ...

Oracle rman duplicate target for standby, standby redo not created on standby side

I was trying to use rman to create a physical standby database. Our database version is 10.2.0.4 Here is the rman script.run{Allocate auxiliary channel aux2 device type disk;duplicate target database for standby dorecover.}The standby redo logs were created in primary database before the rman duplic ...

How to stop and start oracle applications standby database 9.2

I want to do the maintenance of my production and standby dbatabase. i want to stop both standby and production databases, restart the severs and then start the production and standby databases. Our standby database is not open for users.As far as i know, the following are the steps for stopping the ...

Oracle Data Guard appear to be OK but cannot open standby

I configured data Guard physical standby on Red hat with Oracle 11.2. I followed the dochttp://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10g_RACPrimarySingleInstancePhysicalStandby.pdf . Things went smoothly and after the duplication completed and created satndby rego log on the satnd ...

Oracle dataguard recovery not happenning

I have configured physical standby dataguard for maximum availability and was working fine. When i did switchover i found that the archives are transfered but the recovery is not havppening. I created a table on my present primary and log switched, but the table is not recovered at standby.At Primar ...

drop tablespace including contents!!!!

I created an instance Oracle with more tablespace.I have a tablespace "art" with four users (CREATE USER john IDENTIFIED BY john DEFAULT TABLESPACE "art" TEMPORARY TABLESPACE TEMP)owner is user TOM.Now I must drop the tablespace "art" and import again the dmp.I tried wi ...

Deleting OMF Managed LOGFILE Members

Is there a way to add LOGFILE members to a OMF managed LOGFILE group ?I can add an OMF managed LOGFILE group. But any LOGFILE members I add thereafter are not OMF managed.Here is what I did :1. Set destination for ONLINE log groupDB_CREATE_ONLINE_LOG_DEST = 'c:\oradata\db92'2. Add a LOGFILE groupALT ...

Activate Oracle 8i Standby Database

I'm trying to write a DR procedure for my company. We have an Oracle 8i primary database with a Standby database in manual recovery mode (not managed standby).Assuming the primary database has crashed (data unrecoverable), are there any other steps I have to perform to activate the standby database ...

Oracle Lost Current Logfile

Friends. I cannot start my Instance because the Redo logfile current was deleted. I can startup mount but not open the database. I try: 1. Alter system switch logfile, but database is not open 2. alter tablespace drop logfile group 3 , but can not drop because is the current logfile. 3. alter databa ...

Oracle Lost Current Logfile

Friends. I cannot start my Instance because the Redo logfile current was deleted. I can startup mount but not open the database.I try:1. Alter system switch logfile, but database is not open2. alter tablespace drop logfile group 3 , but can not drop because is the current logfile.3. alter database c ...

Oracle drop tablespace including contents!!!!

I created an instance Oracle with more tablespace.I have a tablespace "art" with four users (CREATE USER john IDENTIFIED BY john DEFAULT TABLESPACE "art" TEMPORARY TABLESPACE TEMP)owner is user TOM.Now I must drop the tablespace "art" and import again the dmp.I tried without drop the users but I get ...