f



Archive logs files accumulating on my Oracle log mode Database

>From what I understand is that an Oracle log mode Database is the
recommended configuration for a production database.  However, the
problem we have is that Archive Logs files in the ..\RDBMS\ directory
are accumulating daily which has implications when you have limited
disk space.

How should these Archive log files be maintained? ie when should they
be deleted from the system? is there an automated procedure which will
remove the log files on a weekly basis?

I understand that there are two ways for performing a backup of the
oracle database,

1) cold backup (requires the oracle database to be shutdown)
2) hot backup

Should either of the above backup procedures automatically remove the
archive log files once backup has been completed?

Thanks in advance.
James

0
9/7/2005 10:50:45 AM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

4 Replies
1216 Views

Similar Articles

[PageSpeed] 6

Osso wrote:
>>From what I understand is that an Oracle log mode Database is the
> recommended configuration for a production database.  However, the

Not for all production systems... Data ware houses usually are easier
rebuilt than restored. Of course, apply common sense and *your*
requirements.

> problem we have is that Archive Logs files in the ..\RDBMS\ directory
You can configure that - pfile, or spfile - depending on version.
> are accumulating daily which has implications when you have limited
> disk space.
> 
> How should these Archive log files be maintained? ie when should they
> be deleted from the system? is there an automated procedure which will
> remove the log files on a weekly basis?
No - they actually are your lifeline. No auto-delete of a lifeline,
please.

> 
> I understand that there are two ways for performing a backup of the
> oracle database,
> 
> 1) cold backup (requires the oracle database to be shutdown)
> 2) hot backup
(requires the instance to be up and running)
> 
> Should either of the above backup procedures automatically remove the
> archive log files once backup has been completed?

Time to read up on concepts, and backup and recovery.
http://tahiti.oracle.com

And RMAN - nowadays the recommended way to back up oracle.

RMAN can move the archived redo logs from disk to backup medium,
whether that is disk or tape, if you like.
RMAN will automatically check for corruption; only backup data, not
empty files; it *knows* what is required to backup, and restore.
In short: RMAN is your friend. Maybe not yet, but will be soon.
-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
0
9/7/2005 11:53:46 AM
Thanks for your the quick response.

Just one point, surely once you have performed a backup of an oracle
database configured in archive log mode, any archive logs files
generated before the backup can be purged from the system?

After all the last backup operation should have brought the backup
files upto date?  however any archive logs files generated after the
backup should be kept so that if the system does fail, you can recover
the last backup performed, and roll the database forwards using the log
files to the point before the failure?

Regards
James

0
9/7/2005 12:38:04 PM
Frank van Bortel wrote:

> Osso wrote:
> 
[...]
>>How should these Archive log files be maintained? ie when should they
>>be deleted from the system? is there an automated procedure which will
>>remove the log files on a weekly basis?
> 
> No - they actually are your lifeline. No auto-delete of a lifeline,
> please.
> 
[...]

