Re: Re: RMAN backup of noarchivelog DB
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: anelson77388@xxxxxxxxx
- Date: Fri, 30 Apr 2010 07:45:30 -0500
If you must connect using sqlnet (using @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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx> 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@$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@xxxxxxxxxxxx>
> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] 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.'
Other related posts:
