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;
,