My database is in open and noarchive log mode which was working fine but since from last 2 to 3 days it is throwing me an error
ORA-00308: cannot open archived log with ora -00600
ORA-00308: cannot open archived log 'D:\HFTEST\ARCHIVE\ARC1_779994432.1'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00600: internal error code, arguments: [kewrsp_split_partition_2], [87], [902828405], [11905], [], [], [], [], [], [], [], []
My database is in open and noarchive log mode which was working fine but since from last 2 to 3 days it is throwing me an error ORA-00308: cannot open archived log with ora -00600
ORA-00308: cannot open archived log 'D:\HFTEST\ARCHIVE\ARC1_779994432.1' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified. ORA-00600: internal error code, arguments: [kewrsp_split_partition_2], [87], [902828405], [11905], [], [], [], [], [], [], [], []
I dont understand why it so, i googled it but i didnt find anything.
I want to create a wallet on RAC setup.I have two node setup.I have created the wallet directory under shared folder /u01/oradata/$ORACLE_SID/wallet
I am Unable to open wallet.I tried this using the below command
SQL> alter system set encryption key identified by "aryabhat"; alter system set encryption key identified by "aryabhat" * ERROR at line 1: ORA-28353: failed to open wallet
i'm trying to write a pl/sql to find all missing archived logs that are need for streams replication.
There is already a oracle metalink note for this. But yet it would give only the archive log name that contains my dba_capture.start_scn and we need to check if the files exist in disk or not!
The problem here is, when using ASM, dba_registered_archived_log view is truncation the file name and it is really difficult to pin point the logs. So is it fine to join this view with V$archived_log? is deleted and status column would do the trick? I modified the plsql as below. Is this fine/accurate?
CODEdbms_output.put_line('Capture will restart from SCN ' || lScn ||' in the following file:'); for cr in (select decode (a.name, NULL, 'NOT FOUND', a.name) name, to_char(a.completion_time, 'hh42:mi:ss') completion_time from v$archived_log a,dba_registered_archived_log b where lscn between b.first_scn and b.next_scn and a.deleted = 'YES' and a.status != 'A') loop f_rec :=1; [code]......
Assuming you have a 9i database . where you have it enabled in archive mode , yet constantly deleting the archived redo logs , due to space constraints .
Will you be able to perform a full level 0 backup , and the following incremental backups , in the absence of the archived redo logs ? And are these incremental backups enough to recover the database or particular data files , to the point of the backup itself at least ?
I have recently installed a oracle 11g r2 standard edition in aix 6.1.database is on archive log but archived log is generated in daily different folder named after date on system.
i want to generate all archive log in only one folder.
here i have an question with oracle database backup strategy.my question is
how to backup my oracle database call DB11G without archived logs while the database is open for user activity and also this should be the base for an incremental backup strategy?
Backup your entire database, without archived logs, while the database is open for user activity. This backup should be the base for an incremental backup strategy
ORA-16038: log 2 sequence# 284 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 2 thread 1: /redo02.log' USER (ospid: 792): terminating the instance due to error 16038 Fri Nov 02 13:14:19 2012 System state dump requested by (instance=1, osid=792), summary=[abnormal instance termination].
Fri Nov 02 13:14:19 2012 ARC3 started with pid=23, OS id=822 Errors in file _ora_792.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 10240 bytes is 100.00% used, and has 0 remaining bytes available.
I ran into the message RMAN-08138: WARNING: archived log not deleted - must create more backups during a backup. From what I understand this is caused when logs are removed that are needed for recovery.
rman target / nocatalog <<EOT CONFIGURE CHANNEL DEVICE TYPE DISK clear ; CONFIGURE CHANNEL DEVICE TYPE TAPE clear ; CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear ; CONFIGURE RETENTION POLICY TO recovery window of 14 days; CONFIGURE BACKUP OPTIMIZATION OFF; CONFIGURE DEFAULT DEVICE TYPE TO DISK;
The GAP archived log can not transport to target database by auto, how can i do?
Sun May 27 06:32:59 2012 FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 161-161 DBID 1820932955 branch 775456988 FAL[client]: All defined FAL servers have been attempted. -------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter is defined to a value that is sufficiently large enough to maintain adequate log switch information to resolve archivelog gaps.
i perform logminer in os (window xp and oracle linux 6) both. all the operation are successfully completed but at last i found the same error in both os. the error is
SQL> create table myLogAnalysis as select * from v$logmnr_contents; select * from v$logmnr_contents * ERROR at line 3: ORA-00310: archived log contains sequence 12; sequence 9 required ORA-00334: archived log:'/home/oracle/oracle/product/10.2.0/oradata/orcl/redo02.log'
I'm running Oracle 9i on AIX 5.2. I'm not using a recovery catalog, nor am I using media management software. I perform a full, online rman backup of the database and archived redo logs daily to disk, then use operating system commands to copy the backup to tape. There is only space on disk for two days' backups, so I need to have a retention policy of "redundancy = 1", and run a "delete obsolete" prior to the backup. The problem is that I don't want to subject the archived redo logs to this retention policy.
I have two physical standby databases connected by WAN to the primary site, and I might need archived redo logs that are a few days (or more) old in the event of a prolonged WAN outage. I've read about the "keep forever" option, but apparently it isn't available without using a recovery catalog. Is there any way to spare the archived redo logs from my retention policy?
Note: I want to "protect" the actual archived redo logs from the retention policy, not the backups of the archived redo logs.
I got a database on dataguard and my primary (db1) is shipping files to my standby (db2) with no problems.However, when I query:
select sequence#, status, applied from v$archived_log;
I see this: SEQUENCE# S APP ---------- - --- 4 A YES 5 A YES 6 A YES 7 A YES 8 A YES 9 A YES 10 A YES 11 A YES 12 A YES 13 A YES 14 A YES [code]....
So I did an alter system switch logfile on db1 then looked again and I can see new archived logs being applied.I thought all archived logs had to be applied on the standby since this is the very foundation of the standby database.Am I going to run in trouble later if I have a failover (unsynchronized database)
1) How to copy the ARCHIVED LOG FILE from Primary to DR location. Where if the DR is having the file already, how to SKIP that Particular Archived log file? 2) I have Checked with the FILE_TRANSFER DBMS package, but it gives the error if any file existing already.
SQL> select open_mode from v$database; OPEN_MODE ---------- MOUNTED SQL> alter database open; alter database open * ERROR at line 1: ORA-16014: log 2 sequence# 80 not archived, no available destinations ORA-00312: online log 2 thread 1: 'E:ORACLEPRODUCT10.2.0ORADATAMOONREDO02.LOG' ..
I wanted to make a script for applying the Archived log File in to DR by certain interval.
1) I will use the below view for finding the SEQUENCE so far applied.select sequence# from v$log_archive. 2) But how i can compare with the archive log files available in physical location with the above mentioned view.
eg:- the above view shows, the till the sequence 46789 is applied.And in the DR physical Location available sequences are 46795. which means 6 more archived log files are more, which are not applied into the DR so far.
URL....I'm practicing for the OCP test and one of the questions is that there is a backup from yesterday and the last archived logs are from the day before yesterday not mentioned if it's cold or hot backup.
If its a cold backup - cant we recover it? is it a must to have the archived redo logs also when recovering a cold backup? That sounds not logical since those logs are made only for a hot backup. URL.....
1> Does dataguard in 10g use ftp/rsh to transfer archived log files to standby database or some other protocol?
2> In my primary database, archives are getting generated normally, there is no error in alert log file. But archives are not getting transferred to standby database. I am able to connect through sys user from primary server to standby database & vice versa.
Also, tnsping is working fine.
All was working fine till 2 days back & no parameter has been changed from database side. I am not able to transfer the file manually through FTP to standby server. Does it is the problem? Or dataguard doesnt use FTP protocol to transfer the files?
I've got a legacy SAP system with oracle 8i on Tru64. No changes at all are made but for legal reasons we have to keep it up and running.
we currently do a full backup monthly by shutting down oracle and doing a backup of all the files to tape and that takes around 12 hours.
If I stop doing the full backup and I only backup the control file and the archived redo log files every month and I had to restore the full database years from now, would I be able to restore the database using the last full monthly backup and use the latest control file and archived redo log files?
Backup entire database, without archived logs, while the database is open for user activity and also This backup should be the base for an incremental backup strategy.
RUN {ALLOCATE CHANNEL CH0 TYPE 'sbt_tape'; BACKUP DATABASE FORCE PLUS ARCHIVELOG FORCE NOT BACKED UP DELETE INPUT; RELEASE CHANNEL CH0; }
Then I ran the restore, it failed with Quote:RMAN-06054: media recovery requesting unknown archived log....
When I backup archivelogs and choose to delete the input, it does not delete the multiplexed copy, but the specific file being backed up.So, ideally it should find it in Flah Area or at least in the backed up pieces which are there with it.Still why is it failing?
Also, in recovery, it is deleting the archived log after applying, RMAN does this if we use recover... delete archivelog command.I am using only RECOVER, still in output I can see RMAN deleting the log after it has applied it. WHY?
i, I've Two database one for primary(GISC) and one for standby (GISCST) when i start open standby database i appeare erro :
ORA-16004: backup database requires recovery ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCLSB\SYSTEM01.DBF'
I take the copy the datafiles from primary database and Pase them to the Standby database and the Enviroment of two database is :
SPfile for primary(GISC) IS: *.compatible='10.2.0.3' *.control_files='C:\oracle\product\10.2.0\oradata\gisc\CONTROL01.CTL','C:\oracle\product\10.2.0\oradata\gisc\CONTROL02.CTL','C:\oracle\product\10.2.0\oradata\gisc\CONTROL03.CTL' *.db_block_size=8192 [code]....
