ERROR at line 1:ORA-00210: cannot open the specified controlfileORA-00202: controlfile: '/home/oracle9/oradata/XRP/control01.ctl'ORA-27041: unable to open fileIBM AIX RISC System/6000 Error: 2: No such file or directoryAdditional information: 3
Ou ORA-00205: error in identifying controlfile, check alert log for more info
Actions :
- Se connecter sous ‘oracle9’.
- Fermer la base : ‘dbshut’.
- Restaurer le fichier manquant par copie d’un des fichiers de contrôle valides.
o Lancer ‘cd /oradata/XRP ;cp control02.ctl /oradata/XRP/control01.ctl’- Relancer la base normalement.
$ dbstart SQL*Plus: Release 9.2.0.1.0 - Production on Wed May 19 16:39:42 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> Connected to an idle instance.SQL> ORACLE instance started. Total System Global Area 773292736 bytesFixed Size 742080 bytesVariable Size 134217728 bytesDatabase Buffers 637534208 bytesRedo Buffers 798720 bytesDatabase mounted.Database opened.SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production Database "XRP" warm started.
- Tester une requête.
