DR Server not started generating errors

[Former Member]

Dear All

i want to start dr server

but it generating error

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Oct 22 09:58:18 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1526726656 bytes

Fixed Size 2053752 bytes

Variable Size 771754376 bytes

Database Buffers 738197504 bytes

Redo Buffers 14721024 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> shutdown

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1526726656 bytes

Fixed Size 2053752 bytes

Variable Size 771754376 bytes

Database Buffers 738197504 bytes

Redo Buffers 14721024 bytes

Database mounted.

SQL> select OPEN_RESETLOGS from v$database;

OPEN_RESETL

-

---

REQUIRED

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: 'G:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL>

Please tell how can i resolve that issue........ i want to up DR Immediatly

regards

[Former Member]

Hi

execute the below commands in mount mode

SQL>recover database;

then

SQL> alter database open resetlogs;

Raj

[Former Member]

Hi Imran,

Recover the database completely and then try opening thedatabase with the option.

SQL> alter database open resetlogs;

Whether your backup is online or offline?

Regards

Ashok

[andreas_herzog]

try:

> recover database

if the file is still corrupt you'll have to go for a restore of (at least) the system.data1 and re-open the database (incl. a recover)

if everything went fine you should read "media recovery completed"

GreetZ, AH