Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ora10g disaster recovery - the way
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
![]() |
![]() |