Database Backup and Recovery (MOSC)

MOSC Banner

Point in time recovery WITHOUT RMAN

edited Jan 29, 2025 8:24PM in Database Backup and Recovery (MOSC) 3 commentsAnswered

I am practicing backup and recovery below.

1.Insert one record into Scott's EMP table

SQL> SELECT CURRENT_SCN FROM V$DATABASE;

CURRENT_SCN-----------    2395700

—Recover here———

2. Add one record to Scott's EMP table

SQL> SELECT CURRENT_SCN FROM V$DATABASE;

CURRENT_SCN-----------   2503913

★I took hot backup here★

3. Failure occurs (data file and control file completely lost)

4. Manually recover to state 1

what should I do to get back to

CURRENT_SCN-----------    2395700

Thank you.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center