Except when using the Flash Recovery Area in version 10g! :-(

The OP does not mention version or platform, but there are plenty of 
uses for (and reasons to keep) archived redo log files besides 
recovering your most recent inconsistent backup.  They are well worth 
the space required -- as Frank pointed out you can have them saved 
anywhere you want, not only in the RDBMS directory (which in fact is not 
a very good place to save them).  And of course you need to save copies 
off-server along with your datafile backups.

I suggest you review (or create) your overall disaster recovery plan 
including hands-on testing, and then manage the archived redo log files 
within the requirements of your plan.

See also the following if you are on a Unix platform:
http://www.samag.com/documents/s=9797/sam0507a/0507a.htm

-Mark Bole



0
makbo (354)
9/7/2005 1:38:39 PM
Osso wrote:
> Thanks for your the quick response.
> 
> Just one point, surely once you have performed a backup of an oracle
> database configured in archive log mode, any archive logs files
> generated before the backup can be purged from the system?
> 
> After all the last backup operation should have brought the backup
> files upto date?  however any archive logs files generated after the
> backup should be kept so that if the system does fail, you can recover
> the last backup performed, and roll the database forwards using the log
> files to the point before the failure?
> 
> Regards
> James
> 
In theory, yes. But what if this backup proves to be
faulty? Ah - you have a previous backup, ok.
Ooops! Not the redo log files to go with it...

And remember: a "hot" backup is always an inconsistent backup.
Always. Inconsistent.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
0
9/7/2005 2:39:50 PM
Reply:

Similar Artilces:

Oracle database instance shutdown without logging in log file
oracle database instance shutdown without logging in log file. we have Oracle 10g(10.2.0.1)(HP DL380) databse server from Windows 2003 R2 for test/simulation purpose, we found that its shutting down the database sometimes unusally without any error/warning message in the SID alert log file. we observerd that the OS service for oracle is not starting the datbase server completely. Just after hitting start icon inside the services panel it displays the status "Starting", instead of "Started" and database is not in the "Open" state. So the method adopted to start the database from services as well using the "Startup" command from server manager utility. Why does this happen? On Apr 17, 12:19 pm, 7guru <7...@naver.com> wrote: > oracle database instance shutdown without logging in log file. > > we have Oracle 10g(10.2.0.1)(HP DL380) databse server from Windows > 2003 R2 for test/simulation purpose, > we found that its shutting down the database sometimes unusally > without any error/warning message in the SID alert log file. > > we observerd that the OS service for oracle is not starting the > datbase server completely. > Just after hitting start icon inside the services panel it displays > the status "Starting", instead of "Started" > and database is not in the "Open" state. > > So the method adopted to start the database from services as well > using t...

redo log file on Oracle 11g physical database
Parameter 'LOG_FILE_NAME_CONVERT' definition is: " Specify the location of the primary database online redo log files followed by the standby location. This parameter converts the path names of the primary database log files to the path names on the standby database. If the standby database is on the same system as the primary database or if the directory structure where the log files are located on the standby system is different from the primary system, then this parameter is required. Multiple pairs of paths may be specified by this parameter. " As I understand, if the redo log file directory and file name on physical site are the same as on primary site, I don't have to assign any value to this parameter. For example, if '/redo/redo1.log' is one of the redo log files on primary, at the time I create physical db, I just have to create this redo log file as '/redo/redo1.log' on physical site. Correct? Thanks! ...

Problem with Oracle standby database (automatic transfer of archived logs)
I am on HP UNIX 11 and still on Oracle 8.1.6.1 (cannot move to another version). I setup a standby database and am using Oracle's automatic mechanism to transfer archived logs from primary to standby database by setting: log_archive_dest_2='SERVICE=kdcsb OPTIONAL REOPEN=60' Before moving to production, I did testing of this setup for several months by manually switching an archived log every 15 minutes and everything ran fine. Now, I have moved to production and am finding this setup is not working: 1. Oracle sometimes only partial archived log causing recovery to fail on standby. 2. Oracle sometimes does not transfer archived logs at all, so standby database has some logs missing, i.e., logxxx92, logxxx94, logxxx95, logxxx97. There is no pattern here. I am in production now and I want this problem to be fixed quickly. Are there any options in log_archive_dest, which can be set to remove/ reduce this kind of error? Appreciate, any help. Thanks. On Feb 4, 11:39=A0am, zigzag...@yahoo.com wrote: > I am on HP UNIX 11 and still on Oracle 8.1.6.1 (cannot move to another > version). I setup a standby database and am using Oracle's automatic > mechanism to transfer archived logs from primary to standby =A0database > by setting: > > log_archive_dest_2=3D'SERVICE=3Dkdcsb OPTIONAL REOPEN=3D60' > > Before moving to production, I did testing of this setup for several > months by manually switching an archived log every 15 minu...

Re-logging into An Oracle Database
I am working on an Access 2002/Oracle vba automated overnight process. The problem is there is one user with rights to a certian set of tables and another user with a certain set of tables. I can't run the overnight process with just one login. Currently, I am having problems with relogging into the database with a different login. Even when I enter a different userid and password into a connection string, the system seems to still use to old login and password. Is there a better way to relog into the system? Here is the connection string I am using. "ODBC;DSN=dsnname;uid=user...

Relationship between Oracle log file size and Oracle performance
hi, Last day, I cleared our Oracle DB server network listener's log file, which is around 1.7GB. After doing that, I found I/O queue size decrease A =A3=CC=A3=CF=A3=D4, = while 'sar 3 5' shows wio keeps be to higher than 65%. The oracle version is 8.1.7 running on HP-UX 11i. I want to tune DB performance further. So, I want to know whether this relationship between Oracle perfromance and network listener log file size ? Is there any relationship between Oracle performance and redo log file size? (Our current redo log file size is 500MB, there are two redo logfile defined, show I try to increase the size to 1GB ? ) each word will be highly appreciated. Joe On Mar 7, 4:56 pm, "jshen....@gmail.com" <jshen....@gmail.com> wrote: > hi, > > Last day, I cleared our Oracle DB server network listener's log > file, which is around 1.7GB. > > After doing that, I found I/O queue size decrease A =A3=CC=A3=CF=A3=D4= , while 'sar > 3 5' shows wio keeps be to higher than 65%. > > The oracle version is 8.1.7 running on HP-UX 11i. > > I want to tune DB performance further. So, I want to know whether > this relationship between Oracle perfromance and network listener log > file size ? Is there any relationship between Oracle performance and > redo log file size? (Our current redo log file size is 500MB, there > are two redo logfile defined, show I try to increase the s...

How do I check which Oracle Patches are appplied to an Oracle DataBase Server
I would like to know if someone could help me with this topic, I'm traying to analize and chek which Oracle Patches are appplied to an Oracle DataBase Server >chek which Oracle Patches are appplied to an Oracle DataBase Server If they were applied with oPatch, then "opatch lsinventory" should show you what's there. If you did not use oPatch, then I have no clue. ;-) BD wrote: > >chek which Oracle Patches are appplied to an Oracle DataBase Server > > If they were applied with oPatch, then "opatch lsinventory" should show > you what's there. > > If you did not use oPatch, then I have no clue. ;-) For better or worse ( we know the answer ) opatch is the tool that install patches from oracle support. "If you did not use oPatch" ... what? >"If you did not use oPatch" ... what? In my 8i environments, there are separate scripts that are run - for example, for a cpu, it would be 'install_cpu.sh'. In those cases, I really don't know how (if) one can confirm which patches have been applied to an environment. ...

detach database, attach database without log file
If I detach a database on a server, then attach the database with a single file only using the data file...will I lose any transactions that were in the original log file? There is a debate going on here at work where some people think that during the detach, transactions in the log file are saved to the data file. Thanks! Hi You will not loose any committed transactions. Uncommitted transactions will normally be rolled back rolled back even if you attached the log file!! If this did happen it would be indicated in the SQL Server log file. John "DBA" <kaylisse@yahoo.com> ...

production database to test database, apply archive logs, online backup
if i take the production server backup (full) and restore to test server, and opened it. and then after some time, took the online backup of production with its control file , and restore to the test server, i am able to do so , right? also, i am able to apply archived logs after the online backup so that i have a latest production backup in the test server as the original production backup? Hi Yes You are doing a sort of standby database..remember you shouldnt be doing any transactions in your test database. regards Hrishy yls177@hotmail.com (yls177) wrote in message news:<c06e4d68.0404150445.2d9e2f99@posting.google.com>... > if i take the production server backup (full) and restore to test > server, and opened it. and then after some time, took the online > backup of production with its control file , and restore to the test > server, i am able to do so , right? > > also, i am able to apply archived logs after the online backup so that > i have a latest production backup in the test server as the original > production backup? hrishys@yahoo.co.uk (hrishy) wrote in message news:<4ef2a838.0404160014.26068408@posting.google.com>... > Hi Yes > > You are doing a sort of standby database..remember you shouldnt be > doing any transactions in your test database. > > regards > Hrishy > > yls177@hotmail.com (yls177) wrote in message news:<c06e4d68.0404150445.2d9e2f99@posting.google.com>... > > if i ta...

How to write shell script to export oracle 8.1.6 database to import oracle 10g database
Hi, I am trying to write or understand the conj process for export the data from oracle 8i to oracle 10g database. I have constraint that the previous loaded data into oracle10g should not be deleted or replace by newly imported database. Regards Nikhil ...

Restore of database file and log file
Hi, I have a Sybase Adaptive Server Anywhere 7 database running. I have a database file that is dated june 12, 2003 I have the database log file from yesterday. The backupsoftware have not backed up the database file since june 12 because it did not back up open files. So, can i merge my database file frome june 12 and my logfile from yesterday and have all the changes since june 12 committed ? If, so how do i do it ? Can't see any tools in the Sybase Central that can help me out... This is a library database and my librarian is not happy at the moment..... Hiya, If the transaction log has not been truncated since, I'd say you can apply the log file. Otherwise you can force the log using dbtran and translate it to SQL and apply the SQL to the database. This is a bit risky, you may miss a lot of transactions since the last checkpoint until the time this log got created. Cheers, Willy -- Posted via http://dbforums.com ...

Lag Time Between Log File Switch and Archive Log File
Colleagues: Has anyone experienced lag times after an automatic log switch happens and the time the archive log file appears in the archive log directory? I am running Oracle9i (9.2) on Solaris/UNIX. For additional information, below are SQL results of time differences between when the log switch happened and when the archive log file was written to disk. I welcome all ideas at your earliest convenience on this and thanks in advance. Donna BYTES NEXT_TIME COMPLETION_TIME LAG ---------------- -------------------- -------------------- ---------- 1,048,568,320 JUN-13-2006 00:28:20 JUN-13-2006 01:45:54 77 1,048,573,440 JUN-13-2006 01:11:11 JUN-13-2006 01:46:27 35 1,048,574,976 JUN-13-2006 01:26:43 JUN-13-2006 01:47:06 20 1,048,574,976 JUN-13-2006 01:29:18 JUN-13-2006 01:47:40 18 1,048,574,976 JUN-13-2006 01:41:32 JUN-13-2006 01:48:12 6 1,048,574,976 JUN-13-2006 01:45:54 JUN-13-2006 01:48:28 2 1,048,572,928 JUN-13-2006 02:08:46 JUN-13-2006 03:07:04 58 1,048,574,976 JUN-13-2006 02:23:27 JUN-13-2006 03:07:50 44 1,048,569,856 JUN-13-2006 02:38:10 JUN-13-2006 03:08:19 30 1,048,566,784 JUN-13-2006 02:42:02 JUN-13-2006 03:09:01 26 1,048,571,392 JUN-13-2006 03:04:52 JUN-13-2006 03:09:33 4 1,048,570,368 JUN-13-2006 03:44:33 JUN-13-2006 07:48:41 244 347,355,136 JUN-13-2006 04:44:29 JUN-13-2006 07:47:54 18...

left a database in recover mode, why is it not recognizing archive logs now?
I cloned a 10G database last thursday from an user managed online backup, rebuilt the control files, started up nomount and did the recover until cancel after copying over archivelogs from the production database the online backup was taken from. I left the database in this state, then today came in and copied over the rest of the archive logs from production that had been generated since thursday. I noticed that the recovery process was now looking in another folder for them, and it had already been created, so I copied the archived logs into this new directory, the only problem is, I now have to enter each filename and path as it won't recognize the file. For example it suggests "mypath\2008-10-20\01_MF_1_422x_%U_.arc" (x being latest #) and my logfiles are, for example, like this: "01_MF_1_422x_HMMZK88_.arc, with the last 5 letters/numbers before the last underscore changing with each log. I'm not sure why it is not accepting the suggestions now, I scrolled back to thursday in my cmd window and the archive logs were in a similar format but it was taking the suggestions ok. Not really a big deal, as I only have a couple of dozen more archives to apply to get it to the same as todays production, but I'm curious as to why this is happening, if on thursday the %U in the suggested filename worked fine, and today it is not. ...

moving oracle database server into a new server
Hi all I will be moving oracle from one Solaris server into another Solaris server, the IP address and box name will be changed. Oracle version is 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). Does any one know what I need to do in order to get oracle up and running again on the new server. I know that I will need to change the tnsnames.ora and listner.ora, but is there anything else that I need to do? Thanks Teresa Teresa wrote: > Hi all > > I will be moving oracle from one Solaris server into another Solaris > server, the IP address and box name will be changed. Oracle version is > 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). > Does any one know what I need to do in order to get oracle up and > running again on the new server. I know that I will need to change the > tnsnames.ora and listner.ora, but is there anything else that I need > to do? > > Thanks > Teresa When I do this with windows boxes I either: #1 Install oracle on the new box, create a new database and export/import from old db to new db #2 Copy datafiles, init, sqlnet, tns.. etc over from coldbackup or shutdown old_database, startup nomount and recreate the controlfile to fit new environment. #3 Restore from online backup of old_database and apply redo logs, again recreating the controlfile to fit the new env. (I usually only do this for "practice" and for creating a development copy of a prod db) #2 ...

