• RELEVANCY SCORE 4.98

    DB:4.98:Onlined Redo Logs Questions j1




    Hi,
    i want to know is there any methods to start up a DB after i lost all onlined redo logs
    (including the active one).
    Also, is there any feature in oracle that can store the redo log group in more than one location ???

    thanks
    Stephen

    DB:4.98:Onlined Redo Logs Questions j1

    Hi Stephen
    Yes. There is an option of recovering the database is case of loss of redologs including the active ones.

    1. If you have a backup of last night and if the database is in archivelog mode, all you have to do is to restore the LN backup files and recover it until the last available archivelog and finally open the database using the resetlogs option.

    2. If you have shutdown the database normally after the redo loss, then simply mount the database and open the database with resetlogs option.

    regards
    niveshn

  • RELEVANCY SCORE 3.50

    DB:3.50:Ora-00313 sk




    hi everyody ;

    i have 9i runs on SLES9 .. it has only 3 redo logs on path1 . each group has 1 redo log. i add second member of redo logs with different path on OEM Console..

    ( redo01.log -- path1 )
    ( redo01b.log -- path2 )

    i make this addition to all redo log groups.. each group has 2 member now...

    then i alter my database to archivelog on OEM Console ... after press apply button a pop up menu appears to stop and start my database to take this archivelog affects..

    it succesfully stop and start the database. when i check the alert.log file after this operation i give some error that ; ORA-00313

    Errors in file /opt/oracle/admin/CMAN/bdump/cman_lgwr_3007.trc:
    ORA-00313: open failed for members of log group 1 of thread 1
    Wed Apr 29 16:17:05 2009
    Errors in file /opt/oracle/admin/CMAN/bdump/cman_lgwr_3007.trc:
    ORA-00313: open failed for members of log group 2 of thread 1
    Wed Apr 29 16:17:05 2009
    Errors in file /opt/oracle/admin/CMAN/bdump/cman_lgwr_3007.trc:
    ORA-00313: open failed for members of log group 3 of thread 1
    Wed Apr 29 16:17:05 2009
    Errors in file /opt/oracle/admin/CMAN/bdump/cman_lgwr_3007.trc:
    ORA-00313: open failed for members of log group 1 of thread 1
    Thread 1 opened at log sequence 638
    Current log# 1 seq# 638 mem# 0: /disk2/oracle/oradata/CMAN/redo01.log
    Successful open of redo thread 1.
    Wed Apr 29 16:17:05 2009
    SMON: enabling cache recovery
    Wed Apr 29 16:17:05 2009
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Undo Segment 4 Onlined
    Undo Segment 5 Onlined
    Undo Segment 6 Onlined
    Undo Segment 7 Onlined
    Undo Segment 8 Onlined
    Undo Segment 9 Onlined
    Undo Segment 10 Onlined
    Successfully onlined Undo Tablespace 1.
    Wed Apr 29 16:17:05 2009
    SMON: enabling tx recovery
    Wed Apr 29 16:17:06 2009
    Database Characterset is WE8ISO8859P9
    replication_dependency_tracking turned off (no async multimaster replication found)
    Completed: /* OracleOEM */ ALTER DATABASE OPEN
    Archiving is enabled
    ARCH: STARTING ARCH PROCESSES
    ARC0 started with pid=13
    ARC0: Archival started
    Wed Apr 29 16:17:09 2009
    ARCH: STARTING ARCH PROCESSES COMPLETE
    ARC1 started with pid=14
    ARC1: Archival started

    database works fine . there is no problem .. when i check all initialization parameters on OEM Console log_archive_start parameter is FALSE ..

    did i make mistake about redo logs ?

    and

    did i make mistake on altering database to archivelog ?

    thanks.....

    DB:3.50:Ora-00313 sk

    Yes, you just might need to switch the logfile if it is CURRENT

    So, you can't drop a member if it is in use.
    Then first use:

    ALTER SYSTEM SWITCH LOGFILE ;

    Success

  • RELEVANCY SCORE 3.21

    DB:3.21:Re: Asm Migrate Archive Redo Logs p9




    Not possible. Redo Logs managed by Oracle during lifecycle of database.

    DB:3.21:Re: Asm Migrate Archive Redo Logs p9

    Kindly mark as correct or helpful my post which solved or helped to solve your problem.

  • RELEVANCY SCORE 3.08

    DB:3.08:Check Generated Redo Logs? p9


    hi guys,

    was wondering how do one check that redo logs is generated?

    DB:3.08:Check Generated Redo Logs? p9

    flaskvacuum wrote:

    1) What do YOU mean by 'check that redo logs are generated"?
    {quote}

    i realise that the filesystem (archived log) is growing quite fast lately

    {quote}
    2) Why do you want to do this? What is your long term objective?
    {quote}
    not too sure which batch jobs (transaction) are causing this.. ..would like to narrow it down.

    Edited by: flaskvacuum on Mar 6, 2012 3:20 PMBack to basics here
    - which operating system (including edition and version, especially if Windows), which version of the database (as reported by header from 'sqlplus' command)
    - is this a production or a test system, and roughly what does it do (warehouse, user entry transaction, payroll, ...)
    - how do you take backups (hot/cold; manually, using alter database begin backup; or rman)
    - has something changed since before what you define as 'lately'

    And - is the rapid redo switch and the load into the archive area a problem? Or becoming a problem? Or just for interest?

    The tools we can offer to help you understand, and the short and long term approach depend entirely on your answers. Otherwise each of us who responds will assume a different environment and you will likely get confused.

  • RELEVANCY SCORE 2.92

    DB:2.92:Advise For A Pseudo-Data Warehouse? 8m


    Hello:

    We are looking into setting up a database that is a mirror of our production environment for querying only. Running of queries in our production environment has proven to be too much of a strain on resources. I have been researching setting up this mirrored machine as a standby database in the managed environment. It could then be queried when in "read only" mode. It seems like it would offer a lot of advantages. We are already generating redo logs on the production machine, so I don't think there would be much overhead added to the production machine. One concern I have, is the robustness of the net8 transfer of the redo logs from the production machine to the standby machine? The redo logs would go over a WAN, and thus might be susceptible to blips in the connection. Is the transferring of the redo logs over net8 robust enough to recover from this, or would the transfer just fail and not restart?

    Also, an additional requirement, is for data from another database (Microsoft SQL Server) to be available in this standby database. Is this possible? It seems that when a database is set up as a standby machine, it is basically a slave to the main database, and no operations can be performed on it. Is that the case?

    I know these are kind of vague questions. I can provide more info on our requirements if anybody is curious...

    Thanks!

    DB:2.92:Advise For A Pseudo-Data Warehouse? 8m

    Hello:

    We are looking into setting up a database that is a mirror of our production environment for querying only. Running of queries in our production environment has proven to be too much of a strain on resources. I have been researching setting up this mirrored machine as a standby database in the managed environment. It could then be queried when in "read only" mode. It seems like it would offer a lot of advantages. We are already generating redo logs on the production machine, so I don't think there would be much overhead added to the production machine. One concern I have, is the robustness of the net8 transfer of the redo logs from the production machine to the standby machine? The redo logs would go over a WAN, and thus might be susceptible to blips in the connection. Is the transferring of the redo logs over net8 robust enough to recover from this, or would the transfer just fail and not restart?

    Also, an additional requirement, is for data from another database (Microsoft SQL Server) to be available in this standby database. Is this possible? It seems that when a database is set up as a standby machine, it is basically a slave to the main database, and no operations can be performed on it. Is that the case?

    I know these are kind of vague questions. I can provide more info on our requirements if anybody is curious...

    Thanks!

  • RELEVANCY SCORE 2.87

    DB:2.87:Steps To Load Data Into Tables Using Redo Logs zm


    Hi,

    Anyone know how to load data into target tables using redo logs files.
    I'm implementing Real-time data warehouse.
    Please help on understanding Real-time data warehouse and give me example on loading data into tables using redo logs.

    Thanks you very much adv.

    -D

  • RELEVANCY SCORE 2.76

    DB:2.76:Msg.Disklib.Toomanyredo - Too Many Levels Of Redo Logs x7



    msg.disklib.TOOMANYREDO - Too many levels of redo logs

    Does anybody know when this message will appear - what is the maximum allowed?

    DB:2.76:Msg.Disklib.Toomanyredo - Too Many Levels Of Redo Logs x7


    msg.disklib.TOOMANYREDO - Too many levels of redo logs

    Does anybody know when this message will appear - what is the maximum allowed?

  • RELEVANCY SCORE 2.75

    DB:2.75:Logminer To Recover Mail 7j


    Does LogMiner only look in redo logs or will it use the archive redo log files also?

    DB:2.75:Logminer To Recover Mail 7j

    yep, both - needs to be configured.

  • RELEVANCY SCORE 2.74

    DB:2.74:Redo Logs Deleted?? 87


    Hi there,
    By accident, I lost all my redo logs. The database could not start up.
    Is there any solution??? (Oracle 8i 1.7)
    Thanks a lot
    JF

    DB:2.74:Redo Logs Deleted?? 87

    Hi there,
    By accident, I lost all my redo logs. The database could not start up.
    Is there any solution??? (Oracle 8i 1.7)
    Thanks a lot
    JF was the db cleanly shutdown when u lost your redo logs (ie shutdown normal, immediate, transacational)

    if so,

    issue
    startup mount
    recover database until cancel using backup controlfile

    when prompted for archive logs type CANCEL

    issuse

    alter database open resetlogs.

    If the db was up or you did not have a clean shutdown it may be possible to pop open
    then db with some undocumented underscore parameters. Do this only under the direction of
    oracle support. If you can pop open the db you will have to rebuild with an export as the
    data dictionary could become corrupted.

    steve

  • RELEVANCY SCORE 2.73

    DB:2.73:Standby Redo Logs 9j


    Hi all,11.2.0.3.10aix 6I want to create standby redo logs as pre-requisite for creating DG physical standby.Our prod has currently 3 members per log group. Is it okay if I create 1 member only per group for standby redo? or I need to pattern them on the ONLINE redo logs?Thanks all,mk

    DB:2.73:Standby Redo Logs 9j

    Thanks Brian, you are brilliant

  • RELEVANCY SCORE 2.72

    DB:2.72:Redo Logs: Read = Half Of Write Speed jd


    Dear All,

    What can be the cause of redo logs being read at the same speed of write.
    I have est. 25Mb/sec read and 44Mb/sec write to redo logs.

    I would appreciate to know your suggestions.
    This is not recovery, Logminer or redo logs archive....

    Thanks,
    Roman.

    DB:2.72:Redo Logs: Read = Half Of Write Speed jd

    Jonathan Lewis wrote:
    It would be useful to know how you've established this.
    Here's a simple guess that MIGHT be true for your environment, but MIGHT be completely irrelevant: maybe writes are acknowledged the instant they hit the SAN cache, but reads actually have to go to the disc.Jonathan, thanks for your suggestion. I do understand that answers will be more like guessing with such amount of information that I gave.
    But guesses is ok. This is more theory then practice for me. Server is not production and neither development.

    This is ERP simulation tool from Oracle named OAST.
    The storage is directly attached FC array.
    Read/write ratio is not constant and not any function of time.
    It can be any value 0% to 100% any time.

    Roman.

  • RELEVANCY SCORE 2.72

    DB:2.72:Tablespace Operation Written To Redo Logs? 38


    Hello,

    are operations on tablespaces such as:
    alter tablespace read only/ read write
    alter tablespace offline / online

    written to redo logs?

    Thanx in advance for answer,
    Aliq

    DB:2.72:Tablespace Operation Written To Redo Logs? 38

    Oracle Devotee wrote:
    hi it depends on whether you specified LOGGING option at the time of tablespace creation. by default it will be LOGGING so it will be in redolog files.I think that these dictionary related changes are not affected by the LOGGING attribute of the tablespace, but are logged unconditionally, since these are changes to the underlying dictionary tables. The LOGGING attribute of the tablespace affects the objects that reside within the tablespace. Additionally only certain operations can take advantage of the NOLOGGING feature, so normal DML activity will always generate redo even if NOLOGGING is used.

    Regards,
    Randolf

    Oracle related stuff blog:
    http://oracle-randolf.blogspot.com/

    SQLTools++ for Oracle (Open source Oracle GUI for Windows):
    http://www.sqltools-plusplus.org:7676/
    http://sourceforge.net/projects/sqlt-pp/

  • RELEVANCY SCORE 2.71

    DB:2.71:Re: Redo Logs Frequent Switching c8


    if you resize your redo logs, just check if the problem persist.
    If it will, try to resize to a highter value or create a new group of redo.

    DB:2.71:Re: Redo Logs Frequent Switching c8

    Vikas Kohli wrote:
    i am not able to understand. Can u please help me out, I just want to know wheather performance is affected by redo log file size or notIt can be, but that is not all that affects performance. For example, if the device the redo is on is slow, that will affect your performance no matter the log file size. The normal advice for the normal problem is to add more and/or make them bigger, but if that makes no difference, then obviously you should be looking for the actual problem. Some people might say you should look for the actual problem before you start doing magical incantations, but this might be an exception, where you should get basic configuration correct before you start playing tuning games.

    Get a statspack for 15 minute interval when things are slow. Let us know the layout of your disk devices. For example, do you have everything going to one RAID-5? What patch level of Oracle and OS are you on? What do OS utilities tell you is going on?

    It is possible you are simply doing too much and need to do less.

  • RELEVANCY SCORE 2.70

    DB:2.70:Re: Mass Delete --≫ Too Much Undo / Redo Generated. x1


    does rolling back generate any redo logs at all ?YES
    why is my redo log switching fast ? It depend size of online logs and transaction activities

    DB:2.70:Re: Mass Delete --≫ Too Much Undo / Redo Generated. x1

    Hemant K Chitale wrote:
    In principle, though, it could be possible for a table row delete to be rolled back by unmarking the row delete flag (if the row hasn't been shrunk to a stub). The DELETE does set a "D" flag in the row header. However, as you note, the row might get shrunk again. A block reorganisation by an UPDATE from the same transaction (or for that matter, another transaction) may also cause the contents of the block to be "rewritten". So, there's no guarantee that the pre-delete image is always available in the block ?
    In a simple, single user test, I can see the pre-delete image but I guess we can't be assured that it will always be available ?
    The Undo has the entire row so the rollback action is a "normal" INSERT ... VALUES (although not executed as an INSERT SQL). That way it is "safe" to be able to rollback. Correct so far.

    The re-INSERT may also reorganise the block if there have been other changes to the block. In it's current form the code may to reorganise the block even if there have been NO other changes to the block. Even with an "apparently unnecessary" copy back from undo the replaced row has to be inserted into the block free space - which means a "heap block compress" may have to be performed to make the free space available.

    (hmm.. could even the row have to be migrated if it finds, when attempting a rollback, that there isn't enough free space to re-INSERT ?)I don't think this would be possible. Oracle tracks the total free space and available free space for the block, and the 'free space credit' for each active transaction. This information held means it should be able to infer that an insert from another transaction (which would be the only one that could matter) would not leave enough space for the first transaction to rollback.

    Regards
    Jonathan Lewis

    Edited by: Jonathan Lewis on Apr 6, 2011 9:46 AM
    Corrected "block quotes"

  • RELEVANCY SCORE 2.70

    DB:2.70:Redo Logs In Standby Database 13


    Does standby database regenrates redo. It applies the redo it receives from primary , but does the changes made to standby database are logged in redo and hence archive log as in a normal database.

    DB:2.70:Redo Logs In Standby Database 13

    Physical standby does not generate or regenerate its own redo
    It receives the redo from primary
    manual or managed recovery apply this redo to the standby database via regular recovery mechanism

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/standby.htm#i72459
    2.5.1 Online Redo Logs and Archived Redo Logs

  • RELEVANCY SCORE 2.70

    DB:2.70:Fra, Log Multiplexing, And Shceduled Backup kp


    Oracle 11g R2 on Linux 64 bit. ASM for the data files. I have several questions in regarding to the backup process:For the backup and the log multiplexing, I plan to use the following method to back the data file, online logs, archived redo logs, and control files (I purposely put the backs to two different file system, i.e., one on the raw disk (Oracle managed file system), and another as the cooked file system (ext3 system):Disk 1 formatted as the raw disk for FRA (for data files, online logs, archived redo logs, and control files)Disk 2 formatted as the regular file system, i.e., ext3 file system (for multiplexing of online logs, archived redo logs, and control files) .My understanding is that at the run time, the RMAN automatically backups the datafile, control files, online redo logs, and the archived logs to the FRA disk. 1) For the online redo logs, I believe it is backuped to the FRA and multiplxed in a continuous and simultaneous mode to keep to data in sync with the redo logs in the SGA, right?2) For the datafile, the RMAN backups it to the FRA at a certain time. What could be that time? 2:00:00 am each day or whatever time I may specify?3) For the remote backup. I use the OEM to schedule a backup, say, increatmental on week days and full backup on weekends. From where will this the backed data come from? The FRA disk? or the ASM disks?ThanksScott

    DB:2.70:Fra, Log Multiplexing, And Shceduled Backup kp


    scottjhn wrote:

    I think my confusion of the automated backup concept came from here (excepted from the doc):

    For all installations, you must choose the storage option to use for Oracle Database files. If you want to enable automated backups during the installation, then you must also choose the storage option to use for recovery files (the fast recovery area).

    So I thought if I enabled automated backups, the Oracle would automatically back it up to the FRA. Now I understand that I need to manually set it up (via OEM/RMAN) in order to achieve the "automated backups".

    Another thing is about the backup of the online redo logs.
    there is no backup of online redo logs -- that's why it is strongly suggested you multiplex them.
    As is known, the redo logs are written in a round-robin way. Once the online log are full, they are moved to the archive (so called archived redo logs).
    The online redologs aren't moved anywhere. They are copied to archive redo logs.
    Now assume a synario, while the online redo logs are loaded into the System Global Area,
    That's the second time you've referenced online redo logs as being in the SGA. No, they are never in the SGA. Where are you getting that? The log buffers are in the SGA, but that is not the same as the files
    and being written on , the system gets crashed. This online redo log must be stored somewhere,
    Yes, they must be stored somewhere. And that somewhere is on disk, in exactly the place specified when the redo log group was defined. SELECT MEMBER FROM V$LOGFILE to see it.
    otherwise, when do the recovery lateron, some information will be missing.
    What information do you think will be missing? Your transaction is not complete, control does not return to you, until the OS has confirmed to oracle that the change data has been written to the online redologs -- which are on disk.
    So what my understanding is that while the online logs are written at the runtime, simultaneously, they are multiplxed to other places , asssume I have already specified the dest locations, such as the FRA or /u01/oradata/onlinelogs. By this way, when do the recovery lateron, it will be: data files + online log + archived logs + control files. But I am not sure I am right?
    No, you are not right. You are confusing instance recovery (aka crash recovery) with database/media recovery. Spend some time in the Concepts manual, and use the index to find every reference to 'redo'. Read especially the section on Instance recovery, and keep firmly in mind that instance recovery is not database recovery.
    Thanks
    Scott

  • RELEVANCY SCORE 2.70

    DB:2.70:Question On Standby Redo Logs 9s


    Environment : 11.2 on AIX 6.1

    I have created Physical Standby DBs where the archive logs are shipped to standby site and are applied to the standby DB.
    Only recently I came to know about Standby Redo logs. This is what i gather from a bit of googling

    1. Standby Redo logs , as the name implies are created ONLY at the physical standby server side

    2. If we are using standby redo logs files, then Primary DB does not have to be in ARCHIVELOG mode. We put the primary DB in ARCHIVELOG mode only for the purpose of hot RMAN backups.Are my above assumptions Right?

    I have two questions:

    1. When using the normal Standby DB setup using Archiver(archive log) , when there is a gap we can check whether a particular sequence is applied or not by checking
    v$archived_log.APPLIED = 'YES' and so forth. When using Standby Redo logs+LGWR combination, when there is a gap. How will you diagnose the gap issues ?

    2. To use standby redo logs , on the Primary Side apart from setting
    log_archive_dest_2='service=standby_orcl LGWR SYNC AFFIRM'what else needs to be done?

    DB:2.70:Question On Standby Redo Logs 9s

    CKPT, shivananda, mseberg. You guys have been equally helpful on this question. Thank you very much.

  • RELEVANCY SCORE 2.70

    DB:2.70:Recovery: Restore, Recover : ? j3


    Hello Experts
    I have some good DBA friends,When I ask some questions about recovery, they just said ' RMAN is cool, use need to restore and recover, you need not to bother about internal details !!' Is this right ?
    My questions are given below, they are very basic and might be very simple But they are nightmare to me::

    1. In what format a transaction store in redo logs(transaction, not single sql statement).

    2. Content of the transaction in Online Redo Logs(Does it contain old image of the data).

    3. If it contain Old image of data, in case of crash recovery; Does the required undo is generated from online redo logs ? Undo tablespace is only used to hold undo data generated during the recovery process ?

    4.Can loss of tablespace cause loss of data ? even online redo logs remain safe ?

    5. What is the role of transaction_ID in recovery process ?

    6.Does Oracle inspect Online redo logs before last checkpoint ?

    7. What about transactions those were in the progress while a checkpoint happened ?

    Regards
    Sunil Kumar

    DB:2.70:Recovery: Restore, Recover : ? j3

    you need not to bother about internal details Probably true at least until after you have read the Backup and Recovery Basics manual

    Backup and Recovery Basics
    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/title.htm#BEGIN

    Backup and Recovery Reference
    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/title.htm#BEGIN

    Backup and Recovery Advanced User's Guide
    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/title.htm#BEGIN

    HTH -- Mark D Powell --

  • RELEVANCY SCORE 2.68

    DB:2.68:Standby Questions jd


    Hello everbody,

    1) What is the difference between Real-Time Apply and Non Real-Time Apply?

    2) How Oracle decides whether the archival of the primary database redo logs to remote destination(Standby Database) is permitted?

    Regards

    DB:2.68:Standby Questions jd

    1) What is the difference between Real-Time Apply and Non Real-Time Apply?It depends on transport service you use either LGWR or ARCH for real-time apply LGWR service is applicable and you must have same number size of standby redo log files as Online redo log files, hence you can reduce lag between both sites.

    2) How Oracle decides whether the archival of the primary database redo logs to remote destination(Standby Database) is permitted? It depends on the SCN/sequence what standby need

  • RELEVANCY SCORE 2.68

    DB:2.68:Can Redo Logs Of 10g Express Be Used In 10g Standard Edition To Read Change s9


    Hi,
    I am using 10g Standard Edition database and I want read the redo logs of 10g Express Edition in my database. So is it possible to put redo log of express into standard edition and view all database changes?

    Will logminer utility work for this?

    The way redo logs are written in Express and Standard Edition are same?

    Thanks.

    DB:2.68:Can Redo Logs Of 10g Express Be Used In 10g Standard Edition To Read Change s9

    You probably have access to both version, why not give it a try and post your findings? Or how about going through the docs?
    or try google:
    http://groups.google.com/group/comp.databases.oracle.misc/browse_thread/thread/93a043998b1b1374?pli=1
    or the XE docs:
    http://download-uk.oracle.com/docs/cd/B25329_01/doc/license.102/b25456/toc.htm#BABJIJCJ

  • RELEVANCY SCORE 2.68

    DB:2.68:Change The Default Password Of System Account jm


    Dear all,I use SAPDBA to backup redo logs, but I can't backup redo logs after changing the default password of SYSTEM account(Oracle).Could I use another account to backup redo logs through SAPDBA? Or is there better solution? Many thanks.SAP R/3 4.7Oracle 9i

    DB:2.68:Change The Default Password Of System Account jm

    review SAP note 400241 to setup OPS$after this, you will need to call SAPDBA this way:sapdba -u /You should think about stopping using SAPDBa and start using BRTOOLS. SAPDBA is not supported on Oracle 10g (and you will need to go there eventually)

  • RELEVANCY SCORE 2.67

    DB:2.67:Standby Doubts k8


    Hello all,

    1)Standby Redo Logs do not to be multiplexed. Is it bacause to prevent additional writes by RFS process to SRL?

    2) How can I open the standby in read only mode if I have no online redo logs?

    3)If standby redo logs files is not present then RFS process directly creates archive logs?

    DB:2.67:Standby Doubts k8

    981738 wrote:
    Thanks for your valuable comments.

    Regarding my 1st question:

    Additional writes slowing down sending processes(LNS) on the production database. correct?No, LNS will be on primary and it will send to standby,
    But on standby it has to write in two standby redo log files if in case there is any slowness in archiving. And if in case any corruption on standby redo logs then archives can be fetched or copied from primary, Hence no need to multiplex the archive logs. And it is recommended for online redo log files to avoid SPOF.

    HTH.

  • RELEVANCY SCORE 2.67

    DB:2.67:Re: Redo Log Switch 8f


    If a transaction cannot 'fit' into a redo log, the associated arch file is smaller than the redo log file. 25M redo logs are too small.

    DB:2.67:Re: Redo Log Switch 8f

    yingkuan as you referred this link which nice one but as you and hjr agreed that

    it is wrong loss of all current redo logfiles are protected by frequent checkpoint.

    what i think if we set aside the performance for a while that frequent checkpoint reduce recovery time (i.e downtime concerned) cause less redo need to be applied which will ultimately/indirectly fall the current redo logfiles protected isnt?

    Khurram

  • RELEVANCY SCORE 2.66

    DB:2.66:Redo Logs kx


    i have read that redo log files stores redo entries. that is a group of change vector. change vector means how the blocks has been change. am i right ? please explain me what is change vector..

    that means if i update account no. form 30 to 40, redo log files stores 40 value. am i right ?

  • RELEVANCY SCORE 2.66

    DB:2.66:Re: Database Connection Getting Stuked ma


    Hi,
    Right now I am trying to get connection but stuked. Alert log message is as follows :
    Fri Mar 18 12:29:47 2011
    starting up 1 shared server(s) ...
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
    Fri Mar 18 12:29:52 2011
    alter database mount exclusive
    Fri Mar 18 12:29:59 2011
    Successful mount of redo thread 1, with mount id 3059996737.
    Fri Mar 18 12:29:59 2011
    Database mounted in Exclusive Mode.
    Completed: alter database mount exclusive
    Fri Mar 18 12:30:00 2011
    alter database open
    Fri Mar 18 12:30:05 2011
    Beginning crash recovery of 1 threads
    Fri Mar 18 12:30:06 2011
    Started first pass scan
    Fri Mar 18 12:30:13 2011
    Completed first pass scan
    3512 redo blocks read, 67 data blocks need recovery
    Fri Mar 18 12:30:14 2011
    Started recovery at
    Thread 1: logseq 18, block 7203, scn 0.0
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 18 Reading mem 0
    Mem# 0 errs 0: E:\ORACLE\ORADATA\SUPPORT\REDO02.LOG
    Fri Mar 18 12:30:18 2011
    Ended recovery at
    Thread 1: logseq 18, block 10715, scn 0.49318939
    67 data blocks read, 67 data blocks written, 3512 redo blocks read
    Crash recovery completed successfully
    Fri Mar 18 12:30:30 2011
    Thread 1 advanced to log sequence 19
    Thread 1 opened at log sequence 19
    Current log# 3 seq# 19 mem# 0: E:\ORACLE\ORADATA\SUPPORT\REDO03.LOG
    Successful open of redo thread 1.
    Fri Mar 18 12:30:32 2011
    SMON: enabling cache recovery
    Fri Mar 18 12:30:49 2011
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Undo Segment 4 Onlined
    Undo Segment 5 Onlined
    Undo Segment 6 Onlined
    Undo Segment 7 Onlined
    Undo Segment 8 Onlined
    Undo Segment 9 Onlined
    Undo Segment 10 Onlined
    Successfully onlined Undo Tablespace 1.
    Fri Mar 18 12:30:49 2011
    SMON: enabling tx recovery
    Fri Mar 18 12:30:49 2011
    Database Characterset is WE8MSWIN1252
    Fri Mar 18 12:31:01 2011
    replication_dependency_tracking turned off (no async multimaster replication found)
    Completed: alter database open

    Please Check ...
    Thanks
    Niloy

    DB:2.66:Re: Database Connection Getting Stuked ma

    Check your server memory utilization, if there is some unwanted processes running then kill them.
    It seems to be less memory available for oracle Database.

  • RELEVANCY SCORE 2.66

    DB:2.66:Startup Question - Ora-01111 Error 98


    Hello All-

    I'm working on setting up a Test DB for our Prod System. After much trial and error and help from some experts on here, I can finally get the Test system to recover and open! However, when I attempted to run our night job on it last night, I got an error and was instructed our software consultant to change the 'undo_management' parameter from MANUAL to AUTO in order to successfully run the night job.

    So, today I shut the Test DB down with a "shutdown immediate" command (did not recreate the controlfile), then changed the 'undo_managment' parameter in the init file to AUTO and attempted to restart the Test DB using the "startup" command. However, when I do this, I get an error:

    SQL startup
    ORACLE instance started.

    Total System Global Area 1502242576 bytes
    Fixed Size 743184 bytes
    Variable Size 452984832 bytes
    Database Buffers 1048207360 bytes
    Redo Buffers 307200 bytes
    Database mounted.
    ORA-01092: ORACLE instance terminated. Disconnection forced

    SQL

    And in my ".trc" file:

    /ubc/oracle/dprtest/dumps/udump/dprtest_ora_1355944.trc
    Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.6.0 - Production
    ORACLE_HOME = /ubc/oracle/OraHome1
    System name: AIX
    Node name: p650
    Release: 2
    Version: 5
    Machine: 0001875A4C00
    Instance name: dprtest
    Redo thread mounted by this instance: 1
    Oracle process number: 12
    Unix process pid: 1355944, image: oracle@p650 (TNS V1-V3)

    *** SESSION ID:(9.3) 2007-05-03 11:31:40.547
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Undo Segment 4 Onlined
    Undo Segment 5 Onlined
    Undo Segment 6 Onlined
    Undo Segment 7 Onlined
    Undo Segment 8 Onlined
    Undo Segment 9 Onlined
    Undo Segment 10 Onlined
    ORA-00376: file 20 cannot be read at this time
    ORA-01111: name for data file 20 is unknown - rename to correct file
    ORA-01110: data file 20: '/ubc/oracle/OraHome1/dbs/MISSING00020'

    Then, if I change the parameter value back to MANUAL and log back in and run a regular "startup", Oracle starts and the database mounts and starts without any problems...

    What do the
    ORA-00376: file 20 cannot be read at this time
    ORA-01111: name for data file 20 is unknown - rename to correct file
    ORA-01110: data file 20: '/ubc/oracle/OraHome1/dbs/MISSING00020'
    errors mean and how do I fix them?

    Thanks in advance for your time and help!
    -JG

    DB:2.66:Startup Question - Ora-01111 Error 98

    Thanks so much! That worked!!

    I greatly appreciate your help!
    -JG

  • RELEVANCY SCORE 2.66

    DB:2.66:Re: Online Redo Logs Vs Backup 1k


    Welcome!!!!!

  • RELEVANCY SCORE 2.65

    DB:2.65:Does Asm Hold The Redo Logs And Undo Ts In A Rac Setup aj


    redo logs and undo ts are instance specific. We plan to use ASM to manage the database. Are redo logs and undo ts stored in the ASM disk group?

    DB:2.65:Does Asm Hold The Redo Logs And Undo Ts In A Rac Setup aj

    Yes,
    You can put it in ASM.

    Bellow You can see which types of files You can put in ASM:

    Version 10:
    [File Types Supported by Automatic Storage Management|http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/storeman.htm#i1021337]

    Version 11:

    [File Types Supported by Automatic Storage Management|http://download.oracle.com/docs/cd/E11882_01/server.112/e10500/asmfiles.htm#OSTMG13910]

    Hope it helps,
    Cerreia

  • RELEVANCY SCORE 2.65

    DB:2.65:Redo-Logs fa



    Hello,

    i would like to create REDO-LOGs with some .dsk-files.

    I checked in the "append"-option in esx-server for

    the special .dsk-files. The REDO works fine.

    But now i would like to get the redo-information in

    another Partition (for performance reasons).

    Do you know how i can do this?

    DB:2.65:Redo-Logs fa


    so there is no posibility to create the redo in another folder? IN GSX in know it is possible.

  • RELEVANCY SCORE 2.65

    DB:2.65:Unexpected Shutdown... Urgent kj


    Hi all,

    I have experienced some unexpected shutdowns on my Oracle 9i Database, and I just can4t figure out what4s wrong. There is no error message on the log. The shutdown is followed by an automatic restart just seconds later. What could be wrong??

    Please, any help would be really appreciated...
    Tks..

    Here is the log file:

    Sat Sep 14 15:14:26 2002
    Thread 1 advanced to log sequence 285
    Current log# 3 seq# 285 mem# 0: /data01/oracle/oradata/gowap/redo03.log
    Current log# 3 seq# 285 mem# 1: /data01/oracle/oradata/gowap/redo03b.log
    Mon Sep 16 05:04:35 2002
    Thread 1 advanced to log sequence 286
    Current log# 1 seq# 286 mem# 0: /data01/oracle/oradata/gowap/redo01.log
    Current log# 1 seq# 286 mem# 1: /data01/oracle/oradata/gowap/redo01b.log
    Mon Sep 16 18:39:41 2002
    Shutting down instance: further logons disabled
    Shutting down instance (immediate)
    License high water mark = 43
    Mon Sep 16 18:39:43 2002
    ALTER DATABASE CLOSE NORMAL
    Mon Sep 16 18:39:43 2002
    SMON: disabling tx recovery
    SMON: disabling cache recovery
    Mon Sep 16 18:39:45 2002
    Thread 1 closed at log sequence 286
    Mon Sep 16 18:39:45 2002
    Completed: ALTER DATABASE CLOSE NORMAL
    Mon Sep 16 18:39:45 2002
    ALTER DATABASE DISMOUNT
    Completed: ALTER DATABASE DISMOUNT
    ARCH: Archiving is disabled
    Shutting down archive processes
    archiving is disabled
    Archive process shutdown avoided: 0 active
    ARCH: Archiving is disabled
    Shutting down archive processes
    archiving is disabled
    Archive process shutdown avoided: 0 active
    Mon Sep 16 18:43:14 2002
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    LICENSE_MAX_USERS = 0
    Starting up ORACLE RDBMS Version: 9.0.1.0.0.
    System parameters with non-default values:
    processes = 150
    timed_statistics = TRUE
    shared_pool_size = 67108864
    large_pool_size = 10485760
    java_pool_size = 8388608
    resource_manager_plan = SYSTEM_PLAN
    control_files = /data01/oracle/oradata/gowap/control01.ctl, /data01/oracle/oradata/gowap/control02.ctl, /data01/oracle/oradata/gowap/control03.ctl
    db_block_size = 8192
    db_cache_size = 20971520
    compatible = 9.0.0
    fast_start_mttr_target = 0
    undo_management = AUTO
    undo_tablespace = UNDOTBS
    remote_login_passwordfile= EXCLUSIVE
    db_domain =
    instance_name = gowap
    background_dump_dest = /data01/oracle/admin/gowap/bdump
    user_dump_dest = /data01/oracle/admin/gowap/udump
    core_dump_dest = /data01/oracle/admin/gowap/cdump
    sort_area_size = 5242880
    db_name = gowap
    open_cursors = 300
    Data Guard broker requires Oracle Enterprise Edition license
    PMON started with pid=2
    DBW0 started with pid=3
    LGWR started with pid=4
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    Mon Sep 16 18:43:19 2002
    ALTER DATABASE MOUNT
    Mon Sep 16 18:43:28 2002
    Successful mount of redo thread 1, with mount id 3410670407.
    Mon Sep 16 18:43:29 2002
    Database mounted in Exclusive Mode.
    Completed: ALTER DATABASE MOUNT
    Mon Sep 16 18:43:29 2002
    ALTER DATABASE OPEN
    Mon Sep 16 18:43:33 2002
    Thread 1 opened at log sequence 286
    Current log# 1 seq# 286 mem# 0: /data01/oracle/oradata/gowap/redo01.log
    Current log# 1 seq# 286 mem# 1: /data01/oracle/oradata/gowap/redo01b.log
    Successful open of redo thread 1.
    Mon Sep 16 18:43:34 2002
    SMON: enabling cache recovery
    Mon Sep 16 18:43:35 2002
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Undo Segment 4 Onlined
    Undo Segment 5 Onlined
    Undo Segment 6 Onlined
    Undo Segment 7 Onlined
    Undo Segment 8 Onlined
    Undo Segment 9 Onlined
    Undo Segment 10 Onlined
    Successfully onlined Undo Tablespace 1.
    Mon Sep 16 18:43:35 2002
    SMON: enabling tx recovery
    Mon Sep 16 18:43:36 2002
    Feature not enabled: Database resource manager
    replication_dependency_tracking turned off (no async multimaster replication found)
    Completed: ALTER DATABASE OPEN
    Mon Sep 16 18:54:20 2002
    Shutting down instance: further logons disabled
    Shutting down instance (immediate)
    License high water mark = 2
    Mon Sep 16 18:54:22 2002
    ALTER DATABASE CLOSE NORMAL
    Mon Sep 16 18:54:22 2002
    SMON: disabling tx recovery
    SMON: disabling cache recovery
    Mon Sep 16 18:54:23 2002
    Thread 1 closed at log sequence 286
    Mon Sep 16 18:54:23 2002
    Completed: ALTER DATABASE CLOSE NORMAL
    Mon Sep 16 18:54:23 2002
    ALTER DATABASE DISMOUNT
    Completed: ALTER DATABASE DISMOUNT
    ARCH: Archiving is disabled
    Shutting down archive processes
    archiving is disabled
    Archive process shutdown avoided: 0 active
    ARCH: Archiving is disabled
    Shutting down archive processes
    archiving is disabled
    Archive process shutdown avoided: 0 active
    Mon Sep 16 18:56:06 2002
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    LICENSE_MAX_USERS = 0
    Starting up ORACLE RDBMS Version: 9.0.1.0.0.
    System parameters with non-default values:
    processes = 300
    timed_statistics = TRUE
    shared_pool_size = 67108864
    large_pool_size = 10485760
    java_pool_size = 8388608
    control_files = /data01/oracle/oradata/gowap/control01.ctl, /data01/oracle/oradata/gowap/control02.ctl, /data01/oracle/oradata/gowap/control03.ctl
    db_block_size = 8192
    db_cache_size = 20971520
    compatible = 9.0.0
    fast_start_mttr_target = 0
    undo_management = AUTO
    undo_tablespace = UNDOTBS
    remote_login_passwordfile= EXCLUSIVE
    db_domain =
    instance_name = gowap
    background_dump_dest = /data01/oracle/admin/gowap/bdump
    user_dump_dest = /data01/oracle/admin/gowap/udump
    core_dump_dest = /data01/oracle/admin/gowap/cdump
    sort_area_size = 5242880
    db_name = gowap
    open_cursors = 300
    Data Guard broker requires Oracle Enterprise Edition license
    PMON started with pid=2
    DBW0 started with pid=3
    LGWR started with pid=4
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    Mon Sep 16 18:56:10 2002
    ALTER DATABASE MOUNT
    Mon Sep 16 18:56:19 2002
    Successful mount of redo thread 1, with mount id 3410657354.
    Mon Sep 16 18:56:19 2002
    Database mounted in Exclusive Mode.
    Completed: ALTER DATABASE MOUNT
    Mon Sep 16 18:56:19 2002
    ALTER DATABASE OPEN
    Mon Sep 16 18:56:24 2002
    Thread 1 opened at log sequence 286
    Current log# 1 seq# 286 mem# 0: /data01/oracle/oradata/gowap/redo01.log
    Current log# 1 seq# 286 mem# 1: /data01/oracle/oradata/gowap/redo01b.log
    Successful open of redo thread 1.
    Mon Sep 16 18:56:24 2002
    SMON: enabling cache recovery
    Mon Sep 16 18:56:25 2002
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Undo Segment 4 Onlined
    Undo Segment 5 Onlined
    Undo Segment 6 Onlined
    Undo Segment 7 Onlined
    Undo Segment 8 Onlined
    Undo Segment 9 Onlined
    Undo Segment 10 Onlined
    Successfully onlined Undo Tablespace 1.
    Mon Sep 16 18:56:25 2002
    SMON: enabling tx recovery
    Mon Sep 16 18:56:29 2002
    replication_dependency_tracking turned off (no async multimaster replication found)
    Completed: ALTER DATABASE OPEN
    Tue Sep 17 11:19:42 2002
    Thread 1 advanced to log sequence 287
    Current log# 2 seq# 287 mem# 0: /data01/oracle/oradata/gowap/redo02.log
    Current log# 2 seq# 287 mem# 1: /data01/oracle/oradata/gowap/redo02b.log

    DB:2.65:Unexpected Shutdown... Urgent kj

    This will give you a list of the events you can have system triggers for
    http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96590/adg14evt.htm#999369
    I thought they where also in 8.1.7. I just checked the 8.1.7 documentation and you're right, they're available.

    Thanks.

  • RELEVANCY SCORE 2.65

    DB:2.65:Preferred Method For Shipping Redo Logs To Standby: Archiver Or Lgwr p7


    DB version : 11.2
    OS : AIX

    Which is the preferred method for Shipping redo logs to standby: Archiver or LGWR ?

    DB:2.65:Preferred Method For Shipping Redo Logs To Standby: Archiver Or Lgwr p7

    example

    LOG_ARCHIVE_DEST_2='service=tostby LGWR _______________ '

    If we are using standby redo logs, the primary DB does not even have to be archive log mode. Right ?No.

  • RELEVANCY SCORE 2.64

    DB:2.64:Oracle 9i Dataguard Some Questions. d9


    Hi,

    I have some doubts regarding the Data guard redo log transfers from Primary to Stand by.

    1. In Oracle9i is it really the archived redo logs that are transferred to the standby database or the online redo logs?

    2. Is automatic fail over to standby database possible with Oracle 9i ? I understand it is possible with 10g.

    As I reviewed the document, I understood that the
    1. Primary LGWR is set to transfer the redo log information to Standby.
    2. Standby is tuned to receive online redo from Primary.
    3. Standby DB instantly applies the received redo from Primary in the Media recovery mode.
    4. Standby also archives the applied redo.

    Please let me know if this anyway wrong ? This is in the context of 9i.

    DB:2.64:Oracle 9i Dataguard Some Questions. d9

    Thanks for the information.

    Can Oracle Dataguard 9i fail over to standby automatically when primary database crashes ? I think this feature is implemented in 10g as Fast Start Fail over.

    Is there any way to automate the fail over in 9i ? Any custom solution you heard of.

    Message was edited by:
    user569573

  • RELEVANCY SCORE 2.64

    DB:2.64:Copy Delete Save In Archive Backup cz


    hi all of you,

    When i take archive redo logs backup it having mode copy,delete,save...now it works? from where it copy redo logs?
    and where it save ?

    DB:2.64:Copy Delete Save In Archive Backup cz

    user8694422 wrote:
    hi.. am talking about oracle 9i... when i take my offline redo log buffer it is having Archive function: copy_delete_save ....i can understand copy and delete that it copy redo log to tape and delete it, but what is function of save? please rplay

    Edited by: user8694422 on Aug 17, 2011 3:11 AMPlease read your Tape Manual for this

  • RELEVANCY SCORE 2.63

    DB:2.63:9i - Undo Versus Redo? mj


    I have been used to using redo logs. It seems like it's now a choice between redo and undo logs.

    Could someone explain the merits of each?

    DB:2.63:9i - Undo Versus Redo? mj

    Taken from a 'new features' doc:
    "Oracle9i databases are capable of managing their own undo (Rollback) segments -no
    longer will administrators need to carefully plan and tune the number and
    sizes of rollback segments or bother about how to strategically assign transactions
    to a particular rollback segment. Oracle9i also allows administrators to allocate
    their undo space in a single undo tablespace with the database taking care of
    issues such as undo block contention, consistent read retention and space
    utilization."

    Next to that, if you want to use 'flash back query', also a new feature, you can only do this with undo management, not with rollback management.

    I've tried the undo management and it really works. If you graphically portrait the tablespace usage of the undo tablespace while modifying bulk data, you see some surprising maintenance happening! :)

    Keep in mind that you cannot have them both at the same time. you can switch between the two but you will have to dip the database to do so (as far as I know).

    I can highly recommend looking into this topic in the concepts documentation!

    Hope this helps,
    Lennert

  • RELEVANCY SCORE 2.62

    DB:2.62:Avoiding Redo Logs While Doing Dml Operations 1k


    Dear All,

    I want to avoid redo logs completly while I am doing DML operations on my table.

    The database is in Archive log mode.

    Is there any way to avoid the redo logs.

    Appreciate your help on this.

    Thanks,
    Madhu K.

    DB:2.62:Avoiding Redo Logs While Doing Dml Operations 1k

    569725 wrote:
    Dear All,

    I want to avoid redo logs completly while I am doing DML operations on my table.Why? What problem are you trying to solve? It is not possible to completely suppress redo log for DML, as that would open the database to non-recoverability.

    The database is in Archive log mode.

    Is there any way to avoid the redo logs.

    Appreciate your help on this.

    Thanks,
    Madhu K.

  • RELEVANCY SCORE 2.62

    DB:2.62:Dataguard Redo Logs Queries xf


    HI There

    I have recently configure Data guard with Database 10g (10.2.0.4-64 bits) on Windows 2007 server.

    My Data Gurad Configuration show Success status with 2 databases on same (or local) location.

    My questions are

    1. How to Check that our Redo logs are applied/active with Particular Database?

    2. How to Check that Logs are being copied/working?

    Regards

    Thunder2777

    Edited by: Thunder2777 on Apr 9, 2013 2:13 AM

    DB:2.62:Dataguard Redo Logs Queries xf

    archive log list
    Next log sequence to archive 0Is this on the Primary or the Standby Database ?

    The Primary should show 4,5 or 6 as the "next log sequence to archive".

    Hemant K Chitale

  • RELEVANCY SCORE 2.62

    DB:2.62:Redo Logs And Rac 1a


    Hi,

    Can anyone brief me in How redo logs are working in RAC?

    Thanks in advance

    DB:2.62:Redo Logs And Rac 1a

    Hi,

    Can anyone brief me in How redo logs are working in RAC?

    Thanks in advance

  • RELEVANCY SCORE 2.62

    DB:2.62:Missing Redolog 73


    all
    Give me the steps for recovery with missing online redo logs?

    DB:2.62:Missing Redolog 73

    Please try to recover from documentation link as below :

    Recovering After the Loss of Online Redo Log Files: Scenarios
    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen.htm#CACFFJFB

    Hth
    Girish Sharma

  • RELEVANCY SCORE 2.61

    DB:2.61:Undo V Redo 9j


    Ive read somewhere that Oracle plan to drop the use of REDO logs and move towards UNDO. But from what Ive been reading, Oracle seems to encourage the use of REDO logs in a RAC environment. What is the normal configuration that I should be looking at REDO or UNDO

    DB:2.61:Undo V Redo 9j

    Ive read somewhere that Oracle plan to drop the use of REDO logs and move towards UNDO. But from what Ive been reading, First of all, let me tell you that the REDO and UNDO are there for different purposes and you can't choose any one between them as both are required.
    I am sure that you have miss read it. You might be talking about Rollback segment vs UNDO concepts. if so, yes, Oracle recommends using UNDO instead of Rollback segments.

    Regards,

    Jaffar

  • RELEVANCY SCORE 2.61

    DB:2.61:Alert Log - Undo Segment And Smon z9


    I've found the below logs in alert.log file. What all these mean? Is it normal or bad? i am trying to understrand what is going on here... thanks

    Fri Jan 05 13:20:18 2007
    Created Undo Segment _SYSSMU11$
    Fri Jan 05 13:20:18 2007
    Created Undo Segment _SYSSMU12$
    Fri Jan 05 13:20:18 2007
    Undo Segment 11 Onlined
    Fri Jan 05 13:20:18 2007
    Undo Segment 12 Onlined
    Fri Jan 05 13:20:18 2007
    Created Undo Segment _SYSSMU13$
    Undo Segment 13 Onlined
    Fri Jan 05 13:20:18 2007
    Created Undo Segment _SYSSMU14$
    Fri Jan 05 13:20:18 2007
    Undo Segment 14 Onlined
    Fri Jan 05 13:20:18 2007
    Created Undo Segment _SYSSMU15$
    Fri Jan 05 13:20:18 2007
    Undo Segment 15 Onlined
    Fri Jan 05 13:20:18 2007
    Created Undo Segment _SYSSMU16$
    Undo Segment 16 Onlined

    SMON offlining US=11
    SMON offlining US=12

    DB:2.61:Alert Log - Undo Segment And Smon z9

    this is normal
    In auto management of Undo tablespace, oracle manages the rollback segments and writes the entries in alert log
    It makes the required number of rollback segments online/offlines
    and this is what alert log is showing up

  • RELEVANCY SCORE 2.60

    DB:2.60:Redo Logs Advisory k7


    my redo logs advisory on ora10gR2 database recommends a size of 2.5G where as the current redo file size is 100M.

    I want to know two things here:

    Since i have 5 redo groups(100M each) so should i assume tht my current redo file size is 500M and try to achieve advisory redo size of 2.5G cumulatively summin all the redo log file sizes.

    It;s not possible to extend the redo log file size to such an extent so i tried to reduce MTTR target size. Is there anything else that i can do to better I/O

    DB:2.60:Redo Logs Advisory k7

    yogesh OP is concerned to extending the redo log file size in contrast to reduce minimal lose of data ,what he tried to keep 100M logfile in order to lose at least 100M rather extended lost.

    for an OP is there any reason with yours redo log advisory recommends to extend the log size to 2.5 G i.e frequent checkpointing may be the reason.

    Khurram

  • RELEVANCY SCORE 2.60

    DB:2.60:How Big Should The Redo Logs Be? 1m


    Hi,

    I know that online redo logs are copied to become Archived logs. I was just wondering what criteria one should look at to set the redo log size?

    Bye,

    Vani

    DB:2.60:How Big Should The Redo Logs Be? 1m

    Hi,

    For an OLTP transaction, would you consider 2Mb to be big or small.

    We have not yet started running the database and it's quite difficult to to guess the size of the redo logs right now.

    But for a start, do you believe that 2Mb is Ok. The default during installation is 1Mb.

    Thanks,

    Vani

  • RELEVANCY SCORE 2.59

    DB:2.59:Redo Logs za


    How can I recover a mismatched redo logs in oracle 8.5.1 with netware 5.1 sp 5 os?

    DB:2.59:Redo Logs za

    How can I recover a mismatched redo logs in oracle 8.5.1 with netware 5.1 sp 5 os?

  • RELEVANCY SCORE 2.58

    DB:2.58:Data Guard Questions p7


    Hi I have have few questions for data guard setup.

    1. Can I have same name for both the instances, Primary and standby.
    2. Can we rename redo logs to our custom naming conventions for both standby and primary db. If yes how, like normal process to change redo logs ?

    Edited by: sudubey on Apr 14, 2009 5:09 PM

    DB:2.58:Data Guard Questions p7

    I was able to change online redo logs with standby redo logs. Here is he solution

    http://troubleshootingappsdba.blogspot.com/2009/04/renamingdropping-and-recreating-online.html

  • RELEVANCY SCORE 2.58

    DB:2.58:Logminer 19


    Does LogMiner use online redo logs or archived redo logs or both to generate SQL_UNDO? From where does it take info for generating SQL_REDO?

    DB:2.58:Logminer 19

    Does LogMiner use online redo logs or archived redo logs or both to generate SQL_UNDO? From where does it take info for generating SQL_REDO?

  • RELEVANCY SCORE 2.58

    DB:2.58:Some Questions zj


    Hai All,

    Test Scenario: Database in archive mode.

    1. I import the data from an export file. I can able to apply archive logs(generated after the export) into the datbase ?

    2. I restore the database from the offline backup (so currently datafile,Redo logfile, and controlfiles are old but consistent). I can able to apply archive logs (after the offline backup) above the database.?

    Please help

    Shiju

    DB:2.58:Some Questions zj

    Export/Import is considered a logical backup. Restoring datafiles, controlfiles is a restore of a physical backup. Both are completely different, you cannot perform a recover action with it.
    You cannot apply archivelog if you have restored controlfiles, as those contain the current database timestamp, if you have already restored them from your backup and you don't have a copy of them from the latest time the database was shutdow, then it is not possible.

    ~ Madrid.

  • RELEVANCY SCORE 2.58

    DB:2.58:Data Guard - Beyond The Documentation (Not For The Faint Of Heart) a7


    Oracle Release: 10.2.0.4.

    PRIMARY --------- PHYSICAL Standby

    I have read all documentation and still come back to 2 unanswered questions:

    (1) Does RedoApply use archive log files? In other words does the synchronization occur real-time from the online redo logs or does Redo Apply transport archivelog files to the physical standby location and then apply to the primary online redo logs??

    (2) If a commit occurs on the Primary must it also succeed on the Physical before the transaction is completed? This would not be very ideal in a 24x7 where the Primary has to be accessible at all times.

    If someone can explain these process I would appreciate it. I have read so many rman documentation I am at my wits end.

    Thanks!

    DB:2.58:Data Guard - Beyond The Documentation (Not For The Faint Of Heart) a7

    your questions are pertaining to oracle dataguard protection modes.please read this
    http://download.oracle.com/docs/cd/E11882_01/server.112/e10700/concepts.htm

  • RELEVANCY SCORE 2.58

    DB:2.58:Switched Database To Archivelog Mode, Then It Hung x1


    Hi everyone,

    This db is 9.2 on Windows.

    **After switching my database to Archivelog mode and reopening, it hung forever.**

    (I had to use Shutdown abort to bring it down - these steps worked to get it back online:
    shutdown abort; --startup mount;
    alter system archive log all;
    alter database noarchivelog;
    alter database open;)

    ******
    The Alert.log shows "Cannot allocate new log" immediately after I switched to Archivelog mode. So it hung at that point. Had I known why it hung, maybe running 'Alter system archive log all' would have fixed everything. But I've never had to run that when I've switched other databases to Archivelog mode.

    Does this indicate another problem with this database? I'm leery of it now and feel lucky that I was able to get it up again.

    *****

    Thanks, John

    entries from Alert.log when I switched to Archivelog mode:

    ALTER DATABASE MOUNT
    Wed Aug 06 11:44:19 2008
    Successful mount of redo thread 1, with mount id 1689013583
    Wed Aug 06 11:44:19 2008
    Database mounted in Exclusive Mode.
    Completed: ALTER DATABASE MOUNT
    Wed Aug 06 11:44:45 2008
    alter database archivelog
    Wed Aug 06 11:44:45 2008
    Starting control autobackup
    Control autobackup written to DISK device
    handle 'F:\ORACLE\ORA92\DATABASE\C-1602026732-20080806-00'
    Completed: alter database archivelog
    Wed Aug 06 11:45:17 2008
    alter database open
    Wed Aug 06 11:45:17 2008

    Thread 1 opened at log sequence 9014
    Current log# 1 seq# 9014 mem# 0: F:\ORACLE\ORADATA\PBSMEM\REDO01.LOG
    Successful open of redo thread 1
    Wed Aug 06 11:45:17 2008
    SMON: enabling cache recovery
    Wed Aug 06 11:45:17 2008
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Undo Segment 4 Onlined
    Undo Segment 5 Onlined
    Undo Segment 6 Onlined
    Undo Segment 7 Onlined
    Undo Segment 8 Onlined
    Undo Segment 9 Onlined
    Undo Segment 10 Onlined
    Successfully onlined Undo Tablespace 1.
    Wed Aug 06 11:45:17 2008
    SMON: enabling tx recovery
    Wed Aug 06 11:45:17 2008
    Database Characterset is WE8MSWIN1252
    replication_dependency_tracking turned off (no async multimaster replication found)
    Completed: alter database open
    Wed Aug 06 11:59:58 2008
    Thread 1 advanced to log sequence 9015
    Current log# 2 seq# 9015 mem# 0: F:\ORACLE\ORADATA\PBSMEM\REDO02.LOG
    Wed Aug 06 12:01:03 2008
    Thread 1 advanced to log sequence 9016
    Current log# 3 seq# 9016 mem# 0: F:\ORACLE\ORADATA\PBSMEM\REDO03.LOG
    Wed Aug 06 12:09:16 2008
    Thread 1 cannot allocate new log, sequence 9017
    All online logs needed archiving
    Current log# 3 seq# 9016 mem# 0: F:\ORACLE\ORADATA\PBSMEM\REDO03.LOG

    **** PrefBid App locked up at this point hung users cannot do anything -- Note the gap in log entry time no further entries until my Shutdown request

    DB:2.58:Switched Database To Archivelog Mode, Then It Hung x1

    Thanks, Marcello.

    I have never known it was possible to start up logging while the instance is up.

    That will be very convenient. I assume that is true for 9i as well as 10g.

    John

  • RELEVANCY SCORE 2.58

    DB:2.58:Question On Maximum Performance Mode 9k


    An excerpt from ML note : 239100.1

    To participate in maximum performance the following requirements must be met:

    Redo Archival Process : LGWR or ARCH
    Network Transmission mode : ASYNC when using LGWR only
    Disk Write Option : NOAFFIRM
    Standby Redo Logs : No, but recommended and required for Real-Time Apply What does
    Standby Redo Logs : Nomean ? A database cannot be created without Online redo logs. Right?

    DB:2.58:Question On Maximum Performance Mode 9k

    Thank you, Danke, Merci Uwe, for adding the "only in theory" part :^)

    Steve 74 - For performance and protection you should always configure standby redo log files at all standbys, even if you are using ARCH in 10g to send the redo. You need to configure them on your Primary database also so when you perform a switchover and the Primary becomes a standby them things will still run the way you intended.

    Larry

  • RELEVANCY SCORE 2.58

    DB:2.58:Standby Redo Log 7d


    In what situation, standby redo logs are mandatory.
    I have the below settings and my DATA GAURD setup (10.2.0.3) is working fine without Stdby redo logs.

    Just wondering when do i need standby redo logs.

    SQL show parameter log_Archive_dest_2

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_2 string SERVICE=TO_STANDBY LGWR ASYNC
    AFFIRM DB_UNIQUE_NAME=stand

    SQL select protection_mode from v$database;

    PROTECTION_MODE
    --------------------
    MAXIMUM PERFORMANCE

    DB:2.58:Standby Redo Log 7d

    888442 wrote:
    In what situation, standby redo logs are mandatory.
    I have the below settings and my DATA GAURD setup (10.2.0.3) is working fine without Stdby redo logs.

    Just wondering when do i need standby redo logs.

    SQL show parameter log_Archive_dest_2

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_2 string SERVICE=TO_STANDBY LGWR ASYNC AFFIRM DB_UNIQUE_NAME=stand

    SQL select protection_mode from v$database;

    PROTECTION_MODE
    --------------------
    MAXIMUM PERFORMANCEHi,

    Standby Redo Logs (SRL) require when you are using MAX AVAILABILITY and MAX PROTECTIN protection modes. So SRL using for Real Time Apply.
    In your case (Max Performance) if you want real time apply on standby you must add SRLs to standby database.

    Best practice we adding standby redo logs to primary and standby database same time, but when database role is standby then using SRLs.
    You can ask, why also to primary? Because we can switchover to standby, then priamry role will change to standby, then will use SRLs.

    Regards
    Mahir M. Quluzade

  • RELEVANCY SCORE 2.57

    DB:2.57:Number Of Bytes Used By Redo Logs s3


    What sql command will tell me how much or number of bytes of the memory being utilized by redo logs in 9i.

    DB:2.57:Number Of Bytes Used By Redo Logs s3

    WRONG ! like V$LOG table has BYTES, but that will give you size of your redo log file, not the bytes in memory. Here, author is asking about bytes used by redo in memory.

    Thanks

    ~Keyur

  • RELEVANCY SCORE 2.57

    DB:2.57:Standby Redo Logs 17


    I have few questions regarding Standby Redo Logs.My questions are as follows:

    Oracle Version 10gR2 OS:RHEL

    1) Do we need to multiplex standby Redo Log if we want to deploy Physical Standby Database?

    2) What will happen if the size of the current standby Redo log on standby database doesn't match the size of the online
    Redo Log file on the Primary database?

    With Regards

    DB:2.57:Standby Redo Logs 17

    Hello;

    I forgot to welcome you to the forum before. Welcome to the forum.

    Do we need to multiplex standby Redo Log if we want to deploy Physical Standby Database?No.

    What will happen if the size of the current standby Redo log on standby database doesn't match the size of the online
    Redo Log file on the Primary database? Using the condition with Apply " USING CURRENT LOGFILE" won't work.

    You increase the risk of losing data as Standby Redo will act as a buffer on the Standby.

    See - "Data Guard Concepts and Administration" 11g Release 2 (11.2) Part Number E25608-03 - "6 Redo Transport Service" for additional information.

    http://docs.oracle.com/cd/E11882_01/server.112/e10700/log_transport.htm

    If your other question is answered please consider marking it answered to keep the forum clean.

    Best Regards

    mseberg

  • RELEVANCY SCORE 2.57

    DB:2.57:Re: Lost Redo Log 7z


    when you removed your files , did you also remove redo-logs

    to recover to current state you need redo-logs in their place, i think you mave deleted them, that is why database is asking ?

    if you noticed you may have been recover to current archivelog in your archivelog destination, if you dont have your redo-logs then open resetlogs is the only option

    DB:2.57:Re: Lost Redo Log 7z

    you are simulating a complete database scenario , which a dba always tries and practice but never wishes to happen to his production databases :)

    in a complete loss scenario, you will need openreset logs if you dont have your redo-logs

    if you have shutdown your database with abort before taking a full backup, that will also be a proble, oracle never reccomends using shutdown abort before a complete backup, shutdown immediate/transactional should be used to take a consistent backup.

    check these notes, they will be very helpfull

    http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96519/backup.htm#1004829

  • RELEVANCY SCORE 2.57

    DB:2.57:How To Set Redo Logs And Archive Logs Destination In Nfs 1x


    Hello All,
    I have to 2 separate mount points for redo logs + flashback logs and Archive logs. Please can I know to create redo logs and archive logs on its NFS mount.
    What parameter I need to set?. I will be installing 11.2.1.0 database.

    Thanks.

    DB:2.57:How To Set Redo Logs And Archive Logs Destination In Nfs 1x

    Hi,

    For redo logs:

    http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/onlineredo004.htm

    For archive logs:

    http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/archredo004.htm#i1006386

    HTH -- johnxjean --

  • RELEVANCY SCORE 2.57

    DB:2.57:Redo Logs x7


    Is there a way to increase the size of already existing redo logs for an oracle 8.1.5 database that exists on a unix server. Any information would be greatly appreciated. Thank you.

    DB:2.57:Redo Logs x7

    Hi,

    In any version of database u can not increase the size of the existing redologs.
    what u can do is either u can add a new redolog or group of redolog.

    If u want the syntex of any of the above please specify.

    best of luck

  • RELEVANCY SCORE 2.57

    DB:2.57:How To Recover Database When All Redo Logs Are Losted k1


    pls help me in recovering the database when all the redo logs are losted

    DB:2.57:How To Recover Database When All Redo Logs Are Losted k1

    alter open database with resetlogs
    plz. take complete consistent bkp. cold bkp or ur database.

  • RELEVANCY SCORE 2.57

    DB:2.57:Redo Log Buffer Block Size On Asm m8


    I know that redo logs are not written using oracle block size but with OS block size.

    When we put our redo logs on ASM what is the block size used for redo?

    Thanks in advance

    DB:2.57:Redo Log Buffer Block Size On Asm m8

    The block size would be same-512b but the stripe size would be based on the ASM and would be 128kb(Fine striping) .

    Aman....

  • RELEVANCY SCORE 2.56

    DB:2.56:Mtl_Interface_Errors Filling Up Rapidly And Generating Redo Logs 19


    Hi

    The INV.MTL_INTERFACE_ERRORS as its size has grown up ( 1282142 recs) and also generating huge redo logs filling up the mount point.

    CAn you please help

    Regards,

    DB:2.56:Mtl_Interface_Errors Filling Up Rapidly And Generating Redo Logs 19

    Hussein ,

    I went through the docs but not getting the reason for having the huge redo logs being generated. Is there anyway to minimize these records from being inserted in this table or any regular houskeeeping other than truncating the table after 2 hours. please advise.

    regards

  • RELEVANCY SCORE 2.56

    DB:2.56:Ora-01092: Oracle Instance Terminated. Disconnection Forced fa


    Hi,

    I tried to creat a new database several times but it gives an above mentioned error.

    I will appreciate your help to fix this issue on an urgent basis.

    Thu Sep 28 15:12:12 2006
    CREATE UNDO TABLESPACE UNDOTBS3 DATAFILE '/u01/app/oracle/oradata/db1/undotbs3.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    Successfully onlined Undo Tablespace 1.
    Completed: CREATE UNDO TABLESPACE UNDOTBS3 DATAFILE '/u01/ap
    Thu Sep 28 15:12:17 2006
    create tablespace SYSAUX datafile '/u01/app/oracle/oradata/db1/sysaux01.dbf' size 500m reuse AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
    Thu Sep 28 15:12:29 2006
    Completed: create tablespace SYSAUX datafile '/u01/app/oracl
    Thu Sep 28 15:12:29 2006
    CREATE TEMPORARY TABLESPACE MKODOTEMP1 TEMPFILE '/u01/app/oracle/oradata/db1/mkodotemp.dbf' size 200m reuse
    Completed: CREATE TEMPORARY TABLESPACE MKODOTEMP1 TEMPFILE '
    Thu Sep 28 15:12:30 2006
    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOTEMP1
    Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOT
    Thu Sep 28 15:12:30 2006
    Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_7169.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02236: invalid file name
    Thu Sep 28 15:12:30 2006
    Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_7169.trc:
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6183
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02236: invalid file name
    Error 1519 happened during db open, shutting down database
    USER: terminating instance due to error 1519
    Instance terminated by USER, pid = 7169
    ORA-1092 signalled during: CREATE DATABASE db1
    USER SYS IDENTIFIED BY ***US...

    The output or message from the trace file is as below:
    /u01/app/oracle/admin/db1/udump/db1_ora_7169.trc
    Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
    With the Partitioning, OLAP and Data Mining options
    ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
    System name: Linux
    Node name: polo
    Release: 2.6.11-1.1369_FC4smp
    Version: #1 SMP Thu Jun 2 23:08:39 EDT 2005
    Machine: i686
    Instance name: db1
    Redo thread mounted by this instance: 1
    Oracle process number: 10
    Unix process pid: 7169, image: oracle@polo (TNS V1-V3)

    *** SERVICE NAME:(SYS$USERS) 2006-09-28 15:11:57.252
    *** SESSION ID:(272.1) 2006-09-28 15:11:57.252
    *** 2006-09-28 15:11:57.252
    All processes have switched to database character set
    Created Undo Segment _SYSSMU1$
    Created Undo Segment _SYSSMU2$
    Created Undo Segment _SYSSMU3$
    Created Undo Segment _SYSSMU4$
    Created Undo Segment _SYSSMU5$
    Created Undo Segment _SYSSMU6$
    Created Undo Segment _SYSSMU7$
    Created Undo Segment _SYSSMU8$
    Created Undo Segment _SYSSMU9$
    Created Undo Segment _SYSSMU10$
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Assigned RBS 4 to pool 0
    Undo Segment 4 Onlined
    Assigned RBS 5 to pool 1
    Undo Segment 5 Onlined
    Assigned RBS 6 to pool 2
    Undo Segment 6 Onlined
    Assigned RBS 7 to pool 3
    Undo Segment 7 Onlined
    Assigned RBS 8 to pool 4
    Undo Segment 8 Onlined
    Assigned RBS 9 to pool 5
    Undo Segment 9 Onlined
    Assigned RBS 10 to pool 6
    Undo Segment 10 Onlined
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02236: invalid file name
    Offending statement at line 6183
    CREATE TABLESPACE MKODO1 DATAFILE SEGMENT SPACE MANAGEMENT MANUAL
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6183
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02236: invalid file name

    Thanks in advance.
    Jayesh
    solankijayesh@yahoo.com

    DB:2.56:Ora-01092: Oracle Instance Terminated. Disconnection Forced fa

    Hi, post "Create database ....." statement and /u01/app/oracle/admin/db1/udump/db1_ora_7169.trc:

  • RELEVANCY SCORE 2.56

    DB:2.56:New Redo Log Group Over The Network kj


    Hi,

    I am trying to create a new redolog group on a network drive and it is not letting me. The folder has write permissions and everything seems okay, is it possible to do this?? the SQL I'm using is:

    ALTER DATABASE ADD LOGFILE GROUP 4
    ('\\Libra\_ORACLE REDO LOGS\Redo_2A',
    '\\Libra\_ORACLE REDO LOGS\Redo_2B',
    '\\Libra\_ORACLE REDO LOGS\Redo_2C') SIZE 51200K;

    Any suggestions would be greatly appreciated.

    Kind regards

    Ken

    DB:2.56:New Redo Log Group Over The Network kj

    It is NOT possible to do this, as it would require running Oracle under a domain administrator account.
    Also it is completely unadvisable, as online redo logs are the achilles heel of your database in terms of recoverability and performance.
    What you are up to will be
    a) insecure
    b) slow

    --
    Sybrand Bakker
    Senior Oracle DBA

  • RELEVANCY SCORE 2.56

    DB:2.56:Re: One Process Generating Too Much Archives jx


    hi,

    i hope too much insert or update or bulk loading create more redo entries, hence produce redo logs. arch writes redo logs to archived log files.this happens when log switch occurs or redo log is full..

    regards,
    Deepak

    DB:2.56:Re: One Process Generating Too Much Archives jx

    pls post:

    select sid, event, p1, p2, p3 from v$session_wait where event not in ('SQL*Net message from client', 'rdbms ipc message', 'pipe get', 'PL/SQL lock timer', 'pmon timer')

    select * from v$transaction

  • RELEVANCY SCORE 2.56

    DB:2.56:Basic Question About Flashback Database sx


    Hi,I have a very generic question about using Flashback Database. On my testing systems, for performance testing and simulation purposes, I want to create a guaranteed restore point so I can test impact on batch when code change releases are done, before deployment in production. My confusion is with respect to redo logs, as summarized in the questions below:1. Is it possible to change redo log files, when a guaranteed restore point has been configured?2. If yes, will the Flashback to restore point, also change the size of the redo logs?I could not find anything in the docs about this....hence my question....Appreciate your time taken in responding to these questions....Regards.

    DB:2.56:Basic Question About Flashback Database sx

    HI,
    donneskold wrote:

    Hi,

    I have a very generic question about using Flashback Database.
    On my testing systems, for performance testing and simulation purposes, I want to create a guaranteed restore point so I can test impact on batch when code change releases are done, before deployment in production. My confusion is with respect to redo logs, as summarized in the questions below:
    1. Is it possible to change redo log files, when a guaranteed restore point has been configured?

    1) Yes it is possible.

    2. If yes, will the Flashback to restore point, also change the size of the redo logs?

    2) It will not change the size of redo log file. Cannot resize a redo log file..

    I could not find anything in the docs about this....hence my question....

    Appreciate your time taken in responding to these questions....

    Regards.
    Thank you

  • RELEVANCY SCORE 2.56

    DB:2.56:Redo Logs 10gr2 fx


    I run stats pack how should i calculate redo log file generated.

    I am calculating REDO SIZE + REDO WASTED = will be physical archive redo log size..

    but i found difference when calculated, archive redo log file size is greater than REDO_SIZE+REDO WATED.

    Please advise.

    DB:2.56:Redo Logs 10gr2 fx

    Hi,

    Where do you the above formual .. ??

    Thanks
    Pavan Kumar N

  • RELEVANCY SCORE 2.56

    DB:2.56:Backup/Recovery Strategy - Online Redo Log z1


    What is the mean by "Multiplex the online redo logs"?
    How can I do this?

    DB:2.56:Backup/Recovery Strategy - Online Redo Log z1

    Singleplex=1
    Multiplex=many

    In terms of redo log.

    Group 1
    ------------------------------------
    rego_g1_m1.log ( resides on disk1 )
    rego_g1_m2.log ( resides on disk2 )
    rego_g1_m3.log ( resides on disk3 )

    Group 2
    ------------------------------------
    rego_g2_m1.log ( resides on disk1 )
    rego_g2_m2.log ( resides on disk2 )
    rego_g2_m3.log ( resides on disk3 )

    And so on the idea is that if one of the redo log members ( m1,m2,m3 ) get corrupted / have a disk failure the others are readily available. Just copy them over and you are on your way. ( Kind of like a spare tire ).

    Thanks.

  • RELEVANCY SCORE 2.56

    DB:2.56:Why Redo Logs Generated More When User Managed Hot Backup Runs? Pls Explain 3p


    Guys,

    Why redo logs generated more when user managed hot backup runs? Pls explain.

    Thanks in advance,

    Thanks
    Rocky.

    DB:2.56:Why Redo Logs Generated More When User Managed Hot Backup Runs? Pls Explain 3p

    Lot of redo might be generated for your datafile because the header of datafile is freezed and no checkpoint cannot be done What does a checkpoint operation have to do with the rate of redo generation? Nothing. This is incorrect.

    Cheers,
    Brian

  • RELEVANCY SCORE 2.56

    DB:2.56:Questions On Archive Log Recovery ja


    dear all,

    I have this doubt in my mind and would like you guys to advise on.

    Is it true that when a database is in ARCHIVELOG MODE, database recovery by restoring all datafiles from hotbackup and applying archive logs is possible to the last commit?

    probably using the command: recover database using backup controlfile until cancel; (to apply all the arhive logs to last hotbackup)

    From my point of view, i feel that the database recovery using the ARCHIVED LOGS and hotbackup is possible only up to the last redo log switch.

    In order to recover the database to the last commit, I have to recover the database using both the ARCHIVED LOGS as well as the last ACTIVE REDO LOG (that is not archived).

    It is because the most recent commited transactions on the current redo log might not be written to archive log (as the active log is not full and no alter system switch logfile performed) at the point of time when the db crashed.

    Kindly advise on this as i have alot of misconcept when people say that using archived redo logs can restore the db up to last commit point. What if the last active redo log can't be restored as the current redo logs are deleted?

    Please advise.

    thanks all!

    DB:2.56:Questions On Archive Log Recovery ja

    And then that's why you have all the HA like RAC, Data Guard, and streams etc...

  • RELEVANCY SCORE 2.56

    DB:2.56:Recovery : Restore, Recover ? za


    Hello Experts

    I have some good DBA friends,When I ask some questions about recovery, they just said ' RMAN is cool, use need to restore and recover, you need not to bother about internal details !!' Is this right ?
    My questions are given below, they are very basic and might be very simple But they are nightmare to me::

    1. In what format a transaction store in redo logs(transaction, not single sql statement).

    2. Content of the transaction in Online Redo Logs(Does it contain old image of the data).

    3. If it contain Old image of data, in case of crash recovery; Does the required undo is generated from online redo logs ? Undo tablespace is only used to hold undo data generated during the recovery process ?

    4.Can loss of tablespace cause loss of data ? even online redo logs remain safe ?

    5. What is the role of transaction_ID in recovery process ? 6.Does Oracle inspect Online redo logs before last checkpoint ? 7. What about transactions those were in the progress while a checkpoint happened ?

    Regards
    Sunil Kumar

    DB:2.56:Recovery : Restore, Recover ? za

    Hello Sir

    Thank yor very much.
    Regards
    Sunil Kumar

  • RELEVANCY SCORE 2.56

    DB:2.56:Gg Architecture Questions s7


    Hello, I'm starting to use GG and I have some doubts about its architecture. GG has the ability to extract only committed transactions, which is very good to avoid overloading the network or storage of information is not useful. The question I have is about doing when GG is running a large transaction, BATCH type that can generate dozens of online redo logs and therefore tens of archivers. How to manage such transactions GG?. This would be the case of long transactions in quantity. It could also happen that a transaction is alarge in time, for example, that begins to 9 in the morning and finalize at 11:30, and from that time the system has generated tens of redo logs. I also wanted to know some details of the mechanism used GG for extraction from the redo logs. Use LogMiner? Many Thanks for the help. regards Arturo

    DB:2.56:Gg Architecture Questions s7

    Mike, Thanks for the reply. Although honestly I can not understand the use of flashback by Golden Gate. As you know the use of flashback is based on UNDO blocks. And those blocks that can not ensure providing read consistency for high or if there is a small time DML important activity in the database. And to my knowledge there is no special requirement or GARANTEE_RETENTION UNDO_RETENTION. What could happen if GG can not perform the operation of Flashback? ORA-01555 Snapshot too old? When you say:a is the pk, yet column c is also required by your target system (for some reason) on all updates. If we use the option cols to include some columns at extract level, GG create the adecuate supplemental logging to write in the redo logs this columns also.What other conditions can generate the situation, where GG need a col without supplemetal logging enabled?Many thanksBest regardsArturo

  • RELEVANCY SCORE 2.56

    DB:2.56:Retention Period d1


    What is the minimum acceptable period for storing redo and archive logs for the purpose of security investigation on our transactions?

    If we only retain the redo and archive logs for 2 months, can earlier transactions be traced back? Where else in the database can they trace the transactions besides the redo and archive logs?

    Lewis

    DB:2.56:Retention Period d1

    This depends solely on the requirements of your application. There are lots of applications that discard archive logs as soon as they aren't needed for recovery operations. If you need to be able to go back and see what happened in the database 3 months ago, keeping archive logs for three months may be necessary.

    My first thought, though, would be that if you plan to be able to go back and investigate transactions, you probably want to use Oracle's auditing features rather than relying on using LogMiner on archive logs. Auditing is a much cleaner solution to the problem, assuming you know what it is you'd like to be able to reconstruct. LogMiner is a great tool if something unexpected happens and you know roughly when it happened (i.e. a user calls up saying that he accidentally deleted half the employees in the production database rather than in his development database), but it's not particularly elegant if you're trying to find when in the last three months someone made a $5000 change in an account balance.

    Depending on your application, you may regularly want to visualize changes to the data. If that's the case, you might want to consider Workspace Manager, which essentially lets you do version control on your tables, so you could ask the questions about how and when things changed.

    Justin
    Distributed Database Consulting, Inc.
    http://www.ddbcinc.com/askDDBC

  • RELEVANCY SCORE 2.56

    DB:2.56:Instance Recovery Question - Redo And Undo mz


    I am a bit confused about how undo and redo are used for recovery, please help me clarify this. If redo records changes to database (commits and changes to undo datablocks), does the redo and undo all come from the redo log at instance recovery? What is the source of the undo data, the redo log or undo segments that have been rebuilt using the redo logs?

    Matt

    DB:2.56:Instance Recovery Question - Redo And Undo mz

    http://www.orafaq.com/wiki/Recovery

    Best book to read
    http://www.amazon.com/Oracle8i-Backup-Recovery-Rama-Velpuri/dp/0072127171

  • RELEVANCY SCORE 2.56

    DB:2.56:Resizing Online And Standby Redo Log In Dataguard Setup. jz


    In 10gr2 dataguard i would like to increase redo logsize from 50M to 100M.
    on primary
    standby_file_management=manual
    added online redo groups with 100M
    log switched
    drop old one and readded with 100m
    deleted log added in step2.
    same for standby redo logs.
    On standby
    was able to resize standby redo logs.
    but cannot resize online redologs status is clearing or clearing_current.

    please comment. thanks.

    DB:2.56:Resizing Online And Standby Redo Log In Dataguard Setup. jz

    I assume you just had to wait until the Primary switched out of that online log so it became inactive at the standby as well? We track where the Primary is by marking the online redo log files at the standby as clearing_current so you can tell where the primary was at any given moment.

    Make sure you create new standby redo log files at the Primary and Standby to match the new online redo log file size.

    Larry

  • RELEVANCY SCORE 2.56

    DB:2.56:Cannot Open Db kd


    hi

    after a power failure our 9i r2 db(linux) doesnt start.
    on this machine are 2 instances, the 2nd starts without any problems.
    the other database mounted, when i try to open the db sqlplus hangs.
    no error message, nothing. the trace logs say also mo error nothing.
    when i try to connect with a client application toad, enterprise manager,
    these appz hangs.
    these are the last entry in alert log:

    ------------------------------------------
    .
    .
    .

    Thread 1 advanced to log sequence 41
    Thread 1 opened at log sequence 41
    Current log# 2 seq# 41 mem# 0: /opt/oracle/oradata/ksu2/redo02.log
    Successful open of redo thread 1.
    Tue Oct 8 11:27:27 2002
    SMON: enabling cache recovery
    Tue Oct 8 11:27:28 2002
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Undo Segment 4 Onlined
    Successfully onlined Undo Tablespace 1.
    Tue Oct 8 11:27:28 2002
    SMON: enabling tx recovery
    Tue Oct 8 11:27:29 2002
    Database Characterset is WE8ISO8859P1
    replication_dependency_tracking turned off (no async multimaster replication found)
    Completed: alter database open
    ------------------------------------------

    i need the data in this db ;(.

    thx
    peter

    DB:2.56:Cannot Open Db kd

    puuh
    thx for your help

    ok, this is was i made in sqlplus(svrmgr in 9i?):
    ----------------------
    SQL startup mount
    ORACLE instance started.

    Total System Global Area 269553824 bytes
    Fixed Size 450720 bytes
    Variable Size 167772160 bytes
    Database Buffers 100663296 bytes
    Redo Buffers 667648 bytes
    Database mounted.
    SQL recover automatic database
    Media recovery complete.
    SQL alter database open
    2 ;
    alter database open
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel
    ----------------------

    then the trc log shows this:

    ----------------------------------
    .
    .
    .
    Redo thread mounted by this instance:1
    Oracle process number: 2
    Unix process pid: 3669, image: oracle@linuxoracle (PMON)

    *** 2002-10-10 09:43:22.949
    *** SESSION ID:(1.1) 2002-10-10 09:43:22.948
    error 474 detected in background process
    ORA-00474: SMON process terminated with error
    ----------------------------------

    now the question, why terminated the smon process???

    peter

  • RELEVANCY SCORE 2.56

    DB:2.56:Redo Logs dx


    Running Oracle 11g r2.I just want to confirm if Oracle recommends at least 3 redo logs to run the database? If so, how can I create the third (and fourth) redo logs (I believe the default is 2 redo logs)?Thanks.Scott

    DB:2.56:Redo Logs dx


    scottjhn wrote:

    Running Oracle 11g r2.

    I just want to confirm if Oracle recommends at least 3 redo logs to run the database?

    If so, how can I create the third (and fourth) redo logs (I believe the default is 2 redo logs)?

    Thanks.

    Scott
    Sb has given the link to manage the redo logs but where did you read that at least 3 redo log groups are required?Aman....

  • RELEVANCY SCORE 2.56

    DB:2.56:Question On Backup Strategy In General And Redo Logs In Specific z8



    Hello,

    by evaluating a usable Backup strategy for our two ESX Server (2.5.2) we came across vmbk.pl[/i] (http://www.vmts.net/vmbk.htm). This script supports hot backups for running machines by adding a redo log, copying the redo log and last commiting the redo.

    One of my urgent questions is: in the time the redo log exists will new data in the VM be written in the redo log or in the disk file itself? This is very important to know because if data is written in the redo logs I get under certain circumstances inconsistent backups?!

    One general question about backuping: Are there any realy-life success stories we can copy? We did a lot of research, also read the VMware WhitePaper "Using VMware ESX Server System and VMware Virtual Infrastructure for Backup, Restoration, and Disaster Recovery" (http://www.vmware.com/pdf/esx_backup_wp.pdf) but could't find a suitable solution for us.

    Let summarize, either we install a Backup Client on every machine (we use IBM TSM) and treat the VM's as "normal" Server or copy the VM Diskfiles.

    The requirements are support for hotbackup, the downtime for the backup process must be zero and in case of failure we must be able to get a fully working Server back in less then half a business day (max. 4h).

    What do the other ESX-User use for backup? What are real-life solutions? Snaphot-copying? Redo-copying? Save the whole ESX Servers like normal Servers with Backup Client? Or a combination?

    What looks like the "best" solution for us is using vmbk.pl[/i] to copy the vm's on a local partition (Mountpoint on the RAID-1 Systemdrive) (or SAN - we must have a deeper look) and save the them using our TSM-Backupagent. But one problem is, vmbk.pl[/i] doesn't save powerd-off machines...

    Regards

    DB:2.56:Question On Backup Strategy In General And Redo Logs In Specific z8


    We currently do backup agents on important VMs, have used vmbk.pl some.

    To avoid crash-consistent disk files, the other option is to suspend the vm while it snapshots. This is possible w/ FC infrastructure, since it's fast enough not to cause problems. NetApp has some papers with scripts for doing this. Anyone doing this for real?

    Maybe ESX needs some kind of volume shadow copy. Maybe the new backup server will allow backups of images.

  • RELEVANCY SCORE 2.56

    DB:2.56:Oracle 9i On Solaris - Mysterious Crashes a7


    Hi,

    We have a Oracle 9i on a Solaris 9/Sun E4500 platform. During a data load using a 3rd party tool, the Oracle server crashes mysteriously. I have attached the alert log file; please let me know if you'd like the trace file.

    Any help in debugging this would be greatly appreciated.

    Thanks,
    Arun
    P.S. Sorry for the inline pasting of the log...any way we can attach files to postings?

    Mon Apr 26 10:57:49 2004
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    SCN scheme 2
    Using log_archive_dest parameter default value
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    Starting up ORACLE RDBMS Version: 9.2.0.1.0.
    System parameters with non-default values:
    processes = 150
    timed_statistics = TRUE
    shared_pool_size = 50331648
    large_pool_size = 8388608
    java_pool_size = 33554432
    control_files = /u02/oradata/TETL/control01.ctl, /u01/oradata/TETL/control02.ctl, /u03/oradata/TETL/
    control03.ctl
    db_block_size = 8192
    db_cache_size = 25165824
    compatible = 9.2.0.0.0
    db_file_multiblock_read_count= 16
    fast_start_mttr_target = 300
    undo_management = AUTO
    undo_tablespace = UNDOTBS1
    undo_retention = 10800
    remote_login_passwordfile= EXCLUSIVE
    db_domain = totaletl.com
    instance_name = TETL
    dispatchers = (PROTOCOL=TCP) (SERVICE=TETLXDB)
    job_queue_processes = 10
    hash_join_enabled = TRUE
    background_dump_dest = /u02/oradata/TETL/bdump
    user_dump_dest = /u02/oradata/TETL/udump
    core_dump_dest = /u02/oradata/TETL/cdump
    sort_area_size = 524288
    db_name = TETL
    open_cursors = 300
    star_transformation_enabled= FALSE
    query_rewrite_enabled = FALSE
    pga_aggregate_target = 25165824
    aq_tm_processes = 1
    PMON started with pid=2
    DBW0 started with pid=3
    LGWR started with pid=4
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    CJQ0 started with pid=8
    QMN0 started with pid=9
    Mon Apr 26 10:57:54 2004
    starting up 1 shared server(s) ...
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
    Mon Apr 26 10:57:55 2004
    alter database mount
    Mon Apr 26 10:58:01 2004
    Successful mount of redo thread 1, with mount id 2033223221.
    Mon Apr 26 10:58:01 2004
    Database mounted in Exclusive Mode.
    Completed: alter database mount
    Mon Apr 26 10:58:02 2004
    alter database open read write
    Mon Apr 26 10:58:02 2004
    Beginning crash recovery of 1 threads
    Mon Apr 26 10:58:02 2004
    Started first pass scan
    Mon Apr 26 10:58:03 2004
    Completed first pass scan
    4765 redo blocks read, 84 data blocks need recovery
    Mon Apr 26 10:58:03 2004
    Started recovery at
    Thread 1: logseq 10, block 20743, scn 0.0
    Recovery of Online Redo Log: Thread 1 Group 3 Seq 10 Reading mem 0
    Mem# 0 errs 0: /u02/oradata/TETL/redo03.log
    Mon Apr 26 10:58:05 2004
    Ended recovery at
    Thread 1: logseq 10, block 25508, scn 0.1714806
    84 data blocks read, 84 data blocks written, 4765 redo blocks read
    Crash recovery completed successfully
    Mon Apr 26 10:58:05 2004
    Thread 1 advanced to log sequence 11
    Thread 1 opened at log sequence 11
    Current log# 1 seq# 11 mem# 0: /u02/oradata/TETL/redo01.log
    Successful open of redo thread 1.
    Mon Apr 26 10:58:06 2004
    SMON: enabling cache recovery
    Mon Apr 26 10:58:09 2004
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Undo Segment 4 Onlined
    Undo Segment 5 Onlined
    Undo Segment 6 Onlined
    Undo Segment 7 Onlined
    Undo Segment 8 Onlined
    Undo Segment 9 Onlined
    Undo Segment 10 Onlined
    Successfully onlined Undo Tablespace 1.
    Mon Apr 26 10:58:09 2004
    SMON: enabling tx recovery
    Mon Apr 26 10:58:09 2004
    Database Characterset is WE8ISO8859P1
    replication_dependency_tracking turned off (no async multimaster replication found)
    Completed: alter database open read write
    Mon Apr 26 11:48:58 2004
    Thread 1 advanced to log sequence 12
    Current log# 2 seq# 12 mem# 0: /u02/oradata/TETL/redo02.log
    Mon Apr 26 12:09:15 2004
    Thread 1 advanced to log sequence 13
    Current log# 3 seq# 13 mem# 0: /u02/oradata/TETL/redo03.log
    Mon Apr 26 12:27:33 2004
    Errors in file /u02/oradata/TETL/bdump/tetl_lgwr_489.trc:
    ORA-00345: redo log write error block 150389 count 2
    ORA-00312: online log 3 thread 1: '/u02/oradata/TETL/redo03.log'
    ORA-27063: skgfospo: number of bytes read/written is incorrect
    SVR4 Error: 5: I/O error
    Additional information: -1
    Additional information: 1024
    Mon Apr 26 12:27:33 2004
    Errors in file /u02/oradata/TETL/bdump/tetl_ckpt_491.trc:
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: '/u03/oradata/TETL/control03.ctl'
    ORA-27063: skgfospo: number of bytes read/written is incorrect
    SVR4 Error: 5: I/O error
    Additional information: -1
    Additional information: 8192
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: '/u01/oradata/TETL/control02.ctl'
    ORA-27063: skgfospo: number of bytes read/written is incorrect
    SVR4 Error: 5: I/O error
    Additional information: -1
    Additional information: 8192
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: '/u02/oradata/TETL/control01.ctl'
    ORA-27063: skgfospo: number of bytes read/written is incorrect
    SVR4 Error: 5: I/O error
    Additional information: -1
    Additional information: 8192
    Mon Apr 26 12:27:33 2004
    Errors in file /u02/oradata/TETL/bdump/tetl_ckpt_491.trc:
    ORA-00221: error on write to controlfile
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: '/u03/oradata/TETL/control03.ctl'
    ORA-27063: skgfospo: number of bytes read/written is incorrect
    SVR4 Error: 5: I/O error
    Additional information: -1
    Additional information: 8192
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: '/u01/oradata/TETL/control02.ctl'
    ORA-27063: skgfospo: number of bytes read/written is incorrect
    SVR4 Error: 5: I/O error
    Additional information: -1
    Additional information: 8192
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: '/u02/oradata/TETL/control01.ctl'
    ORA-27063: skgfospo: number of bytes read/written is incorrect
    SVR4 Error: 5: I/O error
    Additional information: -1
    Additional information: 8192
    Mon Apr 26 12:27:33 2004
    CKPT: terminating instance due to error 221
    Instance terminated by CKPT, pid = 491

    DB:2.56:Oracle 9i On Solaris - Mysterious Crashes a7

    The main problem is with the drive. Try to fine out why it is getting offline. Your Oracle is working fine, whenever it tries to write/read from disk it is giving error. If you fix the problem of disk getting offline, I think you should not get any errors.

    Manu

  • RELEVANCY SCORE 2.56

    DB:2.56:Resizing Redo Logs In Data Guard Configuration pd


    I have a Data Guard configuration with one primary and one physical standby. The primary has online redo logs and standby redo logs. The standby has standby redo logs too. Now I need to enlarge the primary's online redo logs, what are the proper way to do this? I know the procedures in non-DataGuard situation: adding new redo groups with right size, doing log switches, and removing the old ones.

    Thanks.

    DB:2.56:Resizing Redo Logs In Data Guard Configuration pd

    Could you provide the commands that you are using and the errors that you are gettingPS: Please submit your questions in a new thread instead of putting it into other's thread

  • RELEVANCY SCORE 2.56

    DB:2.56:Logminer xc


    Does LogMiner use online redo logs to generate SQL_UNDO or does it use archived redo logs to generate SQL_UNDO? From where does it take info for generating SQL_REDO?

    DB:2.56:Logminer xc

    Does LogMiner use online redo logs to generate SQL_UNDO or does it use archived redo logs to generate SQL_UNDO? From where does it take info for generating SQL_REDO?

  • RELEVANCY SCORE 2.55

    DB:2.55:Re: Restore From Cold Backup j3


    You can do a simulated Incomplete Recovery followed by an OPEN RESETLOGS to "discard" the Online Redo Logs and/or where your backup/restore does not include the Online Redo Logs (it being common advice to NOT backup Online Redo Logs).

    DB:2.55:Re: Restore From Cold Backup j3

    I had noted "Normally, the TEMPFILE doesn't need to be copied. It can just be added after the ALTER DATABASE OPEN -- see the other forum thread I provided a link to earlier.".
    I also see that you had followed the Metalink note instructions to get the list of files from V$DATAFILE. That would mean that the TEMPFILE is not included..
    So, the right course is to add the TEMPFILE to the TEMP tablespace.

  • RELEVANCY SCORE 2.55

    DB:2.55:Redo Log File Contents k8


    How can I check the contents of the redo log files?
    I recently install 10g. We haven't used the db yet, but the redo logs are very active.
    Is there a query to determine what activity is filling the redo log files?
    Thank you for any help.
    Take Care.
    S

    DB:2.55:Redo Log File Contents k8

    log miner is the way to find out what transaction was done. the DBMS_LOG_MINER package lets you mine the redo logs. you might have to set up few things before you mine the logs. see oracle docs under log miner.

  • RELEVANCY SCORE 2.55

    DB:2.55:Re:Using Streams And Logminer For Auditing a8


    Streams can only be used on Oracle9i Release 2 database redo logs. Redo logs from releases prior to 9iR2 do not include the information necessary for Oracle Streams.

    DB:2.55:Re:Using Streams And Logminer For Auditing a8

    It is better to construct new lcr and execute it. I tried to modify existing one but had some problems.

    Be sure that you executed new lcr (constructed one) and do not execute new one.

    Regards,
    Sergey

  • RELEVANCY SCORE 2.55

    DB:2.55:Cannot Stop .Redo Logs From Appearing 7a



    Ok, I am stumped. I have a VM that is Windows 2000 Server. It's our main production SQL server (extremely critical) and .redo logs keep appearing.

    Over the last few weeks, I have shut it down and applied the .redo logs but they just keep appearing. I have no idea what is causing them but the .redo logs are at about 15 gig a piece (there are two of them now). HELP!

    DB:2.55:Cannot Stop .Redo Logs From Appearing 7a


    I recreated the VM config file and so far it's looking good -- I will watch for a few days and then give some points

  • RELEVANCY SCORE 2.55

    DB:2.55:Redo Log Group Problem a7


    hi ,
    i want to mirror the redo logs using the
    redo group functionality. However, i can't see the members in the current redo group changed at the same time.
    Can anybody tell me why ???

    stephen

    DB:2.55:Redo Log Group Problem a7

    hi ,
    i want to mirror the redo logs using the
    redo group functionality. However, i can't see the members in the current redo group changed at the same time.
    Can anybody tell me why ???

    stephen

  • RELEVANCY SCORE 2.55

    DB:2.55:Query For Disk In Redo f8



    We have a script in which we place our disk in redo mode for backup and after backup we apply those redo logs.

    If ESX host crashes during this procedure then some disk will stay in redo mode.

    How can we find out which disk are in redo mode with a script?

    DB:2.55:Query For Disk In Redo f8


    Hi Dominic

    There are some problem with perl existence file "-e" if the redo file is greater than 2GB

    I've modify vmbk.pl to use a new function (fexist)instead of -e

    #return 1 if file exist

    sub fexist{

    my $filename = shift;

    my $cmdls = `ls $filename 2/dev/null`;

    chomp ($cmdls);

    my $exitcode=($cmdls eq $filename)?1:0;

    return $exitcode;

    }

    Massimiliano Daneri

    http://www.vmts.net

  • RELEVANCY SCORE 2.55

    DB:2.55:Function Of Standby Redo Logs fa


    This is 11gR2.

    The Oracle document says:

    A stanby redo log is used to store redoreceived from another Oracle databsae. ... Redo received from another Oracle database via redo transport is written to the current standby redo log group by an RFS foreground process. When a log switch occurs on the redo source database, incoming redo is then written to the next standby redo log group, and the previously used standby redo log group is archived by an ARVn foreground process.

    So the flow of the process is (no real-time apply): 1) primary database sends redo data through redo trnasport process, 2) the redo data is written to standby redo log; 3) archive process archives the standby redo when there is a log switch; 4) redo apply process applies the redo data to the standby.

    I created my standby using RMAN restore and recover with standby controlfile. I then issued below command to start the redo apply, without creating standby redo log files:

    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

    I noticed redo data is continuously applied to the standby by querying standby database:

    select sequence#, applied from v$archived_log;

    So do I really need to create standby redo logs?

    Thanks.

    DB:2.55:Function Of Standby Redo Logs fa

    Thank you for your detailed reply.
    It is very clear to me now.

    Best regards.
    Hong

  • RELEVANCY SCORE 2.55

    DB:2.55:Re: Archive Log Missing On Standby: Fal[Client]: Failed To Request Gap Sequence cp


    Are you using Dataguard setup?. If so, create standby redo logs on the standby database to receive online redo information from the Logwriter on the primary database. The recommended number of standby redo groups is no. of redo groups in primary database + 1.

    DB:2.55:Re: Archive Log Missing On Standby: Fal[Client]: Failed To Request Gap Sequence cp

    Hi

    What about following parameter setting..
    SELECT name,value FROM v$parameter WHERE name='log_archive_config';
    Be sure your connect descriptor of fal_server and fal_client are correct.It seems not working properly.
    When we configure to resolve gap through ARC then only need to set FAL (fetch archive log) parameter.If it is not set then gap will be resolved automatically and done by LGWR.

    As alert log showing "FAL request rejected" you can follow one of the following steps.

    1.Verify connect descriptor of FAl parameter is correct.
    2.configure automatic gap detection through making FAL parameter nulll.

    Thanks

    Tinku

  • RELEVANCY SCORE 2.55

    DB:2.55:Question On Redo dm


    I have a question on REDO.

    We know that when make any changes to the databases... online redo logs record the changes.

    In books and various documents it is mentioned that redo logs also store "before image" of data.Before Images go to UNDO Tablespace and this helps in rollback

    My question is why do redo logs store "before image" of data? what is the main purpose of storing before image of data in REDO logs?

    Kindly explain.

    Thanks in Advance.

    DB:2.55:Question On Redo dm

    Though you have marked the answer as correct, still a correction I would like to make. Redo does NOT store the old information but its stores information about the Undo blocks. And for the why, read this thread,
    Why not use Redo log for consistent read

    HTH
    Aman....

  • RELEVANCY SCORE 2.54

    DB:2.54:How To Purge Archived Redo Records From The Controlfile dp


    Couple questions here. First, what is the process that enforces the controlfile_record_keep_time parameter? Is there a way to kick it off manually? I am assuming that archived logs are considered part of the "reusable" space (as per the documentation).

    TIA

    DB:2.54:How To Purge Archived Redo Records From The Controlfile dp

    The primary purpose is for me to learn about "how stuff works". I had read about some of the background processes in the documentation, but did not glean what actually acts as a catalyst for such activity (other then the keep_time parameter).

    From an theoretical standpoint, does the purpose really matter? grin

  • RELEVANCY SCORE 2.54

    DB:2.54:Database Not Opening s3


    i have created a database through the create database cmd. The database was created successfully. Now when i try to open the database it says:-

    ORA-01092: ORACLE instance terminated. Disconnection forced

    If i give startup mount, it starts perfectly but as soon as i give alter database open; , oracle crashes.

    The contents of alert.log file are:-

    Wed Mar 1 18:25:35 2006
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    SCN scheme 2
    Using log_archive_dest parameter default value
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    Starting up ORACLE RDBMS Version: 9.2.0.1.0.
    System parameters with non-default values:
    processes = 150
    timed_statistics = TRUE
    shared_pool_size = 50331648
    large_pool_size = 8388608
    java_pool_size = 33554432
    control_files = /opt/ora9/oradata/orcl/database/control01.ctl
    db_block_size = 8192
    db_cache_size = 25165824
    compatible = 9.2.0.0.0
    log_archive_start = TRUE
    db_file_multiblock_read_count= 16
    fast_start_mttr_target = 300
    undo_management = AUTO
    undo_tablespace = UNDOTBS1
    undo_retention = 10800
    remote_login_passwordfile= EXCLUSIVE
    db_domain =
    instance_name = orcl
    dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
    job_queue_processes = 10
    hash_join_enabled = TRUE
    background_dump_dest = /opt/ora9/oradata/orcl/bdump/
    user_dump_dest = /opt/ora9/oradata/orcl/udump/
    core_dump_dest = /opt/ora9/oradata/orcl/cdump/
    sort_area_size = 524288
    db_name = orcl
    open_cursors = 300
    star_transformation_enabled= FALSE
    query_rewrite_enabled = FALSE
    pga_aggregate_target = 25165824
    aq_tm_processes = 1
    PMON started with pid=2
    DBW0 started with pid=3
    LGWR started with pid=4
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    CJQ0 started with pid=8
    QMN0 started with pid=9
    Wed Mar 1 18:25:36 2006
    starting up 1 shared server(s) ...
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
    ARCH: STARTING ARCH PROCESSES
    ARC0 started with pid=12
    ARC1 started with pid=13
    Wed Mar 1 18:25:36 2006
    ARCH: STARTING ARCH PROCESSES COMPLETE
    Wed Mar 1 18:25:36 2006
    ARC1: Archival started
    ARC1: Thread not mounted
    Wed Mar 1 18:25:36 2006
    ARC0: Archival started
    ARC0: Thread not mounted
    Wed Mar 1 18:25:36 2006
    ALTER DATABASE MOUNT
    Wed Mar 1 18:25:40 2006
    Successful mount of redo thread 1, with mount id 1111723680.
    Wed Mar 1 18:25:40 2006
    Database mounted in Exclusive Mode.
    Completed: ALTER DATABASE MOUNT
    Wed Mar 1 18:26:09 2006
    alter database open
    Wed Mar 1 18:26:09 2006
    Beginning crash recovery of 1 threads
    Wed Mar 1 18:26:09 2006
    Started first pass scan
    Wed Mar 1 18:26:09 2006
    Completed first pass scan
    66 redo blocks read, 10 data blocks need recovery
    Wed Mar 1 18:26:09 2006
    Started recovery at
    Thread 1: logseq 9, block 2, scn 0.165910
    Recovery of Online Redo Log: Thread 1 Group 3 Seq 9 Reading mem 0
    Mem# 0 errs 0: /opt/ora9/oradata/orcl/database/redo03.log
    Wed Mar 1 18:26:09 2006
    Ended recovery at
    Thread 1: logseq 9, block 68, scn 0.185977
    10 data blocks read, 10 data blocks written, 66 redo blocks read
    Crash recovery completed successfully
    Wed Mar 1 18:26:09 2006
    Thread 1 advanced to log sequence 10
    Thread 1 opened at log sequence 10
    Current log# 1 seq# 10 mem# 0: /opt/ora9/oradata/orcl/database/redo01.log
    Successful open of redo thread 1.
    Wed Mar 1 18:26:09 2006
    ARC0: Media recovery disabled
    Wed Mar 1 18:26:09 2006
    SMON: enabling cache recovery
    Wed Mar 1 18:26:09 2006
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Undo Segment 4 Onlined
    Undo Segment 5 Onlined
    Undo Segment 6 Onlined
    Undo Segment 7 Onlined
    Undo Segment 8 Onlined
    Undo Segment 9 Onlined
    Undo Segment 10 Onlined
    Successfully onlined Undo Tablespace 1.
    Wed Mar 1 18:26:09 2006
    SMON: enabling tx recovery
    Wed Mar 1 18:26:09 2006
    Database Characterset is WE8MSWIN1252
    Updating 7.0.0.0.0 NLS parameters in sys.props$
    -- adding 9.2.0.1.0 NLS parameters.
    Wed Mar 1 18:26:09 2006
    Errors in file /opt/ora9/oradata/orcl/udump/orcl_ora_4549.trc:
    ORA-01403: no data found
    Error 1403 happened during db open, shutting down database
    USER: terminating instance due to error 1403
    Instance terminated by USER, pid = 4549
    ORA-1092 signalled during: alter database open...

    The contents of the orcl_orac_4549.trc file are:-

    /opt/ora9/oradata/orcl/udump/orcl_ora_4549.trc
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    ORACLE_HOME = /opt/ora9/product/9.2
    System name:Linux
    Node name:oralinux.com
    Release:2.4.21-37.EL
    Version:#1 Wed Sep 7 13:35:21 EDT 2005
    Machine:i686
    Instance name: orcl
    Redo thread mounted by this instance: 1
    Oracle process number: 15
    Unix process pid: 4549, image: oracle@oralinux.com (TNS V1-V3)

    *** SESSION ID:(11.3) 2006-03-01 18:26:09.609
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 33Kb/sec = 66 blocks in 1s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/79 (0%)
    ----------------------------------------------
    *** 2006-03-01 18:26:09.613
    KCRA: start recovery claims for 10 data blocks
    *** 2006-03-01 18:26:09.613
    KCRA: buffers claimed = 10/10, eliminated = 0
    ORA-01403: no data found

    Please help me to resole this issue.

    Thanks,
    Ashish

    DB:2.54:Database Not Opening s3

    Please cut n paste the Create db script and also the environment settings.

    Can you try this query

    SQLselect count(*) from sys.props$

    Look like in your case the sys.props$ table got corrupted. The only option is to re-create the database.

    -Sri

    Message was edited by:
    Srikanth Pulikonda

  • RELEVANCY SCORE 2.54

    DB:2.54:Backing Up Online Redo Log Files x7


    Version:11g

    For RMAN or User managed backups we don't take the backup of Online Redo Log files. Only Archived redo logs are backed up. Why is that?

    DB:2.54:Backing Up Online Redo Log Files x7

    I find that the best way out of this quasi-religious war is to mention that making copies of the online redo logs and current control file is the first step of recovery if those files still existExcellent Recommendation ! I whole-heartedly agree with this.

    I've come across a few occassions where the Database Recovery could have been re-run better. Even where the DBA did an Incomplete Recovery when he could have done a Complete Recovery. And since he hadn't backed up the online redo logs before the restore, he could'nt redo the recovery.

    Hemant K Chitale
    http://hemantoracledba.blogspot.com

  • RELEVANCY SCORE 2.53

    DB:2.53:Number Of Standby Redo Logs On Standby Database 13


    Hello All:
    Per various docs i calculated and created the number of standby redo logs.
    I created 6 standby redo logs in addition to 3 online.

    However, i always see only two standby redo logs being used. Any ideas?

    Thanks
    San~

    DB:2.53:Number Of Standby Redo Logs On Standby Database 13

    Oracle writes to all members of one group at a time.

    Without having your DML it is impossible to know what you are looking at.

  • RELEVANCY SCORE 2.53

    DB:2.53:Redo Logs c3


    What are pros/cons of following redo setup:

    1) Having 3 redo groups with two redo log file each
    2) Having 6 redo groups with one redo log file each

    Other than more log switch(ing) in the case 2 what else is the reason. Which setup would you recommend and Why?.

    DB:2.53:Redo Logs c3

    Thanks Daniel for confirming.

  • RELEVANCY SCORE 2.53

    DB:2.53:Re: Database Recovery 97


    You cannot use an online backup if the archived redo logs generated during this backup are missing.
    Try to use an online backup with corresponding archived redo logs or a offline backup that does not require archived redo logs.

    DB:2.53:Re: Database Recovery 97

    Without recover system tablespace(database) how you can open database?.Just creating controlfle from trace it should not be work.after creating this system tablespace need recovery.

  • RELEVANCY SCORE 2.53

    DB:2.53:Undo Redo Disabled kz



    Relaunch unity - it's a bug which seems to appear when you open the Asset Store

    DB:2.53:Undo Redo Disabled kz


    Thanks, I keep my asset store window up at all times usually. Once I closed the Asset store window I could undo once again :)


    Thanks a lot

  • RELEVANCY SCORE 2.53

    DB:2.53:Logminer 77


    Does LogMiner use online redo logs or archived redo logs or both to generate SQL_UNDO? From where does it take info for generating SQL_REDO?

    DB:2.53:Logminer 77

    Does LogMiner use online redo logs or archived redo logs or both to generate SQL_UNDO? From where does it take info for generating SQL_REDO?

  • RELEVANCY SCORE 2.53

    DB:2.53:Standby Redo Logs dj


    hi
    when there is a failover , and the standby databse will be the primary,
    will the standby redo logs be the redo log files for the new primary , or shall i create new redo log files for it other than the standby redo logs ?
    thanks

    DB:2.53:Standby Redo Logs dj

    For the standby database you should create a Temporary tablespace with a temporary datafile.

  • RELEVANCY SCORE 2.52

    DB:2.52:Re: A Very Simple Question For Noarchivelog Backups pc


    try to
    * "shutdown abort" an oracle database,
    * move redo logs to another destination
    * keep archive logs
    * try to mount (not open, open needs redo logs) and recover database
    and then see whether redo logs are needed or not

    DB:2.52:Re: A Very Simple Question For Noarchivelog Backups pc

    Actually it is a matter of complete and incomplete recovery.

  • RELEVANCY SCORE 2.52

    DB:2.52:Gathering Statistics sm


    Gather statistics by dbms_stats.gather_schema_stats....does this create redo logs or not.

    DB:2.52:Gathering Statistics sm

    Create redo logs? No.

    Generate redo infomation? Yes, but very little as only the actual rdbms base table updates would be logged. Most of the work is done in memory or in temporary segments where the statistics are generated. The job needs CPU.

    HTH -- Mark D Powell --

  • RELEVANCY SCORE 2.52

    DB:2.52:Frequent Redo Log Switches j7


    Oracle 9.2.0.1 on W2k3 server. the redo log is switching every minute, even without any discernable database activity. It's in archive log mode and the redo logs are 100mb in size, so the archive logs are filling up my hard drive. I'm having a hard time figuring out why the redo logs are switching so often. there are 3 redo log groups. Thanks for any help you can give me.

    DB:2.52:Frequent Redo Log Switches j7

    Thanks for all your help. As so often is the case, this was a stored procedure bug.
    A second test database was attempting to insert thousands of records with through a db link. These records failed foreign key validation and were rolled back. this program ran every 5 minutes. using logminer helped a great deal. thanks again.

  • RELEVANCY SCORE 2.52

    DB:2.52:Re: Concurrent Manager Starts But Doesn't Work zz


    @Shakti1803DB server
    root@clodb:/df -k
    Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
    /dev/hd4 1572864 1350044 15% 2259 1% /
    /dev/hd2 3145728 1031832 68% 34083 13% /usr
    /dev/hd9var 1048576 702036 34% 4623 3% /var
    /dev/hd3 1048576 1042932 1% 59 1% /tmp
    /dev/hd1 1048576 807740 23% 76 1% /home
    /proc - - - - - /proc
    /dev/hd10opt 524288 368664 30% 3710 5% /opt
    /dev/livedump 524288 523880 1% 4 1% /var/adm/ras/livedump
    /dev/fslv03 19922944 17673368 12% 6 1% /backup
    /dev/fslv02 146800640 14883040 90% 421 1% /oradata
    /dev/fslv05 31457280 5543968 83% 36 1% /oradata2
    /dev/fslv06 20971520 12271512 42% 133390 5% /oratech
    Apps Serverroot@cloapp:/df -kFilesystem 1024-blocks Free %Used Iused %Iused Mounted on/dev/hd4 1048576 862100 18% 1734 1% //dev/hd2 2621440 981424 63% 29096 12% /usr/dev/hd9var 1048576 672576 36% 1534 2% /var/dev/hd3 1572864 1553620 2% 158 1% /tmp/dev/hd1 1048576 805272 24% 155 1% /home/proc - - - - - /proc/dev/hd10opt 524288 416192 21% 2353 3% /opt/dev/fslv01 29360128 7597068 75% 6 1% /ebs1/dev/fslv00 20971520 10950668 48% 21042 1% /backup/dev/fslv02 71303168 3516132 96% 710887 48% /oraapproot@cloapp:/@Hussein1. Rebooted both DB and Apps Server
    Starting Database

    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    SCN scheme 3
    Using log_archive_dest parameter default value
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    Starting up ORACLE RDBMS Version: 9.2.0.3.0.
    System parameters with non-default values:
    _trace_files_public = TRUE
    processes = 800
    sessions = 885
    timed_statistics = TRUE
    shared_pool_size = 301989888
    shared_pool_reserved_size= 30000000
    _shared_pool_reserved_min_alloc= 4100
    java_pool_size = 67108864
    enqueue_resources = 32000
    nls_language = american
    nls_territory = america
    nls_sort = binary
    nls_date_format = DD-MON-RR
    nls_numeric_characters = .,
    nls_comp = binary
    nls_length_semantics = BYTE
    control_files = /oradata/proddata/cntrl01.dbf, /oradata2/data/cntrl02.dbf, /oradata/proddata/cntrl03.dbf
    db_block_checksum = TRUE
    db_block_size = 8192
    db_cache_size = 167772160
    compatible = 9.2.0
    log_buffer = 10485760
    log_checkpoint_interval = 100000
    log_checkpoint_timeout = 1200
    db_files = 512
    db_file_multiblock_read_count= 8
    log_checkpoints_to_alert = TRUE
    dml_locks = 10000
    row_locking = always
    undo_management = AUTO
    undo_tablespace = APPS_UNDOTS1
    undo_suppress_errors = FALSE
    undo_retention = 1800
    db_block_checking = FALSE
    max_enabled_roles = 100
    O7_DICTIONARY_ACCESSIBILITY= TRUE
    session_cached_cursors = 200
    utl_file_dir = /usr/tmp, /oratech/proddb/9.2.0/appsutil/outbound/PROD_clodb
    job_queue_processes = 2
    _system_trig_enabled = TRUE
    cursor_sharing = EXACT
    parallel_min_servers = 0
    parallel_max_servers = 8
    background_dump_dest = /oratech/proddb/9.2.0/admin/PROD_clodb/bdump
    user_dump_dest = /oratech/proddb/9.2.0/admin/PROD_clodb/udump
    max_dump_file_size = 20480
    core_dump_dest = /oratech/proddb/9.2.0/admin/PROD_clodb/cdump
    optimizer_features_enable= 9.2.0
    db_name = PROD
    open_cursors = 600
    ifile = /oratech/proddb/9.2.0/dbs/PROD_clodb_ifile.ora
    sql_trace = FALSE
    _sort_elimination_cost_ratio= 5
    _b_tree_bitmap_plans = FALSE
    _fast_full_scan_enabled = FALSE
    optimizer_max_permutations= 2000
    query_rewrite_enabled = true
    _index_join_enabled = FALSE
    _sqlexec_progression_cost= 2147483647
    _like_with_bind_as_equality= TRUE
    pga_aggregate_target = 1073741824
    workarea_size_policy = AUTO
    aq_tm_processes = 1
    olap_page_pool_size = 4194304
    PMON started with pid=2
    DBW0 started with pid=3
    LGWR started with pid=4
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    CJQ0 started with pid=8
    QMN0 started with pid=9
    Wed Mar 26 18:06:49 2014
    ALTER DATABASE MOUNT
    Wed Mar 26 18:06:54 2014
    Successful mount of redo thread 1, with mount id 255049657.
    Wed Mar 26 18:06:54 2014
    Database mounted in Exclusive Mode.
    Completed: ALTER DATABASE MOUNT
    Wed Mar 26 18:06:54 2014
    ALTER DATABASE OPEN
    Wed Mar 26 18:06:55 2014
    Beginning crash recovery of 1 threads
    Wed Mar 26 18:06:56 2014
    Started first pass scan
    Wed Mar 26 18:06:56 2014
    Completed first pass scan
    6675 redo blocks read, 122 data blocks need recovery
    Wed Mar 26 18:06:56 2014
    Started recovery at
    Thread 1: logseq 9245, block 15592, scn 0.0
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 9245 Reading mem 0
    Mem# 0 errs 0: /oradata/proddata/log02a.dbf
    Mem# 1 errs 0: /oradata/proddata/log02b.dbf
    Recovery of Online Redo Log: Thread 1 Group 1 Seq 9246 Reading mem 0
    Mem# 0 errs 0: /oradata/proddata/log01a.dbf
    Mem# 1 errs 0: /oradata/proddata/log01b.dbf
    Wed Mar 26 18:06:56 2014
    Completed redo application
    Wed Mar 26 18:06:56 2014
    Ended recovery at
    Thread 1: logseq 9246, block 1792, scn 0.3903148237
    122 data blocks read, 122 data blocks written, 6675 redo blocks read
    Crash recovery completed successfully
    Wed Mar 26 18:06:57 2014
    Thread 1 advanced to log sequence 9247
    Thread 1 opened at log sequence 9247
    Current log# 3 seq# 9247 mem# 0: /oradata/proddata/log03a.dbf
    Current log# 3 seq# 9247 mem# 1: /oradata/proddata/log03b.dbf
    Successful open of redo thread 1.
    Wed Mar 26 18:06:57 2014
    MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
    Wed Mar 26 18:06:57 2014
    SMON: enabling cache recovery
    Wed Mar 26 18:07:00 2014
    Undo Segment 1 Onlined
    Undo Segment 2 Onlined
    Undo Segment 3 Onlined
    Undo Segment 4 Onlined
    Undo Segment 5 Onlined
    Undo Segment 6 Onlined
    Undo Segment 7 Onlined
    Undo Segment 8 Onlined
    Undo Segment 9 Onlined
    Undo Segment 10 Onlined
    Successfully onlined Undo Tablespace 371.
    Wed Mar 26 18:07:00 2014
    SMON: enabling tx recovery
    Wed Mar 26 18:07:00 2014
    Database Characterset is AR8ISO8859P6
    replication_dependency_tracking turned off (no async multimaster replication found)
    Completed: ALTER DATABASE OPEN

    2. Starting Apps
    root@cloapp:/su - applprod
    [YOU HAVE NEW MAIL]
    applprod@cloapp:/home/applprod./startup.sh

    You are running adstrtal.sh version 115.14

    Executing service control script:
    /oraapp/prodcomn/admin/scripts/PROD_cloapp/adapcctl.sh start
    script returned:
    ****************************************************

    adapcctl.sh version 115.43

    Starting Apache Web Server Listener (dedicated HTTP) ...
    Starting Apache Web Server Listener (dedicated PLSQL) ...

    adapcctl.sh: exiting with status 0

    .end std out.

    .end err out.

    ****************************************************

    Executing service control script:
    /oraapp/prodcomn/admin/scripts/PROD_cloapp/adalnctl.sh start
    script returned:
    ****************************************************

    adalnctl.sh version

    Checking for FNDFS executable.
    Starting listener process APPS_PROD.

    adalnctl.sh: exiting with status 0

    .end std out.

    .end err out.

    ****************************************************

    Executing service control script:
    /oraapp/prodcomn/admin/scripts/PROD_cloapp/adcmctl.sh start
    script returned:
    ****************************************************

    You are running adcmctl.sh version 115.19

    Starting concurrent manager for PROD ...
    Starting PROD_0326@PROD Internal Concurrent Manager
    Default printer is noprint

    adcmctl.sh: exiting with status 0

    .end std out.

    .end err out.

    ****************************************************

    Executing service control script:
    /oraapp/prodcomn/admin/scripts/PROD_cloapp/adfrmctl.sh start
    script returned:
    ****************************************************

    You are running adfrmctl.sh version 115.33

    Starting forms server for PROD on port 9000.

    adfrmctl.sh: exiting with status 0

    .end std out.

    .end err out.

    ****************************************************

    Executing service control script:
    /oraapp/prodcomn/admin/scripts/PROD_cloapp/adrepctl.sh start
    script returned:
    ****************************************************

    You are running adrepctl.sh version 115.29

    starting Reports Server for PROD on port 7000.

    adrepctl.sh: exiting with status 0

    .end std out.

    .end err out.

    ****************************************************

    Executing service control script:
    /oraapp/prodcomn/admin/scripts/PROD_cloapp/adfmcctl.sh start
    script returned:
    ****************************************************

    You are running adfmcctl.sh version 115.16

    Starting forms load balancing client for PROD.

    adfmcctl.sh: exiting with status 0

    .end std out.

    .end err out.

    ****************************************************

    Executing service control script:
    /oraapp/prodcomn/admin/scripts/PROD_cloapp/adfmsctl.sh start
    script returned:
    ****************************************************

    You are running adfmsctl.sh version 115.12

    starting forms metrics server for PROD.

    adfmsctl.sh: exiting with status 0

    .end std out.

    .end err out.

    ****************************************************

    Executing service control script:
    /oraapp/prodcomn/admin/scripts/PROD_cloapp/jtffmctl.sh start
    script returned:
    ****************************************************

    You are running jtffmctl.sh version 115.7

    Starting Fulfillment Server for PROD on port 9300 ...

    jtffmctl.sh: exiting with status 0

    .end std out.

    .end err out.

    ****************************************************

    Executing service control script:
    /oraapp/prodcomn/admin/scripts/PROD_cloapp/addisctl.sh start
    script returned:
    ****************************************************

    addisctl.sh version 115.8

    Oracle Discoverer OAD is not running (no process with PID 426196 )

    Waiting for OAD to start...
    Started OAD.
    OAD logs messages to the file /oraapp/prodora/8.0.6/discwb4/util/oad.log.
    Oracle Discoverer OSAGENT is not running (no process with PID 442586)

    /oraapp/prodora/8.0.6/vbroker/bin/osagent
    Started osagent.
    Osagent logs messages to the file /oraapp/prodora/8.0.6/discwb4/util/osagent.log.
    Oracle Discoverer LOCATOR is not running (no process with PID 139482)

    Discoverer Locator Started.
    Locator logs messages to the file /oraapp/prodora/8.0.6/discwb4/util/locator.log.

    addisctl.sh: exiting with status 0

    .end std out.

    .end err out.

    ****************************************************

    All enabled services for this node are started.
    Check logfile /oraapp/prodcomn/admin/log/PROD_cloapp/03261508.log for details

    Exiting with status 0
    applprod@cloapp:/home/applprod
    3. Going to the log directory of Concurrent Manager in the Apps Server
    applprod@cloapp:/oraapp/prodcomn/admin/log/PROD_cloappls -la *.mgr | grep 26
    -rw-r--r-- 1 applprod dba 2627 Mar 26 15:10 PROD_0326.mgr
    -rw-r--r-- 1 applprod dba 1269795 Jan 05 12:37 PROD_1230.mgr
    -rw-r--r-- 1 applprod dba 258264 Dec 29 22:27 w15097.mgr
    -rw-r--r-- 1 applprod dba 268420 Dec 29 22:27 w15098.mgr
    applprod@cloapp:/oraapp/prodcomn/admin/log/PROD_cloappcat PROD_0326.mgr

    ========================================================================
    Starting PROD_0326@PROD Internal Concurrent Manager -- shell process ID 422094

    logfile=/oraapp/prodcomn/admin/log/PROD_cloapp/PROD_0326.mgr
    PRINTER=noprint
    mailto=applprod
    restart=N
    diag=N
    sleep=60 (default)
    pmon=20 (default)
    quesiz=1 (default)

    establish_icm - Unable to insert ICM record
    Call to establish_icm failed
    The Internal Concurrent Manager has encountered an error.

    Review concurrent manager log file for more detailed information. : 26-MAR-2014 15:10:12 -

    Shutting down Internal Concurrent Manager : 26-MAR-2014 15:10:12

    List of errors encountered:
    .............................................................................

    _ 1 _
    Routine AFPCSQ encountered an ORACLE error. .

    Review your error messages for the cause of the error. (=POINTER)
    .............................................................................

    APP-FND-01564: ORACLE error 1653 in insert_icm_record

    Cause: insert_icm_record failed due to ORA-01653: unable to extend table APPLSY S.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD.

    The SQL statement being executed at the time of the error was: INSERT INTO FND _CONCURRENT_PROCESSES (CONCURRENT_PROCESS_ID, LAST_UPDATE_DATE, CRE ATION_DATE, CREATED_BY, LAST_UPDATED_BY, ORACLE_PROCESS_ID, QUEUE_APPLICATION_ID, CONCURRENT_QUEUE_ID, OS_PROCESS_ID, SESSION_ID, PROCESS_START_DATE, PROCESS_STATUS_CODE, MANAGER_ TYPE, NODE_NAME, DB_NAME, DB_DOMAIN, DB_INS TANCE, Instance_Number) VALUES (:cpid, SYSDATE, SYS DATE, :mgrusrid, :mgrusrid, :opid, :qapp id, :qid, :ospid, :osid, SYSDATE, 'A', 0, :node, :dbname, :dbdomain, :dbinst, (Select instance_number from v$instance)) and was executed from the file ERRFILE.

    List of errors encountered:
    .............................................................................

    _ 1 _
    Routine AFPCAL received failure code while parsing or running your
    concurrent program CPMGR

    Review your concurrent request log file for more detailed information.
    Make sure you are passing arguments in the correct format.
    .............................................................................

    The PROD_0326@PROD internal concurrent manager has terminated with status 1 - gi ving up.
    applprod@cloapp:/oraapp/prodcomn/admin/log/PROD_cloapp

    -rw-r--r-- 1 applprod dba 2026 Jan 09 11:31 w58488.mgr
    -rw-r--r-- 1 applprod dba 2608 Jan 15 11:15 w61305.mgr
    -rw-r--r-- 1 applprod dba 26932 Jan 15 11:15 w61316.mgr
    -rw-r--r-- 1 applprod dba 2609 Mar 22 18:44 w85610.mgr
    what does this mean ? thanks

    DB:2.52:Re: Concurrent Manager Starts But Doesn't Work zz

    Shakti,As you asked:1. Stop all apps servicesStopped Apps.2. Run exec fnd_conc_clone.setup_clean(); as apps
    oraprod@clodb:/oratech/proddb/9.2.0sqlplus apps/apps

    SQL*Plus: Release 9.2.0.3.0 - Production on Thu Mar 27 22:54:28 2014

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.3.0 - Production

    SQL EXEC FND_CONC_CLONE.SETUP_CLEAN;

    PL/SQL procedure successfully completed.

    SQL commit;

    Commit complete.

    SQL exit
    3. Run autoconfig on dbtier
    oraprod@clodb:/oratech/proddb/9.2.02.0/appsutil/scripts/PROD_clodb
    oraprod@clodb:/oratech/proddb/9.2.0/appsutil/scripts/PROD_clodbls *.sh
    adautocfg.sh addbctl.sh addlnctl.sh adlsnodes.sh
    oraprod@clodb:/oratech/proddb/9.2.0/appsutil/scripts/PROD_clodbocfg.sh
    Enter the APPS user password:
    AutoConfig is configuring the Database environment...

    AutoConfig will consider the custom templates if present.
    Using ORACLE_HOME location : /oratech/proddb/9.2.0
    Using java command : /oratech/proddb/9.2.0/jdk/bin/java
    Java version : 1.3.1
    Classpath : /oratech/proddb/9.2.0/jdk/jre/lib/rt.jar:/oratech/proddb/9.2.0/jdk/jre/lib/i18n.jar:/oratech/proddb/9.2.0/jdk/lib/dt.jar:/oratech/proddb/9.2.0/jdk/lib/tools.jar:/oratech/proddb/9.2.0/jdbc/lib/classes12.jar:/oratech/proddb/9.2.0/appsutil/java/xmlparserv2.zip:/oratech/proddb/9.2.0/appsutil/java:/oratech/proddb/9.2.0/jlib/netcfg.jar

    Using Context file : /oratech/proddb/9.2.0/appsutil/PROD_clodb.xml

    Context Value Management will now update the Context file

    Updating Context file...COMPLETED

    Attempting upload of Context file and templates to database...COMPLETED

    Updating rdbms version in Context file to db920
    Updating rdbms type in Context file to 64 bits
    Configuring templates from ORACLE_HOME ...

    AutoConfig completed successfully.
    The log file for this session is located at: /oratech/proddb/9.2.0/appsutil/log/PROD_clodb/03272257/adconfig.log
    oraprod@clodb:/oratech/proddb/9.2.0/appsutil/scripts/PROD_clodb
    4. Run autoconfig on apps tier
    applprod@cloapp:/oraapp/prodcomn/admin/scripts/PROD_cloapp./adautocfg.sh
    Enter the APPS user password:
    AutoConfig is configuring the Applications environment...

    AutoConfig will consider the custom templates if present.
    Using APPL_TOP location : /oraapp/prodappl
    Using java command : /usr/java131/bin/java
    Java version : 1.3.1
    Classpath : /usr/java131/jre/lib/rt.jar:/usr/java131/jre/lib/i18n.jar:/usr/java131/lib/dt.jar:/usr/java131/lib/tools.jar:/oraapp/prodcomn/java/appsborg2.zip:/oraapp/prodcomn/java

    Using Context file : /oraapp/prodappl/admin/PROD_cloapp.xml

    Context Value Management will now update the Context file

    Updating Context file...COMPLETED

    Attempting upload of Context file and templates to database...COMPLETED

    Configuring templates from all of the product tops...
    Configuring AD_TOP........COMPLETED
    Configuring FND_TOP.......COMPLETED
    Configuring ICX_TOP.......COMPLETED
    Configuring IEO_TOP.......COMPLETED
    Configuring ABM_TOP.......COMPLETED
    Configuring ECX_TOP.......COMPLETED
    Configuring BIS_TOP.......COMPLETED
    Configuring GL_TOP........COMPLETED
    Configuring AMS_TOP.......COMPLETED
    Configuring WSH_TOP.......COMPLETED
    Configuring OKE_TOP.......COMPLETED
    Configuring OKL_TOP.......COMPLETED
    Configuring OKS_TOP.......COMPLETED
    Configuring CSF_TOP.......COMPLETED
    Configuring XNC_TOP.......COMPLETED
    Configuring IGS_TOP.......COMPLETED
    Configuring IBY_TOP.......COMPLETED
    Configuring PA_TOP........COMPLETED
    Configuring JTF_TOP.......COMPLETED
    Configuring MWA_TOP.......COMPLETED
    Configuring CN_TOP........COMPLETED
    Configuring CSI_TOP.......COMPLETED
    Configuring WIP_TOP.......COMPLETED
    Configuring CSE_TOP.......COMPLETED
    Configuring EAM_TOP.......COMPLETED
    Configuring IMT_TOP.......COMPLETED
    Configuring FTE_TOP.......COMPLETED
    Configuring ONT_TOP.......COMPLETED
    Configuring AR_TOP........COMPLETED
    Configuring AHL_TOP.......COMPLETED
    Configuring CSD_TOP.......COMPLETED
    Configuring IGC_TOP.......COMPLETED

    AutoConfig completed successfully.
    The log file for this session is located at: /oraapp/prodappl/admin/PROD_cloapp/log/03271959/adconfig.log
    applprod@cloapp:/oraapp/prodcomn/admin/scripts/PROD_cloapp
    * Check fnd_nodes, you should have entries for both the nodes, and check tnsnames.ora, should have correct tns entry.5. Start services.started appschecking the concurrent manager log
    ========================================================================
    Starting PROD_0327@PROD Internal Concurrent Manager -- shell process ID 6750430

    logfile=/oraapp/prodcomn/admin/log/PROD_cloapp/PROD_0327.mgr
    PRINTER=noprint
    mailto=applprod
    restart=N
    diag=N
    sleep=60 (default)
    pmon=20 (default)
    quesiz=1 (default)

    Found dead process: spid=(491536), cpid=(87371), ORA pid=(51), manager=(0/4)
    Found dead process: spid=(417956), cpid=(87373), ORA pid=(52), manager=(0/5)
    Found dead process: spid=(483512), cpid=(87374), ORA pid=(42), manager=(0/0)
    Found dead process: spid=(438280), cpid=(87375), ORA pid=(43), manager=(0/0)
    Found dead process: spid=(409812), cpid=(87376), ORA pid=(44), manager=(0/0)
    Found dead process: spid=(331868), cpid=(87377), ORA pid=(45), manager=(0/0)
    Found dead process: spid=(352364), cpid=(87378), ORA pid=(75), manager=(0/0)
    Found dead process: spid=(499808), cpid=(87379), ORA pid=(46), manager=(0/0)
    Found dead process: spid=(450566), cpid=(87380), ORA pid=(55), manager=(201/15)
    Found dead process: spid=(442526), cpid=(87381), ORA pid=(54), manager=(201/15)
    Found dead process: spid=(217334), cpid=(87382), ORA pid=(56), manager=(201/15)
    Found dead process: spid=(364576), cpid=(87383), ORA pid=(57), manager=(201/222)
    Found dead process: spid=(508152), cpid=(87384), ORA pid=(58), manager=(201/222)
    Found dead process: spid=(512250), cpid=(87385), ORA pid=(59), manager=(201/222)
    Found dead process: spid=(516348), cpid=(87386), ORA pid=(65), manager=(275/40)
    Found dead process: spid=(520446), cpid=(87387), ORA pid=(48), manager=(0/1044)
    Found dead process: spid=(524288), cpid=(87388), ORA pid=(61), manager=(401/10)
    Found dead process: spid=(528386), cpid=(87389), ORA pid=(63), manager=(401/10)
    Found dead process: spid=(532484), cpid=(87390), ORA pid=(62), manager=(401/10)
    Found dead process: spid=(536582), cpid=(87391), ORA pid=(49), manager=(696/1024)
    Found dead process: spid=(540680), cpid=(87392), ORA pid=(50), manager=(696/1025)
    Found dead process: spid=(434354), cpid=(87370), ORA pid=(13), manager=(0/1)

    +---------------------------------------------------------------------------+
    Application Object Library: Concurrent Processing version 11.5

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    Internal Concurrent Manager started : 27-MAR-2014 20:07:57

    +---------------------------------------------------------------------------+

    Process monitor session started : 27-MAR-2014 20:08:03
    Found dead process: spid=(557112), cpid=(87453), Service Instance=(1139)
    Found dead process: spid=(569546), cpid=(87454), Service Instance=(1140)

    Starting FNDCRM Concurrent Manager : 27-MAR-2014 20:08:08

    Starting FNDSCH Concurrent Manager : 27-MAR-2014 20:08:08

    Starting STANDARD Concurrent Manager : 27-MAR-2014 20:08:08
    Starting STANDARD Concurrent Manager : 27-MAR-2014 20:08:08
    Starting STANDARD Concurrent Manager : 27-MAR-2014 20:08:08
    Starting STANDARD Concurrent Manager : 27-MAR-2014 20:08:08
    Starting STANDARD Concurrent Manager : 27-MAR-2014 20:08:08
    Starting STANDARD Concurrent Manager : 27-MAR-2014 20:08:08

    Starting PODAMGR Concurrent Manager : 27-MAR-2014 20:08:08
    Starting PODAMGR Concurrent Manager : 27-MAR-2014 20:08:08
    Starting PODAMGR Concurrent Manager : 27-MAR-2014 20:08:09

    Starting RCVOLTM Concurrent Manager : 27-MAR-2014 20:08:09
    Starting RCVOLTM Concurrent Manager : 27-MAR-2014 20:08:09
    Starting RCVOLTM Concurrent Manager : 27-MAR-2014 20:08:09

    Starting PASMGR Concurrent Manager : 27-MAR-2014 20:08:09

    Starting OAMCOLMGR Concurrent Manager : 27-MAR-2014 20:08:09

    Starting INVMGR Concurrent Manager : 27-MAR-2014 20:08:09
    Starting INVMGR Concurrent Manager : 27-MAR-2014 20:08:09
    Starting INVMGR Concurrent Manager : 27-MAR-2014 20:08:09

    Starting IEU_SH_CS Concurrent Manager : 27-MAR-2014 20:08:09

    Starting IEU_WL_CS Concurrent Manager : 27-MAR-2014 20:08:09

    Starting WFALSNRSVC Concurrent Manager : 27-MAR-2014 20:08:09

    Starting WFMLRSVC Concurrent Manager : 27-MAR-2014 20:08:09

    Process monitor session ended : 27-MAR-2014 20:08:10
    applprod@cloapp:/oraapp/prodcomn/admin/log/PROD_cloapp
    Thank you. Problem resolved.

  • RELEVANCY SCORE 2.52

    DB:2.52:Rebuilding Redo Log Member Using The Mirror Redo Log 13


    One of our redo logs has a block corruption and throws error message that it's reading the mirror redo log. I am wondering if it's possible to re-create redo log using one of it's member?

    I see that it's INACTIVE and archive is set to NO for that member

    DB:2.52:Rebuilding Redo Log Member Using The Mirror Redo Log 13

    See MOS Doc 1078456.6 (REDO LOG CORRUPTION - DROPPING REDO LOGS NOT POSSIBLE - CLEAR LOGFILE )

    HTH
    Srini

  • RELEVANCY SCORE 2.52

    DB:2.52:Redo Logs On Rac zx


    Hello All,

    I am using Oracle 11gR2 RAC two nodes on OEL 5.5

    I faced a corruption on my redo logs related to Node 1, group 1 was corrupted. Now I solved the issue but still have the following questions:

    The wiered issue that i was not able to start my database at all , neither Node 1 nor Node 2.

    why I was not able to start instance 2 on Node 2? all it is related redo logs were not corrupted

    Regards,

    DB:2.52:Redo Logs On Rac zx

    You were not able to start the database because this really is a database issue, not related to an instance. When your logs got corrupted, your database was shut down aswell. To bring it back up and get it to a consistent state, you need to read the redo logs. This also happens across nodes, when you open the database on node 2 and it is in an inconsistent state, node 2 will perform 'crash recovery' and read the redo data from all instances and apply this to the database.

    Bjoern

  • RELEVANCY SCORE 2.52

    DB:2.52:Online Redo Logs js


    Hi all, Can you please tell me how to recover corrupted ONLINE REDO LOG FILES. I know how to recover archived redo logs but I am not sure how to recover corrupted online redo logs. Thanks heaps

    DB:2.52:Online Redo Logs js

    Good point. Ignore what I wrote and read the link Chandra provided in the previous message. It covers all the ins and outs, and a few subtleties I didn't consider.

    -Mark