1005: Failed to create table1006: Failed to create database1007: Database already exists, failed to create database1008: Database does not exist, delete database failed1009: Unable to delete database file causes database failure to be deleted1010: Unable to delete data direc
Original blog link address: Database open error ORA-01555: snapshot too old
During his honeymoon in Dongguan today, a student said that the test library he managed had a problem and could not be opened. Let's first look at the problem:
Recovery of Online Redo Log: Thread 1 Group 4 Seq 4 Reading mem 0 Mem# 0: /onlinelog/shr/redo04.logCompleted redo application of 0.00MBCompleted crash recovery at T
/oradata/ora9i/users01.dbf10/u01/oracle/ora9i/oradata/ora9i/xdb01.dbf11/u01/oracle/ora9i/oradata/xifenfei01.dbf12/u01/oracle/ora9i/oradata/xifenfei02.dbfRows selected.Sqlgt;!rm/u01/oracle/ora9i/oradata/xifenfei02.dbfSqlgt;!ls-l/u01/oracle/ora9i/oradata/xifenfei*-rw-r-----1 ora9i oinstall 10493952 Dec 20:19/u01/oracle/ora9i/oradata/xifenfei01.dbfsqlgt; alter tablespace Xifenfei online;Alter Tablespace Xifenfei Online*ERROR at line 1:Ora-01157:cannot id
After an old DB2 database on the test machine stops the database normally, the sql1_2c error is reported when the database is started. The specific information is as follows: # su-db2inst1 $ db2start2013-04-2313: 23: 0800SQL1042CAnunexpectedsystemerroro
After an old DB2 database
MySQL error code list1005: Failed to create table1006: Failed to create database1007: Database already exists, database creation failed1008: Database does not exist, delete database failed1009: Unable to delete database file cause
Error 5173 in SQL Server database
Yesterday, my colleague gave you a problematic database and asked me to fix it because the customer needed this database. This database only has one MDF file and one LDF file,
When I attach a database
Yesterday, when the Oracle database was restarted, an error was reported, ORA-24324 and ORA-01041 error, the following restore the error process and the process of solving the problem.
Yesterday, when the Oracle database was restarted, an
fileOSD-04002: Unable to open fileO/S-Error: (OS 21) the device is not ready.Sat Dec 31 10:14:26 2011Errors in file c: \ oracle \ product \ 10.2.0 \ admin \ sheng \ bdump \ sheng_mrp0_1724.trc:ORA-19527: physical standby redo log must be renamedORA-00312: online log 1 thread 1: 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ SHENG \ REDO01.LOG'Let's take a look at the redo on the slave database:SQL> set wrap offSQL> select * from v $ logfile;The row is t
This is an operation to restore the RAMN backup of a database in the RAC environment to a single database. The following error is reported when the data file is restored and the recovery is normal.
This is an operation to restore the RAMN backup of a database in the RAC environment to a single
ORA-24324 ORA-01041 reboot Database Error
Yesterday, when the Oracle database was restarted, an error was reported, ORA-24324 and ORA-01041 error, the following restore the error process and the process of solving the problem.
1.
detailed crossing Web documents)) 1. First open "Start menu->oracle database Express Edition" or "Run SQL command line" 2, if "Run SQL command line" run Sqlplus directly, if "Start the database" will just go to the command line, you need to open Sqlplus, enter the Sqlplus/nolog (or help Sqlplus to view assistance) 3. After startup, connect the database: Connect
It's a strange question. Just learn to do Oracle when you do a test when the database startup prompts ORA-08103 error, the following cloud Habitat Small series to give you a moment.
Database failed to start correctly due to ORA-08103 error in open procedure
The code is as follows
Copy Code
Tags: will add target line data share JPG failed item sectionError when restoring a database backed up from SQL Server 2005 in the SQL Server 2008 release: "The database backup in the backup set is not the same as the existing ' * * * ' database. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server,
In the day-to-day maintenance of Oracle databases, we may often encounter some errors that we have never seen before, even inexplicable errors. Many times, even through Metalink, Baidu, even Google can not search the relevant content. This is not, yesterday the company southern colleagues to help restore a customer database; it is said to be an archive database, there is no backup, restart the instance afte
Oracle Database Installation Error highlights:
◆ 1. If you cannot run./runInstaller and the error x11 is prompted, use root to enter the following command # xhost +
◆ 2. If you enter the dbca command, the interface disappears inexplicably In the last step, and the following error message appears on the command line:
/O
Tags: professional designation L Database tle SQL file href function important basicDatabase in today's information age, has played a more and more important role. Is the real core of the data, no database, then the software is just a beautiful interface. Database recovery, database repair is a more common kind of data
message, and then check the default tablespace parameters:
SQL> SELECT INITIAL_EXTENT, NEXT_EXTENT, MIN_EXTENTS, PCT_INCREASE FROM SYS. DBA_TABLESPACES WHERE TABLESPACE_NAME = name;
Use the following SQL command to modify the default storage value of the temporary tablespace:
SQL> ALTER TABLESPACE name DEFAULT STORAGE (INITIAL XXX NEXT YYY );
Increasing the size of the default value may solve the problem. You can also modify the size of your temporary tablespace to solve the problem:
SQL> ALTER
The Dataguard configuration is as follows:
Prod main library, sbdb for standby
Log Group 1-3 Group is Redolog file,4-6 Group is standby log
During the creation of the standby log library, the recovery from the data transfer to the standby is performed using the cold standby tar package.
After the DG configuration is complete, the standby alert log has an error following the start of the repository:
Errors in FILE/U01/APP/ORACLE/ADMIN/SBDB/UDUMP/S
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.