Website Builder. SQL> shutdown abort; hmm The images we are restoring are not from the hotbackup which is backed by using backup exec, they are instead from images created by using symantec system recovery which is run as a seperate backup. Find answers to Oracle database not mounted? Redo Buffers 7135232 bytes Just saw your attachment, reviewing it now. Change ), Hosting solutions Fixed Size 1250428 bytes (Unlock this solution with a 7-day Free Trial). You must either back them up in hot backup mode (requires RMAN or sql commands to be issued to the live database) or tell Symantec to ignore the oradata completely, and use RMAN or sql commands to do the Oracle portion of the system backup, which copies the backupsets or images to another directory (RMAN uses the FRA - Flash Recovery Area) then copy only the backupsets in the FRA with Symantec. Change ), You are commenting using your Facebook account. su - oracle sqlplus / as sysdba create user username identified by password; Exception : ORA-01109 Database not open ORACLE instance shut down. Database fails to start on
due to ORA-01618: redo thread 2 is not enabled - cannot mount (Doc ID 1677362.1) Last updated on DECEMBER 19, 2019. Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 29 11:17:11 2011, connected to target database: JOHNSON (DBID=2710984504, not open), Starting recover at 29-APR-11 ORA-01507: database not mounted. Variable Size 167775108 bytes using target database control file instead of recovery catalog database name (or database unique name) used for search: JOHNSON ( Log Out / Domain Registration Finished recover at 29-APR-11, ----For cross check whether your database was recovered successfully or not, shut it down and start. What should we do to fix it: If you are using the ALTER DATABASE statement via the SQLDBA startup command, specify the MOUNT option to startup; else if you are directly doing an ALTER DATABASE DISMOUNT, do nothing; else specify the MOUNT option to ALTER DATABASE… SQL> startup nomount pfile='c:/initnew.ora'; SQL> create spfile from pfile='c:/initnew.ora'; SQL> shutdown immediate; EA\JOHNSON\AUTOBACKUP\2011_04_29\O1_MF_N_749732909_6VNMPQVT_.BKP Change ), You are commenting using your Twitter account. We help IT Professionals succeed at work. Total System Global Area 612368384 bytes This award recognizes tech experts who passionately share their knowledge with the community and go the extra mile with helpful contributions. Database opened. SQL> startup mount; ORACLE instance started. What triggered the Error: A command was attempted that requires the database to be mounted. SQL>. Our community of experts have been thoroughly vetted for their expertise and industry experience. SQL> startup mount; Neither of the alert logs you provided indicate Oracle errors or anything wrong as far as opening the database. SQL> The show users script that i used was just to test a connection to the oracel database, the main issue is we are not able to use our ERP software (that connects to oracle) it just hangs. SQL> ho rman target /, Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 29 11:15:50 2011. Checking settings of the fast recovery area of source and clone database I found that the FRA of source database was set to 18TB and clone database had only 1TB of FRA. The script was written to do a hot backup of the oracel files into another folder, then at 10PM symantec backup exec 11 backs up all drives. Total System Global Area 8100614144 bytes Fixed Size 2269272 bytes Variable Size 4194308008 bytes Database Buffers 3892314112 bytes Redo Buffers 11722752 bytes Database mounted. Backup controlfile: >>your saying this scirpt is doing something incorrectly and could be cuasing the problems? most all v$ views, based on x$ tables, are in memory data structures, not disk. . . We decided for now to leave this orginal backup in place in case the symantec system recovery backup doesnt work correctly. Description:ORA-01507 database not mounted Cause: A command was attempted that requires the database to be mounted. using target database control file instead of recovery catalog . channel ORA_DISK_1: autobackup found in the recovery area database block size - does it really matter? ( Log Out / Variable Size 167775108 bytes ORA-01507: database not mounted. version 2798. channel ORA_DISK_1: sid=156 devtype=DISK, recovery area destination: D:\oracle\product\10.2.0/flash_recovery_area cataloging done Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.1 and later Oracle Database Cloud Schema Service - Version N/A and later I guess i could try stopping the hot backup scripts from running, although i have tried creating an image of all drives in the middle of the day when oracle is running and we sometimes still encounter the same issues. SQL> Experts exchange is not letting me attach any files today :( ive tried on 2 other computers and it still wont let me upload any type of file, ive never had this issue before on here. ORACLE instance started. allocated channel: ORA_DISK_1 allocated channel: ORA_DISK_1 we havent been restoreing from the backup exec files only from the system recovery image backup.