Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
14 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: Backup & Recovery «» Posted on: Thu, 20 April 2017 01:22 «» By: Patel86
Not able to open database in Oracle
I am facing an issue where i am not able to open the database. Gettting the error "ORA-00312: online log 2 thread 1: '/u01/app/oracle/fast_recovery_area/XE/onlinelog/o1_mf_2_dgy5sxv5_.log'" Since i am unable to open the database, i cant do log...
4 Forum: Data Guard «» Posted on: Wed, 30 November 2016 21:31 «» By: shrinika
Re: dropping RAC standby database
I dropped RAC database manually.. I still see the DB name when i run crsctl status resource -t command. Here are the steps i followed.. Step1 shutdown both instance. SQL> select instance_name from v$instance; INSTANCE_NAME ------...
5 Forum: Backup & Recovery «» Posted on: Mon, 14 March 2016 22:04 «» By: ady_the495
ORA-01152: file 1 was not restored from a sufficiently old backup
HI, I have problem with create backup server use cold backup. With error i get when process backup like : ++++ Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. ORACLE instance shut down. Connected to an idle...
6 Forum: Server Administration «» Posted on: Wed, 29 April 2015 02:11 «» By: John Watson
Re: Default Undo vs Default Temp tablesapces
Can you execute those commands in mount mode? I can't:orclz> startup mount; ORACLE instance started. Total System Global Area 788529152 bytes Fixed Size 3050600 bytes Variable Size 373293976 bytes Database Buffers ...
7 Forum: General «» Posted on: Sun, 10 August 2014 05:55 «» By: aaditya321
Re: Coming problems in my sql plus
Eventually my problems has solved now, so I am giving thanks to all supportive person. Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\windows\system32>d: D:\>sqlplus/nolog SQL*Pl...
8 Forum: Backup & Recovery «» Posted on: Mon, 02 June 2014 15:42 «» By: cakeday
Re: after restore when trying to recover database.. it gives error
TEMPORARY TABLESPACE: What should i do about the temporary tablespace situation? i don't seem to have a valid temporary tablespace and when i try to create one, it says DB NOT OPEN. SQL> CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/p076/tmp001/tem...
9 Forum: Backup & Recovery «» Posted on: Wed, 03 July 2013 06:11 «» By: ishika_20
Re: Duplicate target database unable to open database
Dear Mahesh, Thanks for the link. I tried but still facing problem. Please help me out SQL> startup nomount; ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size ...
10 Forum: Backup & Recovery «» Posted on: Mon, 23 July 2012 11:05 «» By: jxh461
Re: Recovery of database from crashed host server
After doing further research, I actually introduced the parameter _allow_resetlogs_corruption=true in my pfile and this is the result: SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 23 11:44:14 2012 Copyright (c) 1982, 2005, Oracle. All...
11 Forum: Backup & Recovery «» Posted on: Wed, 16 May 2012 06:10 «» By: harshitaankur
ora-01194 file 1 needs more recovery to be consistentora-110
Hello sir , I am tring to open the database bur gettinf following errors ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF' SQL> shutdown O...
12 Forum: Backup & Recovery «» Posted on: Mon, 23 April 2012 09:26 «» By: priteshranjan.preet
Re: how tune the database
i make a clone of the database(oracle 10g 10.2.0.1.0)on os xp service pack2. i use the following code.plz help to let me know where i m wrong. please suggest me the appropriate solution. D:\>set ORACLE_SID=orcl D:\>sqlplus sys/oracle as sysdb...
13 Forum: Backup & Recovery «» Posted on: Thu, 22 March 2012 05:22 «» By: x-oracle
Re: ORA-19809: limit exceeded for recovery files
i also did this SQL> alter system set log_archive_dest_10='location=USE_DB_RECOVERY_FILE_DEST'; System altered. SQL> alter database open; alter database open * ERROR at line 1: ORA-16038: log 1 sequence# 277 cannot be archived ORA-19809...
14 Forum: Backup & Recovery «» Posted on: Thu, 22 March 2012 02:04 «» By: x-oracle
Re: ORA-19809: limit exceeded for recovery files
thanks for your reply michel i did this but still this same error so how much space i can be increase can you guide me SQL> show parameter db_recovery_file_dest NAME TYPE VALUE ------------------------------...

Current Time: Sun Jun 16 19:51:00 CDT 2019