ORA-12514: RMAN connection error resolution

Source: Internet
Author: User
An error occurred while connecting to the database using rman today. [linuxidc @ rhel55 ~] $ RmantargetsysOracle @ orclORA-12514: TNS: listenerdoesnotcurrentlyknow

An error occurred while connecting to the database using rman today. [linuxidc @ rhel55 ~] $ Rman target sys/Oracle @ orcl ORA-12514: TNS: listener does not currently know

An error occurred while connecting to the database using rman today.
[Linuxidc @ rhel55 ~] $ Rman target sys/Oracle @ orcl

ORA-12514: TNS: listener does not currently know of service requested in connect descriptor
[Linuxidc @ rhel55 ~] $ Lsnrctl stop

[Linuxidc @ rhel55 ~] $ Cd $ ORACLE_HOME

[Linuxidc @ rhel55 db_1] $ vim listener. ora

Modify the/u01/app/oracle/product/11.2.0/db_1/network/admin/listener. ora File
Add
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME =/u01/app/oracle/product/11.2.0/db_1)
)
)
Then restart the lisener service and then [linuxidc @ rhel55 db_1] cd [linuxidc @ rhel55 ~] $ Lsnrctl start

[Linuxidc @ rhel55 ~] $
[Linuxidc @ rhel55 ~] $ Rman target sys/oracle @ orcl

Recovery Manager: Release 11.2.0.1.0-Production on Wed Oct 3 04:37:05 2012

Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.

Connected to target database: ORCL (DBID = 1302004769, not open)

RMAN> show all;

Using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
Configure retention policy to recovery window of 31 DAYS;
Configure backup optimization on;
Configure default device type to disk; # default
Configure controlfile autobackup on;
Configure controlfile autobackup format for device type disk to '% F'; # default
Configure device type disk parallelism 1 backup type to backupset; # default
Configure datafile backup copies for device type disk to 1; # default
Configure archivelog backup copies for device type disk to 1; # default
Configure maxsetsize to unlimited; # default
Configure encryption for database off; # default
Configure encryption algorithm 'aes128 '; # default
Configure compression algorithm 'basic 'as of release 'default' optimize for loa d true; # DEFAULT
Configure exclude for tablespace 'sysaux ';
Configure exclude for tablespace 'users ';
Configure exclude for tablespace 'example ';
Configure archivelog deletion policy to none; # default
Configure snapshot controlfile name to '/u01/app/oracle/product/11.0.2/db_1/dbs/snapcf_orcl.f'; # default

RMAN> exit
[Linuxidc @ rhel55 ~] Rman help # view help
[Linuxidc @ rhel55 ~] Rman target sys/oracle @ orcl log/home/linuxidc/rman_log.txt # record logs
RMAN> configure device type disk parallelism 4 backup type to compressed backupset;
RMAN> configure device type disk clear; # reset
RMAN> configure device type sbt_tape parallelism 4 backup type to backupset;
RMAN> configure device type disk clear; # reset again
RMAN> configure device type sbt_tape parallelism 4 backup type to compressed backupset;
RMAN> configure device type disk clear; # reset again
RMAN> configure device type disk parallelism 4 backup type to copy; # copy can only be of the disk type
RMAN> configure device type disk clear; # reset again
RMAN> configure retention policy to recovery window of 7 days; # backup retention policy based on the recovery window, 7 days
RMAN>
RMAN> configure retention policy clear; # The default is based on the redundancy policy. Each file must have at least one copy.

Old RMAN configuration parameters:
Configure retention policy to recovery window of 7 DAYS;
RMAN configuration parameters are successfully reset to default value

RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are:
Configure retention policy to redundancy 1; # default

RMAN> config retention policy to redundancy 2; # Based on redundancy, each file must have at least two copies

RMAN> configure retention policy to recovery window of 0 days;
RMAN> report obsolete; # view outdated backup files
RMAN> delete obsolete; # delete outdated backup files based on the retention policy
RMAN> configure retention policy to recovery window of 7 days;

,

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.