alter database rename

Oracle 11g replica uard creation in ORA-01665 resolution, dataguardora-01665Oracle 11g fails to restore the standby control file when creating data guard. When I mount standby database, tell me that the control file is not a standby control file and

Today, the company's database is restored to a new server, start the database to report a ORA-00312 error, the original backup redo in the D disk, and the new database has no D disk, put in E. the database has three redo groups: delete group 1,

When you use alter database to move a data file, after you run the alter database rename to command, try to open{Tagshow (event, '% Ca % fd % be % DD % BF % e2 ');} "Href =" http://www.cnblogs.com/wuhenke/admin/javascript:; "target =" _ Self

I. Database Name 1. Concept of Database Name The Database Name (db_name) is the ID of a database, just like the ID card number of a person. If a machine is installed with multiple full databases, each database has a database name. After the database

First of all, I apologize to you for your lack of stability due to work reasons, so my blog has not been updated in time. Today, I finally took the time to update my blog and write the results I got in two hours.   Recently, the development platform

I. Database Name1. Concept of Database Name The Database Name (db_name) is the ID of a database, just like the ID card number of a person. If a machine is installed with multiple full databases, each database has a database name. After the database

This article consists of four parts: 1. Create a virtual ASM disk, 2. Create a database on the virtual ASM disk, 3. asmcmd tool, and 4. Add a disk for the disk group. Part 1: create a virtual ASM Disk(In this example, Oracle is installed on D: \

Use the Asmcmd CP command to move the datafile from the file system (move) to the ASM Disk group-for 11GR2Reference text:How to Move a datafile from Filesystem to ASM Using asmcmd CP Command. (Doc ID 1610615.1)Suitable for:Oracle database-enterprise

Use the Asmcmd CP command to move the datafile from the file system (move) to the ASM Disk group-for 11GR2Reference text:How to Move a datafile from Filesystem to ASM Using asmcmd CP Command. (Doc ID 1610615.1)Suitable for:Oracle database-enterprise

Basic rules A. In the SPFile file, all parameters are optional, that is, you only need to list those parameters that need to be modified in the initialization parameter file, others to keep the default values. The B.spfile file can contain only

One. Query article 1. Query Oracle Table space usage Select b.file_id file ID, B.tablespace_name table Space, B.file_name Physical file name, The total number of bytes b.bytes, (B.bytes-sum (NVL (a.bytes,0))) has been used, Sum (NVL (a.bytes,0))

Database failed to start issue Prompt when logging on to database: Ora-12514:tns: The listener is currently unable to recognize the connection descriptor Solution: Then log on to the database server (aix5 Unix), go to the Oracle User (Unix turn user

Show Parameter Service_names Select instance_name from V$instance; Db_name is a real physical name. Service_Name with a domain name, because if two databases no longer have the same name as the same domain. The SID is the instance name of the

Problem Description: When landing Oracle database, whether from SQL Plus or from Toad Landing, there will be no landing on the phenomenon. Prompt for package receive failed: ORA-12637 appears. Workaround: Modify the Sqlnet.ora file,

When learning Oracle database infrastructure earlier, Oracle's storage structure was understood, logically, Oracle data was stored in tablespaces and physically stored in datafiles. A tablespace can only belong to one database (one database can

Environment: RHEL 6.4 + Oracle 11.2.0.3 Scenario One: only some ordinary data file migration, can be online operation. 1. Offline The corresponding table space, move the data file to the new path 2. Data file Alter DATABASE rename file ' to '; 3.

Oracle| Skills | experience 1. Delete a table space DROP tablespace tablespacename [including CONTENTS [and Datafiles]] 2. Delete User DROP USER user_name CASCADE 3. Considerations for deleting a table When you delete all the data in a table,

oracle| Data | database | questions This article mainly describes how to deal with the problem of bad blocks in the Oracle database, for the bad block produced on different objects, the processing method will be different, this article will make a

oracle| Data | database | questions Oracle's data block has a fixed format and structure, divided into three layers: Cache layer, Transaction layer, and data layer. Do a consistency check when reading and writing a block of data: –block

Process | data --9i Migrate data file procedures 1. View View SELECT * FROM Dba_data_files Determine the location and name of the data file you want to move Source location and name: '/HOME/ORACLE/PRODUCT/92/ORADATA/ADP/USERS02.DBF '