logs archiveIRC Archive / Freenode / #oracle / 2010 / March / 5 / 1
zambaboo
RMAN-06054: media recovery requesting unknown log: thread 1 seq 66 lowscn 335571264
sigh
im just really baffled by the fact that i have a full backup with incrementals and i cannot recover the database;
and looksl ike ive done entirely too much in rman and sqlplus sinceim finishing my sentences with a semicolon
rizzo
do you backup archive logs in your backups?
you should
zambaboo
database plus archivelog delete input;
rizzo
k
can you see the backup of that seq in your catalog?
list backup of archivelog sequence 66
;
zambaboo
no
rizzo
list backup of archivelog from sequence 65 until sequence 75;
is there a gap or is everything missing after 65?
zambaboo
everything is missing
rizzo
basically, though, not much you can do if you don't have that log
zambaboo
and the set is marked as expired
         

rizzo
is the backupset really not on disk anymore?
zambaboo
yeah its gone. let me look on the bacula server.
hm ok i have it there
rizzo
if you can't restore those backup files from tape or some other server, then you'd be SOL
copy whatever files you need and catalog/crosscheck them
then rman should see them
zambaboo
oh i see, im missing like 10 pieces, they are all on that bacula box
rizzo
copy those bad boys over
zambaboo
crosscheck revealed several more expired ones
ok
got'em
still no 66 though
metaelucid
does the symbol: / mark the end of an sql script?
i see it in alot of examples
like here: http://www.orafaq.com/scripts/sql/help.txt
or is it a terminator for where
zambaboo
i think its a commit
oh heh
hey rizzo, tijnie, at some point i took the db out of archivelog mode
you cannot perform database point-in-time recovery if you have been running your database in NOARCHIVELOG mode.
oookay
sayaka
hello
I am running Oracle XE Lite under Fedora Linux and would like to use it wirh PHP
so I downloaded ZEND and installed it
hello, anyone at home ????
looks like....The lights are on but Nobody is at home
crashanddie
the topic says "Ask your question, stick around if someone doesn't respond right away"
sayaka
cool....overlook that particular part in the welcoming text...I guess, I will not Crash 'n Die...hehehehe
cyberjames
hi, what's the best filesystem to use in linux for oracle? Also the SAN storage solution..
tijnie
cyberjames, in what respect: performance?
cmug
Regarding Grid Control, I cannot create a monitoring template that has Corrective actions defined ? Can it be?
All my installations has insecure permissions on listener.ora file, and I want to define a corrective action to a monitoring template that I can apply on each target, that would automatically fix the file permissions but this seems impossible
oh my I might have found it after all
but why it does not work, grr. If my policy is checked every 5 min, I would imagine the corrective action would be run whenever the policy is violated ?
Reign1
how do i use appen on create table as select?
create /*+ append */ table ... as select from ... ?
or?
cyberjames
tijnie: yes performance. Because it runs in vmware
tijnie
cyberjames, Oracle will tell you ASM probably.
cyberjames, HOwever I'v never ran into trouble using ext3
cyberjames
oic
what did you used?
tijnie
I would say ext3. But make sure that the fs is under LVM control
So you can enlarge (or optionally shrink) the fs when you need to.
cyberjames
I see. LVM is what Im thinking of too
         

tijnie
For a SAN samething applies. Make sure that the LUN is under LVM-control
ext3 fs's under LVM work fine imho
cyberjames
/wind23
davo
hi all. anyone have the textbook, Oracle 10g by Joan Casteel (2006) ?
cmug
hmm, after succesfull point in time recovery I have suddenly 39000 corrupted blocks in my datafile ??
tijnie
josemoreira, What is the problem you run into?
First thing that comes to mind is some braces ( ) at the condition ==> IF ( x ==1 )
josemoreira
this 1 http://paste.pocoo.org/show/185973/
this is mysql stored pc's
btw
#mysql hasnt been helpuf
nvmd i got it
tijnie
Well I'm afraid that I don't know the syntax you use (Increment : repeat). But ...I wil have a look at the docs...See if I can understand it.
bucky1
can you forcefully move a specific session from one RAC node to another (if its inactive)
if not, could i at least do 'ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE;' if TAF was configured?
tijnie
josemoreira, What is the solution?
josemoreira
nvmd i got it
it was the >"<
i copied the SQL from the web and perhaps they had the wrong charcode
tijnie
ah...ok....well that's sorted out then.
tn
tnx
Rudemeister
mod_certheader
l_r
hello
is there any expert about forms?
« prev next »