- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracle backup
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2008 11:26 PM
тАО03-28-2008 11:26 PM
Re: oracle backup
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2008 12:02 AM
тАО03-29-2008 12:02 AM
Re: oracle backup
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2008 06:51 AM
тАО03-29-2008 06:51 AM
Re: oracle backup
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2008 10:40 PM
тАО03-31-2008 10:40 PM
Re: oracle backup
thanks lot for help
kindly provide me more inputs to resolve this issue
thanks
shabir
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2008 10:52 PM
тАО03-31-2008 10:52 PM
Re: oracle backup
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2008 03:02 AM
тАО04-02-2008 03:02 AM
Re: oracle backup
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2008 03:31 AM
тАО04-02-2008 03:31 AM
Re: oracle backup
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2008 04:14 AM
тАО04-02-2008 04:14 AM
Re: oracle backup
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://
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2008 10:59 PM
тАО04-02-2008 10:59 PM
Re: oracle backup
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-03-2008 03:00 AM
тАО04-03-2008 03:00 AM
Re: oracle backup
-----------
set -vx
---------------
Redirect the o/p to some file .
$ ./incr_backup > some_file 2>&1
diagnose the file some_file for possible errors.
-Santosh