When to use the option clause "PASSWORD FILE" in the RMAN DUPLICATE command ?
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
SQLPLUS
SQL> startup restrictRMAN
RMAN> startup restrictIt'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
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 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
Subscribe to:
Posts (Atom)