cancel
Showing results for 
Search instead for 
Did you mean: 

restore the oracle database with rman

yaosergekouame
Level 3

Hello i have use the NBU rman script to backup the oracle database "TEST2".

ora2.JPG

the backup has worked fine, you can see the backup file and archive:

ora1.JPG

now i am try to restore all database with the content script:

ora3.JPG

ora4.JPG

and i meet and error 6 on NBU console find below the log generate by the script after run

 

ora5.JPG

Please could you help me

thank you

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Will_Restore
Level 6

database in nomount state?

http://www.symantec.com/business/support/index?page=content&id=TECH69229

 

 

Solution


 


Ensure that the database is in a mounted state and not open . To confirm the state Execute the following queries from SQL prompt:

1.      
SQL> SELECT STATUS FROM V$INSTANCE;
STATUS
--------
OPEN

If the database status shows as open , proceed step 2.

2. Login to Oracle database and follow the steps.


SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP NOMOUNT;

3. Now execute the restore job.

 

 

View solution in original post

1 REPLY 1

Will_Restore
Level 6

database in nomount state?

http://www.symantec.com/business/support/index?page=content&id=TECH69229

 

 

Solution


 


Ensure that the database is in a mounted state and not open . To confirm the state Execute the following queries from SQL prompt:

1.      
SQL> SELECT STATUS FROM V$INSTANCE;
STATUS
--------
OPEN

If the database status shows as open , proceed step 2.

2. Login to Oracle database and follow the steps.


SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP NOMOUNT;

3. Now execute the restore job.