alter database backup controlfile

be recycled, online redo login file, control file and parameter file;Shut down the database and perform a full recovery (use the TAR command of the operating system to write it as a shell program). However Then open the database for normal use. The shell program is as follows:Tar cvf/dev/rmt/ctape2/u1/oracle/dbs/ctrl1ora7. ctl/U1/oracle/dbs/ctrl2ora7. ctl/U1/oracle/dbs/ctrl3ora7. ctl/U1/oracle/dbs/systora7

Reprint please specify the address.Backup slice file name wildcard character:Number of copies of%c backup slices%d The day ordinal (DD) in the month%M in the month of the year (MM)%F a unique name based on dbid, which is in the form of C-IIIIIIIIII-YYYYMMDD-QQ,%d database name where IIIIIIIIII is the date of the database DBID,YYYYMMDD, QQ is a sequence of 1-256%n

reported, it may be that the recover managed standby command is being executed: ORA-19870: errorwhile restoring backup piece/tmp/stb_bk/05n5a31s_00000000for_stb.bk ORA-19573: cannotobtain exclusive enqueue for datafile 1 Run the following command or restart the database to the mount status: Idle> alter database recove

;connect/as sysdbasql>shutdown normal; (2) use copy command to back up all time files, redo log files, control files, Initialize parameter file sql>cp (3) Restart Oracle database NBSP; Third, hot backupA hot backup is a method of backing up a database using the Archivelog mode mode in the case of a database run. So if

completed, the directory uploaded from the master database to the backup database may be different from the preceding directory. RMAN> catalog start with '/tmp/stb_bk /'; 4. Check the controlfile location, because the backup control file will be used next. Idle> show parame

Manual hot Standby (open library status)Backup control Files:ALTER DATABASE backup Controlfile to '/U01/ORADATA/PROD/CON.BAK1 ';Back up the data file (use PL/SQL for batch processing, paste the query results to run)BeginFor I in (select Tablespace_name from dba_tablespaces) loopDbms_output.put_line ('

1. Change Database downtime to archive ModeSQL> archive log listSQL> shutdown immediateSQL> startup mountSQL> alter database archivelog;SQL> alter database open;2. Point the database archive to ASMSQL>

files3. Backing up control files with ALTER DATABASE Bachup controlfile command The advantages of hot backup are:1. Can be backed up at the table space or database file level for a short time.2. The database is still available fo

Machine:Select instance_name from v $ instance;Select name from v $ database;Select name from v $ datafile;Log query mode:Archive log list;Shutdown immediate;Startup mount;Change the log archive mode:Alter database archivelog;Alter database open;Alter system archive log curr

### ################################################## #!/bin/bash Source/home/oracle/.bash_profile Cd/dinglp/ora_managed/scripts Exp Parfile=exp_rman.par --Level 0 backup Rman script RMAN_BK_LEVEL0.RCV Connect Catalog RMAN_DLP/DLP Connect Target Sys/dg@primary Run { Allocate channel D1 type disk; Allocate channel D2 type disk; Backup incremental Level 0 da