Shulou(Shulou.com)06/01 Report--

This problem has been bothering me for a while when I first took over Oracle. Now let's share the process of solving the problem.

Oracle version: 11gR2

OS environment: Centos6.4

The problem reappears:

1. Take over the database is to write a backup script, the script content is as follows:

-

#! / bin/bash

# Name: rmanbk_level0.sh

# Write by: Datura at 2014-11-11 v1.0

# Description: The script is used to make the zero level backup for the orcl Library

# The definition of the variable

Lock_file=/tmp/rmanbk.lock

Oracleid= `cat / etc/passwd | grep oracle | awk-F:'{print $3}'`

# Check the script to run or not

If [- f $lock_file]; then

Pid= `cat $lock_ file`

Ps $pid & > / dev/null

[$?-eq 0] & & echo "Script is running..." & & exit 1

Fi

# Create process lock

Echo $$> $lock_file

# Only allows the oracle to run

[$UID-ne $oracleid] & & echo "Please run as oracle!" & & exit 4

# To set environment variables

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

Export PATH=$ORACLE_HOME/bin:$PATH

Export ORACLE_SID=orcl1

Export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Echo on

Rman target / msglog=/storage/script/log/rmanbk_level0_ `date +% yawning report obsolete% mummification% dongfuguo% homemade report obsolete% milieu% S`.log log

RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of 2 days

Report of obsolete backups and copies

Type Key Completion Time Filename/Handle

--

Control File Copy 5 12-DEC-14 + DATA/orcl/snapc_orcl.f

RMAN > delete noprompt obsolete

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03009: failure of delete command on c2 channel at 11/20/2014 09:03:14

ORA-19606: Cannot copy or restore to snapshot control file

RMAN > show snapshot controlfile name

RMAN configuration parameters for database with db_unique_name ORCL are:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ u01 apprenticespact oracleandproduct11.2.0Uniplicationdbroom1anddbsAccordssnapcfpictures orcl1.fills; # default

RMAN > configure snapshot controlfile name to'/ u01ActionAccording to an oracleproduct 11.2.0According to dbSplash snapcfharmorcl1.frankbak'

New RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ u01 apprenticespact oracleUniplicationproductUniverse 11.2.0Uniplicationdbbin1anddbsAccording to snapcfangorcl1.frankbak'

New RMAN configuration parameters are successfully stored

RMAN > crosscheck controlfilecopy'/ u01 ActionApplicationoracleUniplicationproductUniplicate11.2.0OnDbsAction1AccordingdbsAccordingorcl1.f'

Released channel: ORA_DISK_1

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=80 instance=orcl1 device type=DISK

Validation failed for control file copy

Control file copy file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl1.f RECID=2 STAMP=863884566

Crosschecked 1 objects

RMAN > delete expired controlfilecopy'/ u01 ActionApplicationoracleUniplicationproductUniplicate11.2.0OnDbsAction1AccordingdbsAccordingorcl1.f'

Released channel: ORA_DISK_1

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=80 instance=orcl1 device type=DISK

List of Control File Copies

=

Key S Completion Time Ckp SCN Ckp Time

--

2 X 17-NOV-14 67553950 17-NOV-14

Name: / u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl1.f

Tag: TAG20141117T155602

Do you really want to delete the above objects (enter YES or NO)? Yes

Deleted control file copy

Control file copy file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl1.f RECID=2 STAMP=863884566

Deleted 1 EXPIRED objects

RMAN > configure snapshot controlfile name to'/ u01 ActionApplicationoracleUniplicationproductUniplicate11.2.0OnDbsAction1AccordingdbsAccordingorcl1.f'

Old RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ u01 apprenticespact oracleUniplicationproductUniverse 11.2.0Uniplicationdbbin1anddbsAccording to snapcfangorcl1.frankbak'

New RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ u01amp appActionoracleUniverse produce 11.2.0Uniplicationdbroom1anddbsActionsnapcfpictures orcl1.f'

New RMAN configuration parameters are successfully stored

RMAN > configure snapshot controlfile name clear

Old RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/ u01amp appActionoracleUniverse produce 11.2.0Uniplicationdbroom1anddbsActionsnapcfpictures orcl1.f'

RMAN configuration parameters are successfully reset to default value

4. The problem was temporarily solved through the above routine operation, but the same problem will occur again in a few days.

-

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03009: failure of Control File and SPFILE Autobackup command on c1 channel at 12/12/2014 01:05:19

ORA-00245: control file backup failed; target is likely on a local file system

5. The above routine operation can only solve the problem temporarily, not the fundamental problem, so look through the official documents and get the following information

-

Starting with 11gR2, you no longer need to lock controlfile enqueue when backing up control files

There is no change for databases in non-RAC environments

But for the RAC environment, because of the change in the control file backup mechanism

All nodes in the cluster must be able to access snapshot control files, so snapshot control files must be visible to all instances

If the snapshot control file is not placed on the shared device, the above error occurs when rman backs up the snapshot control file

6. Make the following adjustments based on the information obtained

- -

RMAN > show snapshot controlfile name

RMAN > configure snapshot controlfile name to'/ storage/snap_control/snapcf_%d_%I_%s_%p_%T.f'

RMAN > configure snapshot controlfile name to'+ DATA/orcl/snapcf_orcl.f';-can also be assigned to the corresponding ASM disk group (wildcard naming is not supported for disk groups)

The above error does not occur after the snapshot of the control file is placed on the shared storage.

When problems arise, we are all used to using our own experience and using conventional methods to solve problems.

But sometimes flipping through official files is a good choice.

Although the official file can't tell you the specific operation steps.

But it can give the right guidance to solve the fundamental problem.

-the above is a personal point of view, if there is anything wrong Welcome to give us some advice.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.