Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SVR4 Error:

Ibrahim MalekMay 9 2016 — edited May 11 2016

Dear friends

there was an ISO audit so i did the drill & started up all the standby databases for them

i've used RMAN Hot backup to recreated those standby databases but i'm receiving this error on all the standby servers  & the redo logs doesn't exists !!???

please advice what i can do with this?

VR4 Error: 2: No such file or directory

Additional information: 3

Clearing online redo logfile 1 /oracle/prod/d01/db/apps_st/data/log01a.dbf

Clearing online log 1 of thread 1 sequence number 4246

Mon May  9 09:22:52 2016

Errors in file /oracle/prod/d01/db/tech_st/10.2.0/admin/PROD_srvhqon16/bdump/prod_mrp0_26618.trc:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: '/oracle/prod/d01/db/apps_st/data/log01b.dbf'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

ORA-00312: online log 1 thread 1: '/oracle/prod/d01/db/apps_st/data/log01a.dbf'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

Mon May  9 09:22:52 2016

Errors in file /oracle/prod/d01/db/tech_st/10.2.0/admin/PROD_srvhqon16/bdump/prod_mrp0_26618.trc:

ORA-19527: physical standby redo log must be renamed

ORA-00312: online log 1 thread 1: '/oracle/prod/d01/db/apps_st/data/log01a.dbf'

Clearing online redo logfile 1 complete

Media Recovery Waiting for thread 1 sequence 4234

Fetching gap sequence in thread 1, gap sequence 4234-4245

FAL[client]: Error fetching gap sequence, no FAL server specified

Mon May  9 09:22:53 2016

Completed: Alter database recover  managed standby database disconnect  from session

Mon May  9 09:23:23 2016

FAL[client]: Failed to request gap sequence

GAP - thread 1 sequence 4234-4245

DBID 246505118 branch 834666782

FAL[client]: All defined FAL servers have been attempted

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2016
Added on May 9 2016
15 comments
2,397 views