rename file

Windows XP oracle9.2.0.1.0sid: The test database is installed on disk D. Now, the control files, database files, log files, and temporary files under D: ORACLEORADATATEST are moved to F: TEST. First, close the database and copy the files under D:

Rman Machine Recovery considerations:1. When the RMAN machine recovers, the db_name must be the same. If you want to change to another instance name, you can modify it with the NID command after the recovery is successful. The instance name

1. Create the following directory:MKDIR-PV $ORACLE _base/admin/$ORACLE _sid/{{a,b,c,dp,u}dump,pfile}MKDIR-PV $ORACLE _base/flash_recovery_area 2. Create a oracle10g

All data files of the local disk need to be moved to storage.Summary of steps:1.shut Immediate Stop Library2.host CP dbfile to New Path3. Modify the position of the controlfile in the parameter to boot the database to mount4.rename Related Documents5

Move the redo file path, the default redo log file path is the same as the Archivelog path, in the flashback area, because the flash back zone has a size limit, so redo log and archive log, especially archive log, will burst into the flashback zone.

This article describes how to build a Acfs file system on a virtual machine that already has 12c RAC installed, and use the ACFS snapshot to brush a cow (Copy-On-Write) library to do the test library. Highlight Step: Add ASM disk to virtual

There are several ways to migrate a database, and the more common is to use Rman to migrate. Using Rman to migrate a database belongs to the physical backup and Recovery category of the database, and the information about the database is completely

ASM management-how to rename diskgroup The new diskgroup rename function is added in ASM 11.2.0.1. You can use the renamedg command to rename the created diskgroup. Before renaming, you must first dismount diskgroup. If the renamed diskgroup is

Recently in the case of a bank database migration and escalation, as the system for the statistical run batch, the original system configuration has been unable to meet the performance requirements of running batches, it is required to buy new

First, back up the original libraryRun{backup database format '/home/oracle/backup/db_%u_%t.bak '; backup current controlfile format '/home/oracle/backup/ Ctl_%u_%t.bak '; backup spfile format '/home/oracle/backup/spfile_%u_%t.bak '; backup

There are three methods for ORACLE backup and recovery: (1) Data Pump (expdp/impdp) (2) Cold backup (3) RMAN backup In terms of classification, (1) and (2) are collectively referred to as "cold" backup and (3) as "hot" backup. Data Pump and

Renamedatafile reports error ORA-01511, ORA-01121, ORA-01110 Rename datafile reports error ORA-01511, ORA-01121, ORA-01110 Symptom:After the instance is started to mount, rename datafile reports an error ORA-01511, ORA-01121, ORA-01110SQL>SQL>

Transfer Process:1. log on to sqlplus first: C:/Documents and Settings/jbdu> sqlplus "/As sysdba"2. Change the tablespace to offline: SQL> alter tablespace users offline;3. Copy tablespace files

Transfer An oracle Data File "*. dbf" Transfer Process:1. log on to sqlplus: C:/Documents and Settings/jbdu> sqlplus "/as sysdba" 2. change the tablespace to Offline: www.2cto.com SQL> alter tablespace users offline; 3. copy tablespace file copy

      Purpose:Measure the test taker's knowledge about how to set parameters in the binary parameter file and understand the meaning of each parameter.Measure the test taker's knowledge about how to use control files and understand the purpose of

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.

Sunday in order to save the main Library users table space temporarily expanded 20G tablespace, resulting in the DG Library's/bak/datafile/directory is insufficient. The log application to the extended-space archive crashes, and, more tragically,

If you are migrating a tablespace or data file only, you can move the table space or data file offline after the location, andAlert database rename and alter tablespace rename write position changes to the control fileExample migrating a data

First Kind Alter tablespace users rename datafile ' = = ' to ' * * *; In this way, the database is open, and the tablespace can be changed in offline state. sql> alter tablespace users rename DataFile '/opt/ora10g/oradata/orcl/user0100.dbf ', '/opt/

Two methods of Oracle rename data files2012-12-11 20:44 10925 People read comments (0) favorite reports Classification:Oracle (98)Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.First