Oracle DB Backup Recovery directory ____oracle

Source: Internet
Author: User
Tags reserved
The retention policy for the recovery directory is configured, and then the recovery directory is backed up. 1 Set up the environment for the ORCL database.
[Oracle@rtest ~]$ Export oracle_sid=test0924
2 starts RMAN and uses the recovery directory database as the target without specifying a directory.
[Oracle@rtest ~]$ Rman Target sys@rcat1028
Recovery manager:release 11.2.0.3.0-production on Mon Oct 28 16:17:22 2013
Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.
Target database Password: Hu Jintao Connected to target database:rcat1028 (dbid=2744053659)
Rman> 3 ensures that the retention policy for the recovery directory has been set to redundancy greater than 1. If the value is not greater than 1, it is set to at least 2.
Rman> Show retention policy;
Using target database control file instead the recovery catalog RMAN configuration parameters for database with Db_unique_n Ame RCAT1028 are:configure RETENTION POLICY to redundancy 1; # Default
Rman> CONFIGURE RETENTION POLICY to redundancy 2 2>;
New RMAN configuration Parameters:configure RETENTION POLICY to redundancy 2; New RMAN configuration parameters are successfully stored
4 try to back up the database. rman> backup Database;
Starting backup at 28-OCT-13 allocated channel:ora_disk_1 channel ora_disk_1:sid=190 device Type=disk channel Ora_disk_ 1:starting full datafile backup set channel ora_disk_1:specifying datafile (s) in backup set Rman-03009:failure of Backu P command on Ora_disk_1 channel at 10/28/2013 16:18:54 ora-19602:cannot Backup or copy active file in Noarchivelog mode C ontinuing Other job steps, job failed won't is re-run channel ora_disk_1:starting full datafile backup set channel ORA _disk_1:specifying DataFile (s) in backup set including-control file in backup set including current SPFILE in BAC Kup Set channel ora_disk_1:starting piece 1 at 28-oct-13 channel ora_disk_1:finished piece 1 at 28-oct-13 piece handle=+ recovery/rcat1028/backupset/2013_10_28/ncsnf0_tag20131028t161854_0.261.830017137 tag=TAG20131028T161854 comment= NONE Channel Ora_disk_1:backup set complete, elapsed time:00:00:04 RMAN-00571: ======================================= ==================== RMAN-00569: = = ============= ERROR message STACK follows =============== RMAN-00571: ================================================ ===========
Rman-03009:failure of Backup command on Ora_disk_1 channel at 10/28/2013 16:18:54 ora-19602:cannot Backup or copy active File in NoarchivelogMode
Rman>
Note that the open database cannot be backed up by a archivelog mode.   To ensure maximum availability, the recovery catalog database should run in Archivelog mode. 5) Exit RMAN.
Rman> exit
6 first set the environment for the RCAT1028 database, and then change the recovery catalog database to run in Archivelog mode. [Oracle@rtest dbs]$ export oracle_sid=rcat1028 [oracle@rtest dbs]$ Sqlplus/nolog
Sql*plus:release 11.2.0.3.0 Production on Mon Oct 28 16:21:36 2013
Copyright (c) 1982, Oracle. All rights reserved.
Sql> conn/as sysdba Connected. sql> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. Sql> Startup Mount ORACLE instance started.
Total System Global area 1235959808 bytes Fixed size 2227904 bytes Variable Size 738197824 by TEs database buffers 486539264 bytes Redo buffers 8994816 Database bytes. sql> ALTER DATABASE Archivelog;
Database altered.
sql> ALTER DATABASE open;
Database altered.
sql> archive log list; Database Log mode Archive mode Automatic archival Enabled Archive Destination Use_db_r Ecovery_file_dest oldest online log sequence 3 Next log sequence to archive 5 current log sequence 5 SQL&G  T 7 Confirm the RCAT1028 database environment, and log back on to RMAN as provided in the previous steps.
[Oracle@rtest ~]$ export oracle_sid=test0924 [oracle@rtest ~]$ rman Target sys@rcat1028
Recovery manager:release 11.2.0.3.0-production on Mon Oct 28 16:25:17 2013
Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.
Target database Password: Hu Jintao Connected to target database:rcat1028 (dbid=2744053659)
Rman>
9 Backup Recovery directory database. The operation should be successful at this time.
rman> backup Database;
Starting backup at 28-OCT-13 using target database control file instead of recovery catalog allocated Channel:ora_disk_1 Channel ora_disk_1:sid=131 device Type=disk channel ora_disk_1:starting full datafile backup set channel ORA_DISK_1:SP Ecifying DataFile (s) in backup set input datafile file number=00001 name=+data/rcat1028/datafile/system.262.830015445 Input datafile file number=00002 name=+data/rcat1028/datafile/sysaux.261.830015451 input datafile file number=00003 name=+data/rcat1028/datafile/undotbs1.265.830015451 input datafile file number=00005 name=+data/rcat01.dbf input datafile file number=00004 name=+data/rcat1028/datafile/users.259.830015453 channel ora_disk_1:starting piece 1 at 28- OCT-13 Channel ora_disk_1:finished piece 1 at 28-oct-13 piece tag20131028t162544_0.262.830017545 tag=tag20131028t162544 comment=none Channel Ora_disk_1:backup set complete, Elapsed TIME:00:03:25 Channel ora_disk_1:starting full dataFile backup set Channel ora_disk_1:specifying datafile (s) in backup set including control file in Backup set incl Uding current SPFILE in Backup set channel ora_disk_1:starting piece 1 on 28-oct-13 channel ora_disk_1:finished piece 1 At 28-oct-13 piece handle=+recovery/rcat1028/backupset/2013_10_28/ncsnf0_tag20131028t162544_0.263.830017753 tag= tag20131028t162544 Comment=none Channel Ora_disk_1:backup set complete, elapsed time:00:00:04 finished backup at 28-oct- 13
Rman> exit

Recovery Manager complete. [Oracle@rtest ~]$
Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.