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
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
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.