Home > Default > While taking  backup  database

While taking  backup  database

November 30Hits:0
Advertisement
HI guys
while i was taking backup database plus archived . i faced missing archived log .
please provide solution .
Thanks and regards

Answers

Osama_mustafa wrote:
906313 wrote:
HI all ,
i allocated channel and crosscheck archivelog all;
rman>show all ;
configure channel 1 device type disk format '/d01/backup/db.%U';
run
crosscheck archivelog all;
backup database plus archivelog;
Thanks and Regardsalso you can use this
run {
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/u01/%U';
crosscheck archivelog all;there are many ways to allocate channels, but none of them address the fact that the OP reports a missing archivelog.

Read other 10 answers

Tags:

Related Articles

  • Can't backup database in NOarchivelog modeOctober 11

    Hi there, I get this error when I run this command from rman: backup database Starting backup at 19-JAN-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset RMAN-0057

  • How to do backup database in the menu of Oracle XEOctober 11

    Dear all, When I do database backup selecting from the Oracle XE menu, it output the error as below : sql statement: create pfile=''C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile RMAN-00571: ======================

  • Why Backup database then backup archivelog from time...November 30

    Dear Experts, I found in one of our rman scripts the 2 following statements: backup database; backup archivelog from time 'SYSDATE -8'; It seems to me that a "backup database plus archivelog;" is more simple/accurate instead of these 2 lines as

  • T-SQL Code to backup database with multiple files - Syntax errorNovember 30

    Hello, I'm trying to backup a database into multiple files but I'm getting a syntax error. Here is the code: declare @DBName varchar(100) declare @DBFileName varchar(256) declare @FolderName varchar(256) declare @Path varchar(100) set @Path = '\\Back

  • Backup Database Task - User PermissionsNovember 30

    Hi I am currently implementing an SSIS package to cater for the backup of our database system.  I am using a Back Up Database Task connecting to the database using SQL Authentication.  This login has public server rights and db_backupoperator databas

  • How to use the backup database to create report or update testingNovember 30

    Hi, I have a fully backup of production database in the last month, and I have using Oracle 8.1.7. I want to known how can I use this backup to generate a new instance so that I can reproduct some report from the last month data or doing some update

  • How to backup database using sql query?November 30

    Hello,i'm student, i'm researching oracle database,i want to backup database that using sql query (like backup query in SQL SERVER) ,how to do that ?? Thank!No, database backups cannot be done from within the database. Commands for backups are outsid

  • Backup database using RMANNovember 30

    Hi, I wanted to perform the first backup with RMAN and I used this command and I got error: RMAN> BACKUP AS COPY DATABASE; "can not backup or copy active file in noarchivelog mode". But in order to turn on the log_mode to ARCHIVELOG, first I

  • Backup database plus archivelogNovember 30

    Hi I am using 10.2.0.3. What is the difference between "backup database plus archivelog" and "backup database"? I deleted the archive logs after disabling the archive log option. How to fix the below problem? thank you When I do backup

  • BACKUP failed to complete the command BACKUP DATABASE. Check the backup application log for detailed messages.November 30

    Hi, We have a back up that is failing. The error is "BACKUP failed to complete the command BACKUP DATABASE RPS. Check the backup application log for detailed messages.". As I understand it the backup application log is at C:\Program Files\Micros

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.957 s.