Database Backup and Recovery (MOSC)

MOSC Banner

Oracle PITR recover

in Database Backup and Recovery (MOSC) 4 commentsAnswered

Hello experts,

I want to restore database in Oracle 19c(19.13.0.0.0) using duplicate command but when I use restore command it fails following error,

RMAN-06617: UNTIL TIME (05-FEB-23) is ahead of last NEXT TIME in archived logs (05-FEB-23

I tried to reduce the recovery until time with 1 second and it is failing with different error,

RMAN-05575: CONTROLFILE backup created before to_date('05/02/2023 14:50:08','dd/mm/yyyy HH24:MI:SS') not found in xxxx\xxx\xxx


I am getting confused here what time should I use for the recover until ...?

Thanks for your help in advance!

CP

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center