Home » Other » Training & Certification » ALTER DATABASE
ALTER DATABASE [message #307416] Tue, 18 March 2008 17:52 Go to next message
dmkanz
Messages: 9
Registered: March 2008
Junior Member
Currently I am taking a DBA class and I am having an issue finding the answer to one of my questions. Does anyone know how you can use the ALTER DATABASE to generate an alert log. Or what the syntax is for ALTER DATABASE. Here is the question.

To prepare for a disaster, you decide that you should have a text form of a control file stored somewhere. Use a form of the ALTER DATABASE command to achieve this objective. (Hint: Use the alert log). State how you created the command, and where you located the text of the command.

Thanks

Dm Kanz
Re: ALTER DATABASE [message #307417 is a reply to message #307416] Tue, 18 March 2008 18:00 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8635
Registered: November 2002
Location: California, USA
Senior Member
Syntax for all commands can be found in the searchable online documentation on Oracle's web site.
Re: ALTER DATABASE [message #307418 is a reply to message #307416] Tue, 18 March 2008 18:05 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Does anyone know how you can use the ALTER DATABASE to generate an alert log
IMO, this question/statement makes NO sense.
Also, IMO, the hint is bogus & totally misleading.

GOOGLE is your friend, but only when you actually use it.
Re: ALTER DATABASE [message #307421 is a reply to message #307418] Tue, 18 March 2008 18:28 Go to previous messageGo to next message
dmkanz
Messages: 9
Registered: March 2008
Junior Member
Does the alter database backup controlfile option allow you to save a text version of your control file?

ALTER DATABASE database_name
BACKUP CONTROLFILE TO 'filename' [REUSE]

Thanks

Dm Kanz
Re: ALTER DATABASE [message #307422 is a reply to message #307416] Tue, 18 March 2008 18:34 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Does the alter database backup controlfile option allow you to save a text version of your control file?

ALTER DATABASE BACKUP CONTROLFILE
is the basis to get the text version of the control file.

In fact I used it just today, because among other details it contains the database characterset.
Re: ALTER DATABASE [message #307423 is a reply to message #307416] Tue, 18 March 2008 18:40 Go to previous messageGo to next message
dmkanz
Messages: 9
Registered: March 2008
Junior Member
Where does the file get saved when you use the backup option

Thanks

DM Kanz
Re: ALTER DATABASE [message #307424 is a reply to message #307416] Tue, 18 March 2008 18:48 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
the destination can be OS & version dependent & typically it is the "udump" directory which usually exists below the "admin" folder.
Re: ALTER DATABASE [message #307426 is a reply to message #307416] Tue, 18 March 2008 18:52 Go to previous message
dmkanz
Messages: 9
Registered: March 2008
Junior Member
thank you for the help

Dm Kanz
Previous Topic: Need help about project on Oracle
Next Topic: Need logic
Goto Forum:
  


Current Time: Thu Dec 08 12:31:15 CST 2016

Total time taken to generate the page: 0.12983 seconds