Oracle databases on a server
I have Oracle installation on a SUN UNIX server. I tappears that it is running Oracle 10.2 and Solaris 8. I want to find out how many databases are installed on this server. Would it be true to say that all databases installed on this server are listed in tnsnames.ora where the 'HOST' entry points to this server? On Feb 20, 9:00=A0am, p...@qantas.com.au wrote: > I have Oracle installation on a SUN UNIX server. I tappears that it is > running Oracle 10.2 and Solaris 8. > > I want to find out how many databases are installed on this server. > > Would it be true to say that all databases installed on this server > are listed in tnsnames.ora where the 'HOST' entry points to this > server? No, these might be different *services* served by the same instance. The first place to look at is /var/opt/oracle/oratab file, which should list all Oracle instances on your host. If your Oracle installation follows OFA (Optimal Flexible Architecture,) which is usually true, count $ORACLE_BASE/admin/<dbname> directories - each database should have its own directory under admin. Alternatively, you can also count spfile<SID>.ora files in $ORACLE_HOME/dbs directory. Hth, Vladimir M. Zakharychev N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com On 20 Feb, 06:00, p...@qantas.com.au wrote: > I have Oracle installation on a SUN UNIX server. I tappears that it is > running Oracle 10.2 and Solaris 8. > > I want...

