RE: Dataguard setup
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <RStorey@xxxxxxxxxxxxxxxxxx>, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Dec 2010 13:31:20 -0500
Manual creation is not a problem, in short order:
1) Take a full database backup with log files on the primary site.
While #1 is running
2) Transfer the password file from the primary to the secondary
servers
3) Transfer the init.ora file from the primary to the secondary
making the appropriate changes on the way.
Once the backup is done
4) Use the "alter database create physical standby controlfile as
<>;" command to create your standby control file
5) Transfer the standby control file to the standby server
6) Transfer the backup done in 1 to the standby server
7) Place the standby control file in the specified directories and
file names as your init file
8) Make sure that your file systems match up in structure or set the
appropriate parameters in the init file
9) startup mount your standby database
10) Startup rman using nocatalog so you don't mess up your
repository (not fun)
11) Restore and recover the database up to the last sequence number
you backed up.
12) Create as many standby redo log files as you have redo logs +1
and make them the same size as your redo files
13) Alter database recover managed standby database using current
logfile disconnect;
14) Make sure your primary is enabled to ship redo to the standby
15) select process, client_process, sequence#, status from
v$managed_standby where sequence# is not null and sequence# > 0 order by
3; If you get something like:
PROCESS CLIENT_P SEQUENCE# STATUS
---------- -------- ----------- -------------
ARCH ARCH 3478 OPENING
ARCH ARCH 3496 CLOSING
MRP0 N/A 3497 WAIT_FOR_LOG
RFS LGWR 3497 WRITING
Your done. If you see "WAIT_FOR_LOG" with a different number than what
RFS is processing or no RFS process you've got trouble shooting to do.
A look at the alert log on both sides should tell you what is wrong.
Dick Goulet
Senior Oracle DBA
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Storey, Robert
(DCSO)
Sent: Tuesday, December 21, 2010 5:01 PM
To: oracle-l-freelists
Subject: Dataguard setup
As I begin pouring through the documents in what little spare time, can
someone tell me if, in 10g you can manually create and monitor a
Dataguard setup, or do you have to use Grid Control?
Thanks.
Other related posts:
