Archive for October, 2021

ORA-38760: This database instance failed to turn on flashback database

October 24th, 2021, posted in Oracle Queries
Share
Error :

Starting recover at 24-APR-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1072 device type=DISK

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/24/2018 14:54:07
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashback database

Cause :

Database was in flashback mode.

Solution :

trun off flashback mode and rerun recovery.

SQL> alter database flashback off;
Database altered.

SQL>

RMAN> run
{
set until sequence 576;
recover database;
}2> 3> 4> 5>

executing command: SET until clause

Starting recover at 24-APR-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1072 device type=DISK

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=573
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=574
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=575
channel ORA_DISK_1: reading from backup piece /d02/dbbackup/RMAN_backup1/RMAN_BKPMon_23Apr18/ar_974238549_2165_1
channel ORA_DISK_1: errors found reading piece handle=/d02/dbbackup/RMAN_backup1/RMAN_BKPMon_23Apr18/ar_974238549_2165_1
channel ORA_DISK_1: failover to piece handle=/d01/oracln/backup/RMAN_BKPMon_23Apr18/ar_974238549_2165_1 tag=TAG20180423T211704
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:25
archived log file name=/d01/oracln/data/archive1_573_970862557.dbf thread=1 sequence=573
archived log file name=/d01/oracln/data/archive1_574_970862557.dbf thread=1 sequence=574
archived log file name=/d01/oracln/data/archive1_575_970862557.dbf thread=1 sequence=575
media recovery complete, elapsed time: 00:00:27
Finished recover at 24-APR-18

RMAN>
Recovery Manager complete.
Share

Be Hopeful And Do Not Despair O Heart

October 3rd, 2021, posted in Rumi
Share

persian poetry,poetry,english translation

persian poetry,poetry,english translation,Moulana Muhammad Jalaluddin Rumi, rumi,Muhammad Jalaluddin Rumi,

Share