I'm new in Oracle and learning it. I have Oracle Database Server 10.1. on the windows 2003 server platform. The issue is: a database is down. Question is: how can I revive database on an another server (also win 2003) if I have files from folders archivelog, autobackup, backupset and datafile?
Recovery file dest size is full. so that log file cannot be archived. please increase the db_recovery_file_dest_size or If you don't have sufficent space on your disk, just delete expired archivelog and expired backup set.
Let's start from the beginning! What ever happend with database (it's not working), I'm trying clone database to another server by rman. When I try start rman, I get message ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. Listener's name is dbserver21. Host is ZZP-ORACLE21. Port is 1521. In Computer Management I have 2 services: OracleOraDb10g_home1TNSListener and OracleOraDb10g_home1TNSListenerdbserver21. In tnsnames.ora I have conn oracle21. In listener.ora I have dbserver21. How resolve the error?
I have been doing sthg and I get new message: ORA-12528: TNS: listener: all appropriate instances are blocking new connections. When I test lsnrctl status, I get a message: Instance "oracle", status UNKNOWN, has 1 handler(s) for this service. I tried stop, start, reload, but same response: status UNKNOWN.
Pls, any suggestion?
I have made some steps and suceeded to override last obstacle. But, I have been step on next obstacle. Now, I have next messages: ORA-01113: file 1 needs media recovery and ORA-01110: data file 1:'D:\ORACLE_RECOVERED\SYSTEM01.DBF'. How to do that? Or what to do?