Oracle RAC backup and recovery Voting Disks Oracle RAC add and delete Voting Disks reference: http://www.bkjia.com/database/201303/195591.html Oracle RAC does not need to back up and recover the Voting Disks www.2cto.com Voting Disks every day. Generally,
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 $
Whether it's at conferences, or when friends/netizens privately consult Oracle database restores, I stress that if you're not sure, you should make a backup of your site to make sure there are no two damage to the site. You cannot restore the database, but you cannot destroy the database again, making it more difficult to recover two times. Here are some guidelines and simple scripts for pre-restore
18-apr-12
Channel ora_disk_1:finished piece 1 at 18-apr-12
Piece Handle=/u01/oracle/oradata/tmp/ora11g_0_07n8p916_1_1 tag=tag20120418t234958 comment=none
Channel Ora_disk_1:backup set complete, elapsed time:00:01:15
Channel ora_disk_1:starting compressed full datafile backup set
Channel ora_disk_1:specifying DataFile (s) in
non-routine recovery with Oracle Dul tool to recover data from drop-deleted Oracle data tables without backupDul to recover a drop object, you need to provide two information1. Table space to which the deleted table belongs (not required)2. Deleted table structure (required)simulating the deletion of tables in a 1.Oracle
;Alter database noarchivelog;Alter database open;
Change the FRA size and positionAlter system set db_recovery_file_dest_size = 2G;Alter system set db_recovery_file_dest = 'd: \ oracle \ flash_recovery_area ';
Register the recovery directory (the Enterprise Manager cannot create a recovery directory)
SQL> Create tablespace reco_cat datafile 'd: \ oradata \ orcl \
Tags: lines ble backup from dir import ref control detailStep: (Interview) 1, in the new host DBCA build library, the instance name and the original host database name consistent2, create user in new host3,DBMS_METADATA.GET_DDL Export Table Space generation statements4, create table space in new host5,exp exporting all data from the original library6,imp Importing replicated databases Oracle
Oracle controlfile backup and recovery backup: alter database backup controlfile to 'xxxxxx' reuse; alter database bakcup controlfile to trace as 'xxxxxxxx'; RMAN backup control file recovery
The training content developed for the optimization, backup, and restoration technologies related to Oracle databases will involve the following content.
Oracle Optimization
1. Oracle optimizer based on cost and rules and how to select Oracle optimizer
2. Statistical da
In actual operations, the Oracle database backup and recovery advanced options are mainly divided into two steps, including exporting multiple related fixed size files. And how to use N multiple fixed size files to import the actual operation steps.
Oracle database backup an
Oracle backup, recovery of single or multi-table data steps, applicable to Oracle8, 9, 10.
Oracle backup, recovery of single or multi-table data steps, applicable to Oracle 8, 9, 10.
Tags: Oracle training Oracle Tutorial Oracle video Oracle Video tutorial Oracle Database tutorialOracle Video Tutorial Goals Oracle Video tutorial, wind Brother this set of Oracle Tuto
Bytesredo buffers 4259840 bytes database loaded.sql> ALTER DATABASE open;ALTER DATABASE open* 1th line error: ORA-01157: Unable to identify/lock data file 8-see DBWR trace file ORA-01110: Data file 8: ' C:\TYKM. DBF 'sql> ALTER DATABASE datafile 8 offline drop; "8 is 8 in data file"The database has changed.sql> ALTER DATABASE open; "Loop this statement until the error is no longer prompted"The database has changed.sql> shutdown NormalThe database is closed. The database has been uninstalled. Th
Oracle Database physical file backup/recovery
I have written a similar article before. Although it is not a problem to restore the physical files of the Oracle database, I always feel that something is wrong. I learned later that I had some misunderstandings in the past, it is much easier to use this article again.
Env
to another user requires that the user has DBA authority, or imp_full_database Impuserid=system/[emailprotected] tables= (EMP) file=d:\ Xx.dmp Touser=scott 3. Import the structure of a table import only the structure of a table without importing data Impuserid=scott/[emailprotected] tables= (EMP) file=d:\xx.dmp rows=n 4. Import Data If an object (such as a table) already exists, you can import only the data for the table impuserid=scott/ [emailprotected] tables= ( EMP) File=d:\xx.dmp
1041819 August-July -10 d:/app/administrator/oradata/bl/undotbs01. Dbf
4 full 1041819 August-July -10 d:/app/administrator/oradata/bl/users01. Dbf
5 full 1041819 August-July -10 d:/app/administrator/oradata/bl/bl01. Dbf
List of archived log copies of the database Db_unique_name for BL
=====================================================================
Keyword Line program column S time limit
------- ---- ------- - ----------
8 1 A August-July-10
Name: d:/archivelog/bl_arc0000000012_07
Oracle records the changes of all data files in the form of logs, so as long as all data files in oracle are backed up at a certain time point, and have the backup Start Time
Oracle records the changes of all data files in the form of logs, so as long as all data files in oracle
Backup and restore of Oracle database users and tables can be done quickly and easily using the Plsql-developer tool.Full backup and recovery of Oracle database user data1. Backup1.1 pl/sql-> Tools, export user objects, optionsCommon user objects include the following:Table,
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.