Re: Archivelog mode and receiving ORA-19602
Date: Tue, 19 May 2015 13:08:52 +0000
Message-ID: <1822215274.2276698.1432040931578.JavaMail.yahoo_at_mail.yahoo.com>
Hi Pavan, You are correct, it turns out I have 2 db instances running with the same sid hence the confusion. My restore script was passing the service name to connect to the database where I was using OS authentication through sqlplus/rman, so my restore script got the instance that the listener wasn't blocking, and I got the instance that the listener was blocking. The one I was connecting to was in archivelog mode and the one the script was connecting to was in noarchivelog mode. I'm just going to nuke the VM and start over, something funky must have happened during dbca (I swear I only ran it once...). Might have been some leftover files after deleting the last instance (with the same name). Thank you for your time, Stephen
From: pavan kumar <pavan_843_at_yahoo.co.in>
To: "dmarc-noreply_at_freelists.org" <dmarc-noreply_at_freelists.org>; Oracle-L Freelists <oracle-l_at_freelists.org>
Sent: Monday, May 18, 2015 9:08 PM
Subject: Re: Archivelog mode and receiving ORA-19602
Hi Stephen.
Are you sure that your database is in archive log mode.Can you re-confirm once ? to be on safeReason for asking : Since rman internal gets information from the database dictionary only, whether it's archive is enabled or not, it won't pickup from any where else.
- ThanksPavan Kumar N
From: stephen van linge <dmarc-noreply_at_freelists.org>
To: Oracle-L Freelists <oracle-l_at_freelists.org>
Sent: Tuesday, 19 May 2015 5:59 AM
Subject: Archivelog mode and receiving ORA-19602
Hi Oracle-L, I'm working in a playground database at the moment. It's a single instance 11gR2 (11.2.0.3) with no replication and currently running in archivelog mode, which I can verify with archive log list and by switching logfiles and having an archivelog created. The database was newly created. Now, when I attempt to run a simple rman copy incremental: backup incremental level 1 for recover of copy with tag 'daily_bkp' database plus archivelog; I receive the errors: channel ORA_DISK_1: starting datafile copy
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/19/2015 00:17:22
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run Which is clearly incorrect... There are so many... repetitive... questions on Google asking why when they're in noarchivelog mode they get this error, that I can't find anything relevant to my case. Has anyone experienced this before? Thanks, Stephen
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 19 2015 - 15:08:52 CEST