Search: logfile

More Results

Sort by: Relevance | Date

  • What to do with lost logfiles

    I am confused because I have two answers to the same question.

    Question: After a disk crash I lost some control files and all logfiles (no archive). After restoring the system I would like to copy the good control file to the old ones. What... Ask the Expert   |   SearchOracle.com

  • Programming SMO applications for improved management, automation

    SQL Server Management Objects (SMO) are a collection of .NET code libraries containing API classes for accessing and working with all areas of Microsoft SQL Server. Many of the native SQL Server tools such as SQL Server Management Studio (SSMS)... Tip   |   SearchSQLServer.com

  • Decreasing the size of a datafile

    I had created a database named "maverick" and allocated a size of 6 GB for datafile(.mdf) and 1 GB for logfile(.ldf). But after that, due to some disk space re;ated reason, I tried to decrease the datafile size from 6 GB to 2... Ask the Expert   |   SearchSQLServer.com

  • Creating standby databases in SQL Server

    It is a common practice to create a replica database for server testing -- but this can also be done for backup purposes.

    Using DTS with the option to transfer all objects can be very time-consuming. Generating insert scripts would... Tip   |   SearchSQLServer.com

  • Recovering a 9i database

    How do I recover an entire Oracle9i database including controlfile and logfiles? Ask the Expert   |   SearchOracle.com

  • ECC 6.0 system copy attach/detach method

    If you think logfiles and target datafiles have anything to do with a system copy method then you better read this advice from expert Farooq Ali and learn the facts. Ask the Expert   |   SearchSAP.com

  • Replicating data from SQL Server 2000 to Oracle

    This tip is useful for understanding the replication options between SQL Server 2000 and Oracle 8i databases. It will help DBAs enable the sharing of data in a heterogeneous environment that is a common challenge in most IT departments.... Tip   |   SearchSQLServer.com

  • Network-based application performance monitoring for better visibility

    How is network-based application performance monitoring different than other performance management approaches?

    Do you have a question for Jesse?

    Answer   |   SearchNetworking.com

  • Add or drop inactive online redo log files

    Can we add or drop (inactive) online redo log files at the open stage?

    I have been known to do this from time to time. On occasion, I have been required to move the online redo logs from one disk volume to another.... Ask the Expert   |   SearchOracle.com

  • Show all files associated with database instance

    Is there a single query that can be executed to show all files associated with a database instance?
    You can query DBA_DATA_FILES or V$DBFILE to see the datafiles belonging to your tablespaces. The V$LOGFILE view shows... Ask the Expert   |   SearchOracle.com

Search Again: