Check if any there are any active DB backup tasks running:
[root@ProdDB01 ~]# su – oracle
-bash-3.1$ sqlplus ‘/ as sysdba’
SQL*Plus: Release 8.1.6.0.0 – Production on Thu Mar 20 12:44:12 2014
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production
With the Partitioning option
JServer Release 8.1.6.0.0 – Production
SQL> SELECT COUNT(*) FROM v$backup WHERE status =’ACTIVE’;
COUNT(*)
———-
0
SQL>
Attempt to Recover the reported file:
SQL> recover datafile ‘/opt/dbfiles/oradata/inst3/system01inst3.dbf’
ORA-00279: change 339928152 generated at 03/20/2014 09:57:48 needed for thread
1
ORA-00289: suggestion : /opt/dbfiles/inst3/archive/1_2253810.dbf
ORA-00280: change 339928152 for thread 1 is in sequence #2253810
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log ‘/opt/dbfiles/inst3/archive/1_2253810.dbf’
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL>
[root@ProdDB01 ~]# tail -25 /opt/dbfiles/inst3/bdump/alert_inst3.log
Thu Mar 20 14:50:17 2014
ALTER DATABASE RECOVER datafile ‘/opt/dbfiles/oradata/inst3/system01inst3.dbf’
Media Recovery Datafile: ‘/opt/dbfiles/oradata/inst3/system01inst3.dbf’
Media Recovery Start
WARNING! Recovering data file 1 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER datafile ‘/opt/dbfiles/oradat…
Thu Mar 20 14:58:43 2014
ALTER DATABASE RECOVER LOGFILE ‘/opt/dbfiles/inst3/archive/1_2253810.dbf’
Thu Mar 20 14:58:43 2014
Media Recovery Log /opt/dbfiles/inst3/archive/1_2253810.dbf
ORA-308 signalled during: ALTER DATABASE RECOVER LOGFILE ‘/opt/dbfiles/inst3/a…
Thu Mar 20 14:58:43 2014
ALTER DATABASE RECOVER CANCEL
Media Recovery Cancelled
Completed: ALTER DATABASE RECOVER CANCEL
[root@ProdDB01 ~]#
When you specify the existing online Redo Log files, it reports below message:
SQL> recover datafile ‘/opt/dbfiles/oradata/inst3/system01inst3.dbf’
ORA-00279: change 339928152 generated at 03/20/2014 09:57:48 needed for thread
1
ORA-00289: suggestion : /opt/dbfiles/inst3/archive/1_2253810.dbf
ORA-00280: change 339928152 for thread 1 is in sequence #2253810
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/opt/dbfiles/oradata/inst3/log01inst3.dbf
ORA-00310: archived log contains sequence 2253817; sequence 2253810 required
ORA-00334: archived log: ‘/opt/dbfiles/oradata/inst3/log01inst3.dbf’
SQL>
Find the Sequence numbers of Oracle DBF redo log files:
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
———- ———- ———- ———- ———- — —————-
FIRST_CHANGE# FIRST_TIM
————- ———
1 1 2253817 1048576 1 NO ACTIVE
339933743 20-MAR-14
2 1 2253818 1048576 1 NO ACTIVE
339933759 20-MAR-14
3 1 2253820 1048576 1 NO ACTIVE
339933806 20-MAR-14
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
———- ———- ———- ———- ———- — —————-
FIRST_CHANGE# FIRST_TIM
————- ———
4 1 2253819 4194304 1 NO ACTIVE
339933772 20-MAR-14
5 1 2253821 4194304 1 NO ACTIVE
339933816 20-MAR-14
6 1 2253822 4194304 1 NO ACTIVE
339933851 20-MAR-14
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
———- ———- ———- ———- ———- — —————-
FIRST_CHANGE# FIRST_TIM
————- ———
7 1 2253823 4194304 1 NO CURRENT
339933892 20-MAR-14
7 rows selected.
SQL>
In case of successful recovery of media files, you’ll see below outputs:
SQL> STARTUP PFILE=/opt/oracle/product/8.1.7/dbs/initins03.ora
ORACLE instance started.
Total System Global Area 87859360 bytes
Fixed Size 73888 bytes
Variable Size 56893440 bytes
Database Buffers 30720000 bytes
Redo Buffers 172032 bytes
Database mounted.
ORA-01113: file 9 needs media recovery
ORA-01110: data file 9: ‘/opt/dbfiles/oradata/ins03/gapp02ins03.dbf’
SQL>
SQL> recover datafile ‘/opt/dbfiles/oradata/ins03/gapp02ins03.dbf’
Media recovery complete.
SQL>
SQL> STARTUP PFILE=/opt/oracle/product/8.1.7/dbs/initins03.ora
ORACLE instance started.
Total System Global Area 87859360 bytes
Fixed Size  
; 73888 bytes
Variable Size 56893440 bytes
Database Buffers 30720000 bytes
Redo Buffers 172032 bytes
Database mounted.
Database opened.
SQL>
Logs:
Starting ORACLE instance (normal)
Fri Apr 11 07:55:51 2014
WARNING: EINVAL creating segment of size 0x000000000549f000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.4.0.
System parameters with non-default values:
processes = 800
shared_pool_size = 25000000
control_files = /opt/dbfiles/oradata/ins03/ctrl1ins03.ctl, /opt/dbfiles/oradata/ins03/ctrl2ins03.ctl, /opt/dbfiles/oradata/ins03/ctrl3ins03.ctl
db_block_buffers = 15000
compatible = 8.0.0
log_archive_dest = /opt/dbfiles/ins03/archive
log_buffer = 163840
log_checkpoint_interval = 10000
db_files = 20
db_file_multiblock_read_count= 8
dml_locks = 200
rollback_segments = r01, r02, r03, r04, r05, r06
remote_login_passwordfile= SHARED
db_domain =
sort_area_size = 2097152
db_name = ins03
ifile = /opt/dbfiles/admin/ins03/pfile/configins03.ora
optimizer_mode = choose
job_queue_processes = 0
background_dump_dest = /opt/dbfiles/ins03/bdump
user_dump_dest = /opt/dbfiles/ins03/udump
max_dump_file_size = 10240
core_dump_dest = /opt/dbfiles/ins03/cdump
aq_tm_processes = 0
PMON started with pid=2
Load Indicator not supported by OS !
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Fri Apr 11 07:55:52 2014
ALTER DATABASE MOUNT
Fri Apr 11 07:55:56 2014
Successful mount of redo thread 1, with mount id 2583406156.
Fri Apr 11 07:55:56 2014
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Apr 11 07:55:56 2014
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Fri Apr 11 07:55:56 2014
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 11364 Reading mem 0
Mem# 0 errs 0: /opt/dbfiles/oradata/ins03/log03ins03.dbf
Recovery of Online Redo Log: Thread 1 Group 1 Seq 11365 Reading mem 0
Mem# 0 errs 0: /opt/dbfiles/oradata/ins03/log01ins03.dbf
Fri Apr 11 07:56:01 2014
Thread recovery: finish rolling forward thread 1
Thread recovery: 506 data blocks read, 348 data blocks written, 2731 redo blocks read
Crash recovery completed successfully
Fri Apr 11 07:56:01 2014
Thread 1 advanced to log sequence 11366
Thread 1 opened at log sequence 11366
Current log# 2 seq# 11366 mem# 0: /opt/dbfiles/oradata/ins03/log02ins03.dbf
Successful open of redo thread 1.
Fri Apr 11 07:56:01 2014
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Apr 11 07:56:02 2014
Updating 8.1.6.1.0 NLS parameters in sys.props$
— adding 8.1.7.4.0 NLS parameters.
Completed: ALTER DATABASE OPEN
