Posts Tagged ‘Backup And Recovery’

RESTORE RMAN BACKUP FROM ONE SERVER TO ANOTHER SERVER IN 10G:

+10 RESTORE RMAN BACKUP FROM ONE SERVER TO ANOTHER SERVER ON DIFFERENT LOCATION:   Lets take two servers as: SERVER1 SERVER2 ON SERVER1: DB Name: nsndb –Take backup of nsndb with archivelog,controlfile and spfile. –Copy all backupsets from SERVER1(Location: /data1/bak/nsndb/) to SERVER2(Location:/u01/backup/nsndb/) ON SERVER2: –Create pfile for database nsndb. DB Name: nsndb #export ORACLE_SID=nsndb #rman […]

ORA-00376: ORA-01110: file 7 cannot be read at this time

+6 ORA-00376: file 7 cannot be read at this timeORA-01110: data file 7: ‘/u02/oradata/UTF/myrio_data02.dbf’ Solution: Follow following steps to get rid off the above error: SQL> select ONLINE_STATUS from dba_data_files where file_id=7;ONLINE_——-RECOVERSQL> recover datafile 7;ORA-00279: change 248540120 generated at 03/13/2012 16:37:56 needed for thread1ORA-00289: suggestion : /export/home/oracle/archives/UTF/1_3936_761509767.dbfORA-00280: change 248540120 for thread 1 is in sequence […]

User Managed Hot Backup Steps

+15 HOT BACKUP STEPS: 1.           1.  #Export ORACLE_SID=sid_name 2.           2. #sqlplus “/as sysdba” 3.         3.  Sql> alter system checkpoint; 4.         4. Sql> select name, checkpoint_change#, to_char(checkpoint_time, ‘DD.MM.YYYY HH24:MI:SS’) from    v$datafile_header;(for 9i and above)          5.  Sql> select  CHECKPOINT_CHANGE#,ARCHIVELOG_CHANGE# from v$database; (for 9i and above) […]

CLONING A DATABASE USING COLD BACKUP

+15 ClONING A DATABASE USING COLD BACKUP IN SOLARIS AND LINUX ENVIRONMENT:   STEPS FOR COLD BACKUP: Let’s consider running database name: COBRA And New database name(clone of COBRA): COBRA_CLONE 1. Create a backup directory to store all database backup at OS level. #mkdir -p /u01/oradata/cobra_clone 2. Export ORACLE_SID=COBRA 3. Sqlplus “/as sysdba” 4. Get […]