Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

Oracle 11g startup issue after Linux VM restore

Guest OS Oracle Linux 4/5/6(64-bit).
I restored the VM with a commercial backup/restore agent but unable to startup the database. Please see error message below.

SQL> select status from v$instance;
select status from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/MySID/spfileMySID.ora'
ORA-17503: ksfdopn: 2 Failed to open file +DATA/MySID/spfileMySID.ora
ORA-29701: unable to connect to cluster synchronization service
0
mrong
Asked:
mrong
  • 7
  • 7
1 Solution
 
sdstuberCommented:
Is your ASM instance started?
Is your clusterware started?
0
 
mrongAuthor Commented:
The listener must be started before starting the database,right?
0
 
sdstuberCommented:
yes, but your errors aren't listener errors, they are cluster and asm errors
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
mrongAuthor Commented:
tried lsnrctl status
got connecting to (ADDRESS=(PROTOCOL=tcp) (HOST=)(PORT=1521)
TNS-12541: TNS: no listener
TNS-12560: TNS: protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

In the tnsnames.ora and listener.ora the HOST are set to the host name.
0
 
sdstuberCommented:
lsnrctl start

but your previous errors point to other issues
0
 
mrongAuthor Commented:
How to reset ASM?
0
 
gheistCommented:
You cannot reset anything. You need to restore Oracle from RMAN backup. Storage cloning/backups could only work with completely shut down oracle DB provided they properly include all oracle data and temporary files of same moment.
0
 
mrongAuthor Commented:
There is no data imported in my database. Now my problem is to start ASM instance.
Maybe I need to rebuild the database?

Thanks.
0
 
sdstuberCommented:
>>> ORA-29701: unable to connect to cluster synchronization service

Has this been addressed yet?

crsctl check cluster -all
0
 
mrongAuthor Commented:
I tried the following
[oracle@db01 ~] $ crsctl check cluster
bash: crsctl: command not found
0
 
sdstuberCommented:
set your path to include your grid control home's bin directory

if your cluster ware was installed with role separated management you will need to login or su to the grid owner

also, include the "-all"
0
 
mrongAuthor Commented:
From linux->Application->System Tools->Disk Utility, I can see DATA1,DATA2, FRA1 are not mounted.
Can I mount it back?
Thanks.
0
 
sdstuberCommented:
you tell us,  can you?

my guess is no because your clusterware isn't running.  Or if it is, we don't know because we don't have any status info on it.
0
 
mrongAuthor Commented:
how to set my path to include the grid control home's bin directory?
0
 
sdstuberCommented:
I think you should bring your system admin and dba in to help you navigate through your system setup.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 7
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now