OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » help

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

help [message #161065]

Wed, 01 March 2006 19:08

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: help [message #161070 is a reply to message #161065]

Wed, 01 March 2006 19:41

alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com

Senior Member

No. Your standby database should be exactly as the same as the primary database. You'd better follow the oracle documents to do that.

Alex zeng

Report message to a moderator

Re: help [message #161071 is a reply to message #161070]

Wed, 01 March 2006 19:49

skarimi
Messages: 8
Registered: March 2006
Location: Australia

Junior Member

Hi Alex,
Thanks for your reply.
What do I do if it is not?
Which documentation should I follow? The articles I read on the net are only talking about coping the files to the standby environment when the database is shut downed.

Thanks in advance
Shideh

Report message to a moderator

Re: help [message #161072 is a reply to message #161071]

Wed, 01 March 2006 20:01

alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com

Senior Member

The online document link is
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ps.htm#SBYDB00200

Alex zeng

Report message to a moderator

Previous Topic:	rman backup + nfs mount
Next Topic:	Incomplete Recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 01:50:42 CDT 2024