DBA Corner

Data is stored somewhere

Month: April 2005

  • RMAN-10035 / ORA-19502 / ORA-27030 Media Manager Errors

    —

    by

    DBA Corner
    in

    When RMAN reports RMAN-10035, ORA-19502, and ORA-27030 during an SBT backup, the useful diagnosis is usually in the final media-manager message. The Oracle stack says the backup write failed; the vendor text says why. Read the error stack from the bottom ORA-19511 means the linked media-management software returned a failure. Treat the vendor message, backup-server…

  • Trigger RMAN Archivelog Backups Based on Filesystem Usage

    —

    by

    DBA Corner
    in

    A rapidly growing archive destination can fill during bulk loads or data migrations. A usage-triggered RMAN job is a useful emergency backstop, but it should complement—not replace—scheduled archivelog backups, monitoring, and capacity planning. If you use the fast recovery area Measure the Oracle-managed recovery area from the database rather than parsing a filesystem command: V$RECOVERY_AREA_USAGE…

  • SQL Server: Safely Attach Multiple Databases

    —

    by

    DBA Corner
    in

    The old sp_attach_db procedure is deprecated. Modern SQL Server uses CREATE DATABASE … FOR ATTACH, and every data and log file must be accounted for. Prefer backup and restore For planned migrations, a tested full backup and restore is usually safer and easier to audit. Attach is appropriate when you have a cleanly detached, trusted…