Showing posts with label RMAN. Show all posts
Showing posts with label RMAN. Show all posts

Monday, August 26, 2013

Monday, December 3, 2012

RMAN>STARTUP DBA - restrict database

How to startup a database in rman for restricted sessions. You would say conform SQLPLUS

SQLPLUS
SQL> startup restrict 
RMAN
RMAN> startup restrict 
It's not working, the word restrict generate an error inside RMAN.

Friday, May 20, 2011

RMAN Configuration in Data Guard [Archivelog Deletion Policy]

Follow these steps to configure RMAN backups in Data Guard environment. When you want to managed the archivelog deletion policy from one centralpoint.

CONFIGURE ARCHIVELOG DELETION POLICY

Possible options :

APPLIED ON STANDBY - enables flash recovery area to delete archivelogs that are applied on mandatory standby.

NONE - enables flash recovery area to delete archivelogs that are backed up to tertiary device and that are obsolete based on the configured backup retention policy. This is the default configuration.

CLEAR - clears the deletion policy and returns the specified configuration to default value. The default value is NONE.

Thursday, March 31, 2011

Flash Recovery Area backup to disk with RMAN

Is it possible to do a RMAN backup of the Flash Recovery Area (FRA) to disk. The standard method by RMAN is that this is only possible with the use of a SBT channel/library. The RMAN command 'BACKUP RECOVERY AREA' works only with SBT channels, meaning a tertiary storage such as tape.

Oracle has introduce an emulator for SBT library to do a backup of the FRA to disk. The RMAN disksbt library, which emulates a SBT library (but it writes the backups to a disk location). This disksbt, can be used to test backup the FRA to a disk location

Thursday, December 9, 2010

Dynamic listener registration (instance registration) - Connections via the Listener to the Database [TNS-12526 - TNS-12527 - TNS-12528 ]

If you are using dynamic listener registration (instance registration). The instance does not register with the listener until you mount the controlfile. Without sysdba, Net service name using SID or Net service name using SERVICE_NAME with UR=A .


RMAN requires a static listener entry and the tnsnames.ora should not contain FAIL_OVER=ON or LOAD_BALANCING. Just a plain vanilla dedicated server connection.

RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections