Answers - IT and Computing - SearchOracle

What are rolling forward and rolling backward in backup and recovery? Continue Reading

Difference between "active-active" and "active-passive" configuration in RAC environments

Star schema advice for healthcare data warehouse

Data warehousing project for large insurance company

Unknown error codes: ORA-00600, ORA-06544, and ORA-06553

Determining cause of ORA-00600 error

ORA-00604 error on SQL level 2 generated on table update

TNS listener service automatically stopped with Oracle 9.2.0.1 on Windows XP

Using 'consistent=y' in exports

Given that export is now not recommended as a backup mode, what is the effect of the 'consistent=y' parameter when data is exported? Continue Reading

Calling a stored procedure from the same stored procedure

Exporting data to .dat file then into another data table

Are PL/SQL stored procedures multi-threaded?

Counts from two tables in one SQL statement

DIM-00019 and ORA-12560 when creating new database

ORA-03113, ORA-24324 and ORA-01041when trying to start up

Counting rows by month name

Errors installing the recovery catalog from RMAN prompt

RMAN level 0 backup failures: ORA-00235

We are using the RMAN level 0 hot backup process. We invariably have level 0 backup failures during the process. Continue Reading

ORA-01089 when opening the database

ORA-12514 when trying to create db link

I am having a problem creating a db link. It creates successfully but when I run a test query I get the ORA-12514 error. Continue Reading

ORA-04031 in the job queue process

Recovering corrupt data file without any backup files

I have a corrupt datafile ("fractured block"), and our backups have turned out to be unusable. Is there any other method of recovery, short of sending the datafile to Oracle? Continue Reading

Resolving the ORA-03113 error

I have an Oracle 9i database. I am getting the "ERROR at line 1: ORA-03113: end-of-file on communication channel" error message whenever the client is idle for five minutes. Continue Reading

Swapping data of two rows without creating temp fields

Procedure for sending attachments via utl_smtp

Inserting value that includes single quotes

Resolving errors ORA-04091, ORA-06512 and ORA-04088

INITRANS and MAXTRANS explained

Explanation of the different types of indexes

Can't find table x$ksppsv

Database not accessible after IP address change

Redo log files corrupted

We took a cold backup last week. Unfortunately due to media failure my redo log files are corrupted. I have no backup control file. How can I recover the database? Continue Reading

Improving backup speed and uses with RMAN

We want to reduce the time needed to take a daily hot backup with RMAN. How can we speed up this process? Continue Reading

EXP/IMP vs. RMAN for backup

RMAN has many advantages that the logical backup with EXP/IMP cannot provide for you. Continue Reading

Getting a list of tablespaces

Importing a dmp file to Access

Composite keys in M:N relationship tables

System performance slow after SAP ERP upgrade

How does RMAN perform hot backups without shutting down DB?

How are hot backups performed in RMAN without shutting down the database? How are inconsistencies resolved? Continue Reading

RMAN cold backup vs. hot backup

Why would you want to do an RMAN cold backup vs. hot? What's the difference? Continue Reading

Duplicating from a cold backup using RMAN

Oracle9i processes not coming up after install/reboot

Changing redo log buffer size

PL/SQL to display all tables

Correcting a stored procedure

Compilation errors in SQL*Plus stored procedure

Getting a list of all svrmgrl commands

Converting number to HEX value, part 1

Extracting data from .dmp file

Query to retrieve data from past six months

Estimating bitmap index sizes

UTL_File to read directories on client machines

TOP n WITH TIES in MySQL

Inserting and searching many-to-many relationships

Comparing data from source column with target column

Cold backup using RMAN

Use this script to perform a cold backup with RMAN. Continue Reading

Dedicated vs. shared server

What's the difference between dedicated and MTS/Shared Server in Oracle 9i, in terms of architecture and performance in a hybrid database? Continue Reading

Public/private synonyms to improve performance

Number or float for primary key?

How Oracle10g achieves grid computing

Brian Peasland explains the concept of grid computing and how it's achieved in Oracle 10g. Continue Reading

What's the future for Oracle DBAs?

The surrogate key of the row just inserted

Steps for copying a database or schema

Follow these steps to copy an entire database or a schema using Oracle's export and import utilities. Continue Reading

Cause of ORA-1089 error

Turning off Local OS Authenticationo

ODBC vs. SQL*Net security

Optional foreign key can be NULL

Missing right parenthesis

Approving multiple invoices in Oracle AP

How to send consolidated invoices

SQL query for parent/child relationship

Step-by-step backup procedures

Brian Peasland provides step-by-step instructions for performing hot and cold backups. Continue Reading

Six questions to determine your backup requirements

Oracle expert Brian Peasland provides the answers to six basic questions you should ask yourself before designing a backup and recovery solution. Continue Reading

Using ALTER USER for changing passwords

Database Configuration Assistant error after install

Changing database character set, part 2

Factors to consider when creating a new database

GROUP BY with two tables, part 2

UTL_SMTP vs. UTL_TCP

Understanding autoallocate and segment space management

Trying to call SAP BAPI from Oracle Forms

Ask the Experts