| backup controlfile [message #62594] |
Mon, 02 August 2004 04:19  |
p anil
Messages: 4
Registered: August 2004
|
Junior Member |
|
|
how can we have a backupa control file
only by mirroring using operating system commands
using
alter database backup controlfile to trace;
i want know what control file will be in use
when we recover database
giving
alter database recover using backup controlfile:
will the database have another backup of controlfile
|
|
|
|
| Re: backup controlfile [message #62602 is a reply to message #62594] |
Mon, 02 August 2004 20:58  |
satyajit das
Messages: 12
Registered: August 2004
|
Junior Member |
|
|
when u use
alter database recover using backup control file . it means that u are using a older control file backuped earlier during recovery. it doesnot create another backup control file. when u use this command this means that u are doing incomplete recovery where some objects have been deleted and u want to recover the database upto that point of time before deletion.so u have to restore all the datafiles including system,controlfiles of latest earlier backup and then use this alter database recover using backup control file to recover the database
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
