alter database rename

How to create a new database instance for Oracle 10g XE?For Windows, first ensure that there is no important data in the current XE instance. Then, call oradim-delete-sid xe to delete the current system service (Windows Service ).Run XE. bat in D: \

1. Create the same directory as the 9i data file, control file, and redo file on the target server where Oracle 10g software is installed (the data files of the two databases must be in the same location, otherwise, you need to use alter database

Objective: To test whether oracle hot backup files in windows contain spfile, control files, data files, archived logs, and non-rman recovery are available on different machines and not in the original path. Test environment: windows 2003 R2, ORACLE

1Alter 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

When importing data in half, the disk space is insufficient. This requires that the data of the database files be moved to another disk. 1. offline data files: SQL> alter database datafile 2 'H: \ Oracle \ product \ 10.2.0 \ oradata \ lhoms \ pub \

Control files are used to record and maintain databases. When the database is restored, the server process and background process need to read various backup-related information from the control file. If the control file is corrupted, the backup

[Translated from mos] in rac, The asmcmd command is used to move the system datafile from the file system to the asm disk group. asmcmddatafileIn rac, use the asmcmd command to move the system datafile from the file system to the asm disk

Case: a data file in rename cannot be completely restored.SQL> startup mount; // starts to mount.SQL> show parameter control_files // view the location information of the Control FileNAME TYPE VALUE----------------------------------------------------

A small example of redirecting data files under asm (using the toad tool), asmtoad Original works, from the blog of "Deep Blue,Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/46863991   Scenario: in the production environment, you

I. Move data files: You can use alter database or alter tablespace to move data files. 1. ALTER DATABASE Method 1: You can use this method to move data files in any tablespace. Step 1: Close Database # Sqlplus/as sysdba SQL> shutdown immediate Step 2

1. Oracle Database NameThe database name is the "ID number" of the database, used to identify a database. DB_NAME is used in the parameter file.The database name must be used to install the database, create a new database, create a database control

Condition: In the same version of the operating system, copying a database involves copying software and database files as follows:1. Package files in the Oracle Installation Directory of the source database:Js_znjh_1./app/oracle $ tar cvf

1. Shut down the databaseSQL> shutdown immediate;2. Move data files and log files to a new locationSQL> host mv/u01/olddata. dbf/u02/newdata. dbf;SQL> host mv/u01/oldredo. log/u02/newredo. log;3. Start the database in load modeSQL> startup mount;4.

Oracle 10G tablespace movement, all applicable routines of the TNS listener cannot establish a new connection, service_died 12537, c3p0 connection pool parameters, One Oracle O & M experience while learning and working, step by step. A few days ago,

RMAN change tracking The change tracking function of RMAN improves the performance of Incremental backup by recording the changed data blocks in each data file in the change tracking file. If change tracking is enabled, RMAN uses a change tracking

Example of Incomplete recovery based on time points When it comes to Incomplete recovery, there are generally three scenarios: Incomplete recovery based on time points, Incomplete recovery based on scn, and incomplete recovery based on cancel.In all

8.3.4Renaming a Datafile in the Primary Database8.3.4 recommand the data file in the master database (that is, manually modify the same changes in the slave database) When you rename one or more datafiles in the primary database, the change is not

-- ====================================== -- Oracle Hot Backup -- ====================================== Oracle Hot Backup refers to a series of backup operations on database data files, control files, parameter files, and password files when the

Linux Oracle is a common system, so I learned about Linux Oracle. Here I will introduce the application of Linux Oracle System in detail and hope it will be useful to you. In the use of Linux Oracle databases, database files gradually increase with

C. After a long period of development, I would like to express my personal understanding here. Here we will talk about Linux Oracle. Sometimes we encounter such a situation where the existing database needs to be transferred from one machine to