OraFAQ Forum: Backup & Recovery » *.ora files to backup & there location

Home » RDBMS Server » Backup & Recovery » *.ora files to backup & there location

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

*.ora files to backup & there location [message #164725]

Sat, 25 March 2006 01:25

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

For whole system backup (Whole system not only full system) from Operating System some .ora files (i.e. password.ora, init.ora etc) are also must required to backup along with datafiles, control files and log files.
I am not sure which one to backup and which one not to. So I backup all *.ora files in Oracle home. Plus Oracle only ask for password file if whole backup restore at other system.
So I have two questions.

Which exactly are the .ora files must required to backup in whole backup.

How to find out there location. (Any fix location(s). or sql statements to find there location “this is must required for non windows system as search is not simple in non window systems)

Wishes
Jawad

Report message to a moderator

Re: *.ora files to backup & there location [message #164870 is a reply to message #164725]

Mon, 27 March 2006 03:59

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>For whole system backup (Whole system not only full system)
Please explain the differences in your terms.
Whole system and full system.
you find what you want in
$ORACLE_BASE/*
$ORACLE_HOME/dbs/*
$ORACLE_HOME/network/admin/*

Report message to a moderator

Re: *.ora files to backup & there location [message #165260 is a reply to message #164870]

Wed, 29 March 2006 01:59

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Dear Mahesh

thanks for help.

>>>Please explain the differences in your terms.

See Table 5-2 at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconc1.htm#458823

Wishes
Jawad

Report message to a moderator

Re: *.ora files to backup & there location [message #165275 is a reply to message #165260]

Wed, 29 March 2006 03:43

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Cool. Good catch.
I do understant the tags. I was left in a little confusion because you have not provided the magic works. 'RMAN' or 'HOTBACKUP'.
I thought you were talking about a cold backup.
Regards

[Updated on: Wed, 29 March 2006 06:27]

Report message to a moderator

Previous Topic:	RMAN backup error
Next Topic:	export backup strategy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 02:57:08 CDT 2024