database in simple mode yet txn log file can be out of diskspace ?
Hi , I have set up my database to be using "Simple" mode. This will not log any txns ? I have got the err message saying the log file is full and i need to do a txn log backup i do not understand why , could anyone kindly advise ? tks & rdgs -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200510/1 Having you database in SIMPLE recovery mode does NOT mean that transactions are not logged. All it means is that all committed transactions are removed from the T-log when a checkpoint occurs. So if you run lot's of and es...

how to recover/restore a database using archive logs & control files 8i
I deleted a tablespace because it was not needed, now when I start up the instance I get the following; ORA-01113: file 12 needs media recovery If i use the command select * from v$datafiles, I can see the file in online mode, now I just want to rollback to yesterday's state We had a crash last night and I think the oringal datafile locked the system we do not have a back since friday, only an export? Can I use this? E etravels wrote: > I deleted a tablespace because it was not needed, now when I start up > the instance I get the following; > > ORA-01113: file 12 needs media recovery > > If i use the command select * from v$datafiles, I can see the file in > online mode, now I just want to rollback to yesterday's state > > We had a crash last night and I think the oringal datafile locked the > system > > we do not have a back since friday, only an export? Can I use this? > > E You don't say what version of Oracle or what OS you're on. That's critical info. You say you 'deleted' a tablespace, but it sounds like you simply deleted the OS file that implemented tha tablespace. Did you actually issue a DROP TABLESPACE command? That's also critical info. Until we know exactly what you did, and on what system, we'd just be guessing. E, your post is not very clear For starters what version of Oracle are you working with. If you are on 10g and have a flashback database area configured then ...

