image

Incomplete Recovery (until log sequence)

Point in time recovery using RMAN (until a log sequence number) Recovery Objective SQL> conn scott/tiger Connected. SQL> select count(*) from myobjects; COUNT(*) ———- 249410 Switch a logfile SQL> conn / as sysdba Connected. SQL> alter system switch logfile; System altered. Note the current log sequence number (13) SQL> archive log list Database log mode … continue reading

image

NOARCHIVELOG Database Recovery

NOARCHIVELOG DATABASE RECOVERY VIA RMAN Your database is running in No Archive log mode and you have daily/weekly RMAN backup configured. One fine day, your server crashed and you lose one of the disks or all the disks. You have no other option but to restore the whole database backup to point of last valid … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube