RE: RMAN questions

From: Rama Malladi <rmalladi_at_inteliant.com>
Date: Mon, 11 Dec 2000 07:52:06 -0800
Message-Id: <10707.124199@fatcity.com>

Surendra,
1)
Make sure that you have the DB name in the TNSNAMES file on the machines involved. I normally issue the following command to connect to the catalog. In this case as I am on the same machine as the target database there is no need of @ for the target.

rman target sys rcvcat rman/rman_at_testdb

2)
I am enclosing the recent recovery output (only the relevant O/P as the complete one is too big) for one of our production systems. As you can see in the end, RMAN did the media recovery from the online log files. FYI, I could recover the system completely in this case! Few months ago, I had to do incomplete recovery as data from the online logs could not be recovered due to Ora-600.

................................................
RMAN-08089: channel c1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to /u08/oradata/arborora/sysarbor.dbf

RMAN-08523: restoring datafile 00006 to /u01/oradata/arborora/ADM_REF01.dbf RMAN-08523: restoring datafile 00007 to
/u04/oradata/arborora/ADM_REF_IDX01.dbf

RMAN-08523: restoring datafile 00073 to /u02/oradata/arborora/usrarbor3.dbf
RMAN-08023: channel c1: restored backup piece 1
RMAN-08511: piece

handle=/backup/oracle/arbor-106/Level0_arborora_414648636_605_1.bs params=NULL

................................................

RMAN-08024: channel c2: restore complete
RMAN-08039: channel c1: starting incremental datafile backupset restore
RMAN-08502: set_count=737 set_stamp=415253418 creation_time=02-DEC-00

RMAN-08089: channel c1: specifying datafile(s) to restore from backup set RMAN-08509: destination for restore of datafile 00019:
/u04/oradata/arborora/CAT_OLTP_IDX01.dbf
RMAN-08509: destination for restore of datafile 00028:
/u04/oradata/arborora/CUST_MISC_LV1_IDX01.dbf
RMAN-08509: destination for restore of datafile 00061:
/u01/oradata/arborora/CUST_EMF_PROD01.dbf
RMAN-08023: channel c1: restored backup piece 1 RMAN-08511: piece
handle=/backup/oracle/arbor-106/Level1_arborora_415253418_737_1.bs params=NULL
RMAN-08024: channel c1: restore complete

RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-08515: archivelog filename=/u06/oradata/arborora/LOG6.ORA thread=1

sequence=837
RMAN-08515: archivelog filename=/u06/oradata/arborora/LOG7.ORA thread=1 sequence=838
RMAN-08515: archivelog filename=/u06/oradata/arborora/LOG8.ORA thread=1 sequence=839
RMAN-08515: archivelog filename=/u06/oradata/arborora/LOG9.ORA thread=1 sequence=840
RMAN-08055: media recovery complete

RMAN-03022: compiling command: recover(4)
RMAN-08031: released channel: c1
RMAN-08031: released channel: c2

RMAN>

Rama Malladi, Sr. Oracle DBA
Oracle Certified Professional (Oracle 8i DBA) Inteliant Corp., California
RMALLADI_at_inteliant.com

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Tirumala, Surendra HS
Sent: Friday, December 08, 2000 11:48 AM To: Multiple recipients of list ORACLE-L Subject: RMAN questions

Hi List,

I am in the process of developing bkup & reco strategy.I have a couple of questions for the list.

1)
I am not able to connect to target database if I issue

$rman target system/pwd_at_test rcvcat rman/rman_at_rman

I am not using any pwd file with target db.

I am able to connect to, if I issue

$rman target / catalog rman/rman_at_rman

My doubt is whether the OS level privileges are allowing me to connect like this or something else is there.

2)
I developed scripts to take consitent(cold) bkup and hot bkups.

I need some clarifications regarding my following assumption.

RMAN can never take the bkup of current online logfile(the file in which 'shutdown immediate/normal' command is there) And to recover the database (complete) this log file is very much needed. The only way to let RMAN know about this logfile is to bakup at OS level and catalog this.

Looking forward for help in this regard,

Surendra

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tirumala, Surendra   HS
  INET: surendra.tirumala_at_hs.utc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Mon Dec 11 2000 - 09:52:06 CST