Unsolved
This post is more than 5 years old
104 Posts
0
1988
July 15th, 2009 06:00
Restore Oracle database in Networker Module for Documentum
Hi,
I am using NetWorker server 7.5sp1, NetWorker Module for Oracle 5.0, NetWorker Module for Documentum 1.2.
Full backup of Documentum was created successfully.
I've encountered with a problem of database (Oracle) restore:
I don't quite understand how to use RMAN script, value SA_START from report generated by nsrnmdx for restore of database.
What command should I call with any params?
I'll be very pleased for comments.
Message was edited by:
APryamikov
I am using NetWorker server 7.5sp1, NetWorker Module for Oracle 5.0, NetWorker Module for Documentum 1.2.
Full backup of Documentum was created successfully.
I've encountered with a problem of database (Oracle) restore:
I don't quite understand how to use RMAN script, value SA_START from report generated by nsrnmdx for restore of database.
What command should I call with any params?
I'll be very pleased for comments.
Message was edited by:
APryamikov
No Events found!



apriam_i
104 Posts
0
July 15th, 2009 23:00
commands:
connect target zero/***@csdb
shutdown immediate
worked successufully
Command startup mount; printed error message in console output:
RMAN> startup mount;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 07/16/2009 11:22:21
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Message was edited by:
APryamikov
ble1
4 Operator
•
14.3K Posts
0
July 21st, 2009 13:00
apriam_i
104 Posts
0
July 22nd, 2009 01:00
Problem with fixed tns listener fixed
My RMAN restore script is:
connect target sys/111@csdb;
RUN {
ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH2 TYPE 'SBT_TAPE';
SEND 'NSR_ENV=(NSR_SERVER=d65,
NSR_RECOVER_POOL=Documentum,
NSR_CLIENT=d65)';
RESTORE TABLESPACE DM_ZERO_DOCBASE;
RECOVER TABLESPACE DM_ZERO_DOCBASE;
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
}
Restore of database finished sucessfully. Part of log file:
Starting restore at 22-JUL-09
channel CH1: starting datafile backup set restore
channel CH1: specifying datafile(s) to restore from backup set
channel CH1: restoring datafile 00008 to C:\APP\DMADMIN\ORADATA\CSDB\DM_ZERO20090714174443_DB.DBF
channel CH1: reading from backup piece /CSDB_FULL_CSDB_03kkp2tc_1_1/
channel CH1: piece handle=/CSDB_FULL_CSDB_03kkp2tc_1_1/ tag=TAG20090722T111907
channel CH1: restored backup piece 1
channel CH1: restore complete, elapsed time: 00:00:07
Finished restore at 22-JUL-09
Starting recover at 22-JUL-09
starting media recovery
media recovery complete, elapsed time: 00:00:04
Finished recover at 22-JUL-09
released channel: CH1
released channel: CH2
Recovery Manager complete.
When I run query:
'select count(r_object_id) from dm_document' the result '13'
Originally it were 228 objects of type dm_document.
Part of them I've deleted (only 13 objects where left in DB).
After restore of DB count query returns '13' as result. It's not same quantity as in original backed up database.
Message was edited by:
APryamikov
apriam_i
104 Posts
0
July 22nd, 2009 06:00
connect target sys/111@csdb;
RUN {
ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH2 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH3 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH4 TYPE 'SBT_TAPE';
SEND 'NSR_ENV=(NSR_SERVER=d65,
NSR_CLIENT=d65)';
SET UNTIL TIME "TO_DATE('22/07/2009-15:05:58', 'DD/MM/YYYY-HH24:MI:SS')";
RESTORE TABLESPACE DM_ZERO_DOCBASE ;
RECOVER TABLESPACE DM_ZERO_DOCBASE ;
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
RELEASE CHANNEL CH4;
}
After running restore scripts I see same situation:
Database was not returned to position before backup. =(
Any ideas are welcome.
apriam_i
104 Posts
0
July 27th, 2009 06:00