IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get “RMAN-10003: unable to connect to target database ” error.
Details of error are as follows.
RMAN-10003: unable to connect to target databaseCause: Recovery manager was unable to connect to the target database.
This message should be accompanied by other error message(s) indicating the cause of the error.
Action: Ensure that that the target database is started, and that the connect string is valid.
RMAN-10008: could not create channel context RMAN-10003: unable to connect to target database ORA-28000: the account is locked
This error is related with the RMAN Channel, or username password. To solve this error, check your Catalog and source database RMAN username and password,
Or You can clear the RMAN Channels as follows.
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR; old RMAN configuration parameters are successfully deleted RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK CLEAR; old RMAN configuration parameters: CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*'; old RMAN configuration parameters are successfully deleted starting full resync of recovery catalog full resync complete
Do you want to learn more details about RMAN, then read the following articles.
https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/
