Re: log shipping failover to stand by server

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 05/23/04 

Date: Sun, 23 May 2004 13:20:48 +0100

Biju,
the name is perhaps slightly unintuitive. sp_change_secondary_role:
(a) Copies the final production database transaction log backup to the
standby server along with any additional transaction log backups that were
not previously copied.
(b) Disables the log-shipping transaction copy job on the standby server.
(c) Restores all transaction log backups not previously restored to the
standby database and initiates the recovery of the standby database.
(d) Terminates and rolls back all pending transactions.
(e) Sets the access level of the standby database after completion of the
system stored procedure to multiuser mode.
(f) Creates a log-shipping database maintenance plan on the new primary
server for the new production database. The SQL Server Agent job defined in
this plan backs up the transaction log of the new production database to the
folder location you specified when you set up log shipping.
HTH,
Paul Ibison

Relevant Pages

  • Re: An expert on Standby ? ORA-01157 error after adding a new datafile
    ... maybe Oracle has not been able to create the file on the standby ... See alert_SID.log on standby server. ... Otherwise you can create the file on the standby database ...
    (comp.databases.oracle.server)
  • Re: ORACLE RAC and ORACLE Standby
    ... standby is better for disaster recovery and RAC is ... > more useful for high-availability and load balancing. ... > with taking any downtime on your primary database instance. ... > The standby database provides a local or off-site recovery instance. ...
    (comp.databases.oracle.server)
  • Re: ora-00354 on standby site on physical database
    ... I am in Process of creating physical standby database with standby redo ... I am facing ora-00354 on standby database. ... Standby redo log 4 thread 1 sequence 111 is being archived ... Media Recovery Waiting for thread 1 seq# 112 ...
    (comp.databases.oracle.server)
  • Re: ORACLE RAC and ORACLE Standby
    ... standby is better for disaster recovery and RAC is ... with taking any downtime on your primary database instance. ... The standby database provides a local or off-site recovery instance. ... Load balancing capabilities of RAC include ...
    (comp.databases.oracle.server)
  • Re: restore the replication system
    ... the sync with backup option is fairly useless unless you are shipping ... use the sync with backup option on your publication database and possibly ... restore the msdb, publication database, and distribution database backups ... on the standby server with the keep_replication switch. ...
    (microsoft.public.sqlserver.replication)