| Author |
Message |
Richard Foote
*nix forums beginner
Joined: 04 May 2005
Posts: 38
|
 Posted: Thu Feb 10, 2005 11:30 am Post subject:
Re: controlfile backup
|
|
|
"vertigo" <ax178@wp.pl> wrote in message
news:cufaic$e6d$1@nemesis.news.tpi.pl...
| Quote: | Hello
I read that controlfile should be backuped while instance is shut down.
SO what for is: ALTER DATABASE BACKUP CONTROLFILE TO filename ?
|
Hi Michal
A control file should only be physically *copied* while the database is not
opened.
To backup a control file while the database is open, use the above command
or/and (perhaps better still) ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
Careful what you read ...
Cheers
Richard |
|
| Back to top |
|
 |
Rauf Sarwar
*nix forums Guru
Joined: 03 May 2005
Posts: 353
|
| Posted: Thu Feb 10, 2005 8:54 am Post subject:
Re: controlfile backup
|
|
|
vertigo wrote:
| Quote: | Hello
I read that controlfile should be backuped while instance is shut
down.
SO what for is: ALTER DATABASE BACKUP CONTROLFILE TO filename ?
Thanx
Michal
|
To backup the controlfile while the database is still running. You
should use this command just prior to shutdown for cold backup or
during hot backup or after any major additions to the database e.g.
adding a datafile etc.
Regards
/Rauf |
|
| Back to top |
|
|
vertigo
*nix forums addict
Joined: 23 Mar 2005
Posts: 71
|
| Posted: Thu Feb 10, 2005 8:43 am Post subject:
controlfile backup
|
|
|
Hello
I read that controlfile should be backuped while instance is shut down.
SO what for is: ALTER DATABASE BACKUP CONTROLFILE TO filename ?
Thanx
Michal |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Server