Add database to existing oracle database
Hi experts, I am new in oracle.I migrated one database from ms-access to oracle 9i using oracle migration utility on my local machine.But now i need to add this oracle database from my local machine to existing main database oracle 8i on main server.Pls. tell how i can add this database from my machine to main server. I think i can use export/import utility.But i never used this utility before, pls. tell what should i need to do.And if export/import is good way to migrate database pls. explain me in steps. I'll really appreciate your kind help. Pls. reply me soon, it's urgent!!! Thanks..so much Sonika "sonika" <sonika_sehrawat@yahoo.com> wrote in message news:709618ea.0409281225.1a09da58@posting.google.com... > Hi experts, > > I am new in oracle.I migrated one database from ms-access to oracle 9i > using oracle migration utility on my local machine.But now i need to > add this oracle database from my local machine to existing main > database oracle 8i on main server.Pls. tell how i can add this > database from my machine to main server. > I think i can use export/import utility.But i never used this utility > before, pls. tell what should i need to do.And if export/import is > good way to migrate database pls. explain me in steps. > > I'll really appreciate your kind help. > Pls. reply me soon, it's urgent!!! > > Thanks..so much > Sonika You are missing a lot of letters in your typing. You m...

Restoring Oracle 9.0.1 database from original files (server was rebuilt)
Here's my issue ... our database server was rebuilt but all the original files were backed up before the server was rebuilt. The server was shutdown correctly so I'm not worried about a bad shutdown but I've never done this before. It's on a Windows2000 box. I've reconfigured the server to the same way it was before, but I'm unsure which files and I should exclude and/or include to get the box running the way it was before. Can anyone point me in the right direction to an article that outlines how to do this? I'm more a developer than DBA, but I set up the original box and it ran great. Thanks, Joe On Mar 5, 7:01 pm, sandoval....@gmail.com wrote: > Here's my issue ... our database server was rebuilt but all the > original files were backed up before the server was rebuilt. The > server was shutdown correctly so I'm not worried about a bad shutdown > but I've never done this before. It's on a Windows2000 box. I've > reconfigured the server to the same way it was before, but I'm unsure > which files and I should exclude and/or include to get the box running > the way it was before. > > Can anyone point me in the right direction to an article that outlines > how to do this? I'm more a developer than DBA, but I set up the > original box and it ran great. > > Thanks, > Joe Define 'all the original files'. If these include your controlfiles you should be set, and ...

