Re: Re: RMAN backup of noarchivelog DB
Date: Fri, 30 Apr 2010 17:41:07 -0500
Message-ID: <h2tdb3c8dbf1004301541he26da7ecm5ed606450b3d3080_at_mail.gmail.com>
I have implemented Flora's method. I thought there might be a better way than shutting down service/db manually, but I am going to use that one.
Thanks everyone and thanks to Flora.
On Fri, Apr 30, 2010 at 7:45 AM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:
> If you must connect using sqlnet (using _at_service_name), I think make sure
> that you have an adminstrative connection (the ur=a option) configured in
> sqlnet, if I remember right, without that option you will be disconnected
> when the database shuts down. I dont remember for sure if that goes on the
> listener definition or the tnsnames definition.
>
>
> On Thu, Apr 29, 2010 at 3:33 PM, <anelson77388_at_gmail.com> wrote:
>
>> You should also be able to tnsping your target database. Given the
>> ORA-12154 which is a standard "don't have a tns entry for this database"
>> sort of message, it probable that once you get your sqlnet stuff sorted out
>> you should be good to go.
>>
>> Allan
>>
>> On Apr 29, 2010 2:27pm, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
>> > Are you running this on the same server that your database resides? If
>> so, set your oracle sid prior to starting rman, like this:
>> >
>> > export ORACLE_SID=dbname1
>> > $ORACLE_HOME/bin/rman target /
>> >
>> >
>> > On Thu, Apr 29, 2010 at 1:36 PM, Ram K lambu999_at_gmail.com> wrote:
>> >
>> >
>> >
>> > Thanks for helping Mark. I wanted to post the details before, but
>> putting the details along with the issue prevents the message from getting
>> posted because of size limitations or something. I had to wait
>> till the issue got posted.
>> >
>> >
>> >
>> >
>> >
>> > Here is the script that I use:
>> >
>> >
>> >
>> >
>> >
>> > ------------------------------- BEGIN SCRIPT
>> ---------------------------
>> >
>> > $ORACLE_HOME/bin/rman
>> > connect target sys/$syspswd_at_$ORACLE_SID; #
>> > run
>> > {
>> > configure CHANNEL device type 'SBT_TAPE' clear;
>> > CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
>> > CONFIGURE CONTROLFILE AUTOBACKUP ON;
>> > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
>> '${bkupdir}/%F';
>> >
>> >
>> > allocate channel ch1 device type disk maxpiecesize 10G;
>> > allocate channel ch2 device type disk maxpiecesize 10G;
>> > crosscheck backup;
>> > shutdown immediate;
>> > startup mount;
>> > backup
>> >
>> > incremental level=0
>> >
>> > as compressed backupset
>> >
>> > tag 'bk_${DBNAME}_$today'
>> > format '${bkupdir}/%d_%I_%T_%U'
>> > database
>> > ;
>> > backup
>> > tag '${DBNAME}_ctrl_$today'
>> > current controlfile format '${bkupdir}/${DBNAME}_%I_ctrl_$today';
>> >
>> >
>> >
>> > alter database open;
>> > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
>> '/backups/$DBNAME/backup_files/%F';
>> > CONFIGURE CONTROLFILE AUTOBACKUP OFF;
>> > }
>> > exit
>> >
>> > _EOF_
>> >
>> >
>> >
>> > -------------------------------- END SCRIPT
>> -------------------------------
>> >
>> >
>> >
>> > Before I start running the backup of the db (db by name 'april' created
>> for test purposes) here is the status:
>> >
>> >
>> >
>> > ! crsstat | grep april
>> > ora.april.april1.inst ONLINE ONLINE on
>> nmhd01
>> > ora.april.april2.inst OFFLINE
>> OFFLINE
>> > ora.april.aprils.april1.srv ONLINE ONLINE on
>> nmhd01
>> >
>> >
>> > ora.april.aprils.cs ONLINE ONLINE on
>> nmhd01
>> > ora.april.db ONLINE ONLINE on
>> nmht01
>> >
>> >
>> > A while after the backup script is kicked off here is the status:
>> >
>> >
>> >
>> > ! crsstat | grep april
>> > ora.april.april1.inst OFFLINE
>> OFFLINE
>> > ora.april.april2.inst OFFLINE
>> OFFLINE
>> > ora.april.aprils.april1.srv OFFLINE
>> OFFLINE
>> >
>> >
>> > ora.april.aprils.cs OFFLINE
>> OFFLINE
>> > ora.april.db OFFLINE
>> OFFLINE
>> >
>> >
>> >
>> > The backup script completed executing but the status of services still
>> remains above. I have to shutdown the DB and restart the DB to get the
>> services back online.
>> >
>> >
>> >
>> > =================================================================
>> >
>> >
>> >
>> > Here is a portion of the output from RMAN run:
>> >
>> >
>> >
>> > ---------------------------------- BEGIN RMAN OUTPUT
>> -------------------------------------
>> >
>> >
>> >
>> > allocated channel: ch1
>> > channel ch1: sid=132 instance=april1 devtype=DISK
>> >
>> > allocated channel: ch2
>> > channel ch2: sid=131 instance=april1 devtype=DISK
>> >
>> >
>> > database closed
>> > database dismounted
>> > Oracle instance shut down
>> >
>> > RMAN-00571: ===========================================================
>> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>> > RMAN-00571: ===========================================================
>> >
>> >
>> > RMAN-03002: failure of startup command at 04/29/2010 13:10:37
>> > ORA-12514: TNS:listener does not currently know of service requested in
>> connect descriptor
>> >
>> > RMAN>
>> >
>> > Recovery Manager complete.
>> >
>> >
>> >
>> > ---------------------------------- END RMAN OUTPUT
>> -------------------------------------
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > On Thu, Apr 29, 2010 at 12:59 PM, Bobak, Mark Mark.Bobak_at_proquest.com>
>> wrote:
>> >
>> >
>> >
>> >
>> > Hi Ram,
>> >
>> > I’m sure someone can help.
>> >
>> > First, what is the “regular script” that you’re using? Can you post it?
>> >
>> > Second, what “problems with the services” are you referring to,
>> exactly? Specific error with error number would be helpful here.
>> >
>> > We need to know what you’re doing and exactly what problem you’re
>> running into, in order to help.
>> >
>> >
>> > -Mark
>> >
>> >
>> > From: oracle-l-bounce_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] On Behalf Of Ram K
>> >
>> >
>> > Sent: Thursday, April 29, 2010 1:45 PM
>> > To: oracle-l
>> > Subject: RMAN backup of noarchivelog DB
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > Does anyone have script to perform backup of a Db in noarchivelog mode
>> in a 10.2 RAC environment.
>> >
>> >
>> >
>> >
>> >
>> > I tried using the regular script which shuts down the DB and then puts
>> the DB in mount mode to do backup. But I get problems with services in the
>> DB and not able to connect when the DB comes up in mount mode. I tried using
>> "shutdown immediate; startup mount; backup" method in rman. That did not
>> work. I tried stopping the DB and then starting it in mount mode using
>> srvctl, that did not work either.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > This is a two node DB with one instance disabled, so we work out of one
>> instance. The services are configured to automatically come up when the
>> instance comes up using StartSRVonUp.pl.
>> >
>> >
>> >
>> > --
>> > Thanks,
>> > Ram.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > --
>> > Thanks,
>> > Ram.
>> >
>> >
>> >
>> >
>> > --
>> > Andrew W. Kerber
>> >
>> > 'If at first you dont succeed, dont take up skydiving.'
>> >
>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
-- Thanks, Ram. -- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 30 2010 - 17:41:07 CDT