Home » RDBMS Server » Backup & Recovery » Backup of Archive log files (Oracle 10g 10.2.0.3.0 on linux 64 bit)
Backup of Archive log files [message #314928] Fri, 18 April 2008 05:31 Go to next message
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.

Re: Backup of Archive log files [message #314934 is a reply to message #314928] Fri, 18 April 2008 05:46 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member


you want to create a second destination for the archives in a seprate system
Re: Backup of Archive log files [message #314939 is a reply to message #314934] Fri, 18 April 2008 06:01 Go to previous messageGo to next message
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

Re: Backup of Archive log files [message #314945 is a reply to message #314939] Fri, 18 April 2008 06:25 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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?
Re: Backup of Archive log files [message #314972 is a reply to message #314968] Fri, 18 April 2008 07:41 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member


another disk volumm
Re: Backup of Archive log files [message #314976 is a reply to message #314972] Fri, 18 April 2008 07:46 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
yes it is disk volume
Re: Backup of Archive log files [message #314989 is a reply to message #314928] Fri, 18 April 2008 08:19 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Backup of Archive log files [message #315008 is a reply to message #314989] Fri, 18 April 2008 10:12 Go to previous messageGo to next message
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
Re: Backup of Archive log files [message #315071 is a reply to message #314928] Fri, 18 April 2008 17:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.


Re: Backup of Archive log files [message #315470 is a reply to message #315071] Mon, 21 April 2008 10:29 Go to previous message
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
Previous Topic: RMAN Duplicate & ORA-01152
Next Topic: DATABASE ARCHITECTURE FOR APPLICATION
Goto Forum:
  


Current Time: Sat Dec 10 07:07:23 CST 2016

Total time taken to generate the page: 0.08158 seconds