skip to main | skip to sidebar

ORACLE DBA-APPS DBA

THIS SITE IS TOTALLY DEDICATED TO ALL ORACLE DBA AND APPS DBA LOVERS.I WILL TRY TO COVER ALL MY EXPERIENCES AS AN ORACLE DBA.

Monday, June 2, 2008

Remove the TARGDB Database

In this section, I want to remove the TARGDB database to simulate and setup a disaster recovery situation. If the instance is still running, it will need to be shutdown:
% rm /u03/app/oradata/TARGDB/*
% rm /u04/app/oradata/TARGDB/*
% rm /u05/app/oradata/TARGDB/*
% rm /u06/app/oradata/TARGDB/*

% sqlplus "/ as sysdba"

SQL> shutdown abort

SQL> exit
Posted by PDPSHETTY at 5:36 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

E-malls

Banner

Get Chitika eMiniMalls

USEFUL WEBSITES

  • Useful
  • Schan
  • Apps11i
  • Apps12i
  • APPS DBA
  • Good one
  • Oracle Magic
  • Richard Foote
  • Nice one(Jaffar)
  • Jonathan Lewis
  • TOM KYTE
  • ASK TOM
  • OTN
  • GOOGLE
  • METALINK
  • FIREFOX

About Me

My photo
PDPSHETTY
View my complete profile

Search

VISION

Blog Archive

  • ▼  2008 (108)
    • ▼  June (108)
      • USEFUL METALINK DOCS FOR APPS DBA
      • Scheduling backup using Crontab in Linux
      • Oracle Database Architecture: 9i-Part1
      • Oracle Database Architecture: -Part2
      • Oracle Database Architecture:Part3
      • Oracle Database Architecture: Part4
      • Oracle Database Architecture: Part5
      • Oracle Apps Patching - Part 1
      • Oracle Apps Patching - Part 2
      • Oracle Apps Patching - Part 3
      • Oracle Apps Patching - Part 4
      • Mining Information from the Listener Log -Part1
      • Mining Information from the Listener Log -Part2
      • Mining Information from the Listener Log -Part3
      • Oracle Trace Utility (10g)
      • Implementing Data Guard
      • DBMS_PROFILER
      • Manual Db Creation
      • Manual Db Creation 11g
      • Memory Management with 11G
      • Invisible Index with 11G
      • Read Only Table with 11G
      • Oracle Flashback Table
      • Oracle Flashback Technology
      • Oracle Flashback Data Archive (Oracle Total Recall...
      • Oracle Database Block corruption
      • To Find Client IP Address From Server.
      • How to Recover Dropped Tablespace
      • Oracle 11g Password CaSe SEnsiTivE
      • "SYS" USER
      • Network DBA
      • Backup DBA
      • Oracle Streams Setup between two database
      • Improve performance with Oracle Streams
      • Oracle Streams: Adding new site in existing enviro...
      • Oracle Streams Setup between two database
      • Connecting with sys user with Or without pwd
      • Critical Patch Update
      • Database & Patch set Upgrade
      • How to Drop Datafile from tablespace
      • During Import table created in wrong tablespace.
      • Redo Log File Status
      • Recovery Catalog
      • Relocate Database Files
      • OS Authentication
      • Data file fragmentation and Data file resize
      • Index Fragmentation / Rebuild
      • Master Replication
      • Materialized view for Data Warehouse
      • Oracle Latch
      • System Statistics
      • Active Session History (ASH)
      • AWR Report/Snapshot
      • Interpreting Your Statspack Report
      • EXECUTION PLAN
      • Autotrace in SQLPLUS
      • Making User-Managed Backups
      • Making User-Managed Backups of Online/Offline Tabl...
      • Querying V$ Views to Obtain Backup Information
      • Sending-email-from-an-Oracle-10g-Server
      • ORA-19809: limit exceeded for recovery files
      • Control file Backup Option
      • All redolog group lost
      • Cold Backup with RMAN
      • Datafile Recovery
      • How to Enable ARCHIVELOG mode
      • Dropping a Database
      • Renaming Tablespaces
      • Multiple Temporary Tablespaces: Using Tablespace G...
      • remote_login_passwordfile
      • Clone DB on New Host with HotBkp
      • Copy Table From OneDB to AnotherDB
      • Duplicating a Database with RMAN
      • Change User/Schema Name.
      • Logical_bkp_EXPORT_linux
      • RMAN-06054: media recovery requesting unknown log:...
      • Flashback Oracle10gR1 10.1.0.2.0
      • dbms_logmnr package
      • expdp Export Datapump.
      • utl_file plsql package.
      • Tablespace Size
      • History of Oracle Technology Introductions
      • DBA Interview Questions
      • Migrating Databases From NON-ASM to ASM
      • Managing Diskgroups
      • ASM Instance Creation
      • Preparing disk for ASM instance
      • ASM - Introduction
      • Identifying Which Oracle Indexes to Rebuild
      • Oracle Capacity Planner
      • dbms_xplan in 10g
      • Script to Generate Statspack report for a day
      • RDBMS
      • Oracle DBA Checklist
      • Oracle's V$ Views
      • Oracle Histograms
      • Enabling Faster Incremental Backups in Oracle 10g
      • Understanding Asynchronous COMMIT
      • Setting Listener Password
      • CHANGING DATABASE CHARACTER SET