recovery files

Format reload system, only to think of Oracle 10g database did not do backup, began to think very troublesome, did not expect the database recovery is quite smoothRecovery method:1, the original database file backup, (D:\ORACLE\PRODUCT\10.2.0\ORADATA\GQXT), rename it, I named Gqxt_old, (otherwise the database will be prompted when the SID already exists).2, re-install the database to the original path (do not install to the original path is OK, but th

In the implementation of a requirement in the Remcovery mode, in the/cache/recovery/directory to create a log file to record the relevant log information, in order to read the log information after the boot, and then according to the log information to make corresponding processing, But it is strange that every time the file is not automatically deleted by the system, and the system's original log files (su

Tags: Oracle non-critical file Recovery Redo temp file index file password fileApplication of incremental backup in recovery phase, no longer restore phaseUnderstanding the Database Settings table:Sql>desc database_propertiesName Null? Type----------------------------------------- -------- ----------------------------Property_name not NULL VARCHAR2 (30)Property_value VARCHAR2 (4000)DESCRIPTION VARCHAR2 (400

To understand the role of each file, you must master the basic concepts of Oracle. I. backup and recovery of Oracle basic files 1. logfile diversification and Backup Recovery Log query Select * from v $ logfile; Select * from v $ log; Manually switch logs Alter system switch logfile; Manual checkpoint Alter system checkpoint; Alarm Log File Show paramter dump $ O

Oracle non-critical file recovery, redo, temporary files, index files, password files, and oracleredo The Application of Incremental backup is in the rediscovery stage and is no longer in the restore stage. Learn about the database settings table:SQL> desc database_propertiesName Null? Type-----------------------------

-recursiveMaking all in SRCMaking install in SRC/usr/bin/install-c ' extundelete '/usr/local/bin/extundelete 'Restore Operation command--umount or Read only partitionUmount/dev/partitionMount-o remount,ro/dev/partition --Recover filesXtundelete/dev/partition--restore-allExtundelete/dev/partition--restore-directory/backup/gnutool-deleteExtundelete/dev/partition--restore-files/etc/passwdTest recovery--Based

Recovery | Control 1.1. Loss of recovery 1.1.1 for all control files. Analog Control file loss rman> shutdown abort; Oracle routines are closed Rman> host; Microsoft Windows XP [version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\>del d:\oracle92\test1\control*. Ctl C:\>dir d:\oracle92\test1\control*. Ctl The volume in drive D is not lab

1, zip rar compression format before and after the file system is one of the Ntfs/exfat/fat32, and the format of the zip rar compressed file size and location has not changed. 2, if the zip rar compressed file before the file system is one of the Ntfs/exfat/fat32, but the formatted partition has changed, please select "Partition Recovery" 3, if the zip RAR compressed file format before and after the file system is not ntfs/exfat/fat32, please select

There was a client recovery request this morning, and he accidentally used the RM-RF oradata command in the Solaris system to delete all the data files under one partition. Now do not know how to do, ask us to give support. Check it out. found that the database is not crash, it seems that directly consider the use of handle recoveryROOT@CNISORCLSVR # Uname-aSunOS cnisorclsvr 5.9 generic_112233-08 sun4u SPAR

Perform full recovery: the key data file of the SYSTEM is lost in ARCHIVELOG mode. If a data file is lost or damaged and the file belongs to the SYSTEM or UNDO tablespace, perform the following steps: 1. the instance may or may not be automatically closed. 2. If the instance is not automatically closed, use SHUTDOWNABORT to close the instance. 3. Load the database Perform full recovery: the key data file of

About Recovery with a Backup Control FileIf All copies of the current control file is lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVER command, even if no data files has been restored, and open the database with the Resetlogs option. If Some copies of the current control file is usable, however, then can follow the procedure in "responding to th e Loss of

oracle| Recovery | control | data --------------------------------------------- Experimental platform: Windows + Oracle 10.1.0.2.0 Author:ningoo 2005-03-26 -------------------------------------------- After the control file is backed up, the data file is added to the database, and the current control file is corrupted and needs to be recovered using the previous backup control file. 1. Backup Control

UNDO file does not involve data in the rollback segment. Other data files can be recovered online. The main Commands used are: Ps-ef | grep dbw | grep-v grep Ps-ef | grep ckpt | grep-v grep Ll, proc, 10986, fd Cp/proc/10986/fd/258/u01/oradata/bys3/system01.dbf Alter database datafile 6 offline; Recover datafile 6; Alter database datafile 6 online; 1. Delete the recovery experiment for the SYSTEM File: ses

Descriptors associated with the File are closed, the process that has obtained the file descriptor to open can continue reading and writing the file normally as long as the close function is not used to close these descriptors. When all open file characters of the file management are closed, the file is actually deleted.Note: -- SYSTEM cannot be used for online RECOVER. You need to restart the database.The UNDO file can be recovered online, but the UNDO file OFFLINE cannot be operated. The UNDO

Sysdbasql *plus:release 10.2 . 0.1 . 0 -Production on Sat 18 08 : 40 : 55 2012 copyright (c) 1982 , 2005 , Oracle. All rights reserved. Connected to:oracle Database 10g Enterprise Edition Release 10.2 . 0.1 . 0 - Productionwith the partitioning, OLAP and Data Mining optionssql > Set the Remote_login_passwordfile parameter to NONE and restart the databaseThe Remote_login_passwordfile parameter has a value of three:NONE: Login with password is forbiddenEXCLUSIVE: Mainly for multi-insta

: to open the database, you must use the RESETLOGS or NORESETLOGS Option SYS @ orcl # alter database open resetlogs;Alter database open resetlogs*Row 3 has an error:ORA-01194: File 1 requires more recovery to maintain consistencyORA-01110: Data File 1:'/Opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw _. dbf' SYS @ orcl #Try to recover:SYS @ orcl # recover database using backup controlfileORA-00279: Change 4400440 (generated at 05/18/2013 16:04:

Common data file backup and recovery common data file backup and recovery: Common Data Files refer to non-system tablespace, udo tablespace, temporary tablespace, read-only tablespace files. Common data files can be restored using a high-availability

Recovery | Data 1.1. Loss of all data files The major premise is that control files and log files are not corrupted. 1.1.1. Simulate loss of all data files rman> shutdown abort; Oracle routines are closed Rman> host; Microsoft Windows XP [version 5.1.2600] (C) Copy

When the control file backup and recovery instance is started, the process must read the control file and write the control file. Therefore, if a control file is damaged, the instance cannot be mounted. That is, the control files in this phase are indispensable. If the disk is damaged, it can only be started to the NOMOUNT state. Backup control file backups include: online control file image backup, manual

The users of computer cognition are all aware that the empty files of the Recycle Bin only occupy the space of the hard disk is released, and its specific data is still stored in the computer, only the new data write to cover the space released by it, the empty files will be completely deleted. So under normal circumstances, we can not see the empty file, only through the