RE: RMAN questions

Rama,
Thank you for your response.

1. Regarding connectivity , it is working well now with either of the ways.
2. Regarding bkup of online log files, can you please clarify me whether your onlone log files are intact when failure occured.I am just curious to know this as I had to do incomplete recovery when I simulated loss of online log file. I will test this again, If I am wrong.

regards,
Surendra

> -----Original Message-----
> From: Rama Malladi [SMTP:rmalladi_at_inteliant.com]
> Sent: Monday, December 11, 2000 10:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RMAN questions
>
> 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-----
> Surendra HS
> Sent: Friday, December 08, 2000 11:48 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rama Malladi
> INET: rmalladi_at_inteliant.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
Received on Mon Dec 11 2000 - 11:19:52 CST