This content has been marked as final. Show 17 replies
** edited **
Thx! I'm going to try.
Please do not post links to commercial sites, consequently promoting/spamming this site.
Senior Oracle DBA
sorry, i just edited the post
What are the last enteries in the alert log?
If you login as sysdba and run startup what error occurs?
I've tried next:
The result is:
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
ORA-16038: log 2 sequence# 6930 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: 'D:\ORACLE\PRODUCT\10.1.0\ADMIN\ORACLE\REDO02.LOG
You must do:
ORA-16038: log 2 sequence# 6930 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 2 thread 1: 'D:\ORACLE\PRODUCT\10.1.0\ADMIN\ORACLE\REDO02.LOG
alter system set db_recovery_file_dest_size=<size> scope=both;
2) Delete old redo logs (For example):
rman> backup archivelog all delete input ;
rman> delete expired archivelog all;
rman> delete archivelog until time '(sysdate -10)';
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.
I can't increase the db_recovery_file_dest_size. I get a response mentioned in previous posts.
Concerning disk space, I have it enough.
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?
Thx in advance!
(Sorry if the post is wide)
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?
Thx in advance.
If bouncing the listener does not help try restarting instance, may be the instance is not opened or may be its in exclusive mode... Give a try1 person found this helpful
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?
Thx in advance.