Home » Server Options » Data Guard » Copying datafiles from primary to standby
Copying datafiles from primary to standby [message #161066] Wed, 01 March 2006 19:11 Go to next message
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
Re: Copying datafiles from primary to standby [message #161082 is a reply to message #161066] Wed, 01 March 2006 22:50 Go to previous messageGo to next message
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.
Re: Copying datafiles from primary to standby [message #161090 is a reply to message #161082] Wed, 01 March 2006 23:17 Go to previous messageGo to next message
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.
Re: Copying datafiles from primary to standby [message #161092 is a reply to message #161090] Wed, 01 March 2006 23:25 Go to previous messageGo to next message
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
Re: Copying datafiles from primary to standby [message #190095 is a reply to message #161090] Tue, 29 August 2006 04:52 Go to previous message
dinu_dba
Messages: 8
Registered: August 2006
Location: Hyderabad
Junior Member

hi u configure the stby database
Previous Topic: data guard gap monitoring script ASAP
Next Topic: can Media Recovery in advance at standby,if yes and how?
Goto Forum:
  


Current Time: Sat Dec 10 05:00:08 CST 2016

Total time taken to generate the page: 0.11875 seconds