[askdba] Re: Standby database question
- From: "Ankur Shah" <ankur_ora@xxxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Thu, 30 Dec 2004 10:53:38 -0500
Its quiet critical point for a successfull creation of Standby
> U need to take the backup ahead of creating the standby control file
> This would make sure that your standby control file is not having a older
SCN then what the dbfs are having currently
> Go th'h this quick setup guide which meant for 9i
========================================
Ø How is a standby database created ?
1) Create a backup (hot or cold) of the Primary database
datafiles.
2) Create a standby controlfile on the primary.
SVRMGR> alter database create standby controlfile as
'/u01/app/oracle/admin/SID/udump/stby_control.ctl';
3) Copy the datafiles, standby controlfile, and configuration files from
the primary to the standby host.
4) Edit the Primary "init.ora" file. Standby database-specific
parameters include:
# This example specifies a local archiving destination and enables the
# destination.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/arc_dest/'
LOG_ARCHIVE_DEST_STATE_1 = ENABLE
# This example specifies net service name "standby1", makes archiving
mandatory
LOG_ARCHIVE_DEST_2 = 'SERVICE=standby1 MANDATORY REOPEN=5'
LOG_ARCHIVE_DEST_STATE_2 = ENABLE
5) Edit the Standby "init.ora" file. Standby database-specific
parameters include:
# The init.ora values for the standby database, which is on
# remote host.
STANDBY_ARCHIVE_DEST = /oracle/standby/arc/
This parameter defines the standby database destination for the
archive logs to be propogated from the Primary.
5) Start the standby instance and mount the standby database:
SVRMGR> startup nomount
SVRMGR> alter database mount standby database;
Ø The standby database is now ready to be rolled forward.
Ø Recovering the standby database:
SVRMGR> recover standby database;
¨ Simply apply logs as they arrive on the standby host.
With the new remote archival feature, archive logs can be
automatically applied on the remote (standby) host.
¨ To fully automate the process of recovering (rolling forward) the standby
database, the DBA can put the database into sustained recovery mode
SVRMGR> recover managed standby database disconnect from session;
In order to cancel a sustained recovery session, from another server manager
session issue the following command:
SVRMGR> alter database recover managed standby database cancel;
Ø Opening the standby database:
¨ Another significant new feature of Oracle8i standby databases is the
ability to open the standby read-only.
SVRMGR> alter database open read only;
¨ Of course, the standby database can be opened read write but will need to
be activated.
SVRMGR> alter database activate standby;
=====================================
HTHU
Ankur Shah
Oracle DBA
DHR-GA
----- Original Message -----
From: <Rick_Cale@xxxxxxxxxxxxxx>
To: <askdba@xxxxxxxxxxxxx>
Sent: Thursday, December 30, 2004 9:06 AM
Subject: [askdba] Standby database question
>
>
>
>
> Hi DBAs,
>
> In creating a standby database, do you need to backup the control file to
> standby at the same time you backup the database? I think the answer is
> yes, but I wanted to make sure.
>
>
>
> Rick Cale
> Database Administrator
> Team Health, Inc.
> 865-293-5425
> Rick_Cale@xxxxxxxxxxxxxx
>
>
>
Other related posts:
