Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Data Guard - Oracle9i Data Guard is the new name for Oracle8i Standby Database incorporating a large number of new features. This article discusses those relevant to the Oracle9i Database: New Features For Administrators OCP exam.



B. Djordjevic said...

The activation of Standby Datbase as :
ALTER DATABASE ACTIVATE STANDBY DATABASE;
doesn't work. That was a command in Oracle 8.
In Oracle 9 Data Guard Configuration must be done as follows:

alter database recover managed standby database finish skip

Tim... said...

It worked for me and it is in the manual:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/sql_stmts.htm#1007811

Cheers

Tim...

B. Djordjevic said...

Yes, I've tried and it works. But could you explain what we can do in case of emergence.
For example, primary DB is not accessible, standby is in maximal availability mode and we must activate standby site.
Q1: How we know what happened with last transaction on primary site (or we must
say to customer in which state is standby – new primary DB)?
Q2: How to make activation – recovery until last transaction (with data in
standby redo logs)?

Thanks

Tim... said...

Hi.

Please ask technical questions on the forum.

You can only bring the standby up to the point of the last log your received. Once there, you have to accept the data loss. If you are in maximum protection mode you should not have lost any commited data.

Cheers

Tim...

Gaby said...

Your site is realy very interesting!

vin said...

Standby setup information is very precise and useful.

Rupesh Gopani said...

The following command may give error at the time of switchover

ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;

Solution is :

ALTER SYSTEM SET job_queue_processes = 0 SCOPE=MEMORY;
ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;

Now the command will execute successfuly, dont know why..

Yuvraj said...

Great and Very very Userful sites for DBA's !!!

Keep updating
Cheers ...

Baski said...

You can have your standby upto date by running the dataguard in maximum protection mode, (ie with LGWR shipping with SYNC and AFFIRM attributes).

The 10gR2 real time apply will help to keep the standby up to date of primary.

Baski said...

You can have your standby upto date by running the dataguard in maximum protection mode, (ie with LGWR shipping with SYNC and AFFIRM attributes).

The 10gR2 real time apply will help to keep the standby up to date of primary.

pepito said...

Can somebody tell me the advantages from using a dataguard configuration on a RAC environment ?

I got RAC environment, with two nodes and two instances...then i create a logical stand by for my database on RAC....what advantages can bring me this ????


thank's....and sorry for my english.....

selvakumarmvs@gmail.com said...

hi,

1..after performing tablespace pitr on primary db, i got a error when i open standby database read only mode..shall i perform pitr on standby db???..

when you perform pitr ..scn is also change in primary db control file...but it does not change scn in standby db control file ..so i got a error..

2..I got a error when i perform tablespace pitr on primary db in max protection or max availability mode...shall i change the mode into max performance before doing pitr???????

thanks

Chris said...

Freaking awesome, best source of Oracle 9i CLI switchover.

K said...

Typo:
# Uncomment is filename conversion is needed

Correct:
# Uncomment if filename conversion is needed

Tim... said...

Typo corrected.

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired