| Refresh standby controlfile? [message #58553] |
Tue, 16 September 2003 16:23  |
Erin N
Messages: 3
Registered: February 2003
|
Junior Member |
|
|
To refresh the controlfile on a standby oracle8i db the procedures I read say to: 'Transfer the standby control file and archived log files to the standby site...' (while it is shutdown)
Does this mean to overlay the existing control files at the o/s level and then start up the db and restart recovery? If anybody has the exact procedures I'd love the step by step. I want to rename some datafiles on primary. Thanks in advance! Erin
|
|
|
|
| Re: Refresh standby controlfile? [message #58558 is a reply to message #58553] |
Tue, 16 September 2003 18:53  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Erin
You dont have to refresh the standby controlfile mandatorily, for the rename to take effect. You could simply rename the datafile at the standby site . Just cancel the recovery and while the standby database is mounted in standby mode, do a 'alter database rename file 'old_file' to 'new_file';
that should take care of it.
|
|
|
|
|
|
| Re: Refresh standby controlfile? [message #58561 is a reply to message #58560] |
Tue, 16 September 2003 19:59 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
In the mount mode(with recovery cancelled), copy (or move) the datafile to the new location and then rename the datafile . Resume recovery and make sure there are no errors in the alert.log file.
Hope this helps
Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
