Skip to Content
0
Former Member
Apr 18, 2009 at 11:49 AM

Error after Restoring Datafiles in Archivelog but missing archive log files

4213 Views

Hi all,

I have taken backup yesterday monrning in Archive log mode but have lost all the archive log files. Yesterday night i have restored my DB .

I m happy to have my datafile contents till yesterday morning.

But after restoring when i try to open th DB, i m facing the following errors:

SQL> Startup open;

Oracle instance started but in mounted stagell

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

SQL> alter database open resetlogs;

Error: ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: 'E:\oracle\'<SID>\sapdata1\SYSTEM_1\SYSTEM.DATA1'

SQL> recover database using backup controlfile until cancel;

ORA-00279 : change 26627919 generated at DATE TIMEneeded for thread 1

ORA-00289 : Suggestion E:\ORACLE\<SID>\ORAARCH\<SID>ARCHARC03020_0683715008.001

ORA-00280: change 266277189 for thread 1 is in sequence #3020

ORA - 01112: media recovery not started

SQL> recover;

ORA-00283: recovery session cancelled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Alert Log File:

Starting up ORACLE RDBMS Version: 10.2.0.2.0.

System parameters with non-default values:

processes = 80

sessions = 96

event = 10191 trace name context forever, level 1

sga_max_size = 633339904

shared_pool_size = 301989888

shared_pool_reserved_size= 30183260

filesystemio_options = setall

control_files = E:\ORACLE\IE6\ORIGLOGA\CNTRL\CNTRLIE6.DBF, E:\ORACLE\IE6\ORIGLOGB\CNTRL\CNTRLIE6.DBF, E:\ORACLE\IE6\SAPDATA1\CNTRL\CNTRLIE6.DBF

control_file_record_keep_time= 30

db_block_size = 8192

db_cache_size = 301989888

compatible = 10.2.0

log_archive_dest = E:\oracle\IE6\oraarch\IE6arch

log_buffer = 2854912

log_checkpoint_interval = 0

db_files = 254

log_checkpoints_to_alert = TRUE

dml_locks = 4000

undo_management = AUTO

undo_tablespace = PSAPUNDO

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

remote_login_passwordfile= EXCLUSIVE

job_queue_processes = 1

background_dump_dest = E:\ORACLE\IE6\SAPTRACE\BACKGROUND

user_dump_dest = E:\ORACLE\IE6\SAPTRACE\USERTRACE

core_dump_dest = E:\ORACLE\IE6\SAPTRACE\BACKGROUND

optimizer_features_enable= 10.2.0.1

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = IE6

open_cursors = 800

optimpeek_user_binds = FALSE

pga_aggregate_target = 402443468

workarea_size_policy = AUTO

statistics_level = typical

PMON started with pid=2, OS id=804

PSP0 started with pid=3, OS id=9580

MMAN started with pid=4, OS id=5840

DBW0 started with pid=5, OS id=8136

LGWR started with pid=6, OS id=8712

CKPT started with pid=7, OS id=1620

SMON started with pid=8, OS id=7084

RECO started with pid=9, OS id=9576

CJQ0 started with pid=10, OS id=9156

MMON started with pid=11, OS id=6000

MMNL started with pid=12, OS id=2856

Sat Apr 18 04:01:29 2009

ALTER DATABASE MOUNT

Sat Apr 18 04:01:33 2009

Setting recovery target incarnation to 1

Sat Apr 18 04:01:33 2009

Successful mount of redo thread 1, with mount id 1124466585

Sat Apr 18 04:01:33 2009

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Sat Apr 18 04:01:34 2009

ALTER DATABASE OPEN

ORA-1589 signalled during: ALTER DATABASE OPEN...

Sat Apr 18 04:02:13 2009

alter database open resetlogs

Sat Apr 18 04:02:13 2009

ORA-1245 signalled during: alter database open resetlogs...

Sat Apr 18 04:11:05 2009

ALTER DATABASE RECOVER DATABASE UNTIL CANCEL

Sat Apr 18 04:11:05 2009

Media Recovery Start

Sat Apr 18 04:11:06 2009

Media Recovery failed with error 1610

ORA-283 signalled during: ALTER DATABASE RECOVER DATABASE UNTIL CANCEL...

Sat Apr 18 04:11:28 2009

ALTER DATABASE RECOVER DATABASE USING BACKUP CONTROLFILE

Sat Apr 18 04:11:28 2009

Media Recovery Start

parallel recovery started with 3 processes

ORA-279 signalled during: ALTER DATABASE RECOVER DATABASE USING BACKUP CONTROLFILE...

Sat Apr 18 04:17:23 2009

ALTER DATABASE RECOVER database using backup controlfile until cancel

Sat Apr 18 04:17:23 2009

Media Recovery Start

ORA-275 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...

Any suggestions pls..............

Thanks & Regards,

Subbu