Re: Interesting lesson on ARCHIVELOG mode

2003-04-03 Thread Richard Foote
q Tru64 > Unix / Oracle 8.1.7.4. > > A few days ago, I remember talking to a junior DBA who assists me in the > Oracle area, concerning excessive space usage on one of the Unix machines > running a test database environment. I noted that the database was running > in ARCHIVELOG

RE: Interesting lesson on ARCHIVELOG mode

2003-04-03 Thread Biswas, Pradip
Good Posting, JIM . I had once gone thru the exactly same experience. Oracle database has some processes that work both independently , but again, they work in tandem. Here is the peice where LGWR (in Archivelog) and ARCH(s) are expected to work in tandem with each other (in ARCHIVELOG mode

Interesting lesson on ARCHIVELOG mode

2003-04-02 Thread James Damiano
the Oracle area, concerning excessive space usage on one of the Unix machines running a test database environment. I noted that the database was running in ARCHIVELOG mode with automatic archiving (of course), and generating a great many archived logs since there was considerable activity on that

RE: archivelog mode

2002-03-08 Thread Ron Yount
: Friday, March 08, 2002 6:03 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: archivelog mode > > > Try using: LOG_ARCHIVE_DEST instead of LOG_ARCHIVE_DEST_1 > If you would like using LOG_ARCHIVE_DEST_1 you have to read the in Oracle > Doc the syntax for it since

RE: archivelog mode

2002-03-08 Thread Khedr, Waleed
: Multiple recipients of list ORACLE-L Hi All While enabling automatic archiving on our 8.1.7 database I get the following error :- ORA-00439: feature not enabled: Managed Standby ie the database is in archivelog mode and I edit the parameter file to enable automatic archiving .. I get the error when

archivelog mode

2002-03-08 Thread Sajid Iqbal
Hi All While enabling automatic archiving on our 8.1.7 database I get the following error :- ORA-00439: feature not enabled: Managed Standby ie the database is in archivelog mode and I edit the parameter file to enable automatic archiving .. I get the error when trying to startup the database

Re: Shutdown and archivelog mode

2001-09-03 Thread A. Bardeen
Sajid, The db must be cleanly shutdown (normal or immediate) in order to change the archivelog mode. A shutdown immediate may not shutdown immediately for several reasons, most commonly: 1. There is an uncommitted transaction that needs to roll back. 2. SMON is deallocating temp segments

Re: Shutdown and archivelog mode

2001-09-03 Thread Saurabh Sharma
do a shutdown normal ALWAYS after issuing a shutdown abort. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, September 03, 2001 3:16 PM > Hi > > Using Oracle 8.1.6.3 on solaris 2.7. > > I am trying to put my databa

Shutdown and archivelog mode

2001-09-03 Thread Sajid Iqbal
Hi Using Oracle 8.1.6.3 on solaris 2.7. I am trying to put my database in archivelog mode. When I try to shutdown the database using shutdown immediate, it just sits there for ages.. (left it for 30 mins). I've cancelled this and done a shutdown abort. (tried normal shutdown after that,

Re: Database in archivelog mode

2001-06-21 Thread Saurabh Sharma
ple recipients of list ORACLE-L Sent by: <[EMAIL PROTECTED]> root@fatcity.cc: com Subject: Database in archivelog mode 22-Jun-2001

Re: Database in archivelog mode

2001-06-21 Thread Ravinder_Bahadur
Subject: Database in archivelog mode

Database in archivelog mode THANX

2001-06-21 Thread murosa
I've got solution from 1062786.6 note of Metalink. Thank you very much to all who reply to me. Best regards. Miguel Urosa. "Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener informaci

Database in archivelog mode

2001-06-21 Thread murosa
Hi folks. I have a very strange behavour in a database. I want to put database inarchivelogmode, I've changed log_archive_start to true, log_archive_dest_1 to a location where I can write and log_archive_start to true. Then I follow next seq