oracle - Archivelog file deleted, resulting in 'ORA-01113: file 1 needs media recovery' - Database Administrators Stack Exchange


(this not production database. i'm practicing in staging enviroment.)

i'm trying set rman backup/recovery.

i did full backup, seems in state.

i did archivelog backup, went well. , then, (here's f***ed up), i...

  1. created new tmp directory.
  2. ran rman archivelog only backup tmp directory destination
  3. changed mind , deleted tmp directory.

i realize rman keeps track of paths written backups, can't go around , delete these files!

now, after do

run {     restore database;     recover database; }

i get

ora-27037: unable obtain file status linux-x86_64 error: 2: no such file or directory additional information: 3  failover previous backup rman-00571: =========================================================== rman-00569: =============== error message stack follows =============== rman-00571: =========================================================== rman-03002: failure of recover command @ 01/19/2018 20:21:01 rman-20506: no backup of archived log found rman-06053: unable perform media recovery because of missing log rman-06025: no backup of archived log thread 1 sequence 15 , starting scn of 1361136 found restore

and when try open database, looks follows:

2018-01-19 20:23:04 sys@... sysdba> alter database open; alter database open * error @ line 1: ora-01113: file 1 needs media recovery ora-01110: data file 1: '/path/to/a/file.dbf'

i've tried solution posted here: ora-01113: file # needs media recovery ora-01110

but can't work. (i run ora-00308: cannot open archived log.)

update: tried crosscheck backup; followed delete expired backup; unfortunately results in this.

ran rman archivelog backup new directory
changed mind , deleted directory.

assuming still have archivelog files , not deleted when backed up, need tell rman files aren't coming back:

use crosscheck command synchronize physical reality of backups , copies logical records in rman repository

if, on other hand, original archivelog files deleted along backups, not have full recovery set , thing said "this not production database. i'm practising in staging environment". full backup run online not consistent backup — need archivelog files containing log records before backup starts until after finishes or there no way restore database consistently.


Comments

Post a Comment

Popular posts from this blog

auto reset an Arduino using ftdi - DTR signal stays low and needs to go high after 1-50ms - Electrical Engineering Stack Exchange

Image
hello have cheap ftdi going recreate on pcb can flash atmega2560 chip onboard, ftdi has dtr line pulled low when sequence starts stays low instead of going low high after 1ms 50ms, need find out how create simple circuit when pulled low goes high, how can this, have simple components hand. my stocked parts: 103 ceramic caps 25uf aluminium caps 220uf aluminium caps some blue ceramic caps labeled "10" practically common resistors values 5v zener diodes 5v switching diodes npn transistors n channel mosfets 5v reflecting diodes can make using ? else can what's needed. many thank edwin sorry it's atmel atmega 2560 chip on pcb have serial lines , reset,5v,ground , 2 gpios on pin out. can flash ftdi. , ftdi dtr line stay low , need pluse rest line need figure out how use low signal pull reset low high right after. if try on arduino mega or uno holding down reset not work it's pulse going low high load boot manager. hence dfti dtr...
Read more

microcontroller - Why is the Voltage only 1.4 for reset input when in high impedance? - Electrical Engineering Stack Exchange

Image
i attempted make myself 2-in-1 programmer can program both at89cx051 , at89s52 on same board without having plugging/unplugging of port. the main issue strobe pin aka reset (rst in circuit). (pin 1 of db25 connector). tested pc , got no results. what seems work if connected rst vcc via 1k resistor. works because though output @ 3.8v instead of 5 (which vcc at), puts at89s52 in reset mode expected, i'm not getting 12v @ pin 1 of small at89cx051 socket. if don't make manual connection, 1.4v measured @ rst, after added 10k resistor between vcc , rst. without rst being forced ground, should 5v i'm not. i have tested transistors manually leg leg using diode setting on multimeter , turned out fine. resistors going base of transistors 2.2k , used 1k resistors in place of diodes. other resistors 10k. resistor going buffer (74hc125) 0 ohm. all capacitors 0.1uf. why getting such awkward voltages reset pin? using weak of resistors or something? update so ended ma...
Read more

Choosing and replace capacitors for audio amplifier - Electrical Engineering Stack Exchange

Image
i have old audio amplifier (jvc a-gx2b) produces crackling noises on 1 of outputs. so, opened , discovered 2 largest capacitors seem leaking : can replace capacitor same characteristics (4700uf 50v), or should instead take specific capacitors audio? if yes, ones ? in addition, have interest replace capacitors of amp (not 2 largest)? 1: wear safety gloves when handling toxic leaky capacitors, remove , clean safely isoprop. , mark note polarity (-) 2 : measure dia , lead pitch dxl [mm] sort parts this 3: audio or better low esr, highest ripple current caps. < 50mohm, > 3aripple 4: better caps run cooler lower esr , rated higher temp. may not fit. 5: japanese caps have better reliability i suggest 1st choice panasonic @ digikey .. cost of shipping may more cost of caps. as suggested: cap voltage must same or more - capacitance tolerance doesn't matter, , may larger value. - large e-caps may replaced @ same time.
Read more