database recovery.

• kubersk91

  Valued Member

  Points: 56

  More actions

  September 17, 2014 at 11:14 pm

  #293329

  you can recover database using RMAN

  tool.

  your database should in archieve mode.

  command;

  first open the database.

  after that make RMAN connnection.

  type

  RMAN>shutdown immediate

  RMAN>startup mount

  RMAN>backup database;

  RMAN>sql ?alter database open?;

  it is RMAN offline backup;

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 18, 2014 at 1:15 am

  #1746291

  And the question is?

  Moreover, this is a SQL Server forum: no Oracle experts here.

  -- Gianluca Sartori