Unsolved

This post is more than 5 years old

104 Posts

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

104 Posts

July 15th, 2009 23:00

I started rman manually

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

4 Operator

 • 

14.3K Posts

July 21st, 2009 13:00

104 Posts

July 22nd, 2009 01:00

Fixed password for connection.
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

104 Posts

July 22nd, 2009 06:00

RMAN script changed to:
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.

104 Posts

July 27th, 2009 06:00

Problem solved!
No Events found!

Top