Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
13 Search Results Found
1 Forum: Server Administration «» Posted on: Mon, 22 April 2019 01:55 «» By: reym21
Re: invalid datafile
@John Watson Sir how about the codes below: 1st run ============================================================== SVRMGR> @abc_recreate_ctlf_20190416.sql ORACLE instance started. CREATE CONTROLFILE REUSE DATABASE "ABC" NORESETLOGS...
2 Forum: Server Administration «» Posted on: Sun, 21 April 2019 20:38 «» By: reym21
Re: invalid datafile
@gazzag Sir, I re-run my recreate control file scripts, eliminating the problematic "MISSING" datafiles and included 1 file, re: "/VOL02/oradata/abc/data/tas_data_lrg39.dbf" Please refer below: 1st run ======================...
3 Forum: Data Guard «» Posted on: Fri, 28 September 2018 08:05 «» By: muthukrish104
ORA-00308: -- DR looking for older archive logfiles
Hello All, We are trying to make a Physical Standby DR (with manual mode - transferring and applying archive log manually). But it looks for older archive log, which is not there in primary and the query also not showing it. Here is the steps we d...
4 Forum: Backup & Recovery «» Posted on: Thu, 25 January 2018 18:28 «» By: juniordbanewbie
Re: Cannot drop undotbs2 when restoring 10.2.0.4 rac db to 11.2.0.4 single instance db
Dear all, I discover the main issues here is not so much why I cannot drop undotbs2. I have to drop undotbs2 only after upgrading to 11.2.0.4 successfully. the main show stopper for not being able to upgrade is because I not able to recover up to the...
5 Forum: Backup & Recovery «» Posted on: Sun, 28 May 2017 19:43 «» By: ulvi_ugur
Re: Oracle SYSAUX UNDO tablespaces corrupt
Ok, finally I could run this now. The console looks like this : SQL> startup mount pfile='C:\Users\ulvi\init.ora'; ORACLE instance started. Total System Global Area 2.1179E+10 bytes Fixed Size 2185032 bytes Variable Size ...
6 Forum: Backup & Recovery «» Posted on: Wed, 19 April 2017 23:43 «» By: 1982Hashmi
Manual Hot Backup in Oracle 11gR2
I want to take & restore from hot backup without using RMAN. But It generates error at Step No. 7 while restoring. Can anybody help with that. ================================================================================== ...
7 Forum: Backup & Recovery «» Posted on: Thu, 27 November 2014 00:35 «» By: Michel Cadot
Re: Restore & Recover Oracle Database with zero lose data
ORA-00279: change %s generated at %s needed for thread %s *Cause: The requested log is required to proceed with recovery. *Action: Please supply the requested log with "ALTER DATABASE RECOVER LOGFILE <file_name>" or c...
8 Forum: Backup & Recovery «» Posted on: Tue, 09 September 2014 14:06 «» By: HIMUAHMED86
resetlogs or noresetlogs
SQL> STARTUP ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1375792 bytes Variable Size 662700496 bytes Database Buffers 402653184 bytes Redo Buffers 4603904 byt...
9 Forum: Backup & Recovery «» Posted on: Thu, 03 January 2013 07:39 «» By: abdulaziz
Re: trying to recover but lattest archive file missing
Hello, Here is what I did and got: SQL*Plus: Release 11.2.0.2.0 Production on Mer. Janv. 2 17:16:29 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> conn sys as sysdba Enter password: Connected. SQL> alter database open; ...
10 Forum: Backup & Recovery «» Posted on: Tue, 31 July 2012 12:19 «» By: drumboy
Flash Recovery ->SYSTEM.DBF
Hi! How can I repair the C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF file? Drumboy sqlplus SQL*Plus: Release 11.2.0.2.0 Beta on K. J˙l. 31 18:43:26 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: /as sysdba ...
11 Forum: Backup & Recovery «» Posted on: Thu, 19 July 2012 23:18 «» By: jxh461
Re: Need to restore database, have all files
After installing the software. Here is the script I am using to create the control file. STARTUP NOMOUNT CREATE CONTROLFILE SET DATABASE "ORCL" RESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINS...
12 Forum: Backup & Recovery «» Posted on: Fri, 11 May 2012 10:45 «» By: Seant
Re: ORA-01113: file 5 needs media recovery
Michel, I ran recover database command and got this SQL> recover database ORA-00279: change 3660589 generated at 05/10/2012 11:10:26 needed for thread 1 ORA-00289: suggestion : C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\SPF433\ARCHIVELOG\2012_0...
13 Forum: Backup & Recovery «» Posted on: Tue, 24 January 2012 17:38 «» By: meetdileep
Re: Recovery using copied oracle folder
As advised by you i have executed like this SQL> recover database until cancel; ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done SQL> recover database until cancel u...

Current Time: Wed Jun 19 16:45:08 CDT 2019