| Flashback old primary after a failover [message #149537] |
Fri, 02 December 2005 03:10  |
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
|
Senior Member |
|
|
Hi,
after a failover i want to bring back the old-primary as a new standby using the flashback database. i've been following the oracle documentaion and one thing i need clarification with is this
| Quote: |
2. Create the standby control file and shut down the database:
SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS control_file_name;
SQL> SHUTDOWN IMMEDIATE;
3. Issue operating system copy commands to replace the current control files with the new standby control file.
|
what does this step 3 means?
i created my standby controlfile as '/tmp/standy.ctl'
and then copy it to the directory where controlfiles were when the database was running as the primary. '/oradata/pri/'
but when i issued startup mount it still mount as a primary database instead of a standby.
when i deleted the old controlfiles control01.ctl, control02.ctl, etc then startup mount gives an error saying unable to recognize the controlfile.
after that i modified the pfile and gave the standby controlfile in the controlfile parameter. then the database got mounted.
but didn't apply any logs after i started the log apply service.
so i want to know how to implement this mounting the database using the standby controlfile. and what happens to the old controlfiles? do i delete them or keep them?
thank you
|
|
|
|
|
|
| Re: Flashback old primary after a failover [message #149560 is a reply to message #149537] |
Fri, 02 December 2005 04:40  |
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
|
Senior Member |
|
|
the above article is very good but i need to know one more thing
| Quote: |
# Shutdown the old primary database (Instance A), and replace the control files with the new standby control files. SQL> shutdown immediate; $ cp /dba/standby/stbyct.f /u02/oradata/sid/control01.ctl $ cp /dba/standby/stbyct.f /u02/oradata/sid/control02.ctl
|
how do i do this when my control files are in ASM?
thank you
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
