Database Administration (MOSC)

MOSC Banner

Rman point in time recovery

edited Jul 21, 2016 9:18AM in Database Administration (MOSC) 12 commentsAnswered

I'm new dba and i Wonder if the below scenario woul be possible in real case:

-i have à 11gR2 database running in ibm aix OS

-archivelog is on

-we often take the backup at  23:30 PM (archive log are also backup)

Let's suppose the next day of the backup,in the day, the database can no more start due to a human manipulation at 10:15 am .We decide to restore the database to its situation at 7:00 am

In the morning of the next day, at about 8:24 am, the dba added a datafile(so the previous backup at 23:30 PM will not really reflect the current situation in the database).

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