RMAN 2005-04-18 - By m.colom@(protected)
Hi
The target database must be open. rman is complaining that it isnt, or
perhaps tnsnames.ora doesnt have an entry for target DB.
connected to target database (not started)<<---
connected to recovery catalog database
connected to auxiliary database (not started)
regards
Miquel Colom Pizá
Director Area Técnica
Dept. Sistemas Hotelbeds S.L.
c-Joan Muntaner i Bordoy s/n Bjs.
07006 - Palma de Mallorca
Telf. +34 971178839
Fax. +34 971465062
Maurice Kemmann <kemmann@(protected)>
16/04/2005 19:18
Por favor, responda a
kemmann@(protected)
Para
Scott Miller <scottm@(protected)>
cc
Oracle Liste <suse-oracle@(protected)>
Asunto
RE: [suse-oracle] RMAN
Hi Scott,
Am Samstag, den 16.04.2005, 12:50 -0400 schrieb Scott Miller:
> looks like a tns config error. check that your listener provides a
service with a name
> identical to the one in your tnsnames.ora entry. use "lsnrctl status",
etc.
yes i think so too but i have no idea which entry i need. All tnspings
between the two servers work fine. Somehow the command
rman target / catalog rman/rman@(protected) auxiliary sys/PASSWORD@(protected)
makes the problem. Setting the ORACLE_SID to STANDBY( alias in the
tnsnames) and using
rman target / catalog rman/rman@(protected) auxiliary sys/password
works for the connection ! RMAN says:
Recovery Manager: Release 10.1.0.3.0 - 64bit Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database (not started)
connected to recovery catalog database
connected to auxiliary database (not started)
RMAN>
But the following script does not work. I guess because of the wrong
ORACLE_SID.
Script:
run {
allocate auxiliary channel aux1 device type disk;
duplicate target database for standby nofilenamecheck;
release channel aux1;
}
Error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 04/16/2005 19:15:26
RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-01034 (See ORA-01034.ora-code.com): ORACLE not
available
RMAN> **end-of-file**
Any idea ?
Thanx in advance,
Maurice
--
OpenIT GmbH tel +49 211 239 577-0
Maurice Kemmann fax +49 211 239 577-10
Jahnstr. 18 email kemmann@(protected)
D-40215 Düsseldorf http://www.openit.de
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
