1748195 Members
2626 Online
108759 Solutions
New Discussion юеВ

Re: oracle backup

 
sh5490
Frequent Advisor

Re: oracle backup

hi
out put of script executing under oracle user

[4] % ./rman_full.sh
./rman_full.sh[5]: setenv: not found.
RMAN-00557: could not open MSGLOG "/home/shabir/scripts/oracle/rman/logfiles/rman_full-290308-1254.log"

Recovery Manager: Release 10.2.0.3.0 - Production on Sat Mar 29 12:54:50 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: CIEHO (DBID=103616347)
connected to recovery catalog database
Yogeeraj_1
Honored Contributor

Re: oracle backup

hi Shabir,

the script is not able to create the file: /home/shabir/scripts/oracle/rman/logfiles/rman_full-290308-1254.log


can you verify if the directory exists and also execute this following command:

touch /home/shabir/scripts/oracle/rman/logfiles/rman_full-290308-1254.log


revert!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
sh5490
Frequent Advisor

Re: oracle backup

hi yogeeraj,

yes there was permission problem,
it creating the file.

while running script it is not executing the rman script but displays only rman prompt
like

% ./rman_full.sh
RMAN>

thanks

shabir
sh5490
Frequent Advisor

Re: oracle backup

hi yoograj,

thanks lot for help
kindly provide me more inputs to resolve this issue

thanks

shabir
Yogeeraj_1
Honored Contributor

Re: oracle backup

hi Shabir,

Then you get the "RMAN>" prompt, it may mean that the backup is currently in execution. It may take some time before the backup completes.

To view the status, you may wish to open another telnet/ssh session and launch the following command:

tail -f "/home/shabir/scripts/oracle/rman/logfiles/rman_full-$(date +%d%m%y-%H%M).log"

also, "ps -ef|grep rman" to see if the process is running.

revert!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
sh5490
Frequent Advisor

Re: oracle backup

hi yoograj,

the following entry are seen in log file
home/shabir/scripts/oracle/rman/logfiles/
rman_inc-020408-1617.log

Recovery Manager: Release 10.2.0.3.0 - Production on Wed Apr 2 16:17:18 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: CIEHO (DBID=103616347)
connected to recovery catalog database

RMAN>

Recovery Manager complete.

pls how i can see the backup is completed sucessfully.

regards

shabir
SANTOSH S. MHASKAR
Trusted Contributor

Re: oracle backup

Hi,

Just give following command at RMAN prompt.

RMAN> list backupset summary;

It will show all completed backup summary.
If u have successfully completed a backup then it should get listed in above command's o/p.

Also to get fine details of backupsets get
the backupset number from above o/p and give command,

RMAN> list backup

This will show the files on OS where the backup is happened. U can check the existance of those files in filesystem.

-Santosh
Yogeeraj_1
Honored Contributor

Re: oracle backup

hi Shabir,

You can use the commands listed above by -Santosh.

e.g.

$ rman catalog=rman/rman target sys/redhat

Recovery Manager: Release 10.2.0.3.0 - Production on Wed Apr 2 16:07:50 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: MYDB (DBID=1116966042)
connected to recovery catalog database

RMAN> list backup;
..


Note that you can also monitor the status of all backups using the Oracle Enterprise manager Database Control.
http://:1158/em

Maitenance -> High Availability -> Backup/Recovery -> Backup Reports

Remember that if your RMAN has been configured properly and is working, you should perform test restore to make sure that your backup is recoverable.

You may also review your Recoverability window and other parameters.

if you need any further assistance, please let us know

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
sh5490
Frequent Advisor

Re: oracle backup

hi all,

thanks for reply

while checking the backup summary,there is no backup date and time when this backup script was executed .this indicates, backup script not works.

when we run rman script manually like
run
{ execute script incr_backup;}
this works fine and display the output of each script commands.
which is not case when we run this on shell prompt like

./incr_backup


thanks

shabir


SANTOSH S. MHASKAR
Trusted Contributor

Re: oracle backup

insert followint in ur script at beginning to debug it.

-----------
set -vx
---------------

Redirect the o/p to some file .

$ ./incr_backup > some_file 2>&1

diagnose the file some_file for possible errors.

-Santosh