03-29-2013 12:57 PM
I am trying to perform a Oracle Restore and it failed, I have very limited experience so my troubleshooting skills are limited.
Any idea of what I am doing incorrectly?
from RMAN I did the following, I am trying to restore the entire Database from a specific day. In this case a Full Oracle Backup I did this morning.
03-30-2013 06:10 AM
Please suggest how to Restore Oracle Data.. can we restore from Master server..
Please share any technote...
Ankit Maheshwari
03-30-2013 08:14 AM
can we restore from Master server..
03-30-2013 08:15 AM
THis is syntax error in RMAN - not related with NetBackup. Please ask Oracle DBA or experts to check your command lines.
IF you want to restore backups taken by Netbackup, you need to allocate SBT channel. But no such statement here.
04-15-2013 01:38 AM
Are you using recovery catalog or nocatalog? Or autobackup? Is the backup on a filesystem or on external media (tape or disk)?
You need to have the database in nomount state when you are restoring controlfile. You can do that as follows:
su - oracle
export ORACLE_SID=DBSID
sqlplus / as sysdba
shutdown immediate;
startup nomount;
For recovery:
This restores controlfile and puts the database in mount state so you can continue with database restore. Note that you need put the client name and policy there, and also edit the timestamp to which you want to do the point-in-time recovery. Also you need to put DBID before you start. Everything is done in RMAN.
SET DBID=<bunch of numbers here>;
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' parms='ENV=(NB_ORA_CLIENT=client_name@here.com,NB_ORA_POLICY=policy_name_here)';
set until time "to_date('2010 Jan 31 21:30','yyyy mon dd hh24:mi')";
restore controlfile;
sql 'alter database mount';
}
This restores and does a recovery for the database. Note that you need put the client name and policy there, and also edit the timestamp to which you want to do the point-in-time recovery.
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' parms='ENV=(NB_ORA_CLIENT=client_name@here.com,NB_ORA_POLICY=policy_name_here)';
set until time "to_date('2010 Mar 21 21:30','yyyy mon dd hh24:mi')";
restore database;
recover database;
}
After that you need to open the database using either resetlogs or noresetlogs. Resetlogs zeros the sequence numbering, noresetlogs doesn't. It is recommended that you use resetlogs and do the database opening in sqlplus.
sqlplus / as sysdba
alter database open resetlogs;
-v