Re: RMAN backup of noarchivelog DB
- From: Roman Podshivalov <roman.podshivalov@xxxxxxxxx>
- To: lambu999@xxxxxxxxx
- Date: Fri, 30 Apr 2010 18:42:47 -0400
DB should have been statically registered in listener.ora
(SID_LIST_<LISTENER_NAME> parameter) and configured with external password
file (orapwd).
--romas
On Thu, Apr 29, 2010 at 2: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 <<_EOF_
> connect target sys/$syspswd@$ORACLE_SID; # <- tried with values 'dbname',
> 'dbname1' for ORCL_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.
>
Other related posts:
