Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Archive for the ‘FLASHBACK’ Category

ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

Posted by Hendry chinnapparaj on January 19, 2011

Problem

—————

When trying to do flashback in a data guard environment in 10g.

SQL> startup mount
ORACLE instance started.

Total System Global Area 3321888768 bytes
Fixed Size                  2087680 bytes
Variable Size            2013267200 bytes
Database Buffers         1291845632 bytes
Redo Buffers               14688256 bytes
Database mounted.
SQL> flashback database to restore point primary_jan17;
flashback database to restore point primary_jan17
*
ERROR at line 1:
ORA-38754: FLASHBACK DATABASE not started; required redo log is not available
ORA-38761: redo log sequence 57 in thread 1, incarnation 3 could not be
accessed

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     108
Next log sequence to archive   111
Current log sequence           111

Cause

———-

The required archived logs were already backedup to tape / deleted from disk , hence not available for flashback.

Solution

—————

Restore the archive logs from tape

RMAN> restore archivelog from sequence 40;

or

RMAN> restore archivelog from time ‘sysdate – 3’;

Starting restore at 19-01-2011 14:22:55
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1

archive log thread 1 sequence 63 is already on disk as file /u03/oradata/flash_recovery_area/CPSOA1_JS/archivelog/2011_01_17/o1_mf_1_63_1EfFdyHyY_.arc
archive log thread 1 sequence 64 is already on disk as file /u03/oradata/flash_recovery_area/CPSOA1_JS/archivelog/2011_01_17/o1_mf_1_64_1EfLwYh1X_.arc
archive log thread 1 sequence 65 is already on disk as file /u03/oradata/flash_recovery_area/CPSOA1_JS/archivelog/2011_01_17/o1_mf_1_65_1EfMEfwdz_.arc
archive log thread 1 sequence 66 is already on disk as file /u03/oradata/flash_recovery_area/CPSOA1_JS/archivelog/2011_01_17/o1_mf_1_66

channel ORA_SBT_TAPE_1: starting archive log restore to default destination
channel ORA_SBT_TAPE_1: restoring archive log
archive log thread=1 sequence=37
channel ORA_SBT_TAPE_1: reading from backup piece tpm2930c_1_1
channel ORA_SBT_TAPE_1: restored backup piece 1
piece handle=tpm2930c_1_1 tag=TAG20110116T161052
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:02:25
channel ORA_SBT_TAPE_1: starting archive log restore to default destination
channel ORA_SBT_TAPE_1: restoring archive log
archive log thread=1 sequence=38
channel ORA_SBT_TAPE_1: reading from backup piece trm293n4_1_1
channel ORA_SBT_TAPE_1: restored backup piece 1
piece handle=trm293n4_1_1 tag=TAG20110116T162300
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_1: starting archive log restore to default destination
channel ORA_SBT_TAPE_1: restoring archive log
archive log thread=1 sequence=39

SQL> flashback database to restore point primary_jan17;

Flashback complete.

SQL> alter database open resetlogs;

Also do the flashback on the standby database

SQL> flashback database to restore point stby_jan17;

SQL> Recover managed standby database disconnect from session

 

and enable the dataguard configuration

 

Shalom

Posted in FLASHBACK | Leave a Comment »