Solved: Recover Database Probelm

Dear All

I take online whole database backup and when i restore

startup mount;

ORACLE instance started.

Total System Global Area 8925478912 bytes

Fixed Size 2085656 bytes

Variable Size 4445965544 bytes

Database Buffers 4462739456 bytes

Redo Buffers 14688256 bytes

Database mounted.

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: '/oracle/ARP/sapdata1/system_1/system.data1'

please say how i solved this problem

Nainesh

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hi Nainesh,

You should import offline redologs, first. Then, execute "alter database open resetlogs".

shutdown
startup mount
recover database using backup controlfile until cancel; <-- Apply offline redologs
alter database open resetlogs;
shutdown
startup
exit

Best regards,

Orkun Gedik

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear

SQL> shutdown

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 8925478912 bytes

Fixed Size 2085656 bytes

Variable Size 4445965544 bytes

Database Buffers 4462739456 bytes

Redo Buffers 14688256 bytes

Database mounted.

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 454358067 generated at 09/16/2011 12:05:32 needed for thread

ORA-00289: suggestion : /oracle/ARP/oraarch/ARParch1_26861_661604004.dbf

ORA-00280: change 454358067 for thread 1 is in sequence #26861

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

AUTO

ORA-00308: cannot open archived log

'/oracle/ARP/oraarch/ARParch1_26861_661604004.dbf'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

ORA-00308: cannot open archived log

'/oracle/ARP/oraarch/ARParch1_26861_661604004.dbf'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/ARP/sapdata1/system_1/system.data1'

SQL>

Now What i do pleas say me

Nainesh

hi Nainesh,

it seems like the file '/oracle/ARP/oraarch/ARParch1_26861_661604004.dbf' doesnt exists physically ,check the storage device is online, and the archived file is in the correct location. Then attempt to continue recovery or restart the recovery session

regards

George

Hello,

'ORA-00308: cannot open archived log

'/oracle/ARP/oraarch/ARParch1_26861_661604004.dbf'

Above said re-do log file should be available in oraarch directory, please confirm.

Thanks

dear

you are rite file is there now what i do

Nainesh

Dear

Sorry

A File ORA-00308: cannot open archived log '/oracle/ARP/oraarch/ARParch1_26861_661604004.dbf'

not there

ls -l

total 3221936

-rw-r----- 1 oraarp dba 44004352 Jul 09 13:47 ARParch1_25320_661604004.dbf

-rw-r----- 1 oraarp dba 43984896 Jul 09 14:57 ARParch1_25321_661604004.dbf

-rw-r----- 1 oraarp dba 43985920 Jul 09 16:00 ARParch1_25322_661604004.dbf

-rw-r----- 1 oraarp dba 44028416 Jul 09 17:28 ARParch1_25323_661604004.dbf

-rw-r----- 1 oraarp dba 43983872 Jul 09 19:06 ARParch1_25324_661604004.dbf

-rw-r----- 1 oraarp dba 43999232 Jul 09 21:28 ARParch1_25325_661604004.dbf

-rw-r----- 1 oraarp dba 43984896 Jul 09 23:58 ARParch1_25326_661604004.dbf

-rw-r----- 1 oraarp dba 43984896 Jul 10 01:40 ARParch1_25327_661604004.dbf

-rw-r----- 1 oraarp dba 43984896 Jul 10 03:05 ARParch1_25328_661604004.dbf

-rw-r----- 1 oraarp dba 43985408 Jul 10 04:27 ARParch1_25329_661604004.dbf

-rw-r----- 1 oraarp dba 43987456 Jul 10 06:30 ARParch1_25330_661604004.dbf

-rw-r----- 1 oraarp dba 43985408 Jul 10 08:28 ARParch1_25331_661604004.dbf

-rw-r----- 1 oraarp dba 43984384 Jul 10 11:05 ARParch1_25332_661604004.dbf

-rw-r----- 1 oraarp dba 43990528 Jul 10 12:27 ARParch1_25333_661604004.dbf

-rw-r----- 1 oraarp dba 43992576 Jul 10 13:30 ARParch1_25334_661604004.dbf

-rw-r----- 1 oraarp dba 46614016 Jul 10 13:30 ARParch1_25335_661604004.dbf

-rw-r----- 1 oraarp dba 43987456 Jul 10 13:57 ARParch1_25336_661604004.dbf

-rw-r----- 1 oraarp dba 12261376 Jul 10 14:51 ARParch1_25337_661604004.dbf

-rw-r----- 1 oraarp dba 43984896 Aug 21 18:28 ARParch1_25338_661604004.dbf

-rw-r----- 1 oraarp dba 43984896 Aug 29 16:08 ARParch1_25339_661604004.dbf

-rw-r----- 1 oraarp dba 43984896 Aug 29 16:08 ARParch1_25340_661604004.dbf

-rw-r----- 1 oraarp dba 44086272 Aug 30 02:02 ARParch1_25341_661604004.dbf

-rw-r----- 1 oraarp dba 44775936 Aug 31 18:30 ARParch1_25342_661604004.dbf

-rw-r----- 1 oraarp dba 43998720 Sep 03 08:30 ARParch1_25343_661604004.dbf

-rw-r----- 1 oraarp dba 12445696 Sep 03 10:47 ARParch1_25344_661604004.dbf

-rw-r----- 1 oraarp dba 44787712 Sep 08 12:06 ARParch1_26658_661604004.dbf

-rw-r----- 1 oraarp dba 43992064 Sep 08 13:57 ARParch1_26659_661604004.dbf

-rw-r----- 1 oraarp dba 43995648 Sep 08 17:27 ARParch1_26660_661604004.dbf

-rw-r----- 1 oraarp dba 43984896 Sep 08 19:11 ARParch1_26661_661604004.dbf

-rw-r----- 1 oraarp dba 43986944 Sep 08 22:27 ARParch1_26662_661604004.dbf

-rw-r----- 1 oraarp dba 44363776 Sep 09 00:31 ARParch1_26663_661604004.dbf

-rw-r----- 1 oraarp dba 43984896 Sep 09 01:57 ARParch1_26664_661604004.dbf

-rw-r----- 1 oraarp dba 43982336 Sep 09 04:06 ARParch1_26665_661604004.dbf

-rw-r----- 1 oraarp dba 43982336 Sep 09 05:06 ARParch1_26666_661604004.dbf

-rw-r----- 1 oraarp dba 44013568 Sep 09 07:27 ARParch1_26667_661604004.dbf

-rw-r----- 1 oraarp dba 36779520 Sep 09 10:23 ARParch1_26668_661604004.dbf

-rw-r----- 1 oraarp dba 2660352 Sep 09 11:42 ARParch1_26669_661604004.dbf

-rw-r----- 1 oraarp dba 29682176 Sep 09 12:04 ARParch1_26670_661604004.dbf

-rw-r----- 1 oraarp dba 333312 Sep 09 12:20 ARParch1_26671_661604004.dbf

-rw-r----- 1 oraarp dba 250368 Sep 09 12:42 ARParch1_26672_661604004.dbf

-rw-r----- 1 oraarp dba 29113344 Sep 09 13:08 ARParch1_26673_661604004.dbf

-rw-r----- 1 oraarp dba 471552 Sep 09 14:17 ARParch1_26674_661604004.dbf

-rw-r----- 1 oraarp dba 43991552 Sep 09 16:27 ARParch1_26675_661604004.dbf

-rw-r----- 1 oraarp dba 3826176 Sep 09 16:47 ARParch1_26676_661604004.dbf

-rw-r----- 1 oraarp dba 21273600 Sep 18 10:35 ARParch1_26770_661604004.dbf

drwxr-xr-x 2 root system 256 Aug 21 14:46 lost+found

sapbkpail:oraarp 8> pwd

/oracle/ARP/oraarch

Nainesh

Hi Nainesh,

In that case we will have to 'restore/copy' these re-do log files from the backup disk/location. I am not sure whether you take the backup on disk/tape or on TSM, you will have to transfer/restore the redo log files required from that backup media to the orarch location.

Thanks

Dear

i take daily whole database online backup treu db13

A file /oracle/ARP/oraarch/ARParch1_26861_661604004.dbf' not on tape and also no on my original production server

so now how can we start our database can we start serve

Nainesh

hi Nainesh,

after issuing the restore command ,can you please key 'enter' instead of typing auto,

untill you get a message recovery completed

BRs

George

Dear

As your instruction i do

SQL> startup mount;

ORACLE instance started.

Total System Global Area 8925478912 bytes

Fixed Size 2085656 bytes

Variable Size 4445965544 bytes

Database Buffers 4462739456 bytes

Redo Buffers 14688256 bytes

Database mounted.

SQL> ecover database using backup controlfile until cancel;

SP2-0734: unknown command beginning "ecover dat..." - rest of line ignored.

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 454358067 generated at 09/16/2011 12:05:32 needed for thread

ORA-00289: suggestion : /oracle/ARP/oraarch/ARParch1_26861_661604004.dbf

ORA-00280: change 454358067 for thread 1 is in sequence #26861

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log

'/oracle/ARP/oraarch/ARParch1_26861_661604004.dbf'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/ARP/sapdata1/system_1/system.data1'

SQL>

Nainesh

Hi Nainesh,

>> ORA-00308: cannot open archived log

>> '/oracle/ARP/oraarch/ARParch1_26861_661604004.dbf'

How do you expect to apply non-exist offline redolog file??

Open the online backup logfile (????.anf). Then, find the "Oldest online log sequence" string and take note the corresponding value, let's say <xyz>. It will be last offline redolog number, in order to open the database, consistently. Copy/restore offline redolog files between "ARParch1_26861_661604004.dbf" and "ARParch1_<xyz>_661604004.dbf" and into "oraarch" folder. Then, apply one by one.

I hope that it is clear...

Best regards,

Orkun Gedik

Dear

As your instruction i found

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/ARP/oraarch/ARParch

Archive format %t_%s_%r.dbf

Oldest online log sequence 26861

Next log sequence to archive 26864

Current log sequence 26864 SCN: 454378394

Database block size 8192 Thread: 1

Current system change number 454378396 ResetId: 661604004

BR0056I End of database backup: begudqtb.ant 2011-09-16 12.55.07

BR0280I BRBACKUP time stamp: 2011-09-16 12.55.07

BR0052I BRBACKUP completed successfully

please guide me

Nainesh

Hi,

Then, apply the following sequence

ARParch1_26861_661604004.dbf

And execute "alter database open resetlogs;"

Best regards,

Orkun Gedik

Thanks

Dear Orkun,

i am also facing same problem ,please help me i am new to SAP and facing this issue ,

given below details of my sapbackup latest log.

i am getting the below error when i use old aracch file in "RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL"

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 287296315 generated at 08/15/2012 16:50:19 needed for thread

ORA-00289: suggestion : /oracle/JP1/oraarch/JP1arch1_9911.dbf

ORA-00280: change 287296315 for thread 1 is in sequence #9911

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

suggestion /oracle/JP1/oraarch/JP1arch_9901.dbf;

ORA-00308: cannot open archived log 'suggestion'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

suggestion /oracle/JP1/oraarch/JP1arch_9898.dbf;

ORA-00308: cannot open archived log 'suggestion'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00308: cannot open archived log '/oracle/JP1/oraarch/JP1arch1_9911.dbf'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

ORA-00308: cannot open archived log '/oracle/JP1/oraarch/JP1arch1_9911.dbf'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/JP1/sapdata1/system_1/system.data1'

SQL>

This is my sapbackup log

BR0051I BRBACKUP 6.40 (15)

BR0055I Start of database backup: bejeojhs.and 2012-08-11 12.02.20

BR0477I Oracle pfile /oracle/JP1/920_64/dbs/initJP1.ora created from spfile /oracle/JP1/920_64/dbs/spfileJP1.ora

BR0319I Control file copy created: /oracle/JP1/sapbackup/cntrlJP1.dbf 6791168

BR0101I Parameters

Name Value

oracle_sid JP1

oracle_home /oracle/JP1/920_64

oracle_profile /oracle/JP1/920_64/dbs/initJP1.ora

sapdata_home /oracle/JP1

sap_profile /oracle/JP1/920_64/dbs/initJP1.sap

backup_mode ALL

backup_type online

backup_dev_type disk

backup_root_dir /oracle/JP1/sapbackup

compress no

disk_copy_cmd copy

cpio_disk_flags -pdcu

exec_parallel 0

system_info orajp1/orajp1 jprod SunOS 5.10 Generic_118822-30 sun4u

oracle_info JP1 9.2.0.7.0 8192 9901 286912656

sap_info 640 SAPJP1 JP1 L0742807518 R3_ORA 0020233464

make_info sun_64 OCI_920 Oct 9 2004

command_line /usr/sap/JP1/SYS/exe/run/brbackup -p initJP1.sap -d disk -t online -m all -k no -e 0 -l E -U

BR0116I ARCHIVE LOG LIST before backup for database instance JP1

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/JP1/oraarch/JP1arch

Archive format %t_%s.dbf

Oldest online log sequence 9898

Next log sequence to archive 9901

Current log sequence 9901 SCN: 286912656

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata3/jp1_1/jp1.data1 5578432512 3 5570633 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata3/jp1_2/jp1.data2 5221916672 4 5570633 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata3/jp1_3/jp1.data3 4928315392 5 5570633 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata3/jp1_4/jp1.data4 4739571712 6 5570633 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1_6/jp1.data6 2642419712 8 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1_8/jp1.data8 2495619072 10 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1_10/jp1.data10 2432704512 12 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1_9/jp1.data9 2474647552 11 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1_7/jp1.data7 2600476672 9 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1_14/jp1.data14 5955919872 32 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1_13/jp1.data13 5683290112 30 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1_12/jp1.data12 5599404032 29 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1_11/jp1.data11 5662318592 27 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1 ONLINE* ONLINE+ /oracle/JP1/sapdata3/jp1_5/jp1.data5 4424998912 7 5570633 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata1/jp1640_1/jp1640.data1 2097160192 13 5570631 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata1/jp1640_2/jp1640.data2 2097160192 14 5570631 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata1/jp1640_4/jp1640.data4 2097160192 16 5570631 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata2/jp1640_6/jp1640.data6 2097160192 18 5570632 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata2/jp1640_8/jp1640.data8 2097160192 20 5570632 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata2/jp1640_10/jp1640.data10 2097160192 22 5570632 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1640_12/jp1640.data12 2097160192 24 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE /oracle/JP1/sapdata4/jp1640_16/jp1640.data16 5368717312 33 5570634 NOLINK FILE 0 0

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1640_15/jp1640.data15 5368717312 31 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1640_14/jp1640.data14 5368717312 28 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1640_13/jp1640.data13 2097160192 25 5570634 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata3/jp1640_11/jp1640.data11 2097160192 23 5570633 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata2/jp1640_9/jp1640.data9 2097160192 21 5570632 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata2/jp1640_7/jp1640.data7 2097160192 19 5570632 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata1/jp1640_5/jp1640.data5 2097160192 17 5570631 NOLINK FILE 10485760000 20971520

PSAPJP1640 ONLINE* ONLINE+ /oracle/JP1/sapdata1/jp1640_3/jp1640.data3 2097160192 15 5570631 NOLINK FILE 10485760000 20971520

PSAPJP1USR ONLINE* ONLINE+ /oracle/JP1/sapdata4/jp1usr_1/jp1usr.data1 20979712 26 5570634 NOLINK FILE 10485760000 20971520

PSAPTEMP ONLINE# ONLINE+ /oracle/JP1/sapdata1/temp_1/temp.data1 1268785152 -1 5570631 NOLINK FILE 10485760000 20971520

PSAPUNDO ONLINE- ONLINE+ /oracle/JP1/sapdata1/undo_1/undo.data1 7277125632 2 5570631 NOLINK FILE 10485760000 20971520

SYSTEM ONLINE* SYSTEM+ /oracle/JP1/sapdata1/system_1/system.data1 2147491840 1 5570631 NOLINK FILE 10485760000 20971520

BR0119I Redo log files

File Size Group Device Status Link Type

/oracle/JP1/origlogA/log_g11m1.dbf 104858112 1 5570627 INUSE NOLINK FILE

/oracle/JP1/mirrlogA/log_g11m2.dbf 104858112 1 5570629 INUSE NOLINK FILE

/oracle/JP1/origlogB/log_g12m1.dbf 104858112 2 5570626 INUSE NOLINK FILE

/oracle/JP1/mirrlogB/log_g12m2.dbf 104858112 2 5570628 INUSE NOLINK FILE

/oracle/JP1/origlogA/log_g13m1.dbf 104858112 3 5570627 INUSE NOLINK FILE

/oracle/JP1/mirrlogA/log_g13m2.dbf 104858112 3 5570629 INUSE NOLINK FILE

/oracle/JP1/origlogB/log_g14m1.dbf 104858112 4 5570626 INUSE NOLINK FILE

/oracle/JP1/mirrlogB/log_g14m2.dbf 104858112 4 5570628 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

/oracle/JP1/origlogA/cntrl/cntrlJP1.dbf 6791168 0 5570627 NOLINK FILE

/oracle/JP1/sapdata1/system_1/cntrl/cntrlJP1.dbf 6791168 0 5570631 NOLINK FILE

/oracle/JP1/saparch/cntrl/cntrlJP1.dbf 6791168 0 5570630 NOLINK FILE

BR0227E Not enough disk space in /oracle/JP1/sapbackup for backup, missing at least 103038.004 MB

BR0056I End of database backup: bejeojhs.and 2012-08-11 12.02.22

BR0280I BRBACKUP time stamp: 2012-08-11 12.02.22

BR0054I BRBACKUP terminated with errors

Regards

Aymaan Mohammed

Hi Aymaan,

As you can seen in the log output, the system is not able to access offline redolog files. Be sure that the files (/oracle/JP1/oraarch/JP1arch_xxxx.dbf) are accessible by "ora<sid>" user.

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 287296315 generated at 08/15/2012 16:50:19 needed for thread 1

ORA-00289: suggestion : /oracle/JP1/oraarch/JP1arch1_9911.dbf

ORA-00280: change 287296315 for thread 1 is in sequence #9911

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

suggestion /oracle/JP1/oraarch/JP1arch_9901.dbf;

ORA-00308: cannot open archived log 'suggestion'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

suggestion /oracle/JP1/oraarch/JP1arch_9898.dbf;

ORA-00308: cannot open archived log 'suggestion'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00308: cannot open archived log '/oracle/JP1/oraarch/JP1arch1_9911.dbf'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

ORA-00308: cannot open archived log '/oracle/JP1/oraarch/JP1arch1_9911.dbf'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

Check the quota that I noted previously, below;

Best regards,

Orkun Gedik

Dear Sir,

Thanks for your reply , i have 11th august oraarch backup i copied back to /oracle/JP1/oraarch/ .

oldest is oraarchJP1_9898.dbf to oraarchJP1_9910 , with group dba and user orajp1 permission ,

but still it and ran command " sql> recover database using controlfile until cancel "

I got this error,

SQL> connect /as sysdba

Connected.

SQL> recover database using backup controlfile until cancel;

