OraFAQ Forum: Data Guard » Copying datafiles from primary to standby

Home » Server Options » Data Guard » Copying datafiles from primary to standby

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Copying datafiles from primary to standby [message #161066]

Wed, 01 March 2006 19:11

skarimi
Messages: 8
Registered: March 2006
Location: Australia

Junior Member

Hi,
I am new to oracle and my first task is setting up a Data Guard.
I am investigating how to set up a primary and a standby database.
After alter database archivelog on primary databse and
alter database force logging, I queried the v$DATAFILE to find out
which datafiles I need to copy from primary to standby database.

/*Primary database*/
select name from v$datafile;

/u01/app/oracle/oradata/solpro/system01.dbf
/u01/app/oracle/oradata/solpro/undotbs01.dbf
/u01/app/oracle/oradata/solpro/sysaux01.dbf
/u01/app/oracle/oradata/solpro/users01.dbf
/u01/app/oracle/oradata/solpro/SOLTEC_INDEX
/u01/app/oracle/oradata/solpro/SOLTEC_DATA

These are the datafiles on the standby database.

/*Standby database*/
select name from v$datafile;

/opt/oracle/oradata/solca/system01.dbf
/opt/oracle/oradata/solca/undotbs01.dbf
/opt/oracle/oradata/solca/sysaux01.dbf
/opt/oracle/oradata/solca/users01.dbf
/opt/oracle/oradata/solca/soltecdata
/opt/oracle/oradata/solca/soltecindex

My question now is:
The 2 last datafile names are different (SOLTEC_DATA and soltecdat...). It would mean that after copying I will have 8 data files on the standby database and 6 on the primary. Is this ok?

Thanks in advance
Shideh

Report message to a moderator

Re: Copying datafiles from primary to standby [message #161082 is a reply to message #161066]

Wed, 01 March 2006 22:50

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

I believe, you misinterpreted the documentation.

Standby database can not have any other datafiles other than primary's datafiles.

Standby database is created only after datafiles are copied from primary database but you already have datafiles.

Check the manuals for Data Guard again.

Report message to a moderator

Re: Copying datafiles from primary to standby [message #161090 is a reply to message #161082]

Wed, 01 March 2006 23:17

skarimi
Messages: 8
Registered: March 2006
Location: Australia

Junior Member

I have a primary database which is the production database and a standby database is the test databse. I am not creatinf a new database , the test database already exists I just need to make it as the standby database to the production. I am sure there is a way to do without creating a new database.

Report message to a moderator

Re: Copying datafiles from primary to standby [message #161092 is a reply to message #161090]

Wed, 01 March 2006 23:25

sach_sumit
Messages: 9
Registered: September 2005

Junior Member

Hi

I think you should read the oracle documentation

http://www.cs.umb.edu/cs634/ora9idocs/server.920/a96653/toc.htm

read 1st and 3rd chapter initially

Your preception of standby database is not correct.

Regards
Sumit Sachdeva

Report message to a moderator

Re: Copying datafiles from primary to standby [message #190095 is a reply to message #161090]

Tue, 29 August 2006 04:52

dinu_dba
Messages: 8
Registered: August 2006
Location: Hyderabad

Junior Member

hi u configure the stby database

Report message to a moderator

Previous Topic:	data guard gap monitoring script ASAP
Next Topic:	can Media Recovery in advance at standby,if yes and how?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 19:38:21 CDT 2024