oracle rman training

This article mainly introduces common methods of RMAN, including the author's experience, the experiment is also basically successful in Windows 2 K and ORACLE 8.1.6 environments (because this environment is easier to implement ).　　This article draws on some articles related to experts on the Internet. I hope you will not be surprised. I would like to thank you here.　　Due to limited space, some technical de

I. The concept and architecture of Rman Recovery Manager (RMAN) is an Oracle tool for backup (Backup), restore (Restore), and recovery (recover) databases. Rman can only be used in ORACLE8 or higher versions. It can back up the entire database or database parts, such as tablespaces, data files, control files, archive

@ ebs01 backup] $ rm * 1) Start backup and back up data files together with archive logs: [Oracle @ ebs01 backup] $ rman target/ Recovery Manager: Release 11.2.0.1.0-Production on Mon Jun 11 09:16:52 2012 Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved. Connected to target database: ORCL (DBID = 1290854593)

2.1 Operational Requirements 1. Process and memory requirements The need for more processes Allocation of large pools 2. Basic Environment variable Demand Oracle_sid, Oracle_home, PATH, Nls_lang, if you use a time based backup and restore Duplicate, need to set up additional Nls_date_format 3. Permission Requirements Requires SYSDBA system permissions If it is local, you can use the OS certification, remote need to use password file authentication 4, version requirements The

oracle| Quick Start Preface This article mainly introduces the common methods of Rman, including some of the author's own experience, the experiment is basically all in the win 2K and Oracle 8.1.6 Environment Test success (because this environment is relatively easy to implement). This article for reference to some of the online experts related articles, I hope

Seven Online Rman Database backup 7.1 Online Database backup To perform an online backup operation using Rman, the database must be placed in Archivelog mode. If you are not in archive mode, Rman generates an error when you attempt an online backup. Oracle Archiving and non-archive switching Http://blog.csdn.net/ti

After a database restore, try set newname but the error RMAN-06015. We can hand catalog in first, in set NewName. You can look at the following test cases: --1. The pure set newname is OK. Rman> run{2> set newname for datafile 6 to '/u01/oracle11gr2/oracle/oradata/ora11g/u_nolob2.dbf222 ';3>}Executing Command:set NEWNAMERman>

location: Run { Set archivelog destination to "D:/arch"; Restore Archivelog All; } Note: 1. The set command in the example above has no workaround and must require the use of set. 2. If Rman believes that an archived redo log already exists, it will not restore the archived redo log on disk, and Oracle will not restore archived redo logs in this new location, even if the restore location is set diff

http://blog.csdn.net/u011364306/article/details/50036429 of Rman Level012 Backup experiment With a 0221222 incremental backup strategy, 7 days a cycle That is, Sunday level 0 backup, Week 1 2 4 5 6 using 2 level incremental backup, week 3 with 1 level incremental backup Open Control File Automatic backup CONFIGURE Controlfile autobackup on; 11g control file Automatic backup new features: http://blog.csdn.net/u011364306/article/details/50051303 Conf

Oracle 10g R2 supports manually moving databases across platforms, even if these platforms have different mantissa formats (endian format). The mantissa format is related to byte ordering, which has two different formats, the large mantissa and the small mantissa. If you move the database between platforms in different mantissa byte formats, you will need to manually manipulate and use the convert datafile or convert tablespace command of

oracle| Quick Start Preface This article mainly introduces the common methods of Rman, including some of the author's own experience, the experiment is basically all in the win 2K and Oracle 8.1.6 Environment Test success (because this environment is relatively easy to implement). This article for reference to some of the online experts related articles, I hope

ORACLE Rman Backup and restoreRman can be incrementally backed up: database, tablespace, data fileOnly used blocks can be backed up as backup setTablespace and Data file correspondence: Dba_data_files/v$datafile_headerIn Noarchivelog mode, you can use Rman to back up read-only and offline table spacesORACLE Rman Downti

RMAN-04015 error reported when rman cannot be enabled after manual Oracle database creation The solution is as follows:SQL> shutdown immediate;SQL> startup upgrade;SQL> @? /Rdbms/admin/utlirp. SQLSQL> @? /Rdbms/admin/utlrp. SQLSQL> shutdown immediate;SQL> startup;Where:Utlirp. SQL is used to compile all relevant content on the 32bit platform.Utlrp. SQL is used to

Note: Rman backup (supports SPFile-based backup only and does not support Init.ora configuration-based backups)exercise: Turn on Archivelog mode1\ For archived redo logs are referred to FRA and separate archive log target SQL>Show parameter db_recovery_file_dest; SQL>AlterSystemSetDb_recovery_file_dest_size=2G; SQL>AlterSystemSetDb_recovery_file_dest='/u01/app/oracle/fast_recovery_area'; 2\ Now, define two