ORA-00283: recovery session canceled due to errors

ORA-01124: cannot recover data file 1 - file is in use or recovery

ORA-01110: data file 1: '/oracle/JP1/sapdata1/system_1/system.data1'

Please help me out , this is effecting to our buisness,

Regards

Aymaan

>> oraarchJP1_9898.dbf to oraarchJP1_9910

But, the system requires "JP1arch_xxxx.dbf". Could you execute the statement, below and paste the result here?

SQL> show parameter log_archive_dest;

Then, go to "/oracle/<DBSID>/oraarch" at the OS level and type "ls -ltr" and paste the result here

SQL> show parameter log_archive_dest;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest string /oracle/JP1/oraarch/JP1arch

log_archive_dest_1 string

log_archive_dest_10 string

log_archive_dest_2 string

log_archive_dest_3 string

log_archive_dest_4 string

log_archive_dest_5 string

log_archive_dest_6 string

log_archive_dest_7 string

log_archive_dest_8 string

log_archive_dest_9 string

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_state_1 string enable

log_archive_dest_state_10 string enable

log_archive_dest_state_2 string enable

log_archive_dest_state_3 string enable

log_archive_dest_state_4 string enable

log_archive_dest_state_5 string enable

log_archive_dest_state_6 string enable

log_archive_dest_state_7 string enable

log_archive_dest_state_8 string enable

log_archive_dest_state_9 string enable

SQL>

root@jprod # cd oracle

root@jprod # cd JP1

root@jprod # cd oraarch

root@jprod # ls -ltr

total 2472432

-rwxrwxrwx 1 orajp1 dba 104853504 Aug 15 11:39 JP1arch1_9909.dbf

-rwxrwxrwx 1 orajp1 dba 104778240 Aug 15 16:50 JP1arch1_9910.dbf

-rwxrwxrwx 1 orajp1 dba 66257920 Aug 22 15:41 JP1arch1_9898.dbf

-rwxrwxrwx 1 orajp1 dba 104857088 Aug 22 15:41 JP1arch1_9899.dbf

-rwxrwxrwx 1 orajp1 dba 104857088 Aug 22 15:41 JP1arch1_9900.dbf

-rwxrwxrwx 1 orajp1 dba 104856064 Aug 22 15:41 JP1arch1_9901.dbf

-rwxrwxrwx 1 orajp1 dba 45460480 Aug 22 15:41 JP1arch1_9903.dbf

-rwxrwxrwx 1 orajp1 dba 104855040 Aug 22 15:41 JP1arch1_9902.dbf

-rwxrwxrwx 1 orajp1 dba 104854016 Aug 22 15:41 JP1arch1_9904.dbf

-rwxrwxrwx 1 orajp1 dba 104857088 Aug 22 15:41 JP1arch1_9905.dbf

-rwxrwxrwx 1 orajp1 dba 104849920 Aug 22 15:42 JP1arch1_9906.dbf

-rwxrwxrwx 1 orajp1 dba 104855552 Aug 22 15:42 JP1arch1_9907.dbf

-rwxrwxrwx 1 orajp1 dba 104856064 Aug 22 15:42 JP1arch1_9908.dbf

I assume that you created new control files or copied to the locations coming with backup. So, execute the statements in the sequence, below and paste result;

SQL> shutdown

SQL> startup mount

SQL> recover database using backup controlfile until cancel;

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 7535046480 bytes
Fixed Size                   741200 bytes
Variable Size            3808428032 bytes
Database Buffers         3724541952 bytes
Redo Buffers                1335296 bytes
Database mounted.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 287296315 generated at 08/15/2012 16:50:19 needed for thread
1
ORA-00289: suggestion : /oracle/JP1/oraarch/JP1arch1_9911.dbf
ORA-00280: change 287296315 for thread 1 is in sequence #9911

JP1arch1_9911.dbf this log is physically not available in oraarch dir

Hi ,

Details of my .and file of last backup .in that oldest is 9898.dbf