Database Backup and Recovery (MOSC)

MOSC Banner

Flashback on 11grel2

edited Oct 25, 2013 4:04AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
Hi all

do i need to put the DB in mount mode to enable flashback on one DB 11grel 2 like SR note 416496.1?

1. Shutdown immediate all instances

2. Mount the database:

SQL> startup mount;

3. If database is NOT in archivelog mode, issue:

SQL> alter database archivelog;

4. Turn on flashback database:

SQL> alter database flashback on;

5. Shutdown database:

SQL> shutdown immediate;

6. Open all the RAC database instances

Please confirm ?

Jesus

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center