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!

CONTROL_FILE_RECORD_KEEP_TIME

Ibrahim MalekAug 15 2016 — edited Aug 15 2016

Good morning friedns

i'm trying to re create this stand by db

but i'm facing this errors

my CONTROL_FILE_RECORD_KEEP_TIME is set to 7

regards

MRP0 started with pid=25, OS id=1896

Mon Aug 15 09:07:28 2016

MRP0: Background Managed Standby Recovery process started (PROD)

Managed Standby Recovery not using Real Time Apply

parallel recovery started with 16 processes

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

Clearing online log 1 of thread 1 sequence number 4716

Mon Aug 15 09:07:36 2016

Errors in file /oracle/prod/d01/db/tech_st/10.2.0/admin/PROD_srvhqon16/bdump/prod_mrp0_1896.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 4710

Fetching gap sequence in thread 1, gap sequence 4710-4714

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

Mon Aug 15 09:07:37 2016

Completed: Alter database recover  managed standby database disconnect  from session

Mon Aug 15 09:08:06 2016

FAL[client]: Failed to request gap sequence

GAP - thread 1 sequence 4710-4714

DBID 246505118 branch 834666782

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

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

Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization

parameter is defined to a value that is sufficiently large

enough to maintain adequate log switch information to resolve

archivelog gaps.

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2016
Added on Aug 15 2016
2 comments
6,375 views