Video Screencast Help

restore the oracle database with rman

Created: 10 Jun 2013 • Updated: 02 Jul 2013 | 1 comment
This issue has been solved. See solution.

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

 

 

 

Operating Systems:

Comments 1 CommentJump to latest comment

Will Restore's picture

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.

 

 

Will Restore -- where there is a Will there is a way

SOLUTION