|
Home > Archive > Oracle Database Server > August 2005 > standby database on standard edition (once again) 10g
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
standby database on standard edition (once again) 10g
|
|
| Dariusz Adamiak 2005-08-30, 2:54 am |
| Hi everyone,
i still have a problem with building standby database with standard edition
oracle,
I am DBA beginner, i think very beginer...
could anyone help me?
in documentation is
1. backup the data file your primary database
2. create control file ...
3. archive the current on-line redo logs ...
4. transfer standby controlfile archived log files and backup data to the
remote (standby) site
5. maintaning the standby database
a)the standby database must be mounted and put in to standby recovery mode
....... /etc
BUT, how i should create this database, how can i recover from backup (my
backup procedure: backup database plus archivelog;),
becouse i think thats must be first,
....
regards
Dariusz
| |
| Holger Baer 2005-08-30, 2:54 am |
| Dariusz Adamiak wrote:
> Hi everyone,
> i still have a problem with building standby database with standard edition
> oracle,
> I am DBA beginner, i think very beginer...
> could anyone help me?
>
> in documentation is
> 1. backup the data file your primary database
> 2. create control file ...
> 3. archive the current on-line redo logs ...
> 4. transfer standby controlfile archived log files and backup data to the
> remote (standby) site
> 5. maintaning the standby database
> a)the standby database must be mounted and put in to standby recovery mode
> ...... /etc
>
>
>
> BUT, how i should create this database, how can i recover from backup (my
> backup procedure: backup database plus archivelog;),
> becouse i think thats must be first,
> ...
>
> regards
>
> Dariusz
>
>
OS?
Versions?
Holger
| |
| Holger Baer 2005-08-30, 8:08 am |
| Dariusz Adamiak wrote:
>
>
> Windows 2003 server
> Oracle Database 10g Release 1 10.1.0.2
>
>
>
The documentation on dataguard (Dataguard concepts and administration) is quite verbose on
the matter. You should follow that step by step.
You can find the documentation at
http://tahiti.oracle.com/
(Registration required, but the best investment you can make regarding oracle)
If you have trouble with specific steps, let us know but after you've read the relevant
documentation.
>
> btw. what is Oracle Database 10g Developer's Release 2
>
>
>
> Dariusz Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft
> Windows New! (03-Aug-05)
>
>
>
That's the public beta for the next Release. I found it quite amazing that the final linux version
made it in June and since then only a beta for Windows was made available.
However, Oracle Open World is in about 3 weeks, so I'd expect some more versions to be available
around that time.
Regards,
Holger
| |
| Dariusz Adamiak 2005-08-30, 5:59 pm |
|
----- Original Message -----
From: "Holger Baer" <holger.baer@science-computing.de>
Newsgroups: comp.databases.oracle.server
Sent: Tuesday, August 30, 2005 10:50 AM
Subject: Re: standby database on standard edition (once again) 10g
>
> The documentation on dataguard (Dataguard concepts and administration) is
> quite verbose on
> the matter. You should follow that step by step.
>
> You can find the documentation at
>
> http://tahiti.oracle.com/
>
> (Registration required, but the best investment you can make regarding
> oracle)
>
> If you have trouble with specific steps, let us know but after you've read
> the relevant
> documentation.
>
Hi, Thank You for help and patience,
I intented to do standby on standard version (no data guard) but ok, first
I try to follow procedure from Oracle Data Guard Concepts and
Administration, chapter 3 Creating a Physical Standby Database,
unfortunetly still dont know how should I create stanby from backup
there is:
3.2 Creating Physical Standby Database
3.2.1 backup database
3.2.2 creating contrlo file
3.2.3 initialization parameter (pfile)
!!3.2.4 copy files from primary system to the standby system!! /just system
copy backup, standby, initialization parameters/
3.2.5 set up envirnoment
step1 windows based service
step 2 create password file
step 3 create listener
step 4 enable broken connection detection
step 5 create ora net service names (for log transport i think)
step 6 create server parameter /standby/
and :::
3.2.6 start physical standby database
step 2 start physical standby database ( SQL> startup open read only)
/etc...
thats all? what for first i did backup?
or when i load backup or ....
or just i dont understand one thing, one small part of DBA....
heh sorry,
first i'll try with enterprise and Oracle Data Guard Concepts and
Administration step by step
regards
Dariusz
| |
| Holger Baer 2005-08-31, 7:50 am |
| Dariusz Adamiak wrote:
>
>
> Hi, Thank You for help and patience,
>
> I intented to do standby on standard version (no data guard) but ok, first
> I try to follow procedure from Oracle Data Guard Concepts and
> Administration, chapter 3 Creating a Physical Standby Database,
> unfortunetly still dont know how should I create stanby from backup
> there is:
> 3.2 Creating Physical Standby Database
> 3.2.1 backup database
> 3.2.2 creating contrlo file
> 3.2.3 initialization parameter (pfile)
> !!3.2.4 copy files from primary system to the standby system!! /just system
> copy backup, standby, initialization parameters/
> 3.2.5 set up envirnoment
> step1 windows based service
> step 2 create password file
> step 3 create listener
> step 4 enable broken connection detection
> step 5 create ora net service names (for log transport i think)
> step 6 create server parameter /standby/
>
> and :::
> 3.2.6 start physical standby database
> step 2 start physical standby database ( SQL> startup open read only)
> /etc...
>
> thats all? what for first i did backup?
> or when i load backup or ....
You made the backup, you put the files in place on the standby and you had your
controlfile created using 'alter database create standby controlfile...'
so yes, that's basically all there is to do.
I think your confusion comes from not really understanding what standby
does, which is simply put (although that changed quite a bit from 8i to 10g)
to apply all redo information to the standby destination. So you create
a backup, and tell oracle to constantly apply redo as soon as it finds it.
>
> or just i dont understand one thing, one small part of DBA....
> heh sorry,
It's confusing as long as one doesn't understand what the files involved
actually do, so I'd suggest a roundtrip to the concepts guide at tahiti.oracle.com.
>
> first i'll try with enterprise and Oracle Data Guard Concepts and
> Administration step by step
It certainly will make matters more easy. But so does understanding what you do ;-)
>
> regards
>
> Dariusz
>
>
Cheers,
Holger
|
|
|
|
|