alter database rename

oracle| Data | Database Oracle database in the use of the process, as the data increase in the database files are gradually increased, to a certain size may cause hard disk space; Then we can move the database file to another large hard disk

First, recover via file descriptor (descriptor) (RM delete data file not backed up) Scene: misoperation Delete data file tp10.dbf Rm-rf/u01/app/oracle/oradata/bxdb/tp10.dbf Select Ts#,file#,name,bytes,status from V$datafile; Ps-ef |grep dBW

System environment:CentOS Release 6.7 (Final)Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bitOperation Process:1. When you add a data file or create a tablespace, you specify the path as a single-node localSql> alter tablespace users

A few days ago the teacher arranged a task to import a 50G dmp file into our Oracle server. Because I practiced this before, I thought it was a relatively simple thing.Just try to use the Plsql directly to the server guide AH. Log in to the server

One, backup mode: 1, in the non-archive mode, can only do cold backup 2, in the archive mode, you can use hot backup, can also do cold backup. (Data file control file temporary file online log file) Second, cold backup (do it once a week) 1,

This article mainly describes how to deal with the problem of bad blocks in the Oracle database, for the bad blocks produced on different objects, the method of processing will be different, this article will be a general introduction to these

Oracle 11g Recovery of standby control files was unsuccessful when creating data guard. At Mount Standby database, I was told that the control file was not a standby control file, and that the specific information was "Ora-01665:control file is not

The establishment and use of Oracle database linkFirst, the establishment of the database link:1, the database link building syntax is generally: Create databases Link[db_link_name] CONNECT to[USER_NAME] identified by [password] USING ' [tns_name] ';

Server System for Windows R2 64-bit, because the C disk space will be full, to the C-disk of the Oracle DBF data file to migrate to the D disk, the steps are as follows:1. Enter CMD to start the Cmd.exe window2. Enter Sqlplus/nolog3. Input conn Sys/[

Dbnewid is a tool that Oracle provides to modify database dbid and dbname.Before we introduce this tool, we must rebuild the control file if we want to change the database name of the database. However, it is not possible to modify the dbid of the

Reprinted from:The difference between db_name,sid,db_domain,service_name and so on in OracleDb_name: A unique identifier for a database (Oracle db). This representation is sufficient for a single database, but with the popularization of a

The establishment and use of Oracle database linkFirst, the establishment of the database link:1, the database link building syntax is generally: Create databases Link[db_link_name] CONNECT to[USER_NAME] identified by [password] USING ' [tns_name] ';

Method One:1. Offline The status of the data fileSql> Select file_name, Tablespace_name fromDba_data_fileswhere file_name like '%user%';file_name--------------------------------------------------------------------------------Tablespace_name---------

the growth of Blue-Chase DBA (3): antique operation, data import and export become a problemStatement ***************************************An individual's growth record on Oracle's path, with blue self-metaphor, to share growing emotions, horizons

OS:Oracle Linux Server Release 5.7Db:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionFirst create the Yoon databasesql> Create Tablespace Yoon datafile '/u01/oracle/oradata/yoon/yoon01.dbf ' size 50m;Tablespace created.Sql>

Original: Oracle Cold backup and RecoveryThere are three ways Oracle backup and Recovery works: (1) Data pump (EXPDP/IMPDP) (2) Cold backup (3) Rman backup In terms of classification, (1) and (2) are called "Cold" backups, (3) called "Hot" backups.

Overview under the Oracle installation directory $home/network/admin, you often see Sqlnet.ora Tnsnames.ora Listener.ora these three files, in addition to Tnsnames.ora, the other two files detailed use many people do not understand.The Sqlnet.ora is

Environment:Windows 2008 server,Oracle 11g R2 database Task Requirements:There are three DB instances, one instance for use by the management subsystem, one for use by the subsystem, and one for backup. Selected technology:Oracle Stream

I did not know much about the remote restoration of the RMAN backup database. When I went to Shangguan Technology for lectures last Saturday, Teacher Zhang lie was talking about RM. I did not know much about the remote restoration of the RMAN backup

Oracle Tablespace management Tablespace & Data Files [SQL] 1. Objectives Define the purpose of tablespaces and data files (the purpose of defining tablespaces and Data Files) create tablespaces www.2cto.com Manage tablespaces Create and manage