I. The rman database can be stored in two locations1. control files of the target database;2. Restore the directory;
2. There are two types of storage records in the control file1. records the history of archived log files and the metadata of rman
##################################Rman Combat###################################以下是一个实战的rman备份脚本BACKUP as compressed backupsetskip inaccessible Filesperset DATABASE PLUS ARCHIVELOG filesperset 20DELETE all INPUT;Compressed: Represents a compressed
Directory1 database modified to Automatic archive mode2 Modifying Rman parameters3 Rman Automatic backup script4 Set up system automatic backup parameters5 Rman RestoreRestore the entire databaseRecover a single table space1 database modified to
MySQL TABLE maintenance and transformation change the column data type www.2cto.com [SQL] alter table visitor MODIFY nam VARCHAR (30); append a new column [SQL] ALTER TABLE visitor ADD age INT; alter table visitor ADD age int first; alter table
Note:① The premise for recovery is that the backup has been completed② A database fault occurs when the database is fully recovered, and no committed data is lost during recovery.Incomplete restoration of the database is a fault in the database.
Incomplete recovery based on log sequence using rman
sql> select * from test;a-----123456sql>hostramn target/
rman>run{allocate channel c1 type disk;bakup full tag 'dbful' format 'd:\backup\full_%u_%s_%p' databaseinclude current controlfile;sql'
1. Check the database mode:Sqlplus/nologConn/As sysdbaArchive log list (check whether the database is in archive Mode)
If not, the database archive mode is modified.Startup MountAlter database archivelogAlter database open
2. connect to the target
V. Restoration and recovery5.1 conventional restoration and recoveryThe entire recovery process of RMAN can be divided into restoration and recovery.The difference is that one refers to the restoration and copying of physical files, and the other
Change the data type of a column
[SQL]
ALTER TABLE Visitor MODIFY Nam VARCHAR (30);
Append new Column
[SQL]
ALTER TABLE Visitor ADD age INT;
ALTER TABLE Visitor ADD age INT A;
ALTER TABLE Visitor ADD age INT after Nam;
Change the position of a
Note:The prerequisite for ① recovery is that the backup is done② Full Recovery database is the database encountered a failure, at the time of recovery did not lose any of the submitted things data recoveryIncomplete recovery database is a database
Source DB End:Oracle_base=/u01/app/oracleOracle_home=/u01/app/oracle/product/11.2.0/db_1Oracle_sid=ygdgData File location:/U01/APP/ORACLE/ORADATA/YGDGTarget DB
First, common tools:Recovery Manager:rman can only perform hot sparing (mount or open state)Oracle Secure BackupUser-managed Backup: CP/DD [if=/of=/blocksize=]Ii. Name of RmanThe Rman name does not allow duplication, and%u is definitely not
Change the Data Type of a column[SQL]Alter table visitor MODIFY nam VARCHAR (30 );Append a new column[SQL]Alter table visitor ADD age INT;Alter table visitor ADD age int first;Alter table visitor ADD age int after nam;Change column
GoldenGateforOracle Data Consistency Initialization Scheme
GoldenGate for Oracle Data Consistency Initialization Scheme
The O & M process is a process that constantly generates new problems and requires continuous research and development. Just
Mysql table maintenance and transformation code sharing bitsCN.com changing the column data type
[SQL]
Alter table visitor MODIFY nam VARCHAR (30 );
Append a new column
[SQL]
Alter table visitor ADD age INT;
Alter table visitor ADD age int
When the number of tables in the database is large, it is not conducive to maintenance. This article will detail how to maintain the mysql table, and how to modify the mysql table.
When the number of tables in the database is large, it is not
The daily work and responsibilities of DBAs in Oracle --- [1] The following summary is a summary written in "Deep Oracle", which corresponds to the amount of funds learned. 1. Let's take a look at Oracle's learning route: 2. learning basics: I have
Example 1: The tablespace data file is deleted by mistake.Delete all data files corresponding to the tablespace in the open state.Use alter tablespace... offline for recover offline tablespace in the open state.Use restore tablespace... to dump all
Modify the database character set: [SQL] ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE...]; change the default character set and all CHARACTER columns (CHAR, VARCHAR, TEXT) of the table to the new character set: [SQL] ALTER
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.