RMAN backup scheme RMAN backup archive mode damages (loss) multiple data files, restores the entire database 1. connects to the database, creates a test table, and inserts records
SQL * Plus: Release 8.1.6.0.0-Production on Tue May 6 13:46:32 2003 oracle training (c) Copyright 1999 Oracle Corporation. all rights reserv
backup set of the largest data file is 170 MB.
In the backup script, the format is "$ ORACLE_SID-% I _ % T _ % t _ % s. db". The specific statement of the script is as follows:
Backup as compressed backupset database format' $ RMAN_BACKUPSETS/$ ORACLE_SID-% I _ % T _ % t _
compressed backupset parallelism 2;Configure device type 'sbt _ tape 'Backup Type to backupset parallelism 2;Configure datafile backup copies for device type disk to 1; # defaultConfigure datafile backup copies for device type sbt_tape to 1; # defaultConfigure archivelog backup copies for device type disk to 1; # defa
In the RMAN backup script, we added the option to delete the archive log, but in some cases, we still need to deploy the script to delete the archive log. For example
In the RMAN backup script
information of RMAN. The LOG parameter can only be used in command lines. SPOOLING cannot be started in RMAN. When the application log file is used, the output information is not displayed on the screen.
TRACE
Similar to the log parameter, a file that displays the input information of RMAN is generated. TRACE is also displayed on the screen.
APPEND
Special u
. RestoreA. Full Recoverymethod One: Restore the entire database from the most recent backup set and the database will run automatically Redo and the Archive log (Full recovery):Sql>shutdown ImmediateSql>startup MountRman>restore database;Rman>recover database;Rman>sql ' ALTER DATABASE open ';method Two: from Tag restore the entire database and the database will
ORACLE11G restores the rman backup of dataguard to the detailed process of standalone oracle in the test environment
1. copy the full backup file 1.1 from the production database to view the parameter file information.
RMAN> list backup of spfile;
Find the latest
status
Linux Error: 2: No such file or directory
Additional information: 3
First, create/u01/app/oracle/flash_recovery_area/DGWH/backupset/directory using the oracle account on the slave database. If you use root, you need to modify the directory permission.
[Oracle @ localhost flash_recovery_area] mkdir-p DGWH/backupset
Execute the scp command in the master database to copy all the backup files to the sla
This article describes how Oracle uses odu to verify rman backup to process command instances for truncate object backup. If you need rman backup, you can refer to this article.
By Digging data files before and after rman
' database;B. Back up a tablespace backup tag 'tsuser' format'/bak/oradata/tsuser _ % u _ % s _ % P' tablespace users;C. backup archiving log backup tag 'alog 'format'/bak/archivebak/arcbak _ % u _ % s _ % P' archivelog all delete input;
Ii. Maintain RMAN
RMAN maintenance is
Example of using RMAN to create a backup set for Oracle11g backup and recovery
Oracle 11 GB backup and recovery example of using RMAN to create backup Sets
Homepage → Database Technology
Background:Read News
Or
so that the control file takes effect and proofread and synchronize the control file version. Then we use RESETLOGS to open the database. Because the log file is cleared and the previous backup is invalid, we should back up the database again. This is crucial.
We can also use the RUN Command to write all operations into a human script, which can reduce many operations, provided that such a
Usage type: the system load is concentrated in a certain period of time, such as 8 hours during the day, and is usually idle at night. Therefore, data can be backed up at night.
It corresponds to full-Database Backup:
Http://blog.csdn.net/jacson_bai/article/details/39636915
1. env:IP Address: 10.244.171.180/181Oracle Database Oracle 11.2.0.3OS RHEL 5.5Backup toos: rman, Shell, crontab
2.
recovery operations.
I/O type used
The channel control command can be used:Controls OS resources used by RMANAffect degree of ParallelismSpecify the I/O bandwidth limit (set the limit read rate parameter)Specify the size limit of the backup slice (set limit Kbytes)Specify the limit of the currently opened file (set limit maxopenfiles)
============================================ Typical one-week backup
database and Restore directory scripts, refer:
Create and use RMAN catalog
Create RMAN storage script based on catalog
Catalog-based RMAN backup and recovery
Bytes -------------------------------------------------------------------------------------------------------
-- All
RmanInfluence degree of parallelismSpecify the throttling value for I/O bandwidth (set limit read rate parameter)Specify a limit on the size of the backup slice (set limit Kbytes)Specifies the limit value for the currently open file (set limit maxopenfiles)
=================================rman Typical backup solution for one week ============================
1.
client_info is not null;
Sid username client_info
----------------------------------------------------------------------
140 sys id = RMAN
SQL> select Sid, spid, client_info
2 from V $ PROCESS p, V $ session s
3 where P. ADDR = S. paddr
4 and client_info like '% id = % ';
Sid spid client_info
----------------------------------------------------
140 5002 id = RMAN
-- View the
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.