Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Standby Database from Hot Backup?
You can do it from hot backup as well. Here is how:
You have already setup the standby database. Then:
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
"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