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
…: /u1arch/archive/abc/abcarch_377825.arc ORA-00280: Change 353161828602 for thread 1 is in sequence #377825 SVRMGR> SVRMGR> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SVRMGR>…
2 Forum: Server Administration «» Posted on: Sun, 21 April 2019 20:38 «» By: reym21
Re: invalid datafile
…shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SVRMGR> The ABC database cannot be opened and I just ran another controlfile script to exclude the "/VOL02/oradata/abc/data/tas_data_lrg39.…
3 Forum: Backup & Recovery «» Posted on: Thu, 20 April 2017 01:22 «» By: Patel86
Not able to open database in Oracle
…SYSTEM SWITCH LOGFILE * ERROR at line 1: ORA-01109: database not open SQL> ALTER SYSTEM ARCHIVE LOG GROUP 2; ALTER SYSTEM ARCHIVE LOG GROUP 2 * ERROR at line 1: ORA-00259: log 2 of open instance XE (thread 1) is the current log, cannot …
4 Forum: Data Guard «» Posted on: Wed, 30 November 2016 21:31 «» By: shrinika
Re: dropping RAC standby database
…altered. SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount restrict ORACLE instance started. Total System Global Area 524288000 bytes Fixed Size …
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
…REUSE * ERROR at line 1: ORA-01109: database not open alter tablespace TEMP1 add tempfile '/d01/devadis01/temp04.dbf' REUSE * ERROR at line 1: ORA-01109: database not open alter tablespace TEMP1 add tempfile '/d01/devadis01/temp03.dbf' …
6 Forum: Server Administration «» Posted on: Wed, 29 April 2015 02:11 «» By: John Watson
Re: Default Undo vs Default Temp tablesapces
…pluggable database not open: queries allowed on fixed tables or views only orclz> alter database default temporary tablespace temp; alter database default temporary tablespace temp * ERROR at line 1: ORA-01109: database not open orclz>…
7 Forum: General «» Posted on: Sun, 10 August 2014 05:55 «» By: aaditya321
Re: Coming problems in my sql plus
…shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 289406976 bytes Fixed Size 1290184 bytes Variable Size…
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
…200M AUTOEXTEND OFF * ERROR at line 1: ORA-01109: database not open = = = = when i look at v$tempfile, the tempfiles are from the source database.. PLEASE HELP!SQL> select name from v$tempfile; NAME…
9 Forum: Backup & Recovery «» Posted on: Wed, 03 July 2013 06:11 «» By: ishika_20
Re: Duplicate target database unable to open database
…Mining options SQL> shut immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup nomount; ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size …
10 Forum: Backup & Recovery «» Posted on: Mon, 23 July 2012 11:05 «» By: jxh461
Re: Recovery of database from crashed host server
…[b]shutdown immediate[/b] ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> [b]startup[/b] ORACLE instance started. Total System Global Area 612368384 bytes Fixed Size 1250428 bytes …
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
…shutdown ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 289406976 bytes Fixed Size 1248576 bytes Variable Size …
12 Forum: Backup & Recovery «» Posted on: Mon, 23 April 2012 09:26 «» By: priteshranjan.preet
Re: how tune the database
…at line 1: ORA-01109: database not open ORA-01081: cannot start already-running ORACLE - shut it down first SP2-0042: unknown command "DATAFILE" - rest of line ignored. SP2-0734: unknown command beginning "'D:\ORACLE..." - rest…
13 Forum: Backup & Recovery «» Posted on: Thu, 22 March 2012 05:22 «» By: x-oracle
Re: ORA-19809: limit exceeded for recovery files
…shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> starup SP2-0042: unknown command "starup" - rest of line ignored. SQL> startup ORACLE instance started. Total System Global…
14 Forum: Backup & Recovery «» Posted on: Thu, 22 March 2012 02:04 «» By: x-oracle
Re: ORA-19809: limit exceeded for recovery files
…system switch logfile * ERROR at line 1: ORA-01109: database not open SQL> alter database open; alter database open * ERROR at line 1: ORA-16014: log 1 sequence# 277 not archived, no available destinations ORA-00312: online log 1 thread 1…

Current Time: Sat Dec 14 01:35:24 CST 2019