Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Loss of system datafile in Database (User Managed Recovery)

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31

    Loss of system datafile in Database (User Managed Recovery)

    Given hot backup available...

    System tablespace got corrupted/lost somehow then....

    Recovery can only be done in mount mode as it is required to warm up the

    database.

    SQL> startup mount pfile=/u02/home/dbtest/initdbtest.ora
    ORACLE instance started.

    Restore the System datafile(s) from the backup
    SQL>!cp /u02/home/backups/weekly/dbtest/hot/system.dbf /u2/home/dbtest/

    Recoever the System Datafile
    SQL> ALTER DATABASE RECOVER datafile '/u02/home/dbtest/system.dbf' ;

    Database altered.

    SQL> alter database open ;

    Database altered.
    Last edited by Hemant; 11-01-2011 at 05:24 PM.

+ Reply to Thread

Similar Threads

  1. RECOVERY SCENARIO: Complete loss of all database files including SPFILE using RMAN
    By devesh_ocp in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 04-25-2012, 10:26 AM
  2. Difference / Advantages of Oracle RMAN over User Managed Backups
    By sukhman in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 02-10-2012, 03:01 PM
  3. Replies: 1
    Last Post: 01-01-2012, 03:50 PM
  4. Loss of Non-System datafile in a Database (User Managed Recovery)
    By ajaysingh in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 1
    Last Post: 11-01-2011, 03:35 PM
  5. Loss of all controlfiles of the Database (User Managed Recovery)
    By ajaysingh in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 11-01-2011, 11:41 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics