-
Dear fellows in misery,
I´m 'playing' with different crash szenarious to be prepared for the worsed case:
master data:
os: Win2000
db: oracle8i version: 8.1.7.0.0
rman uses with nocatalog
backup: full offline backup with rman
situation:
- I renamed all control files
- run the following script on rman:
run {
allocate channel channel1 type disk format 'd:\oracle8i\oradata\RecTest\backup\b_%u_%s_%p';
restore controlfile;
}
The error message is:
ORA-06512: in "SYS.X$DBMS_RCVMAN", Zeile 4461
ORA-06512: in Zeile 1
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . setDatabase ( upp
er ( :dbname:dbname_i ) , :rlscn , :rltime , :fhdbi:fhdbi_i ) ; end ;
RMAN-06099: error occurred in source file: krmk.pc, line: 9196
What have I done wrong?
Chris
-
Did you start database in nomount state?
Did you try to allocate channel type disk and not provide full path to location of backup?. It just occured to me that you are not using recovery catalog, is that cou be a problem?
[Edited by BV1963 on 05-16-2002 at 10:38 AM]
-
> Did you start database in nomount state?
Yes, I did.
> Did you try to allocate channel type disk and not provide full > path to location of backup?. It just occured to me that you are > not using recovery catalog, is that cou be a problem?
O.k., I rman has no Information abbout backups and so on because he gets it from the controlfile of the database. But for what reason rman provides backup for controlfile if one can not restore the database without any conrol file?!
Maybe it would be better to use an catalog...
Chris
-
The second problem I have is, that I can not use the auto chanal feature. Every time I do a backup or something else, I have to allocate a chanel. Hmm. Could the reason be the not existing catalog as well?
Chris
-
O.k., I rman has no Information abbout backups and so on because he gets it from the controlfile of the database. But for what reason rman provides backup for controlfile if one can not restore the database without any conrol file?!
It gives you a choice, either use recovery catalog or backup control file yourself. In case you do not use catalog your controlfile backup becomes very important.
-
But I got a backup of controfile and I´m not able to use it.
Chris
-
hallo,
my solution for the problem is to create an catalog and use him: Situation: Database is started but not mounted:
C:\ rman target internal/*****@target_db_name
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\>rman target internal/*****@target_db_name
Recovery Manager: Version 8.1.7.0.0 - Production
RMAN-06006: Verbindung mit Zieldatenbank: RecTest (nicht angeschlossen)
RMAN> connect catalog rman_db/*****@catalog_db_name
RMAN-06008: Verbindung mit Datenbank des Wiederherstellungskatalogs
RMAN> run {
allocate channel c1 type disk format 'D:\oracle8i\oradata\RecTest\backup\b_%u_%s_%p';
3> restore controlfile;
4> }
Some information is in german language. I hope even though you anderstand it.
Chris