on 06-01-2011 9:31 PM
Unable to schedule the full online backup on our production server.I have paste the logs below can any one help.?
Job started
Step 001 started (program RSDBAJOB, variant &0000000000007, user ID ADMIN)
Execute logical command BRBACKUP On host ora-pro
Parameters:-u / -jid ALLOG20110601231705 -c force -t online -m all -p initPRO_Disk.sap -a -c force -p initPRO_D
isk.sap -s
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: begaalyg.and 2011-06-01 23.17.06
BR0484I BRBACKUP log file: /oracle/PRO/sapbackup/begaalyg.and
BR0477I Oracle pfile /oracle/PRO/102_64/dbs/initPRO.ora created from spfile /oracle/PRO/102_64/dbs/spfilePRO.ora
BR0280I BRBACKUP time stamp: 2011-06-01 23.17.06
BR0319I Control file copy created: /oracle/PRO/sapbackup/cntrlPRO.dbf 13844480
BR0066E For online backup, the database must be in ARCHIVELOG mode
BR0056I End of database backup: begaalyg.and 2011-06-01 23.17.06
BR0280I BRBACKUP time stamp: 2011-06-01 23.17.06
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2011-06-01 23.17.06
BR0291I BRARCHIVE will be started with options '-U -jid ALLOG20110601231705 -d disk -c force -p initPRO_Disk.sap -s'
BR0002I BRARCHIVE 7.00 (40)
BR0006I Start of offline redo log processing: aegaalyg.sve 2011-06-01 23.17.06
BR0484I BRARCHIVE log file: /oracle/PRO/saparch/aegaalyg.sve
BR0477I Oracle pfile /oracle/PRO/102_64/dbs/initPRO.ora created from spfile /oracle/PRO/102_64/dbs/spfilePRO.ora
BR0252E Function fopen() failed for '/oracle/PRO/saparch/archPRO.log' at location arch_last_get-1
BR0253E errno 13: Permission denied
BR0016I 0 offline redo log files processed, totalsize 0.000 MB
BR0252W Function fopen() failed for '/oracle/PRO/saparch/archPRO.log' at location BrCleanup-8
BR0253W errno 13: Permission denied
BR0121W Processing of log file /oracle/PRO/saparch/archPRO.log failed
BR0007I End of offline redo log processing: aegaalyg.sve 2011-06-01 23.17.07
BR0280I BRARCHIVE time stamp: 2011-06-01 23.17.07
BR0005I BRARCHIVE terminated with errors
BR0280I BRBACKUP time stamp: 2011-06-01 23.17.07
BR0292I Execution of BRARCHIVE finished with return code 3
External program terminated with exit code 3
BRBACKUP returned error status E
Job finished
Can any tell me what permission need to be given to which folder...??
Edited by: letzfriend on Jun 1, 2011 11:15 PM
Hi Liz,
It is clearly saying that the database should be archive log mode
BR0280I BRBACKUP time stamp: 2011-06-01 23.17.06
BR0319I Control file copy created: /oracle/PRO/sapbackup/cntrlPRO.dbf 13844480
BR0066E For online backup, the database must be in ARCHIVELOG mode
Enable archivelogs in database with the following procedure ..
schedule a outage .. shutdown all applications .. and do a shutdown of database
SQL> shutdown immediate
now check status of archive log
SQl> archive log list;
it will be in disabled state .. now start database in mount
SQL> startup mount
now setup archive logs
SQL> alter database archivelog;
open database
SQL> alter database open;
now check with the command
SQL> archive log list;
now the status will be enabled. Start all applications and listener and schedule the backup
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.