Re: Standby Database from Hot Backup?

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Fri, 08 Feb 2002 03:06:35 GMT
Message-ID: <%gH88.1696$UW7.987833406@newssvr21.news.prodigy.com>

You can do it from hot backup as well. Here is how:

You have already setup the standby database. Then:

Create a standby controlfile. On the primary database: SVRMGR> alter database create standby controlfile as '<path/file>';
Create a backup of the primary database datafiles (hot or cold).
Copy the datafiles, standby controlfile, and configuration files from the primary to the standby host.
Modify the standby init.ora if necessary.
Mount the standby database: SVRMGR> startup nomount SVRMGR> alter database mount standby database;
Apply any logs already archived to the standby host: SVRMGR> recover standby database ORA-00279: change 57953 generated at .... ORA-00289: suggestion : .... ORA-00280: change 57953 .... Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

     When prompted, type AUTO. All archived logs will be applied. As
     soon as Oracle fails to find a log, the recovery session will be
     terminated, and the user will be returned to the SVRMGR prompt:

     ORA-00308: cannot open archived log ....
     ORA-27037: unable to obtain file status
     SVR4 Error: 2: No such file or directory
     Additional information: 3
     SVRMGR>
  7) At this stage, the standby database can be put into sustained
     recovery mode:
     SVRMGR> recover managed standby database (timeout <mins>)
  8) As logs are archived from the primary, they will be applied to
     the standby. There is no indication in the recovery session that
     logs are being applied. In order to monitor progress, check the
     standby alert log. For example:
     Fri Nov  6 09:57:53 1998
     ALTER DATABASE RECOVER   managed standby database
     Fri Nov  6 09:57:53 1998
     Media Recovery Start: Managed Standby Recovery
     Media Recovery Log
     Media Recovery Waiting for thread 1 seq# 112
     Fri Nov  6 09:58:08 1998
     Media Recovery Log /spare/sme81/app/oracle/admin/jb/arch/log_112.arc
     Media Recovery Waiting for thread 1 seq# 113
     Fri Nov  6 09:58:53 1998
     Media Recovery Log /spare/sme81/app/oracle/admin/jb/arch/log_113.arc
     Media Recovery Waiting for thread 1 seq# 114
  9) To cancel the recovery session:
     SVRMGR> alter database recover managed standby database cancel;

Please, next time include your db version, OS version as well.

Hope that helps.

Trifon Anguelov
Senior Oracle DBA

Join the new Oracle DBA forums at:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

"nntp.ix.netcom.com" <djjr_at_ix.netcom.com> wrote in message news:a3tfp0$sm4$1_at_slb6.atl.mindspring.net...
> Is it possible to create a standby database from a hot backup. I've only
> done it by starting out with
> a cold backup. If possible, what are the issues. The documentation seems
> to imply that you need a cold backup.
>
> Thanks in advance
>
>
Received on Thu Feb 07 2002 - 21:06:35 CST