OraFAQ Forum: Backup & Recovery » Backup of Archive log files

Home » RDBMS Server » Backup & Recovery » Backup of Archive log files (Oracle 10g 10.2.0.3.0 on linux 64 bit)

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

Backup of Archive log files [message #314928]

Fri, 18 April 2008 05:31

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

Hi,
I have production server and replication server (replication server is mainly used as data warehouse).
So the function of both servers are different. Both have their own Oracle database running on archive log mode.(Oracle 10.2.0.3.0).

I want to create archive log of Production database on second destination, just for backup on any storage device.

We also have NAS, so can i create archive in production as well as other storage like in NAS or Replication server. If i give second destination to Replication then does it affect functions of Replication database.

I do not want to create Standby database. Only want to store additional copy of archive in server other than production server for any mishap.

Report message to a moderator

Re: Backup of Archive log files [message #314934 is a reply to message #314928]

Fri, 18 April 2008 05:46

gopu_g
Messages: 54
Registered: March 2008
Location: mumbai

Member

you want to create a second destination for the archives in a seprate system

Report message to a moderator

Re: Backup of Archive log files [message #314939 is a reply to message #314934]

Fri, 18 April 2008 06:01

gopu_g
Messages: 54
Registered: March 2008
Location: mumbai

Member

hi,

it is possible.
Ship the log using NET 8 utility. you can have a look into the Standby database configuration it will give u a good idea how this is done.

LOG_ARCHIVE_DEST_1=”location=/u02/ica/arc1”

If you want you can specify second destination also

LOG_ARCHIVE_DEST_2=”location=/u02/ica/arc1”

if you want to keep the backup of the archives seperately, then you can go for RMAN to take the archive backups ups.why you want to keep the archivelogs in a seperate location.

Gopu

Report message to a moderator

Re: Backup of Archive log files [message #314945 is a reply to message #314939]

Fri, 18 April 2008 06:25

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

If i create second destination in my dataware house server. does it affect my dataware house database because i will be providing service name of datawarehouse server for destination 2.

And if i go for NAS, i donot have Oracle installed in NAS so how do i provide destination without service name.

I want to have seperate storage for archivelog because if production database is down(and there is no chance of its recovery) and i have RMAN backup in NAS then i will be able restore the database but if i want complete recovery i need to apply archivelog, so i will apply archive log to recover database from my second destination (NAS or dataware house).

[Updated on: Fri, 18 April 2008 06:30]

Report message to a moderator

Re: Backup of Archive log files [message #314968 is a reply to message #314928]

Fri, 18 April 2008 07:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>If i create second destination in my dataware house server
I see these words & have little idea what they mean.
What is a "destination"? Disk volume, database instance, schema, what it is?

Report message to a moderator

Re: Backup of Archive log files [message #314972 is a reply to message #314968]

Fri, 18 April 2008 07:41

gopu_g
Messages: 54
Registered: March 2008
Location: mumbai

Member

another disk volumm

Report message to a moderator

Re: Backup of Archive log files [message #314976 is a reply to message #314972]

Fri, 18 April 2008 07:46

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

yes it is disk volume

Report message to a moderator

Re: Backup of Archive log files [message #314989 is a reply to message #314928]

Fri, 18 April 2008 08:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Oracle (RDBMS) really does not know or care about any difference between NAS, SAN, raw, ASM, OCFS2, etc.

If Oracle can access its "stuff"; typically called files, it works as desired.
Oracle will only care about the "files" it has been told to use.
Oracle is oblivious to "files" that other processes may act against; unless & until it is told about the "new" files.

Do NOT make this more difficult that it alreadyis.

Report message to a moderator

Re: Backup of Archive log files [message #315008 is a reply to message #314989]

Fri, 18 April 2008 10:12

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

Could you please tell me one thing that how do i provide path of NAS server in log_archive_dest_2 parameter of in production server

Report message to a moderator

Re: Backup of Archive log files [message #315071 is a reply to message #314928]

Fri, 18 April 2008 17:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how do i provide path of NAS server in log_archive_dest_2 parameter

It will look similar to log_archive_dest_1's value but be contain the mount point where the NAS volume is mounted.

Since it is YOUR system, I don't have a clue to how the NAS is configured or specifically attached your system.

Report message to a moderator

Re: Backup of Archive log files [message #315470 is a reply to message #315071]

Mon, 21 April 2008 10:29

MIFI
Messages: 256
Registered: February 2008
Location: U.K.

Senior Member

If i am using Service name to create second copy of my Production database archive log to Test database folder, i will provide service name in Log_arch_dest_2

So where does it create the Archive log and does it affect my running Test database which is already in Archive log mode

Report message to a moderator

Previous Topic:	RMAN Duplicate & ORA-01152
Next Topic:	DATABASE ARCHITECTURE FOR APPLICATION

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 06:54:04 CST 2024