RE: 10g standby database setup question
- From: Juan Miranda <jcmiranda@xxxxxxxxx>
- To: <maureen.english@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 4 Feb 2011 10:14:35 +0100
Hi
You don´t need to stop service at all.
All the parameters are dynamic and you can use a hotbackup.
Look at this doc:
Doc ID: 469493.1 Step By Step Guide To Create Physical Standby Database Using
RMAN
-----Mensaje original-----
De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En
nombre de Maureen English
Enviado el: jueves, 03 de febrero de 2011 23:21
Para: oracle-l@xxxxxxxxxxxxx
Asunto: 10g standby database setup question
I set up a test standby database and everything is fine. I now want to do the
same thing for our production database, but with the least amount of downtime.
The database is in archivelog mode and force logging is on.
I'm creating the standby log files and making a copy of the pfile, but I
haven't added any of the new parameters, yet (i.e. fal_server).
My plan is to take a backup of the database, copy the files to the standby
server, then on Sunday shutdown the production database, modify the parameters,
create a standby parameter file, create a standby control file, make the
listener mods I need and bring the production server back up, with the
log_archive_state for the standby destination set to 'defer' until I have the
standby created and ready to receive redo.
Does anyone see a problem with this plan? For the test system, I had all of
the parameters set before I did the database backup. I'm pretty sure that
won't make a difference, though....
- Maureen
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
