Printable View
Hi all,
I just wanna asking what is the best backup and recovery strategy for 9i RAC (9.2.0.4). This DB using RAW device running on solaris 8.
I read some oracle DOC saying that using RMAN is expensive for RAC.
My 2nd question is what is the best approach to copy from RAW to cooked filesystem?
Thanks.
Hi
In both the cases its RMAN and nothing but RMAN..wheather cooked file systems or RAW.
regards
Hrishy
there is another option to use "alter tablespace xxx begin backup" and use dd command to copy from RAW to cook's.
Which one is better RMAN or dd?
i'm thinking that
RMAN: if RMAN DB crash, then it need to recover.
restore also must be from RMAN
Lots of issue using RMAN
dd (conventional):?????
Hi
I would always prefer RMAN over dd.dd is less complicated agree..but for a incremental complexity look at the features you get
backup database will backup your complete database
restore database will restore the complete database
go to metalink and refer docid on
243760.1
and let me know which one you prefer.
If you ask my opinion since your are on 9i.I would say RMAN RMAN RMAN..no to DD..been there done it.
If you have any special requirement let me know on why you prefer dd over RMAN.
dd would be preferred in oracle7.3 OPS database certainly not for 9i..no way
regards
Hrishy
i dont think we need to do complete restore if using dd. same to RMAN.
could you please explain why we need to restore all oracle files (datafile,controlfile,etc). Assume one datafile is missing, we only restore that particular file and apply archive log. isn't it?
Hi
With RMAN also you do the same thing.If you lose a datafile in RMAN you just restore and recover that datafile..Thats it..
regards
Hrishy
Then what is this statement refering to? incremental backup also available on export/import method not only on RMAN. Seem you are prefer RMAN rahter than dd. why??? is that just because you are using RMAN or what?Quote:
Originally posted by hrishy
backup database will backup your complete database
restore database will restore the complete database
look, i never use RMAN before as well as dd for RAW, that why i'm asking your opinion. Is there someone else here have experiance on this?
As far as i'm concern RMAN:
- use another DB to store it catalog -> therefore it requre another space
- RMAN db need to recover it is crash -> else main db unrecoverable
- lots of issue especially bug
(thats software for you :-))Quote:
Originally posted by zainalj
Then what is this statement refering to? incremental backup also available on export/import method not only on RMAN. Seem you are prefer RMAN rahter than dd. why??? is that just because you are using RMAN or what?
look, i never use RMAN before as well as dd for RAW, that why i'm asking your opinion. Is there someone else here have experiance on this?
As far as i'm concern RMAN:
- use another DB to store it catalog -> therefore it requre another space (This is wrong not true in 9i and RAC)
- RMAN db need to recover it is crash -> else main db unrecoverable
(Nope not true in 9i and RAC)
- lots of issue especially bug
well i suggest that you read the RMAN documentaion.I suspect you test with the 9i version of RMAN be comfortable and then evaluate yourself.
I have been there and done that i am not saying i am the best.But i have seen people striggling with raw file systems and DD dont do it..its for machoists..check up cluster file systems available form various vendors..read the docs esepecially on 9i and RMAN
RMAN in 9i doesnt require a separate DB it stores everything in the control file..read metalink .
regards
Hrishy
Thank You hrishy. You advice and opinion is highly appreciated. Will look into RMAN and 9i docs.
Meanwhile if other people want to say something you are welcome too.
/Greenhorn to 9i/RAC/RMAN
Hi,
I am in total agreement with the use of RMAN.
dd is a very time consuming way for copying and you will have great problem in backup and restoration.
secondly, dd is a high I/O intensive so the system performance will go down drastically.
RMAN once implemented will be easier to manage. You can create custon scripts for backup, restoration, incremental backups etc. There is a little extra effort initially but it helps in long term. You can attach RMAN to other third party tools like Legato, Veritas backup and automate the whole process of backup. I have been using RMAN for last 1.5 yrs and would prefer it over any other thing.
Thanks
Regards
If you're afraid of rman god help you with RAC!Quote:
Originally posted by zainalj
Then what is this statement refering to? incremental backup also available on export/import method not only on RMAN. Seem you are prefer RMAN rahter than dd. why??? is that just because you are using RMAN or what?
look, i never use RMAN before as well as dd for RAW, that why i'm asking your opinion. Is there someone else here have experiance on this?
As far as i'm concern RMAN:
- use another DB to store it catalog -> therefore it requre another space
- RMAN db need to recover it is crash -> else main db unrecoverable
- lots of issue especially bug
What could be simplier in 9i than
run
{
backup database;
}
come on man, get with the times dude, this ain't rocket science.
Build your sandbox database, read the manual and do some testing
Quote:
Originally posted by hrishy
(thats software for you :-))
RMAN in 9i doesnt require a separate DB it stores everything in the control file..read metalink .
regards
Hrishy
Hrishy,
what do you mean RMAN doesn't need to have seperate DB??? Is it something new in 9i??? B/c I have been using seperate DB and store the rigistry and catalog in this database. It must be somehting I am missing in 9i. Could you please explain or point me somewhere to read up on this.
thanks
read the book dudeQuote:
Originally posted by learning_bee
Hrishy,
what do you mean RMAN doesn't need to have seperate DB??? Is it something new in 9i??? B/c I have been using seperate DB and store the rigistry and catalog in this database. It must be somehting I am missing in 9i. Could you please explain or point me somewhere to read up on this.
thanks
Although RMAN can conduct all major backup and recovery operations using just the control file, note these advantages of using the catalog:
Some RMAN commands and operations function only with a catalog.
The recovery catalog retains historical backup information that can get overwritten in the control file.
The recovery catalog stores information about backups from different incarnations of the database.
http://download-west.oracle.com/docs...a96566/toc.htm
stmontgo,
thanks your reply. you misunderstood my question. the question I want to know is that you should have a seperate database for RMAN and catalog right???
Hi LearningBee
Till 8i you needed to have a catalog or a separate database for RMAN to have many of the functionalities working.RMAN has undergone a major revamp in 9i.Most of the things now in 9i can be accomplished without using a catalog or a separate database.
You read the RMAN 9i Book by Mcgraw Hill Authored by robert freeman or the documentation.
regards
Hrishy