Database Administration (MOSC)

MOSC Banner

Flashback query

edited Jul 4, 2018 5:02AM in Database Administration (MOSC) 4 commentsAnswered

We have 2 queries :

1. In one of our Production Database we have enabled the Flashback logs and archivelog and we placed a separate diskgroup to store these files.

Now we have a request like these Flashback logs and archive log should be moved to new disk groups. So, if we set new diskgroup then new logs will get reside on it.

What about the older flashback logs ? Does it delete once the flashback log retention breach or we need to turn off the Flashback option to clear the old log ?

2. In our DR database which is Phy. standby DB which opened it in Snap shot standby mode. So the flashback have generated in the existing the diskgroup. We have a requirement like we need to set a new diskgroup for this standby db and we set also. Now if we revert the back the standby from snapshot to Physical standby mode does oracle automatically identifies older flashback logs ? is the conversion would work fine ?

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