Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ora10g disaster recovery - the way

ora10g disaster recovery - the way

From: Dariusz Adamiak <dadamiak_at_wp.pl>
Date: Wed, 24 Aug 2005 14:26:44 +0200
Message-ID: <dehovm$n27$1@nemesis.news.tpi.pl>


Hi,
is there any simple way to recover database after disaster?

now i tested procedure /below/ , it seems is OK, but http://localhost:5500/em ... doesnt work...

procedure
1. Backup

rman>backup database plus archivelog
rman>restore database validate
rman>delete noprompt obsolete

so I have backup, control files with spfile i copy also pwd___.ora tnsnames.ora

2. Recovery
install oracle software (instance)
create listener
create directory structure
create oracle service (oradim -new ...)
copy pwd___.ora, tnsnames.ora
set oracle SID (in windows registry)

rman> set DBID
rman> restore SPFILE from backup file
rman>restore control files from backup file
rman> copy backup to flash_recovery_area
rman> restore database
rman>recover database
rman>alter database open resetlogs


Regards

Dariusz Received on Wed Aug 24 2005 - 07:26:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US