alter database rename

Requirement: To move a data file in a table space of a user to a path from one path to another for some reasonReason:(1) The Table space files and system tablespace files in the current instance are all on one hard disk, which causes IO to increase.

with backup control file recovery, the control file does not contain data files, but the online log hasALTER DATABASE backup Controlfile to ' D:\control.ctl ';Create tablespace tp1 datafile ' d:/tp1.dbf ' size 10M;CREATE TABLE t1 (ID int,name

Environment: 11.2.0.1 + RHEL6.5 Reference Document ID:1678747.11. Simulate creating a node:sql> create tablespace tdb datafile '/u02/app/oracle/datafile/ tdb.dbf ' size 10m autoextend off; Tablespace Created.2. Viewing a data File node: file# NAME---

Select File#,name,status from V$datafile;SELECT * from V$tablespace;1. Alter tablespace AAA offline;2. Shutdown immediate;3. Copy data file to Destination directory4. Startup Mount;Alter DATABASE rename file ' F:\ORACLE\ORADATA\ORCL\AAA_01.DBF ' to '

  Redo redo logs are as important to Oracle as the liver, and are an important part of Oracle's function of detoxifying and restoring health !! Related Basic concepts: 1. SCN 2. Log serial number 3. Log groups and log members, especially

■ Log Switching SQL> alter system switch logfile; ■ Add a redo log file groupSQL> alter database add logfile2 group 4 ('/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/redo04.log') Size 10 m; ■ Add members of the redo log file groupSQL> alter

How to connect to the Oracle database and how to solve the fault-Summary highly recommended This article describes how to connect to Oracle Summary , Especially suitable Program Developers and Oracle cainiao How to configure to connect the client

FYI:http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126Rman Duplicate database must be the same platform, but supports 32bit\64bit replication, which needs to be run after replication is complete

OS:Oracle-linux 5.7Db:11.2.0.3.0Full recoveryTo view an existing data fileSql> select name from

In RAC, use the asmcmd command to move the system datafile from the file system to the ASM disk group. Reference Original: How to move a system datafile from filesystem to the ASM diskgroup using asmcmd on RAC. (Doc ID

OverviewIn the Oracle installation directory $ home/Network/admin, sqlnet is often seen. ora tnsnames. ora listener. ora files except tnsnames. ora, the detailed usage of the other two files is not well understood by many people.Sqlnet. ora is used

I. Improve database performance 1. Use explain plan to check SQL statement Performance Specific operations: Generate a plan_table table Run rdbms \ admin \ utlxplain. SQL Explain plan set statement_id = 'statement1 'into plan_table For select * from

1. Create tablespaces SQL> Create tablespace tablespace_name datafile 'C:/Oracle/oradata/file1.dbf' size 100 m, SQL> 'C:/Oracle/oradata/file2.dbf' size 100 m minimum extent 550 K [logging/nologging] SQL> default storage (initial 500 K next 500 k

1. About Bare Devices 1.1 What is a raw device) A bare device is a raw partition or raw logical volume that has not been created for a file system. Character device driver to access it. How to read and write data on the device depends on the

Common Oracle commands-tablespace Management 1. Create tablespacesSQL> Create tablespace tablespace_name datafile 'C: \ oracle \ oradata \ file1.dbf 'size 100 m,SQL> 'C: \ oracle \ oradata \ file2.dbf' size 100 m minimum extent 550 K

Db_name: Unique identifier of a database (Oracle database. This expression is sufficient for a single database, but with the popularization of distributed databases composed of multiple databases, this method of Command database creates a certain

1 alter Database: modify data files Alter database datafile 4 offline; Alter database datafile '/opt/Oracle/datafile/users01.dbf' offline; Alter database datafile '/opt/Oracle/datafile/users01.dbf' resize 100 m; Alter database datafile

One quiet afternoon, an AIX small machine with an ORACLE database in the test environment was shut down due to an unexpected power failure. In the test environment, an engineer was assigned to solve the problem. Specifically, the server was

1. Close the database completely. 2. Close the database and modify the server parameter file to use Oracle Managed Files (OMF ). 3. edit and execute the following RMAN Script: startup nomount; restore controlfile from '/u1/c1.ctl'; alter database

① ASM file conversion Take the created asmtest tablespace as an example. (I) convert OS files to ASM files Sys @ ORCL> create tablespace asmtest datafile size 10 m; Tablespace created. Sys @ ORCL> alter tablespace asmtest offline; Tablespace