Dump Database / Porting Database to Oracle
Hi, I do not know much about informix. I have no running instance here, but its my job to transfer data from informix to oracle. - Is there a tool to dump a whoole database into an ASCII file? - In mysql there is a tool called "mysqldump" which dumps the whole database and create a file with sql statements (create, insert , insert ...), so you can transfer the whole database with mysqldump >file.sql and mysql <file.sql. Is there such a tool in informix? (I have seen that there is a infdump direcorty) - Is there a good way or a (cheap) tool to transfer a database from infomix to oracle? Best Regards Sven Anders, Digitec GmbH Sven Anders wrote: > Hi, > I do not know much about informix. I have no running instance here, > but its my job to transfer data from informix to oracle. > > - Is there a tool to dump a whoole database into an ASCII file? > > - In mysql there is a tool called "mysqldump" which dumps the whole > database and create a file with sql statements (create, insert , > insert ...), so > you can transfer the whole database with mysqldump >file.sql and mysql > <file.sql. Is there such a tool in informix? (I have seen that there > is a > infdump direcorty) dbexport > - Is there a good way or a (cheap) tool to transfer a database from > infomix to oracle? dbexport? -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi ...

Oracle 9i Database Server on Windows 2003 Server
I am wondering if we can install this Server on Windows 2003 Server without any problems. Is there anybody that did that before? Thanks in advance if someone know the answer. Yvon Bouchard, B. Sc. Computer Science Teacher http://info.cegepat.qc.ca/siteyvon I've installed it on windows 2003 enterprise ed. about 1 month ago without any problem. I've installed the version 9.2.0.1 with the patch to 9.2.0.3. 9.2.0.3 is the only version certified by oracle for win 2003. Ciao "Yvon Bouchard" <yvon.bouchard@cablevision.qc.ca> ha scritto nel messaggio news:QCLvb.21605$ZF1.2102185@news20.bellglobal.com... > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > > Yvon Bouchard, B. Sc. Computer Science > Teacher > http://info.cegepat.qc.ca/siteyvon > > > Yvon Bouchard wrote: > > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > Although I have not installed on Windows 2003 myself, I know of several such installations and all occurred without issue. I do note that Oracle has a separate download (CD set) for the WIndows 2003 compared to NT/2000/XP, so I suspect the install for the latter may not be ...

Data/Transaction log files for two databases have same file name
We have two db's. One live and one test. When I right click on the live one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\LIVE.MDF When I right click on the test one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\TEST.MDF Same thing applies to Transaction log files too. My concern is File Name is same in both the above cases even though the location is different. What are the consequences of this. Thanks for your help GVV Girish (kattukuyil@hotmail.co...

