The following error occurs when RMAN is used for full-Database Backup:
RMAN> backup database format = 'd:/orabak/20081008_fullbk.bak 'tag = 'seagal'; Start backup from March 10 to 08 using the channel ora_disk_1 ora_disk_1: start all data file
(1) Create an OS directory for storing backup database-Related Files
(2) create a routine service
(3) configure the listener and Network Service name
(4) Prepare the parameter file of the primary database
(5) Prepare backup database parameter files
(6) Enable the standby routine and establish the standby Database
(7) Enable the standby Database
Back up the database first:
C: \>
:~ /Oradata/temp> mv eygle. f eygle_bak.f
8. Modify the table space egyle Status online. An error is returned.
SQL> alter tablespace eygle online;Alter tablespace eygle online*ERROR at line 1:ORA-01157: cannot identify/lock data file 29-see DBWR trace fileORA-01110: data file 29: '/home/oracle/oradata/temp/eygle. F'
9. rman recovery
RMAN> restore tablespace eygl
(1) Create an OS directory for storing backup database-Related Files
(2) create a routine service
(3) configure the listener and Network Service name
(4) Prepare the parameter file of the primary database
(5) Prepare backup database parameter files
(6) copy relevant files to the backup host
(7) Enable the backup routin
I. Basic Theoretical knowledge of rman backup
Rman (recovery manager) is used to manage backup, dumping, and recovery operations. When the rman command is executed, Oracle parses these commands into PL/SQL blocks, the server proce
, And you cloned to system B, only C drive is available ). Of course, you can do this using other methods, such as export/import. You can also play the recreate control file game. However, the read-only tablespaces game is not very fun. Although the solution is also very simple.
4. I almost forgot. If your database is ill and you want Oracle support to help you, and if he asks you to recreate the control file, you probably won't have a choice.
I haven
Label:I. Rman Backup Source LibraryNote the point:It is best to keep the Rman backup log $rman target/log=Backup.log RMAN>Run {Allocate channel T1 type disk; Allocate channel t2 type disk; allocate channel T3 type disk; allocate c
+ % W ` 23 Date_2 =' Date + % Y % m % D' 24 Backup_path =/u01/APP/Oracle/ Rman_bak 25 # Input parameters: Backup level 26 Level = $ @ 27 Target_sid =Emar 28 Rman_sid = Emar. Emar 29 Bin =/u01/APP/Oracle/db10g/ Bin 30 31 # Delete the data backuped Last Time You can modify the value based on the backup r
Rman backup script rman shell script editing is first tested in rman to check whether the backup is normal. The statement is being judged. Backup script sh command export target/msglog =/oracl
RMAN recovery is divided into full recovery and Incomplete recovery. Full recovery, as its name implies, is to restore data based on full backup. However, in the real environment, such recovery is very useful.
RMAN recovery is divided into full recovery and Incomplete recovery. Full recovery, as its name implies, is to restore data based on full
Rman fully preparedparameter files, control files, data files, archive logs, not back up online log filesrman> backup Database;Rman backup is divided into copy physical backup: The source file is as large as the backup fileBackup
connect to the backup database.
RMAN> backup database include current controlfile for standby plus archivelog; // note that the standby control file is created while the database is backed up, and archive logs are included. It can also be split into backup database; copy current controlfile for standby to '/tmp/st. ct
Backup | data | database
Oracle9i begins Rman to provide the plus archivelog option, greatly simplifying the operation of the Rman backup.
When you define the plus Archivelog statement, Rman performs the following steps:
1. Run an alter SYSTEM archivelog current command
2.
the Oracle networking configuration using TNSNames or a equivalent for Both the target and recovery catalog instances:RMAN>Connect Catalog Rcat/Rcat@rman;--Connect to the recovery catalog database Rman-00571:===========================================================RMAN-00569:===============ERROR MESSAGE STACK follow
1: first, restore the spfile parameter file information in the backup of the control file.
RMAN> set dbid = 1133434343Executing command: SET DBID
RMAN> startup nomount;Startup failure: ORA-01078: failure in processing system parametersLRM-00109: cocould not open parameter file '/u01/oracle/product/10.2.0/db_1/dbs/inith
required for recovery. Scenario 1: Use the catalog Database 1. Create a catalog tablespaceCreate tablespace rman_tsDatafile 'xxxxxxxx/rman_ts01.dbf'Size 10 m; 2. Create an rman userCreate user rman identified by rmanDefault tablespace rman_tsTemporary tablespace tempQuota unlimited on rman_ts 3. user authorizationGrant recovery_catalog_owner to rmanGrant resource, connect to
Oracle RMAN-06023 and ORA-19693 errors
When restoring a 0-level backup database to another machine, first encountered a RMAN-06023 and then encountered a ORA-19693 error, the error occurred in the environment and content is roughly as follows:Database Version:
Start restoring the database:
SQL> select * from v $ versio
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.