How to copy table from oracle database to sqlserver database ?
Hello, I need to copy a table from an 8i oracle database to a sqlserver 2000 database. Is it possible to use the command "COPY FROM ... TO ..." ? So, what is the correct syntax ? Thanks for your help Cyril "Cyril" <jewelk@free.fr> wrote in message news:cd38c3d6.0408100617.6f7b9f3e@posting.google.com... > Hello, > > I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > > Is it possible to use the command "COPY FROM ... TO ..." ? > So, what is the correct syntax ? > > > Thanks for your help > &...

Establishing connection from Oracle Database to DB2 database
Hi, Can any one help me in connecting oracle database to DB2 database oracle is on unix and DB2 is on AS400. Please guide me step by step on the same. Waiting for reply. Its critical umeshchoudhary@gmail.com (U C) wrote in news:d06590c8.0504252348.71a5c6f8@posting.google.com: > Hi, > Can any one help me in connecting oracle database to DB2 database > oracle is on unix and DB2 is on AS400. Please guide me step by step on > the same. > > Waiting for reply. Its critical > use PERL between the two DBs. >Hi, > Can any one help me in connecting oracle database to DB2 database >oracle is on unix and DB2 is on AS400. Please guide me step by step on >the same. >Waiting for reply. Its critical http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358 I have used this to example to connect to DB2. chet ...

How to copy table from oracle database to sqlserver database ?
Hello, I need to copy a table from an 8i oracle database to a sqlserver 2000 database. Is it possible to use the command "COPY FROM ... TO ..." ? So, what is the correct syntax ? Thanks for your help Cyril On 10 Aug 2004, jewelk@free.fr wrote: > Hello, > > I need to copy a table from an 8i oracle database to a > sqlserver 2000 database. A few options exist. If this is one-off, just use sqlldr to drop the data to a file and then bcp to get it into SQLServer. > Is it possible to use the command "COPY FROM ... TO ..." ? > So, what is the correct syntax ? Well, I'm sure SQLServer has connectivity to Oracle? If you want to go this route, use that and do this from SQLServer. -- Galen Boyer On 10 Aug 2004 07:15:16 -0700, jewelk@free.fr (Cyril) wrote: >Hello, > >I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > >Is it possible to use the command "COPY FROM ... TO ..." ? >So, what is the correct syntax ? > > >Thanks for your help > >Cyril Read up on using the Heterogeneous Gateway to Sqlserver. -- Sybrand Bakker, Senior Oracle DBA "Cyril" <jewelk@free.fr> wrote in message news:cd38c3d6.0408100615.6371b40e@posting.google.com... > Hello, > > I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > > Is it possible to use the command "...

Web resources about - Archive logs files accumulating on my Oracle log mode Database - comp.databases.oracle.server

"What I typically find with kid prodigies is that they come from this clinical, Western European way ...
"What I found with Joey is that he’s coming from a more intuitive, communal way of playing music, which is so beautiful to see." Joey [Alexander] ...

Check Out The Collection Of A Guy Who Started Accumulating Classic Apple Computers At Age 14
When Apple enthusiast Mark Peck was 14 he started collecting classic Apple computers. To share his collection with the world, Peck created the ...

Report: Teen "knockout" game accumulating victims
Police in Brooklyn say they are deploying more officers in one neighborhood after several people were attacked in "knockout" game

For teen meteorologist, expertise and a following are accumulating
Kennebec Journal & Morning Sentinel For teen meteorologist, expertise and a following are accumulating Kennebec Journal & Morning Sentinel ...


Congressional nays on military intervention in Syria still accumulating
USS Barry fires a Tomahawk missile during Libyan intervention in 2011. What with Russia, the U.S. and Syria possibly considering putting Syria's ...

Notebook brands turn conservative about accumulating orders to inland plants
While notebook ODMs become aggressive about building up their production capacities at plants in inland China to save costs, notebook vendors ...

Katy Perry Was The Most-Watched Musician On YouTube Last Year, Accumulating 2.4 Billion Views
Katy Perry rocked plenty of charts last year (as she always does), including the one that measured the most-watched channels on YouTube. The ...

Accumulating Snow Could Follow Rain in Ala., Miss.
Forecasters: Snow could follow days of rain in Alabama, Mississippi, other areas of South

A Marketer's Guide to Accumulating Awesome Online Reviews
The results of the Local Consumer Review Survey (2012) are in, and Search Engine Land pulled out some interesting pieces of data around the impact ...

Resources last updated: 3/20/2016 3:57:45 AM